Schema for taxon

Database: uniProt Primary Table: taxon Row Count: 385,011 Data last updated: 2018-04-06
Format description: An NCBI taxon
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`id`	654924	`int(11)`	range	Taxon NCBI ID
`binomial`	Frog virus 3	`varchar(255)`	values	Binomial format name
`toGenus`	Viruses; dsDNA viruses, no ...	`longtext`	values	Taxonomy - superkingdom to genus

Connected Tables and Joining Fields


	uniProt.accToTaxon.taxon (via taxon.id) uniProt.commonName.taxon (via taxon.id) visiGene.antibody.taxon (via taxon.id) visiGene.gene.taxon (via taxon.id) visiGene.genotype.taxon (via taxon.id) visiGene.lifeStageScheme.taxon (via taxon.id) visiGene.lifeTime.taxon (via taxon.id) visiGene.specimen.taxon (via taxon.id) visiGene.strain.taxon (via taxon.id)

Sample Rows

id	binomial	toGenus
654924	Frog virus 3	Viruses; dsDNA viruses, no RNA stage; Iridoviridae; Ranavirus.
345201	Invertebrate iridescent virus 3	Viruses; dsDNA viruses, no RNA stage; Iridoviridae; Chloriridovirus.
176652	Invertebrate iridescent virus 6	Viruses; dsDNA viruses, no RNA stage; Iridoviridae; Iridovirus.
561445	African swine fever virus	Viruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
10500	African swine fever virus	Viruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
561443	African swine fever virus	Viruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
561444	African swine fever virus	Viruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
10498	African swine fever virus	Viruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
5874	Theileria annulata	Eukaryota; Alveolata; Apicomplexa; Aconoidasida; Piroplasmida; Theileriidae; Theileria.
5875	Theileria parva	Eukaryota; Alveolata; Apicomplexa; Aconoidasida; Piroplasmida; Theileriidae; Theileria.

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.