Schema for sgdDescription
  Database: sacCer1    Primary Table: sgdDescription    Row Count: 5,769   Data last updated: 2003-12-31
Format description: Description of SGD Genes and Other Features
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name YAL068Cvarchar(10) values Name in sgdGene or sgdOther table
type CDS:Uncharacterizedvarchar(255) values Type of feature from gff3 file
description Hypothetical ORFlongblob   Description of feature

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

Sample Rows
 
nametypedescription
YAL068CCDS:UncharacterizedHypothetical ORF
YAL067W-ACDS:UncharacterizedIdentified by gene-trapping, microarray-based expression analysis, and genome-wide homology searching
YAL067CCDS:VerifiedSuppressor of Sulfoxyde Ethionine resistance
YAL064W-BCDS:UncharacterizedHypothetical ORF
YAL064C-ACDS:UncharacterizedHypothetical ORF
YAL064WCDS:UncharacterizedHypothetical ORF
YAL063C-ACDS:UncharacterizedIdentified by expression profiling and mass spectrometry
YAL063CCDS:Verifiedputative cell wall protein involved in flocculation
YAL062WCDS:VerifiedInvolved in glutamate biosynthesis
YAL061WCDS:Uncharacterizedputative polyol dehydrogenase

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