Schema for spReactomeEvent
  Database: proteome    Primary Table: spReactomeEvent    Row Count: 504,224   Data last updated: 2018-04-07
Format description: mapping from uniProt id to Reactome event id
On download server: MariaDB table dump directory
fieldexampleSQL type description
spID P31946varchar(40) UniProt protein Accession number
eventID R-HSA-450394varchar(40) Reactome Event id
eventDesc p-S60,S186-ZFP36 (Tristetra...varchar(255) Reactome Event description

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

Sample Rows
 
spIDeventIDeventDesc
P31946R-HSA-450394p-S60,S186-ZFP36 (Tristetraproline, TTP) binds 14-3-3beta
P31946R-HSA-450406p-S92,203-BRF1 binds 14-3-3
P31946R-HSA-482788p-S54,92,203-BRF1 binds 14-3-3
P31946R-HSA-5672824Phosphorylated AKT1S1:mTORC1 binds YWHAB
P31946R-HSA-169901(ARMS)Rap1-GTP binds and activates B-Raf
P31946R-HSA-2028644YWHAB (14-3-3 beta/alpha) dimer binds phosphorylated YAP1
P31946R-HSA-5672951Inactive RAFs bind YWHAB
P31946R-HSA-5672954p-S311,S406 KSR1:MARK3 binds YWHAB dimer
P31946R-HSA-5672958YWHAB dimer dissociates from KSR1:MARK3
P31946R-HSA-5672960YWHAB dimer dissociates from dephosphorylated RAF

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