Database: hg19    Primary Table: knownCanonical    Row Count: 27,297
Format description: Describes the canonical splice variant of a gene

field	example	SQL type	info	description
chrom	chr1	varchar(255)	values	Chromosome
chromStart	11873	int(11)	range	Start position (0 based). Corresponds to txStart
chromEnd	14409	int(11)	range	End position (non-inclusive). Corresponds to txEnd
clusterId	1	int(11)	range	Which cluster of transcripts this belongs to in knownIsoforms
transcript	uc010nxq.1	varchar(255)	values	Corresponds to knownGene name field.
protein	uc010nxq.1	varchar(255)	values	SwissProt ID of associated protein.

      hg19.knownIsoforms.clusterId (via knownCanonical.clusterId)
      hg19.bioCycPathway.kgID (via knownCanonical.transcript)
      hg19.ccdsKgMap.geneId (via knownCanonical.transcript)
      hg19.ceBlastTab.query (via knownCanonical.transcript)
      hg19.dmBlastTab.query (via knownCanonical.transcript)
      hg19.drBlastTab.query (via knownCanonical.transcript)
      hg19.foldUtr3.name (via knownCanonical.transcript)
      hg19.foldUtr5.name (via knownCanonical.transcript)
      hg19.gnfAtlas2Distance.query (via knownCanonical.transcript)
      hg19.gnfAtlas2Distance.target (via knownCanonical.transcript)
      hg19.humanHprdP2P.query (via knownCanonical.transcript)
      hg19.humanHprdP2P.target (via knownCanonical.transcript)
      hg19.humanVidalP2P.query (via knownCanonical.transcript)
      hg19.humanVidalP2P.target (via knownCanonical.transcript)
      hg19.humanWankerP2P.query (via knownCanonical.transcript)
      hg19.humanWankerP2P.target (via knownCanonical.transcript)
      hg19.keggPathway.kgID (via knownCanonical.transcript)
      hg19.kg4ToKg5.newId (via knownCanonical.transcript)
      hg19.kgAlias.kgID (via knownCanonical.transcript)
      hg19.kgColor.kgID (via knownCanonical.transcript)
      hg19.kgProtAlias.kgID (via knownCanonical.transcript)
      hg19.kgProtMap2.qName (via knownCanonical.transcript)
      hg19.kgSpAlias.kgID (via knownCanonical.transcript)
      hg19.kgTargetAli.qName (via knownCanonical.transcript)
      hg19.kgTxInfo.name (via knownCanonical.transcript)
      hg19.kgXref.kgID (via knownCanonical.transcript)
      hg19.knownBlastTab.query (via knownCanonical.transcript)
      hg19.knownBlastTab.target (via knownCanonical.transcript)
      hg19.knownGene.name (via knownCanonical.transcript)
      hg19.knownGeneMrna.name (via knownCanonical.transcript)
      hg19.knownGenePep.name (via knownCanonical.transcript)
      hg19.knownIsoforms.transcript (via knownCanonical.transcript)
      hg19.knownToAllenBrain.name (via knownCanonical.transcript)
      hg19.knownToEnsembl.name (via knownCanonical.transcript)
      hg19.knownToGnfAtlas2.name (via knownCanonical.transcript)
      hg19.knownToHprd.name (via knownCanonical.transcript)
      hg19.knownToLocusLink.name (via knownCanonical.transcript)
      hg19.knownToPfam.name (via knownCanonical.transcript)
      hg19.knownToRefSeq.name (via knownCanonical.transcript)
      hg19.knownToSuper.gene (via knownCanonical.transcript)
      hg19.knownToTreefam.name (via knownCanonical.transcript)
      hg19.knownToU133.name (via knownCanonical.transcript)
      hg19.knownToVisiGene.name (via knownCanonical.transcript)
      hg19.mmBlastTab.query (via knownCanonical.transcript)
      hg19.rnBlastTab.query (via knownCanonical.transcript)
      hg19.scBlastTab.query (via knownCanonical.transcript)

chrom	chromStart	chromEnd	clusterId	transcript	protein
chr1	11873	14409	1	uc010nxq.1	uc010nxq.1
chr1	14362	19759	2	uc009viu.2	uc009viu.2
chr1	14406	29370	3	uc009viw.2	uc009viw.2
chr1	34611	36081	4	uc001aak.2	uc001aak.2
chr1	69090	70008	5	uc001aal.1	uc001aal.1
chr1	89294	237877	6	uc010nxt.1	uc010nxt.1
chr1	137838	139228	7	uc001aam.3	uc001aam.3
chr1	321083	321114	8	uc001aaq.1	uc001aaq.1
chr1	321145	321223	9	uc001aar.1	uc001aar.1
chr1	322036	326938	10	uc009vjk.2	uc009vjk.2

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