Schema for knownGene

Database: hg19 Primary Table: knownGene Row Count: 639,948 Data last updated: 2026-07-16
Format description: Transcript from default gene set in UCSC browser
On download server: MariaDB table dump directory

field	example	SQL type	description
`name`	ENST00000833856.1_2	`varchar(255)`	Name of gene
`chrom`	chr1	`varchar(255)`	Reference sequence chromosome or scaffold
`strand`	+	`char(1)`	+ or - for strand
`txStart`	10369	`int(10) unsigned`	Transcription start position (or end position for minus strand item)
`txEnd`	10582	`int(10) unsigned`	Transcription end position (or start position for minus strand item)
`cdsStart`	10369	`int(10) unsigned`	Coding region start (or end position if for minus strand item)
`cdsEnd`	10369	`int(10) unsigned`	Coding region end (or start position if for minus strand item)
`exonCount`	2	`int(10) unsigned`	Number of exons
`exonStarts`	10369,10465,	`longblob`	Exon start positions (or end positions for minus strand item)
`exonEnds`	10377,10582,	`longblob`	Exon end positions (or start positions for minus strand item)
`proteinID`		`varchar(40)`	UniProt display ID, UniProt accession, or RefSeq protein ID
`alignID`	uc353afa.2	`varchar(255)`	Unique identifier (GENCODE transcript ID for GENCODE Basic)

Connected Tables and Joining Fields


	hg19.bioCycPathway.kgID (via knownGene.name) hg19.ceBlastTab.query (via knownGene.name) hg19.dmBlastTab.query (via knownGene.name) hg19.drBlastTab.query (via knownGene.name) hg19.foldUtr3.name (via knownGene.name) hg19.foldUtr5.name (via knownGene.name) hg19.gnfAtlas2Distance.query (via knownGene.name) hg19.gnfAtlas2Distance.target (via knownGene.name) hg19.gnfU95Distance.query (via knownGene.name) hg19.gnfU95Distance.target (via knownGene.name) hg19.humanHprdP2P.query (via knownGene.name) hg19.humanHprdP2P.target (via knownGene.name) hg19.humanVidalP2P.query (via knownGene.name) hg19.humanVidalP2P.target (via knownGene.name) hg19.humanWankerP2P.query (via knownGene.name) hg19.humanWankerP2P.target (via knownGene.name) hg19.keggPathway.kgID (via knownGene.name) hg19.kgAlias.kgID (via knownGene.name) hg19.kgColor.kgID (via knownGene.name) hg19.kgProtAlias.kgID (via knownGene.name) hg19.kgProtMap2.qName (via knownGene.name) hg19.kgSpAlias.kgID (via knownGene.name) hg19.kgTargetAli.qName (via knownGene.name) hg19.kgTxInfo.name (via knownGene.name) hg19.kgXref.kgID (via knownGene.name) hg19.knownAttrs.kgID (via knownGene.name) hg19.knownBlastTab.query (via knownGene.name) hg19.knownBlastTab.target (via knownGene.name) hg19.knownCanonical.transcript (via knownGene.name) hg19.knownCds.name (via knownGene.name) hg19.knownGeneMrna.name (via knownGene.name) hg19.knownGenePep.name (via knownGene.name) hg19.knownGeneTxMrna.name (via knownGene.name) hg19.knownGeneTxPep.name (via knownGene.name) hg19.knownIsoforms.transcript (via knownGene.name) hg19.knownToAllenBrain.name (via knownGene.name) hg19.knownToEnsembl.name (via knownGene.name) hg19.knownToGnfAtlas2.name (via knownGene.name) hg19.knownToHInv.name (via knownGene.name) hg19.knownToHprd.name (via knownGene.name) hg19.knownToKeggEntrez.name (via knownGene.name) hg19.knownToLocusLink.name (via knownGene.name) hg19.knownToLynx.name (via knownGene.name) hg19.knownToMrna.name (via knownGene.name) hg19.knownToMrnaSingle.name (via knownGene.name) hg19.knownToMupit.name (via knownGene.name) hg19.knownToNextProt.name (via knownGene.name) hg19.knownToPfam.name (via knownGene.name) hg19.knownToRefSeq.name (via knownGene.name) hg19.knownToSuper.gene (via knownGene.name) hg19.knownToTag.name (via knownGene.name) hg19.knownToTreefam.name (via knownGene.name) hg19.knownToU133.name (via knownGene.name) hg19.knownToU133Plus2.name (via knownGene.name) hg19.knownToU95.name (via knownGene.name) hg19.knownToVisiGene.name (via knownGene.name) hg19.knownToWikipedia.name (via knownGene.name) hg19.mmBlastTab.query (via knownGene.name) hg19.rnBlastTab.query (via knownGene.name) hg19.scBlastTab.query (via knownGene.name) hg19.ucscScop.ucscId (via knownGene.name) knownGeneV39.bioCycPathway.kgID (via knownGene.name) knownGeneV39.ceBlastTab.query (via knownGene.name) knownGeneV39.dmBlastTab.query (via knownGene.name) knownGeneV39.drBlastTab.query (via knownGene.name) knownGeneV39.foldUtr3.name (via knownGene.name) knownGeneV39.foldUtr5.name (via knownGene.name) knownGeneV39.gnfAtlas2Distance.query (via knownGene.name) knownGeneV39.gnfAtlas2Distance.target (via knownGene.name) knownGeneV39.kgAlias.kgID (via knownGene.name) knownGeneV39.kgColor.kgID (via knownGene.name) knownGeneV39.kgProtAlias.kgID (via knownGene.name) knownGeneV39.kgSpAlias.kgID (via knownGene.name) knownGeneV39.kgTargetAli.qName (via knownGene.name) knownGeneV39.kgXref.kgID (via knownGene.name) knownGeneV39.knownAttrs.kgID (via knownGene.name) knownGeneV39.knownBlastTab.query (via knownGene.name) knownGeneV39.knownBlastTab.target (via knownGene.name) knownGeneV39.knownCanonical.protein (via knownGene.name) knownGeneV39.knownCanonical.transcript (via knownGene.name) knownGeneV39.knownCds.name (via knownGene.name) knownGeneV39.knownGene.name (via knownGene.name) knownGeneV39.knownGeneMrna.name (via knownGene.name) knownGeneV39.knownGenePep.name (via knownGene.name) knownGeneV39.knownIsoforms.transcript (via knownGene.name) knownGeneV39.knownToEnsembl.name (via knownGene.name) knownGeneV39.knownToGnfAtlas2.name (via knownGene.name) knownGeneV39.knownToHprd.name (via knownGene.name) knownGeneV39.knownToLocusLink.name (via knownGene.name) knownGeneV39.knownToMrna.name (via knownGene.name) knownGeneV39.knownToMrnaSingle.name (via knownGene.name) knownGeneV39.knownToMupit.name (via knownGene.name) knownGeneV39.knownToPfam.name (via knownGene.name) knownGeneV39.knownToRefSeq.name (via knownGene.name) knownGeneV39.knownToSuper.gene (via knownGene.name) knownGeneV39.knownToTag.name (via knownGene.name) knownGeneV39.knownToU133.name (via knownGene.name) knownGeneV39.knownToU95.name (via knownGene.name) knownGeneV39.knownToVisiGene.name (via knownGene.name) knownGeneV39.knownToWikipedia.name (via knownGene.name) knownGeneV39.mmBlastTab.query (via knownGene.name) knownGeneV39.rnBlastTab.query (via knownGene.name) knownGeneV39.scBlastTab.query (via knownGene.name) knownGeneV39.ucscScop.ucscId (via knownGene.name)

