Schema for sgdAbundance
  Database: sacCer1    Primary Table: sgdAbundance    Row Count: 3,868   Data last updated: 2003-12-31
Format description: Protein abundance data from http://yeastgfp.yeastgenome.org via SGD
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name YAL001Cvarchar(10) values ORF name in sgdGene table
abundance 125float range Absolute abundance from 41 to 1590000
error  varchar(10) values Error - either a floating point number or blank

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

Sample Rows
 
nameabundanceerror
YAL001C125
YAL002W736
YAL005C269000
YAL007C26300
YAL008W1920
YAL009W861
YAL010C768
YAL011W1380
YAL012W38300
YAL016W16900

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