Schema for knownGene
  Database: knownGeneV39    Primary Table: knownGene    Row Count: 266,064   Data last updated: 2022-01-17
Format description: GENCODE bigGenePred
On download server: MariaDB table dump directory
This track is available both in ASCII MariaDB table dump format and bigGenePred (bigBed) format.
bigBed File Download: https://hgdownload.soe.ucsc.edu/gbdb/hg38/gencode/gencodeV47.bb
fieldexampleSQL type info description
name ENST00000619216.1varchar(255) values Ensembl ID
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
strand -char(1) values + or - for strand
txStart 17368int(10) unsigned range  
txEnd 17436int(10) unsigned range  
cdsStart 17368int(10) unsigned range  
cdsEnd 17368int(10) unsigned range  
exonCount 1int(10) unsigned range  
exonStarts 17368,longblob    
exonEnds 17436,longblob    
proteinID  varchar(40) values  
alignID uc031tla.1varchar(255) values