Schema for sgdDescription

Database: sacCer3 Primary Table: sgdDescription Row Count: 6,691 Data last updated: 2011-08-30
Format description: Description of SGD Genes and Other Features
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`name`	Q0010	`varchar(10)`	values	Name in sgdGene or sgdOther table
`type`	gene	`varchar(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

name	type	description
Q0010	gene	Dubious mitochondrial open reading frame unlikely to encode a protein, based on available experimental and comparative sequence ...
Q0017	gene	Dubious mitochondrial open reading frame unlikely to encode a protein, based on available experimental and comparative sequence ...
Q0032	gene	Dubious open reading frame unlikely to encode a protein, based on available experimental and comparative sequence data
Q0045	gene	Subunit I of cytochrome c oxidase, which is the terminal member of the mitochondrial inner membrane electron transport chain on ...
Q0050	gene	Reverse transcriptase required for splicing of the COX1 pre-mRNA, encoded by a mobile group II intron within the mitochondrial C ...
Q0055	gene	Reverse transcriptase required for splicing of the COX1 pre-mRNA, encoded by a mobile group II intron within the mitochondrial C ...
Q0060	gene	Endonuclease I-SceIII, encoded by a mobile group I intron within the mitochondrial COX1 gene
Q0065	gene	Endonuclease I-SceII, encoded by a mobile group I intron within the mitochondrial COX1 gene intron is normally spliced by the B ...
Q0070	gene	Endonuclease I-SceIV, involved in intron mobility encoded by a mobile group I intron within the mitochondrial COX1 gene
Q0075	gene	Protein 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.