Schema for knownCds

Database: hg38 Primary Table: knownCds Row Count: 516,441 Data last updated: 2025-09-26
Format description: The CDS part of a genePredExt.
On download server: MariaDB table dump directory

field	example	SQL type	description
`name`	ENST00000000233.10	`varchar(255)`	Name of gene
`cdsStartStat`	cmpl	`varchar(255)`	Status of CDS start annotation (none, unknown, incomplete, or complete)
`cdsEndStat`	cmpl	`varchar(255)`	Status of CDS end annotation (none, unknown, incomplete, or complete)
`exonCount`	6	`int(10) unsigned`	number of exons
`exonFrames`	0,1,1,0,0,0,	`longblob`	Exon frame {0,1,2}, or -1 if no frame for exon

Connected Tables and Joining Fields


	hg38.bioCycPathway.kgID (via knownCds.name) hg38.ccdsKgMap.geneId (via knownCds.name) hg38.ceBlastTab.query (via knownCds.name) hg38.dmBlastTab.query (via knownCds.name) hg38.drBlastTab.query (via knownCds.name) hg38.foldUtr3.name (via knownCds.name) hg38.foldUtr5.name (via knownCds.name) hg38.gnfAtlas2Distance.query (via knownCds.name) hg38.gnfAtlas2Distance.target (via knownCds.name) hg38.gnfU95Distance.query (via knownCds.name) hg38.gnfU95Distance.target (via knownCds.name) hg38.humanHprdP2P.query (via knownCds.name) hg38.humanHprdP2P.target (via knownCds.name) hg38.humanVidalP2P.query (via knownCds.name) hg38.humanVidalP2P.target (via knownCds.name) hg38.humanWankerP2P.query (via knownCds.name) hg38.humanWankerP2P.target (via knownCds.name) hg38.keggPathway.kgID (via knownCds.name) hg38.kgAlias.kgID (via knownCds.name) hg38.kgColor.kgID (via knownCds.name) hg38.kgProtAlias.kgID (via knownCds.name) hg38.kgSpAlias.kgID (via knownCds.name) hg38.kgTargetAli.qName (via knownCds.name) hg38.kgXref.kgID (via knownCds.name) hg38.knownAttrs.kgID (via knownCds.name) hg38.knownBlastTab.query (via knownCds.name) hg38.knownBlastTab.target (via knownCds.name) hg38.knownCanonical.transcript (via knownCds.name) hg38.knownGene.name (via knownCds.name) hg38.knownGeneMrna.name (via knownCds.name) hg38.knownGenePep.name (via knownCds.name) hg38.knownIsoforms.transcript (via knownCds.name) hg38.knownToEnsembl.name (via knownCds.name) hg38.knownToGnfAtlas2.name (via knownCds.name) hg38.knownToHprd.name (via knownCds.name) hg38.knownToKeggEntrez.name (via knownCds.name) hg38.knownToLocusLink.name (via knownCds.name) hg38.knownToLynx.name (via knownCds.name) hg38.knownToMrna.name (via knownCds.name) hg38.knownToMrnaSingle.name (via knownCds.name) hg38.knownToMupit.name (via knownCds.name) hg38.knownToNextProt.name (via knownCds.name) hg38.knownToPfam.name (via knownCds.name) hg38.knownToRefSeq.name (via knownCds.name) hg38.knownToSuper.gene (via knownCds.name) hg38.knownToTag.name (via knownCds.name) hg38.knownToU133.name (via knownCds.name) hg38.knownToU95.name (via knownCds.name) hg38.knownToVisiGene.name (via knownCds.name) hg38.knownToWikipedia.name (via knownCds.name) hg38.mmBlastTab.query (via knownCds.name) hg38.rnBlastTab.query (via knownCds.name) hg38.scBlastTab.query (via knownCds.name) hg38.ucscScop.ucscId (via knownCds.name) knownGeneV39.bioCycPathway.kgID (via knownCds.name) knownGeneV39.ceBlastTab.query (via knownCds.name) knownGeneV39.dmBlastTab.query (via knownCds.name) knownGeneV39.drBlastTab.query (via knownCds.name) knownGeneV39.foldUtr3.name (via knownCds.name) knownGeneV39.foldUtr5.name (via knownCds.name) knownGeneV39.gnfAtlas2Distance.query (via knownCds.name) knownGeneV39.gnfAtlas2Distance.target (via knownCds.name) knownGeneV39.kgAlias.kgID (via knownCds.name) knownGeneV39.kgColor.kgID (via knownCds.name) knownGeneV39.kgProtAlias.kgID (via knownCds.name) knownGeneV39.kgSpAlias.kgID (via knownCds.name) knownGeneV39.kgTargetAli.qName (via knownCds.name) knownGeneV39.kgXref.kgID (via knownCds.name) knownGeneV39.knownAttrs.kgID (via knownCds.name) knownGeneV39.knownBlastTab.query (via knownCds.name) knownGeneV39.knownBlastTab.target (via knownCds.name) knownGeneV39.knownCanonical.protein (via knownCds.name) knownGeneV39.knownCanonical.transcript (via knownCds.name) knownGeneV39.knownCds.name (via knownCds.name) knownGeneV39.knownGene.name (via knownCds.name) knownGeneV39.knownGeneMrna.name (via knownCds.name) knownGeneV39.knownGenePep.name (via knownCds.name) knownGeneV39.knownIsoforms.transcript (via knownCds.name) knownGeneV39.knownToEnsembl.name (via knownCds.name) knownGeneV39.knownToGnfAtlas2.name (via knownCds.name) knownGeneV39.knownToHprd.name (via knownCds.name) knownGeneV39.knownToLocusLink.name (via knownCds.name) knownGeneV39.knownToMrna.name (via knownCds.name) knownGeneV39.knownToMrnaSingle.name (via knownCds.name) knownGeneV39.knownToMupit.name (via knownCds.name) knownGeneV39.knownToPfam.name (via knownCds.name) knownGeneV39.knownToRefSeq.name (via knownCds.name) knownGeneV39.knownToSuper.gene (via knownCds.name) knownGeneV39.knownToTag.name (via knownCds.name) knownGeneV39.knownToU133.name (via knownCds.name) knownGeneV39.knownToU95.name (via knownCds.name) knownGeneV39.knownToVisiGene.name (via knownCds.name) knownGeneV39.knownToWikipedia.name (via knownCds.name) knownGeneV39.mmBlastTab.query (via knownCds.name) knownGeneV39.rnBlastTab.query (via knownCds.name) knownGeneV39.scBlastTab.query (via knownCds.name) knownGeneV39.ucscScop.ucscId (via knownCds.name)

Sample Rows

name	cdsStartStat	cdsEndStat	exonCount	exonFrames
ENST00000000233.10	cmpl	cmpl	6	0,1,1,0,0,0,
ENST00000000412.8	cmpl	cmpl	7	0,2,0,1,2,0,-1,
ENST00000000442.11	cmpl	cmpl	7	-1,0,1,1,1,1,1,
ENST00000001008.6	cmpl	cmpl	10	0,0,1,0,1,2,0,0,0,0,
ENST00000001146.7	cmpl	cmpl	6	0,0,0,0,0,0,
ENST00000002125.9	cmpl	cmpl	10	0,1,0,0,0,1,0,0,0,0,
ENST00000002165.11	cmpl	cmpl	7	0,2,0,2,1,2,0,
ENST00000002501.11	cmpl	cmpl	4	1,1,1,0,
ENST00000002596.6	cmpl	cmpl	2	0,-1,
ENST00000002829.8	cmpl	cmpl	19	-1,0,1,0,0,0,0,1,1,0,1,2,0,1,0,0,2,1,0,

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