Schema for spOldNew
  Database: proteome    Primary Table: spOldNew    Row Count: 1,601,269   Data last updated: 2018-04-12
Format description: mapping from old uniProt display id's to species specific names
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc P15711varchar(40) uniProt id
oldDisplayId 104K_THEPAvarchar(40) old uniProt display id without species added
newDisplayId 104K_THEPAvarchar(40) uniProt display id maybe with species added

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

Sample Rows
 
accoldDisplayIdnewDisplayId
P15711104K_THEPA104K_THEPA
Q43495108_LYCES108_LYCES
P1864610KD_VIGUN10KD_VIGUN
P13813110K_PLAKN110K_PLAKN
P1908411S3_HELAN11S3_HELAN
P1374411SB_CUCMA11SB_CUCMA
P32234128U_DROME128U_DROME
P2121512AH_CLOS412AH_CLOS4
Q0534912KD_FRAAN12KD_FRAAN
P8043812KD_MYCSM12KD_MYCSM

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