Sample Rows

name	chrom	strand	txStart	txEnd	cdsStart	cdsEnd	exonCount	exonStarts	exonEnds	alignID
ENST00000833856.1_2	chr1	+	10369	10582	10369	10369	2	10369,10465,	10377,10582,	uc353afa.2
ENST00000832824.1_1	chr1	+	11120	14413	11120	11120	4	11120,12009,12612,13452,	11211,12227,12721,14413,	uc352yrt.1
ENST00000832825.1_1	chr1	+	11124	14405	11124	11124	4	11124,12009,12612,13402,	11211,12227,12721,14405,	uc352yru.1
ENST00000832826.1_1	chr1	+	11409	14413	11409	11409	4	11409,12009,12594,13482,	11671,12227,12721,14413,	uc352yrv.1
ENST00000832827.1_1	chr1	+	11410	14413	11410	11410	4	11410,12009,12612,13482,	11671,12227,12721,14413,	uc352yrw.1
ENST00000832828.1_1	chr1	+	11425	14409	11425	11425	4	11425,12009,12612,13220,	11671,12227,12721,14409,	uc352yrx.1
ENST00000832829.1_1	chr1	+	11769	14416	11769	11769	4	11769,12009,12612,13482,	11844,12227,12721,14416,	uc352yry.1
ENST00000832830.1_1	chr1	+	11818	14413	11818	11818	4	11818,12009,12612,13482,	11844,12227,12697,14413,	uc352yrz.1
ENST00000832837.1_1	chr1	+	11822	14406	11822	11822	4	11822,12009,12594,13220,	11844,12227,12721,14406,	uc352ysg.1
ENST00000832836.1_1	chr1	+	11823	14409	11823	11823	3	11823,12009,13482,	11844,12697,14409,	uc352ysf.1

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