Schema for accToTaxon
  Database: uniProt    Primary Table: accToTaxon    Row Count: 28,967,110   Data last updated: 2018-04-07
Format description: accession/taxon relationship
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
taxon 654924int(11) ID in taxon table

Connected Tables and Joining Fields
        ce2.sangerCanonical.protein (via accToTaxon.acc)
      ce2.sangerGene.proteinID (via accToTaxon.acc)
      ce2.sangerLinks.protName (via accToTaxon.acc)
      ce4.sangerCanonical.protein (via accToTaxon.acc)
      ce4.sangerGene.proteinID (via accToTaxon.acc)
      ce4.sangerLinks.protName (via accToTaxon.acc)
      ce6.sangerCanonical.protein (via accToTaxon.acc)
      ce6.sangerGene.proteinID (via accToTaxon.acc)
      ce6.sangerLinks.protName (via accToTaxon.acc)
      dm1.bdgpCanonical.protein (via accToTaxon.acc)
      dm1.bdgpGene.proteinID (via accToTaxon.acc)
      dm1.bdgpSwissProt.swissProtId (via accToTaxon.acc)
      dm1.flyBaseSwissProt.swissProtId (via accToTaxon.acc)
      go.goaPart.dbObjectId (via accToTaxon.acc)
      hg16.kgProtAlias.alias (via accToTaxon.acc)
      hg16.kgProtMap.qName (via accToTaxon.acc)
      hg16.kgXref.spID (via accToTaxon.acc)
      hg17.kgProtAlias.alias (via accToTaxon.acc)
      hg17.kgProtMap.qName (via accToTaxon.acc)
      hg17.kgSpAlias.spID (via accToTaxon.acc)
      hg17.kgXref.spID (via accToTaxon.acc)
      hg18.kgSpAlias.spID (via accToTaxon.acc)
      hg18.kgXref.spID (via accToTaxon.acc)
      hg19.kgSpAlias.spID (via accToTaxon.acc)
      hg19.kgXref.spID (via accToTaxon.acc)
      hg38.kgSpAlias.spID (via accToTaxon.acc)
      hg38.kgXref.spID (via accToTaxon.acc)
      knownGeneV39.kgProtAlias.alias (via accToTaxon.acc)
      knownGeneV39.kgSpAlias.spID (via accToTaxon.acc)
      knownGeneV39.kgXref.spID (via accToTaxon.acc)
      mm10.kgSpAlias.spID (via accToTaxon.acc)
      mm10.kgXref.spID (via accToTaxon.acc)
      mm7.kgProtAlias.alias (via accToTaxon.acc)
      mm7.kgProtMap.qName (via accToTaxon.acc)
      mm7.kgSpAlias.spID (via accToTaxon.acc)
      mm7.kgXref.spID (via accToTaxon.acc)
      mm8.kgProtAlias.alias (via accToTaxon.acc)
      mm8.kgProtMap.qName (via accToTaxon.acc)
      mm8.kgSpAlias.spID (via accToTaxon.acc)
      mm8.kgXref.spID (via accToTaxon.acc)
      mm9.kgSpAlias.spID (via accToTaxon.acc)
      mm9.kgXref.spID (via accToTaxon.acc)
      proteome.spOldNew.acc (via accToTaxon.acc)
      proteome.spReactomeEvent.spID (via accToTaxon.acc)
      proteome.spReactomeId.spID (via accToTaxon.acc)
      rn3.kgProtAlias.alias (via accToTaxon.acc)
      rn3.kgProtMap.qName (via accToTaxon.acc)
      rn3.kgSpAlias.spID (via accToTaxon.acc)
      rn3.kgXref.spID (via accToTaxon.acc)
      rn4.rgdGene2ToUniProt.value (via accToTaxon.acc)
      sacCer1.sgdCanonical.protein (via accToTaxon.acc)
      sacCer1.sgdGene.proteinID (via accToTaxon.acc)
      sacCer1.sgdToSwissProt.value (via accToTaxon.acc)
      sacCer2.sgdCanonical.protein (via accToTaxon.acc)
      sacCer2.sgdGene.proteinID (via accToTaxon.acc)
      sacCer2.sgdToSwissProt.value (via accToTaxon.acc)
      sacCer3.sgdCanonical.protein (via accToTaxon.acc)
      sacCer3.sgdGene.proteinID (via accToTaxon.acc)
      sacCer3.sgdToSwissProt.value (via accToTaxon.acc)
      uniProt.accToKeyword.acc (via accToTaxon.acc)
      uniProt.citation.acc (via accToTaxon.acc)
      uniProt.comment.acc (via accToTaxon.acc)
      uniProt.description.acc (via accToTaxon.acc)
      uniProt.displayId.acc (via accToTaxon.acc)
      uniProt.extDbRef.acc (via accToTaxon.acc)
      uniProt.feature.acc (via accToTaxon.acc)
      uniProt.gene.acc (via accToTaxon.acc)
      uniProt.geneLogic.acc (via accToTaxon.acc)
      uniProt.info.acc (via accToTaxon.acc)
      uniProt.otherAcc.acc (via accToTaxon.acc)
      uniProt.protein.acc (via accToTaxon.acc)
      visiGene.gene.uniProt (via accToTaxon.acc)
      uniProt.commonName.taxon (via accToTaxon.taxon)
      uniProt.taxon.id (via accToTaxon.taxon)
      visiGene.antibody.taxon (via accToTaxon.taxon)
      visiGene.gene.taxon (via accToTaxon.taxon)
      visiGene.genotype.taxon (via accToTaxon.taxon)
      visiGene.lifeStageScheme.taxon (via accToTaxon.taxon)
      visiGene.lifeTime.taxon (via accToTaxon.taxon)
      visiGene.specimen.taxon (via accToTaxon.taxon)
      visiGene.strain.taxon (via accToTaxon.taxon)

Sample Rows
 
acctaxon
Q6GZX4654924
Q6GZX3654924
Q197F8345201
Q197F7345201
Q6GZX2654924
Q6GZX1654924
Q197F5345201
Q6GZX0654924
Q91G88176652
Q6GZW9654924

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