Schema for sgdToSwissProt
  Database: sacCer3    Primary Table: sgdToSwissProt    Row Count: 5,879   Data last updated: 2011-08-29
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name YMR084Wvarchar(10) values primary ID
value A2P2R3varchar(10) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        sacCer3.ceBlastTab.query (via sgdToSwissProt.name)
      sacCer3.choExpDistance.query (via sgdToSwissProt.name)
      sacCer3.choExpDistance.target (via sgdToSwissProt.name)
      sacCer3.dmBlastTab.query (via sgdToSwissProt.name)
      sacCer3.drBlastTab.query (via sgdToSwissProt.name)
      sacCer3.esRegGeneToModule.gene (via sgdToSwissProt.name)
      sacCer3.esRegGeneToMotif.gene (via sgdToSwissProt.name)
      sacCer3.esRegUpstreamRegion.name (via sgdToSwissProt.name)
      sacCer3.hgBlastTab.query (via sgdToSwissProt.name)
      sacCer3.mmBlastTab.query (via sgdToSwissProt.name)
      sacCer3.rnBlastTab.query (via sgdToSwissProt.name)
      sacCer3.sgdBlastTab.query (via sgdToSwissProt.name)
      sacCer3.sgdBlastTab.target (via sgdToSwissProt.name)
      sacCer3.sgdCanonical.transcript (via sgdToSwissProt.name)
      sacCer3.sgdDescription.name (via sgdToSwissProt.name)
      sacCer3.sgdGene.name (via sgdToSwissProt.name)
      sacCer3.sgdIsoforms.transcript (via sgdToSwissProt.name)
      sacCer3.sgdPep.name (via sgdToSwissProt.name)
      sacCer3.sgdToName.name (via sgdToSwissProt.name)
      go.goaPart.dbObjectId (via sgdToSwissProt.value)
      knownGeneV39.kgProtAlias.alias (via sgdToSwissProt.value)
      knownGeneV39.kgSpAlias.spID (via sgdToSwissProt.value)
      knownGeneV39.kgXref.spID (via sgdToSwissProt.value)
      proteome.spOldNew.acc (via sgdToSwissProt.value)
      proteome.spReactomeEvent.spID (via sgdToSwissProt.value)
      proteome.spReactomeId.spID (via sgdToSwissProt.value)
      sacCer3.sgdCanonical.protein (via sgdToSwissProt.value)
      sacCer3.sgdGene.proteinID (via sgdToSwissProt.value)
      uniProt.accToKeyword.acc (via sgdToSwissProt.value)
      uniProt.accToTaxon.acc (via sgdToSwissProt.value)
      uniProt.citation.acc (via sgdToSwissProt.value)
      uniProt.comment.acc (via sgdToSwissProt.value)
      uniProt.description.acc (via sgdToSwissProt.value)
      uniProt.displayId.acc (via sgdToSwissProt.value)
      uniProt.extDbRef.acc (via sgdToSwissProt.value)
      uniProt.feature.acc (via sgdToSwissProt.value)
      uniProt.gene.acc (via sgdToSwissProt.value)
      uniProt.geneLogic.acc (via sgdToSwissProt.value)
      uniProt.info.acc (via sgdToSwissProt.value)
      uniProt.otherAcc.acc (via sgdToSwissProt.value)
      uniProt.protein.acc (via sgdToSwissProt.value)
      visiGene.gene.uniProt (via sgdToSwissProt.value)

Sample Rows
 
namevalue
YMR084WA2P2R3
YAR009CA5JYZ4
YPR010C-AA5Z2X5
YOR175CA9EDP4
YPL061WA9LRZ7
YDR539WB2NII0
YJR094CB8XW28
YGR044CB8XW41
YMR030WB8XW45
YDL227CC9ELN8

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