Schema for sgdToName
  Database: sacCer3    Primary Table: sgdToName    Row Count: 6,692   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 Q0010varchar(10) values primary ID
value Q0010varchar(10) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
Q0010Q0010
Q0017Q0017
Q0032Q0032
Q0045COX1
Q0050AI1
Q0055AI2
Q0060AI3
Q0065AI4
Q0070AI5_ALPHA
Q0075AI5_BETA

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