Schema for knownGene

Database: knownGeneV39 Primary Table: knownGene Row Count: 266,064 Data last updated: 2022-01-17
On download server: MariaDB table dump directory

field	example	SQL type	info
`name`	ENST00000619216.1	`varchar(255)`	values
`chrom`	chr1	`varchar(255)`	values
`strand`	-	`char(1)`	values
`txStart`	17368	`int(10) unsigned`	range
`txEnd`	17436	`int(10) unsigned`	range
`cdsStart`	17368	`int(10) unsigned`	range
`cdsEnd`	17368	`int(10) unsigned`	range
`exonCount`	1	`int(10) unsigned`	range
`exonStarts`	17368,	`longblob`
`exonEnds`	17436,	`longblob`
`proteinID`		`varchar(40)`	values
`alignID`	uc031tla.1	`varchar(255)`	values