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

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

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