Schema for sgdToSwissProt
  Database: sacCer2    Primary Table: sgdToSwissProt    Row Count: 5,890   Data last updated: 2009-02-20
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 YCR043Cvarchar(10) values primary ID
value P25361varchar(10) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        sacCer2.ceBlastTab.query (via sgdToSwissProt.name)
      sacCer2.choExpDistance.query (via sgdToSwissProt.name)
      sacCer2.choExpDistance.target (via sgdToSwissProt.name)
      sacCer2.dmBlastTab.query (via sgdToSwissProt.name)
      sacCer2.drBlastTab.query (via sgdToSwissProt.name)
      sacCer2.esRegGeneToModule.gene (via sgdToSwissProt.name)
      sacCer2.esRegGeneToMotif.gene (via sgdToSwissProt.name)
      sacCer2.esRegUpstreamRegion.name (via sgdToSwissProt.name)
      sacCer2.hgBlastTab.query (via sgdToSwissProt.name)
      sacCer2.mmBlastTab.query (via sgdToSwissProt.name)
      sacCer2.rnBlastTab.query (via sgdToSwissProt.name)
      sacCer2.sgdAbundance.name (via sgdToSwissProt.name)
      sacCer2.sgdBlastTab.query (via sgdToSwissProt.name)
      sacCer2.sgdBlastTab.target (via sgdToSwissProt.name)
      sacCer2.sgdCanonical.transcript (via sgdToSwissProt.name)
      sacCer2.sgdDescription.name (via sgdToSwissProt.name)
      sacCer2.sgdGene.name (via sgdToSwissProt.name)
      sacCer2.sgdIsoforms.transcript (via sgdToSwissProt.name)
      sacCer2.sgdLocalization.name (via sgdToSwissProt.name)
      sacCer2.sgdPep.name (via sgdToSwissProt.name)
      sacCer2.sgdToName.name (via sgdToSwissProt.name)
      sacCer2.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)
      sacCer2.sgdCanonical.protein (via sgdToSwissProt.value)
      sacCer2.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
YCR043CP25361
YCR067CP25365
YCR095CP25366
YCL031CP25368
YCL036WP25370
YCL035CP25373
YCL057WP25375
YCR105WP25377
YCL048WP25380
YCR045CP25381

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