Schema for sgdToSwissProt
  Database: sacCer1    Primary Table: sgdToSwissProt    Row Count: 6,126   Data last updated: 2003-12-31
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 YPL228Wvarchar(10) values primary ID
value O13297varchar(10) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        sacCer1.choExpDistance.query (via sgdToSwissProt.name)
      sacCer1.choExpDistance.target (via sgdToSwissProt.name)
      sacCer1.dmBlastTab.query (via sgdToSwissProt.name)
      sacCer1.esRegGeneToModule.gene (via sgdToSwissProt.name)
      sacCer1.esRegGeneToMotif.gene (via sgdToSwissProt.name)
      sacCer1.esRegUpstreamRegion.name (via sgdToSwissProt.name)
      sacCer1.hgBlastTab.query (via sgdToSwissProt.name)
      sacCer1.mmBlastTab.query (via sgdToSwissProt.name)
      sacCer1.rnBlastTab.query (via sgdToSwissProt.name)
      sacCer1.sgdAbundance.name (via sgdToSwissProt.name)
      sacCer1.sgdBlastTab.query (via sgdToSwissProt.name)
      sacCer1.sgdBlastTab.target (via sgdToSwissProt.name)
      sacCer1.sgdCanonical.transcript (via sgdToSwissProt.name)
      sacCer1.sgdDescription.name (via sgdToSwissProt.name)
      sacCer1.sgdGene.name (via sgdToSwissProt.name)
      sacCer1.sgdIsoforms.transcript (via sgdToSwissProt.name)
      sacCer1.sgdLocalization.name (via sgdToSwissProt.name)
      sacCer1.sgdPep.name (via sgdToSwissProt.name)
      sacCer1.sgdToName.name (via sgdToSwissProt.name)
      sacCer1.sgdToPfam.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)
      sacCer1.sgdCanonical.protein (via sgdToSwissProt.value)
      sacCer1.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
YPL228WO13297
YDR110WO13329
YAL065CO13511
YAL064W-BO13512
YAL056C-AO13513
YAL042C-AO13514
YAL034C-BO13515
YPL081WO13516
YPL102CO13517
YPL114WO13518

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