Schema for knownCanonical
  Database: mm7    Primary Table: knownCanonical    Row Count: 18,908   Data last updated: 2005-11-14
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 55346int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 65931int(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_008483varchar(255) values Corresponds to knownGene name field.
protein LAMB2_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)
      mm7.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)
      mm7.dupSpMrna.dupProteinID (via knownCanonical.protein)
      mm7.dupSpMrna.proteinID (via knownCanonical.protein)
      mm7.kgProtAlias.displayID (via knownCanonical.protein)
      mm7.kgSpAlias.alias (via knownCanonical.protein)
      mm7.kgXref.spDisplayID (via knownCanonical.protein)
      mm7.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)
      mm7.affyGnfU74ADistance.query (via knownCanonical.transcript)
      mm7.affyGnfU74ADistance.target (via knownCanonical.transcript)
      mm7.affyGnfU74BDistance.query (via knownCanonical.transcript)
      mm7.affyGnfU74BDistance.target (via knownCanonical.transcript)
      mm7.affyGnfU74CDistance.query (via knownCanonical.transcript)
      mm7.affyGnfU74CDistance.target (via knownCanonical.transcript)
      mm7.dmBlastTab.query (via knownCanonical.transcript)
      mm7.drBlastTab.query (via knownCanonical.transcript)
      mm7.dupSpMrna.mrnaID (via knownCanonical.transcript)
      mm7.foldUtr3.name (via knownCanonical.transcript)
      mm7.foldUtr5.name (via knownCanonical.transcript)
      mm7.gnfAtlas2Distance.query (via knownCanonical.transcript)
      mm7.gnfAtlas2Distance.target (via knownCanonical.transcript)
      mm7.hgBlastTab.query (via knownCanonical.transcript)
      mm7.keggPathway.kgID (via knownCanonical.transcript)
      mm7.kgAlias.kgID (via knownCanonical.transcript)
      mm7.kgProtAlias.kgID (via knownCanonical.transcript)
      mm7.kgSpAlias.kgID (via knownCanonical.transcript)
      mm7.kgXref.kgID (via knownCanonical.transcript)
      mm7.knownBlastTab.query (via knownCanonical.transcript)
      mm7.knownBlastTab.target (via knownCanonical.transcript)
      mm7.knownGene.name (via knownCanonical.transcript)
      mm7.knownGeneLink.name (via knownCanonical.transcript)
      mm7.knownGeneMrna.name (via knownCanonical.transcript)
      mm7.knownGenePep.name (via knownCanonical.transcript)
      mm7.knownIsoforms.transcript (via knownCanonical.transcript)
      mm7.knownToAllenBrain.name (via knownCanonical.transcript)
      mm7.knownToEnsembl.name (via knownCanonical.transcript)
      mm7.knownToGnfAtlas2.name (via knownCanonical.transcript)
      mm7.knownToKeggEntrez.name (via knownCanonical.transcript)
      mm7.knownToLocusLink.name (via knownCanonical.transcript)
      mm7.knownToPfam.name (via knownCanonical.transcript)
      mm7.knownToRefSeq.name (via knownCanonical.transcript)
      mm7.knownToVisiGene.name (via knownCanonical.transcript)
      mm7.rnBlastTab.query (via knownCanonical.transcript)
      mm7.scBlastTab.query (via knownCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrUn_random55346659311NM_008483LAMB2_MOUSE
chrUn_random121378412196242AK141751Q3V462_MOUSE
chrUn_random150964415171643AK079850Q99N48-5
chrUn_random171022517247684NM_001004153Q5RJY3_MOUSE
chrUn_random185681118887475AJ245453Q9QYZ4_MOUSE
chrUn_random201811520199466NM_030740Q9EPS9_MOUSE
chrUn_random248492424868657BC089532Q5FWA1_MOUSE
chrUn_random342073134286428AK030037Q8CDH4_MOUSE
chrUn_random413161441335569BC089532Q5FWA1_MOUSE
chrUn_random4275534427744210AB055856GMCL2_MOUSE

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