Schema for refFlat

Database: mm10 Primary Table: refFlat Row Count: 47,382 Data last updated: 2020-08-18
Format description: A gene prediction with additional geneName field.
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`geneName`	Wdsub1	`varchar(255)`	values	Name of gene as it appears in genome browser.
`name`	NM_001159636	`varchar(255)`	values	Name of gene
`chrom`	chr2	`varchar(255)`	values	Reference sequence chromosome or scaffold
`strand`	-	`char(1)`	values	+ or - for strand
`txStart`	59855193	`int(10) unsigned`	range	Transcription start position (or end position for minus strand item)
`txEnd`	59882606	`int(10) unsigned`	range	Transcription end position (or start position for minus strand item)
`cdsStart`	59855270	`int(10) unsigned`	range	Coding region start (or end position for minus strand item)
`cdsEnd`	59878527	`int(10) unsigned`	range	Coding region end (or start position for minus strand item)
`exonCount`	11	`int(10) unsigned`	range	Number of exons
`exonStarts`	59855193,59858609,59861560,...	`longblob`		Exon start positions (or end positions for minus strand item)
`exonEnds`	59855275,59858750,59861737,...	`longblob`		Exon end positions (or start positions for minus strand item)