Schema for otherAcc
  Database: uniProt    Primary Table: otherAcc    Row Count: 308,645   Data last updated: 2018-04-06
Format description: Relate ID and other accessions
On download server: MariaDB table dump directory
fieldexampleSQL type info description
acc P15711char(12) values Primary accession
val Q4N2B5char(12) values Secondary accession

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

Sample Rows
 
accval
P15711Q4N2B5
P68744P18556
P32234Q9V648
Q8GBW6Q05617
Q9XFM4Q9M641
P81928Q9VFM8
P48347Q9LME5
Q9S9Z8A0JQ87
Q9S9Z8F4HWN0
Q9S9Z8Q0WL19

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