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

Viruses

@kaggle.lsind18_genome_information_by_organism.viruses

1.71 MB
34747 rows
16 columns

organism_name Organism Name	organism_groups Organism Groups	biosample BioSample	bioproject BioProject	assembly Assembly	level Level	size_mb Size(Mb)	gc GC%	host Host	cds CDS	neighbors Neighbors	release_date Release Date	genbank_ftp GenBank FTP	refseq_ftp RefSeq FTP	genes Genes	scaffolds Scaffolds
White spot syndrome virus	Viruses;Other;Nimaviridae	nan	nan	GCA_000848085.2	Complete	0.309286	40.9	invertebrates	177	16	Tue Nov 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/848/085/GCA_000848085.2_ViralProj14616	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/848/085/GCF_000848085.2_ViralProj14616	177	1
Posavirus sp.	Viruses;unclassified viruses;unclassified	nan	nan	GCA_002374955.1	Complete	0.00957	32.8	vertebrates	1	46	Tue Dec 27 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/002/374/955/GCA_002374955.1_ASM237495v1	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/002/374/955/GCF_002374955.1_ASM237495v1	1	1
Hepatitis E virus	Viruses;Other;Hepeviridae	nan	nan	GCA_000861105.1	Complete	0.007176	57.9	human,vertebrates	3	569	Mon Aug 02 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/861/105/GCA_000861105.1_ViralProj15435	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/861/105/GCF_000861105.1_ViralProj15435	3	1
Heterosigma akashiwo RNA virus SOG263	Viruses;Other;Marnaviridae	nan	nan	GCA_000863545.1	Complete	0.008587	46.9	nan	1		Wed Jul 23 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/863/545/GCA_000863545.1_ViralProj15425	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/863/545/GCF_000863545.1_ViralProj15425	1	1
Pyrococcus abyssi virus 1	Viruses;unclassified viruses;unclassified	nan	nan	GCA_000871785.1	Complete	0.018098	47.2	archaea	25		Sat Jun 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/871/785/GCA_000871785.1_ViralProj19929	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/871/785/GCF_000871785.1_ViralProj19929	25	1
Marine RNA virus SOG	Viruses;Other;Other	nan	nan	GCA_000871885.1	Complete	0.004449	51.7	nan	3		Sun Jul 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/871/885/GCA_000871885.1_ViralProj20647	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/871/885/GCF_000871885.1_ViralProj20647	3	1
Tomato marchitez virus	Viruses;Other;Secoviridae	nan	nan	GCA_000879575.1	Complete	0.012135	42.0809	land plants	3	6	Fri Dec 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/879/575/GCA_000879575.1_ViralMultiSegProj30365	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/879/575/GCF_000879575.1_ViralMultiSegProj30365	3	2
Ourmia melon virus	Viruses;Other;Botourmiaviridae	nan	nan	GCA_000874705.1	Complete	0.004852	51.5204	land plants	3		Sat Jul 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/874/705/GCA_000874705.1_ViralMultiSegProj30737	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/874/705/GCF_000874705.1_ViralMultiSegProj30737	3	3
Epirus cherry virus	Viruses;Other;Botourmiaviridae	nan	nan	GCA_000875525.1	Complete	0.004757	53.0887	land plants	3		Sat Jul 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/875/525/GCA_000875525.1_ViralMultiSegProj30739	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/875/525/GCF_000875525.1_ViralMultiSegProj30739	3	3
Vibrio phage douglas 12A4	Viruses;Other;Podoviridae	nan	PRJNA39215	GCA_000908255.1	Complete	0.057611	39	bacteria	75		Mon Mar 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/908/255/GCA_000908255.1_ViralProj198432	ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/000/908/255/GCF_000908255.1_ViralProj198432	75	1


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