Schema for sgdDescription
  Database: sacCer2    Primary Table: sgdDescription    Row Count: 6,716   Data last updated: 2009-02-24
Format description: Description of SGD Genes and Other Features
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name Q0010varchar(10) values Name in sgdGene or sgdOther table
type CDSvarchar(255) values Type of feature from gff3 file
description Dubious mitochondrial open ...longblob   Description of feature

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

Sample Rows
 
nametypedescription
Q0010CDSDubious mitochondrial open reading frame unlikely to encode a protein, based on available experimental and comparative sequence ...
Q0017CDSDubious mitochondrial open reading frame unlikely to encode a protein, based on available experimental and comparative sequence ...
Q0032CDSDubious open reading frame unlikely to encode a protein, based on available experimental and comparative sequence data
Q0045CDSSubunit I of cytochrome c oxidase, which is the terminal member of the mitochondrial inner membrane electron transport chain  on ...
Q0050CDSReverse transcriptase required for splicing of the COX1 pre-mRNA, encoded by a mobile group II intron within the mitochondrial C ...
Q0055CDSReverse transcriptase required for splicing of the COX1 pre-mRNA, encoded by a mobile group II intron within the mitochondrial C ...
Q0060CDSEndonuclease I-SceIII, encoded by a mobile group I intron within the mitochondrial COX1 gene
Q0065CDSEndonuclease I-SceII, encoded by a mobile group I intron within the mitochondrial COX1 gene  intron is normally spliced by the B ...
Q0070CDSEndonuclease I-SceIV, involved in intron mobility  encoded by a mobile group I intron within the mitochondrial COX1 gene
Q0075CDSProtein of unknown function, encoded within an intron of the mitochondrial COX1 gene  translational initiation codon is predicte ...

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