Schema for spReactomeId
  Database: proteome    Primary Table: spReactomeId    Row Count: 35,457   Data last updated: 2018-04-07
Format description: mapping from uniProt id to Reactome db id
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID P31946varchar(40) values UniProt protein Accession number
DB_ID  varchar(40) values Reactome DB_ID

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

Sample Rows
 
spIDDB_ID
P31946
P62258
P62259
Q04917
P61981
P61982
P31947
P27348
P63104
O43715

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