Schema for knownCds
  Database: mm39    Primary Table: knownCds    Row Count: 264,588   Data last updated: 2024-08-15
Format description: The CDS part of a genePredExt.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000000001.5varchar(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 9int(10) unsigned range number of exons
exonFrames -1,1,0,2,2,0,2,1,0,longblob   Exon frame {0,1,2}, or -1 if no frame for exon

Connected Tables and Joining Fields
        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)
      mm39.bioCycPathway.kgID (via knownCds.name)
      mm39.ceBlastTab.query (via knownCds.name)
      mm39.dmBlastTab.query (via knownCds.name)
      mm39.drBlastTab.query (via knownCds.name)
      mm39.foldUtr3.name (via knownCds.name)
      mm39.foldUtr5.name (via knownCds.name)
      mm39.hgBlastTab.query (via knownCds.name)
      mm39.kgAlias.kgID (via knownCds.name)
      mm39.kgColor.kgID (via knownCds.name)
      mm39.kgProtAlias.kgID (via knownCds.name)
      mm39.kgSpAlias.kgID (via knownCds.name)
      mm39.kgTargetAli.qName (via knownCds.name)
      mm39.kgXref.kgID (via knownCds.name)
      mm39.knownAttrs.kgID (via knownCds.name)
      mm39.knownBlastTab.query (via knownCds.name)
      mm39.knownBlastTab.target (via knownCds.name)
      mm39.knownCanonical.transcript (via knownCds.name)
      mm39.knownGene.name (via knownCds.name)
      mm39.knownGeneMrna.name (via knownCds.name)
      mm39.knownIsoforms.transcript (via knownCds.name)
      mm39.knownToEnsembl.name (via knownCds.name)
      mm39.knownToLocusLink.name (via knownCds.name)
      mm39.knownToMrna.name (via knownCds.name)
      mm39.knownToMrnaSingle.name (via knownCds.name)
      mm39.knownToMupit.name (via knownCds.name)
      mm39.knownToNextProt.name (via knownCds.name)
      mm39.knownToPfam.name (via knownCds.name)
      mm39.knownToRefSeq.name (via knownCds.name)
      mm39.knownToSuper.gene (via knownCds.name)
      mm39.knownToTag.name (via knownCds.name)
      mm39.knownToVisiGene.name (via knownCds.name)
      mm39.knownToWikipedia.name (via knownCds.name)
      mm39.rnBlastTab.query (via knownCds.name)
      mm39.scBlastTab.query (via knownCds.name)
      mm39.ucscScop.ucscId (via knownCds.name)

Sample Rows
 
namecdsStartStatcdsEndStatexonCountexonFrames
ENSMUST00000000001.5cmplcmpl9-1,1,0,2,2,0,2,1,0,
ENSMUST00000000003.14cmplcmpl7-1,1,1,1,2,0,0,
ENSMUST00000000010.9cmplcmpl20,1,
ENSMUST00000000028.14cmplcmpl20-1,1,2,0,0,2,2,2,2,2,2,0,2,0,0,0,0,0,0,-1,
ENSMUST00000000033.12cmplcmpl40,1,0,-1,
ENSMUST00000000049.6cmplcmpl80,1,1,2,1,1,1,1,
ENSMUST00000000058.7cmplcmpl30,0,2,
ENSMUST00000000080.8cmplcmpl40,0,1,2,
ENSMUST00000000087.13cmplcmpl17-1,-1,-1,-1,0,1,0,1,0,1,0,1,1,1,1,1,0,
ENSMUST00000000090.8cmplcmpl50,1,1,0,-1,

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