Schema for sgdDescription
  Database: sacCer3    Primary Table: sgdDescription    Row Count: 6,691   Data last updated: 2011-08-29
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 genevarchar(255) values Type of feature from gff3 file
description Dubious mitochondrial open ...longblob   Description of feature

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

Sample Rows
 
nametypedescription
Q0010geneDubious mitochondrial open reading frame unlikely to encode a protein, based on available experimental and comparative sequence ...
Q0017geneDubious mitochondrial open reading frame unlikely to encode a protein, based on available experimental and comparative sequence ...
Q0032geneDubious open reading frame unlikely to encode a protein, based on available experimental and comparative sequence data
Q0045geneSubunit I of cytochrome c oxidase, which is the terminal member of the mitochondrial inner membrane electron transport chain  on ...
Q0050geneReverse transcriptase required for splicing of the COX1 pre-mRNA, encoded by a mobile group II intron within the mitochondrial C ...
Q0055geneReverse transcriptase required for splicing of the COX1 pre-mRNA, encoded by a mobile group II intron within the mitochondrial C ...
Q0060geneEndonuclease I-SceIII, encoded by a mobile group I intron within the mitochondrial COX1 gene
Q0065geneEndonuclease I-SceII, encoded by a mobile group I intron within the mitochondrial COX1 gene  intron is normally spliced by the B ...
Q0070geneEndonuclease I-SceIV, involved in intron mobility  encoded by a mobile group I intron within the mitochondrial COX1 gene
Q0075geneProtein 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.