Schema for knownCanonical
  Database: rn3    Primary Table: knownCanonical    Row Count: 6,668   Data last updated: 2004-04-06
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chr1varchar(255) values Chromosome
chromStart 1306645int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 1307637int(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 AY389467varchar(255) values Corresponds to knownGene name field.
protein AAR26470varchar(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)
      rn3.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)
      proteome.spOldNew.newDisplayId (via knownCanonical.protein)
      proteome.spOldNew.oldDisplayId (via knownCanonical.protein)
      rn3.dupSpMrna.dupProteinID (via knownCanonical.protein)
      rn3.dupSpMrna.proteinID (via knownCanonical.protein)
      rn3.kgProtAlias.displayID (via knownCanonical.protein)
      rn3.kgSpAlias.alias (via knownCanonical.protein)
      rn3.kgXref.spDisplayID (via knownCanonical.protein)
      rn3.spMrna.spID (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)
      rn3.dmBlastTab.query (via knownCanonical.transcript)
      rn3.drBlastTab.query (via knownCanonical.transcript)
      rn3.dupSpMrna.mrnaID (via knownCanonical.transcript)
      rn3.gnfAtlas2Distance.query (via knownCanonical.transcript)
      rn3.gnfAtlas2Distance.target (via knownCanonical.transcript)
      rn3.hgBlastTab.query (via knownCanonical.transcript)
      rn3.keggPathway.kgID (via knownCanonical.transcript)
      rn3.kgAlias.kgID (via knownCanonical.transcript)
      rn3.kgProtAlias.kgID (via knownCanonical.transcript)
      rn3.kgSpAlias.kgID (via knownCanonical.transcript)
      rn3.kgXref.kgID (via knownCanonical.transcript)
      rn3.knownBlastTab.query (via knownCanonical.transcript)
      rn3.knownBlastTab.target (via knownCanonical.transcript)
      rn3.knownGene.name (via knownCanonical.transcript)
      rn3.knownGeneLink.name (via knownCanonical.transcript)
      rn3.knownGeneMrna.name (via knownCanonical.transcript)
      rn3.knownGenePep.name (via knownCanonical.transcript)
      rn3.knownIsoforms.transcript (via knownCanonical.transcript)
      rn3.knownToEnsembl.name (via knownCanonical.transcript)
      rn3.knownToGnfAtlas2.name (via knownCanonical.transcript)
      rn3.knownToLocusLink.name (via knownCanonical.transcript)
      rn3.knownToPfam.name (via knownCanonical.transcript)
      rn3.knownToRefSeq.name (via knownCanonical.transcript)
      rn3.knownToSuper.gene (via knownCanonical.transcript)
      rn3.scBlastTab.query (via knownCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chr1130664513076371AY389467AAR26470
chr1605155761723132AF347030Q91XQ2
chr1788267379225023U72620P70616
chr1878301590323514D37951Q63725
chr1961424796272575U37058NMBR_RAT
chr112721563127231806AF361476Q99MA1
chr112805345128072957U15425Q62700
chr114846482148649588BC062039AAH62039
chr114877649148910059AJ555485Q7TNI4
chr1155838491566585210AY325172Q7TP73

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