Schema for knownCds
  Database: hg38    Primary Table: knownCds    Row Count: 258,053   Data last updated: 2023-08-22
Format description: The CDS part of a genePredExt.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000000233.10varchar(255) values Name of gene
cdsStartStat cmplvarchar(255) values Status of CDS start annotation (none, unknown, incomplete, or complete)
cdsEndStat cmplvarchar(255) values Status of CDS end annotation (none, unknown, incomplete, or complete)
exonCount 6int(10) unsigned range 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
 
namecdsStartStatcdsEndStatexonCountexonFrames
ENST00000000233.10cmplcmpl60,1,1,0,0,0,
ENST00000000412.8cmplcmpl70,2,0,1,2,0,-1,
ENST00000000442.11cmplcmpl7-1,0,1,1,1,1,1,
ENST00000001008.6cmplcmpl100,0,1,0,1,2,0,0,0,0,
ENST00000001146.7cmplcmpl60,0,0,0,0,0,
ENST00000002125.9cmplcmpl100,1,0,0,0,1,0,0,0,0,
ENST00000002165.11cmplcmpl70,2,0,2,1,2,0,
ENST00000002501.11cmplcmpl41,1,1,0,
ENST00000002596.6cmplcmpl20,-1,
ENST00000002829.8cmplcmpl19-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.