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
fieldexampleSQL type info description
id 654924int(11) range Taxon NCBI ID
binomial Frog virus 3varchar(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
 
idbinomialtoGenus
654924Frog virus 3Viruses; dsDNA viruses, no RNA stage; Iridoviridae; Ranavirus.
345201Invertebrate iridescent virus 3Viruses; dsDNA viruses, no RNA stage; Iridoviridae; Chloriridovirus.
176652Invertebrate iridescent virus 6Viruses; dsDNA viruses, no RNA stage; Iridoviridae; Iridovirus.
561445African swine fever virusViruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
10500African swine fever virusViruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
561443African swine fever virusViruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
561444African swine fever virusViruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
10498African swine fever virusViruses; dsDNA viruses, no RNA stage; Asfarviridae; Asfivirus.
5874Theileria annulataEukaryota; Alveolata; Apicomplexa; Aconoidasida; Piroplasmida; Theileriidae; Theileria.
5875Theileria parvaEukaryota; Alveolata; Apicomplexa; Aconoidasida; Piroplasmida; Theileriidae; Theileria.

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