Schema for knownCanonical

Database: mm10 Primary Table: knownCanonical Row Count: 55,421 Data last updated: 2019-09-20
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`chrom`	chr3	`varchar(255)`	values	Chromosome
`chromStart`	108107279	`int(11)`	range	Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
`chromEnd`	108146146	`int(11)`	range	End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
`clusterId`	1	`int(11)`	range	Which cluster of transcripts this belongs to in knownIsoforms
`transcript`	ENSMUST00000000001.4	`varchar(255)`	values	Corresponds to knownGene name field.
`protein`	ENSMUSG00000000001.4	`varchar(255)`	values	Accession of the associated protein, or UCSC ID in newer tables.