Name: Genome Information By Organism
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Genome Information By Organism

Context 🔬

Information on genomes including sequences, maps, chromosomes, assemblies, and annotations organized by National Center for Biotechnology Information, U.S. National Library of Medicine.

Content

This directory contains summary reports conveying the organism scope and detailed genome project reports grouped by major taxonomic divisions.

genomes.csv (4.25 MB): Comprehensive report of organisms that have one or many genome sequencing projects that may be complete, in progress or planned.
eukaryotes.csv (3.68 MB): Eukaryotic genome sequencing projects excluding projects that represent only organelles.
prokaryotes.csv (84.9 MB): Prokaryotic genome sequencing projects excluding projects that represent only plasmids.
viruses.csv (8.92 MB): Viral genome sequencing projects.
organelles.csv (2.39 MB): Organelle genome sequencing projects.
plasmids.csv (3.84 MB): Plasmid genome sequencing projects.

Acknowledgements

These files correspond to the tables available online at NCBI.

Tables

Eukaryotes

@kaggle.lsind18_genome_information_by_organism.eukaryotes

1.36 MB
11,160 rows
17 columns

CREATE TABLE eukaryotes (
  "organism_name" VARCHAR,
  "organism_groups" VARCHAR,
  "strain" VARCHAR,
  "biosample" VARCHAR,
  "bioproject" VARCHAR,
  "assembly" VARCHAR,
  "level" VARCHAR,
  "size_mb" DOUBLE  -- Size(Mb),
  "gc" DOUBLE  -- GC%,
  "replicons" VARCHAR,
  "wgs" VARCHAR,
  "scaffolds" BIGINT,
  "cds" BIGINT,
  "release_date" TIMESTAMP,
  "genbank_ftp" VARCHAR,
  "refseq_ftp" VARCHAR,
  "genes" BIGINT
);

Genomes

@kaggle.lsind18_genome_information_by_organism.genomes

1.15 MB
49,903 rows
7 columns

CREATE TABLE genomes (
  "organism_name" VARCHAR,
  "organism_groups" VARCHAR,
  "size_mb" DOUBLE  -- Size(Mb),
  "chromosomes" BIGINT,
  "organelles" BIGINT,
  "plasmids" BIGINT,
  "assemblies" BIGINT
);

Organelles

@kaggle.lsind18_genome_information_by_organism.organelles

928.93 kB
16,357 rows
12 columns

CREATE TABLE organelles (
  "organism_name" VARCHAR,
  "organism_groups" VARCHAR,
  "strain" VARCHAR,
  "biosample" VARCHAR,
  "bioproject" VARCHAR,
  "size_mb" DOUBLE  -- Size(Mb),
  "gc" DOUBLE  -- GC%,
  "type" VARCHAR,
  "replicons" VARCHAR,
  "cds" BIGINT,
  "release_date" TIMESTAMP,
  "genes" BIGINT
);

Plasmids

@kaggle.lsind18_genome_information_by_organism.plasmids

1.12 MB
21,175 rows
12 columns

CREATE TABLE plasmids (
  "organism_name" VARCHAR,
  "organism_groups" VARCHAR,
  "strain" VARCHAR,
  "biosample" VARCHAR,
  "bioproject" VARCHAR,
  "size_mb" DOUBLE  -- Size(Mb),
  "gc" DOUBLE  -- GC%,
  "replicons" VARCHAR,
  "cds" BIGINT,
  "neighbors" BIGINT,
  "release_date" TIMESTAMP,
  "genes" BIGINT
);

Prokaryotes

@kaggle.lsind18_genome_information_by_organism.prokaryotes

26.08 MB
249,357 rows
17 columns

CREATE TABLE prokaryotes (
  "organism_name" VARCHAR,
  "organism_groups" VARCHAR,
  "strain" VARCHAR,
  "biosample" VARCHAR,
  "bioproject" VARCHAR,
  "assembly" VARCHAR,
  "level" VARCHAR,
  "size_mb" DOUBLE  -- Size(Mb),
  "gc" DOUBLE  -- GC%,
  "replicons" VARCHAR,
  "wgs" VARCHAR,
  "scaffolds" BIGINT,
  "cds" BIGINT,
  "release_date" TIMESTAMP,
  "genbank_ftp" VARCHAR,
  "refseq_ftp" VARCHAR,
  "genes" BIGINT
);

Viruses

@kaggle.lsind18_genome_information_by_organism.viruses

1.79 MB
34,747 rows
16 columns

CREATE TABLE viruses (
  "organism_name" VARCHAR,
  "organism_groups" VARCHAR,
  "biosample" VARCHAR,
  "bioproject" VARCHAR,
  "assembly" VARCHAR,
  "level" VARCHAR,
  "size_mb" DOUBLE  -- Size(Mb),
  "gc" DOUBLE  -- GC%,
  "host" VARCHAR,
  "cds" BIGINT,
  "neighbors" DOUBLE,
  "release_date" TIMESTAMP,
  "genbank_ftp" VARCHAR,
  "refseq_ftp" VARCHAR,
  "genes" BIGINT,
  "scaffolds" BIGINT
);