Schema for knownCanonical
  Database: mm8    Primary Table: knownCanonical    Row Count: 19,199   Data last updated: 2006-03-08
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chrUn_randomvarchar(255) values Chromosome
chromStart 1505369int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 1522930int(11) range End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
clusterId 1int(10) unsigned range Which cluster of transcripts this belongs to in knownIsoforms
transcript NM_030175varchar(255) values Corresponds to knownGene name field.
protein Q9D2G9_MOUSEvarchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        knownGeneV39.knownCanonical.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownCanonical.clusterId)
      mm8.knownIsoforms.clusterId (via knownCanonical.clusterId)
      go.goaPart.dbObjectSymbol (via knownCanonical.protein)
      knownGeneV39.kgProtAlias.displayID (via knownCanonical.protein)
      knownGeneV39.kgSpAlias.alias (via knownCanonical.protein)
      knownGeneV39.kgXref.spDisplayID (via knownCanonical.protein)
      knownGeneV39.knownCanonical.protein (via knownCanonical.protein)
      mm8.dupSpMrna.dupProteinID (via knownCanonical.protein)
      mm8.dupSpMrna.proteinID (via knownCanonical.protein)
      mm8.kgProtAlias.displayID (via knownCanonical.protein)
      mm8.kgSpAlias.alias (via knownCanonical.protein)
      mm8.kgXref.spDisplayID (via knownCanonical.protein)
      mm8.spMrna.spID (via knownCanonical.protein)
      proteome.spOldNew.newDisplayId (via knownCanonical.protein)
      proteome.spOldNew.oldDisplayId (via knownCanonical.protein)
      uniProt.displayId.val (via knownCanonical.protein)
      knownGeneV39.bioCycPathway.kgID (via knownCanonical.transcript)
      knownGeneV39.ceBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.dmBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.drBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.foldUtr3.name (via knownCanonical.transcript)
      knownGeneV39.foldUtr5.name (via knownCanonical.transcript)
      knownGeneV39.gnfAtlas2Distance.query (via knownCanonical.transcript)
      knownGeneV39.gnfAtlas2Distance.target (via knownCanonical.transcript)
      knownGeneV39.kgAlias.kgID (via knownCanonical.transcript)
      knownGeneV39.kgColor.kgID (via knownCanonical.transcript)
      knownGeneV39.kgProtAlias.kgID (via knownCanonical.transcript)
      knownGeneV39.kgSpAlias.kgID (via knownCanonical.transcript)
      knownGeneV39.kgTargetAli.qName (via knownCanonical.transcript)
      knownGeneV39.kgXref.kgID (via knownCanonical.transcript)
      knownGeneV39.knownAttrs.kgID (via knownCanonical.transcript)
      knownGeneV39.knownBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.knownBlastTab.target (via knownCanonical.transcript)
      knownGeneV39.knownCanonical.protein (via knownCanonical.transcript)
      knownGeneV39.knownCanonical.transcript (via knownCanonical.transcript)
      knownGeneV39.knownCds.name (via knownCanonical.transcript)
      knownGeneV39.knownGene.name (via knownCanonical.transcript)
      knownGeneV39.knownGeneMrna.name (via knownCanonical.transcript)
      knownGeneV39.knownGenePep.name (via knownCanonical.transcript)
      knownGeneV39.knownIsoforms.transcript (via knownCanonical.transcript)
      knownGeneV39.knownToEnsembl.name (via knownCanonical.transcript)
      knownGeneV39.knownToGnfAtlas2.name (via knownCanonical.transcript)
      knownGeneV39.knownToHprd.name (via knownCanonical.transcript)
      knownGeneV39.knownToLocusLink.name (via knownCanonical.transcript)
      knownGeneV39.knownToMrna.name (via knownCanonical.transcript)
      knownGeneV39.knownToMrnaSingle.name (via knownCanonical.transcript)
      knownGeneV39.knownToMupit.name (via knownCanonical.transcript)
      knownGeneV39.knownToPfam.name (via knownCanonical.transcript)
      knownGeneV39.knownToRefSeq.name (via knownCanonical.transcript)
      knownGeneV39.knownToSuper.gene (via knownCanonical.transcript)
      knownGeneV39.knownToTag.name (via knownCanonical.transcript)
      knownGeneV39.knownToU133.name (via knownCanonical.transcript)
      knownGeneV39.knownToU95.name (via knownCanonical.transcript)
      knownGeneV39.knownToVisiGene.name (via knownCanonical.transcript)
      knownGeneV39.knownToWikipedia.name (via knownCanonical.transcript)
      knownGeneV39.mmBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.rnBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.scBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.ucscScop.ucscId (via knownCanonical.transcript)
      mm8.affyGnfU74ADistance.query (via knownCanonical.transcript)
      mm8.affyGnfU74ADistance.target (via knownCanonical.transcript)
      mm8.affyGnfU74BDistance.query (via knownCanonical.transcript)
      mm8.affyGnfU74BDistance.target (via knownCanonical.transcript)
      mm8.affyGnfU74CDistance.query (via knownCanonical.transcript)
      mm8.affyGnfU74CDistance.target (via knownCanonical.transcript)
      mm8.ccdsKgMap.geneId (via knownCanonical.transcript)
      mm8.ceBlastTab.query (via knownCanonical.transcript)
      mm8.dmBlastTab.query (via knownCanonical.transcript)
      mm8.drBlastTab.query (via knownCanonical.transcript)
      mm8.dupSpMrna.mrnaID (via knownCanonical.transcript)
      mm8.foldUtr3.name (via knownCanonical.transcript)
      mm8.foldUtr5.name (via knownCanonical.transcript)
      mm8.gnfAtlas2Distance.query (via knownCanonical.transcript)
      mm8.gnfAtlas2Distance.target (via knownCanonical.transcript)
      mm8.hgBlastTab.query (via knownCanonical.transcript)
      mm8.keggPathway.kgID (via knownCanonical.transcript)
      mm8.kgAlias.kgID (via knownCanonical.transcript)
      mm8.kgProtAlias.kgID (via knownCanonical.transcript)
      mm8.kgSpAlias.kgID (via knownCanonical.transcript)
      mm8.kgTargetAli.qName (via knownCanonical.transcript)
      mm8.kgXref.kgID (via knownCanonical.transcript)
      mm8.knownBlastTab.query (via knownCanonical.transcript)
      mm8.knownBlastTab.target (via knownCanonical.transcript)
      mm8.knownGene.name (via knownCanonical.transcript)
      mm8.knownGeneMrna.name (via knownCanonical.transcript)
      mm8.knownGenePep.name (via knownCanonical.transcript)
      mm8.knownIsoforms.transcript (via knownCanonical.transcript)
      mm8.knownToAllenBrain.name (via knownCanonical.transcript)
      mm8.knownToEnsembl.name (via knownCanonical.transcript)
      mm8.knownToGnfAtlas2.name (via knownCanonical.transcript)
      mm8.knownToKeggEntrez.name (via knownCanonical.transcript)
      mm8.knownToLocusLink.name (via knownCanonical.transcript)
      mm8.knownToPfam.name (via knownCanonical.transcript)
      mm8.knownToRefSeq.name (via knownCanonical.transcript)
      mm8.knownToSuper.gene (via knownCanonical.transcript)
      mm8.knownToVisiGene.name (via knownCanonical.transcript)
      mm8.rnBlastTab.query (via knownCanonical.transcript)
      mm8.scBlastTab.query (via knownCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrUn_random150536915229301NM_030175Q9D2G9_MOUSE
chrUn_random26621316622NM_001030293Q3UUD2_MOUSE
chrUn_random2999263013263NM_153523O70518_MOUSE
chrUn_random3093533144584NM_001037925Q3V185_MOUSE
chrUn_random4234174307605NM_172505Q497U3_MOUSE
chrUn_random4915565100696NM_027861Q8K2Q7_MOUSE
chrUn_random5660575688387NM_026136Q9D5E3_MOUSE
chrUn_random6252006256718NM_053112Q923L6_MOUSE
chrUn_random8227788242539NM_001008551Q5U445_MOUSE
chrUn_random94082594275410NM_027955GMCL2_MOUSE

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