Genome Information By Organism

genomes including sequences, maps, chromosomes, assemblies and annotations

@kaggle.lsind18_genome_information_by_organism

Table List

6 tables(30.92 MB)

Genomes

Viruses

Plasmids

@kaggle.lsind18_genome_information_by_organism.plasmids

1.06 MB
21175 rows
12 columns

organism_name Organism Name	organism_groups Organism Groups	strain Strain	biosample BioSample	bioproject BioProject	size_mb Size(Mb)	gc GC%	replicons Replicons	cds CDS	release_date Release Date	genes Genes
Absiella argi	Bacteria;Terrabacteria group;Firmicutes	JCM 30884	SAMD00172297	PRJDB8336	0.00473	34.4397	pABar1:NZ_AP019696.1/AP019696.1	6	Sun Mar 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	6
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.374161	47.3483	pREB1:NC_009926.1/CP000838.1	284	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	325
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.356087	45.3367	pREB2:NC_009927.1/CP000839.1	320	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	357
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.273121	45.1902	pREB3:NC_009928.1/CP000840.1	241	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	292
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.22668	45.877	pREB4:NC_009929.1/CP000841.1	199	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	222
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.177162	44.6755	pREB5:NC_009930.1/CP000842.1	174	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	178
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.172728	47.1267	pREB6:NC_009931.1/CP000843.1	137	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	166
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.15511	45.5909	pREB7:NC_009932.1/CP000844.1	123	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	135
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.120693	45.4185	pREB8:NC_009933.1/CP000845.1	100	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	110
Acaryochloris marina MBIC11017	Bacteria;Terrabacteria group;Cyanobacteria/Melainabacteria group	MBIC11017	SAMN02604308	PRJNA12997	0.002133	42.5223	pREB9:NC_009934.1/CP000846.1	1	Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2


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