Schema for sgdToName
  Database: sacCer2    Primary Table: sgdToName    Row Count: 6,717   Data last updated: 2009-07-10
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 YAL068W-Avarchar(10) values primary ID
value YAL068W-Avarchar(10) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
YAL068W-AYAL068W-A
YAL064WYAL064W
YAL058WCNE1
YAL055WPEX22
YAL051WOAF1
YAL031W-AYAL031W-A
YAL017WPSK1
YAL013WDEP1
YAL009WSPO7
YAR033WMST28

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