Schema for commonName
  Database: uniProt    Primary Table: commonName    Row Count: 99,973   Data last updated: 2018-04-06
Format description: Common name for a taxon
On download server: MariaDB table dump directory
fieldexampleSQL type info description
taxon 654924int(11) range Taxon table ID
val isolate Goorhavarchar(255) values Common name

Connected Tables and Joining Fields
        uniProt.accToTaxon.taxon (via commonName.taxon)
      uniProt.taxon.id (via commonName.taxon)
      visiGene.antibody.taxon (via commonName.taxon)
      visiGene.gene.taxon (via commonName.taxon)
      visiGene.genotype.taxon (via commonName.taxon)
      visiGene.lifeStageScheme.taxon (via commonName.taxon)
      visiGene.lifeTime.taxon (via commonName.taxon)
      visiGene.specimen.taxon (via commonName.taxon)
      visiGene.strain.taxon (via commonName.taxon)

Sample Rows
 
taxonval
654924isolate Goorha
654924FV-3
345201IIV-3
345201Mosquito iridescent virus
176652IIV-6
176652Chilo iridescent virus
561445isolate Pig/Kenya/KEN-50/1950
561445ASFV
10500isolate Tick/Malawi/Lil 20-1/1983
10500ASFV

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