Schema for sgdToName
  Database: sacCer1    Primary Table: sgdToName    Row Count: 6,703   Data last updated: 2007-03-16
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 YAL069Wvarchar(10) values primary ID
value YAL069Wvarchar(10) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        sacCer1.choExpDistance.query (via sgdToName.name)
      sacCer1.choExpDistance.target (via sgdToName.name)
      sacCer1.dmBlastTab.query (via sgdToName.name)
      sacCer1.esRegGeneToModule.gene (via sgdToName.name)
      sacCer1.esRegGeneToMotif.gene (via sgdToName.name)
      sacCer1.esRegUpstreamRegion.name (via sgdToName.name)
      sacCer1.hgBlastTab.query (via sgdToName.name)
      sacCer1.mmBlastTab.query (via sgdToName.name)
      sacCer1.rnBlastTab.query (via sgdToName.name)
      sacCer1.sgdAbundance.name (via sgdToName.name)
      sacCer1.sgdBlastTab.query (via sgdToName.name)
      sacCer1.sgdBlastTab.target (via sgdToName.name)
      sacCer1.sgdCanonical.transcript (via sgdToName.name)
      sacCer1.sgdDescription.name (via sgdToName.name)
      sacCer1.sgdGene.name (via sgdToName.name)
      sacCer1.sgdIsoforms.transcript (via sgdToName.name)
      sacCer1.sgdLocalization.name (via sgdToName.name)
      sacCer1.sgdPep.name (via sgdToName.name)
      sacCer1.sgdToPfam.name (via sgdToName.name)
      sacCer1.sgdToSwissProt.name (via sgdToName.name)

Sample Rows
 
namevalue
YAL069WYAL069W
YAL068W-AYAL068W-A
YAL066WYAL066W
YAL059C-AYAL059C-A
YAL056C-AYAL056C-A
YAL047W-AYAL047W-A
YAL045CYAL045C
YAL042C-AYAL042C-A
YAL037C-BYAL037C-B
YAL034C-BYAL034C-B

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