Schema for ensGene

Database: macEug1 Primary Table: ensGene Row Count: 53,057 Data last updated: 2012-08-24
On download server: MariaDB table dump directory

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`name`	ENSMEUT00000010658	`varchar(255)`	values
`chrom`	Scaffold10	`varchar(255)`	values
`strand`	-	`char(1)`	values
`txStart`	48310	`int(10) unsigned`	range
`txEnd`	48444	`int(10) unsigned`	range
`cdsStart`	48310	`int(10) unsigned`	range
`cdsEnd`	48444	`int(10) unsigned`	range
`exonCount`	1	`int(10) unsigned`	range
`exonStarts`	48310,	`longblob`
`exonEnds`	48444,	`longblob`
`score`	0	`int(11)`	range
`name2`	ENSMEUG00000010607	`varchar(255)`	values
`cdsStartStat`	incmpl	`enum('none', 'unk', 'incmpl', 'cmpl')`	values
`cdsEndStat`	incmpl	`enum('none', 'unk', 'incmpl', 'cmpl')`	values
`exonFrames`	0,	`longblob`

To download this table in different text formats or to intersect or correlate it with other tables, use the Table Browser.

Connected Tables and Joining Fields


	knownGeneV39.knownToEnsembl.value (via ensGene.name) macEug1.ensGtp.transcript (via ensGene.name) macEug1.ensPep.name (via ensGene.name) macEug1.ensemblSource.name (via ensGene.name) macEug1.ensemblToGeneName.name (via ensGene.name)

Sample Rows

bin	name	chrom	strand	txStart	txEnd	cdsStart	cdsEnd	exonCount	exonStarts	exonEnds	name2	cdsStartStat	cdsEndStat	exonFrames
585	ENSMEUT00000010658	Scaffold10	-	48310	48444	48310	48444	1	48310,	48444,	ENSMEUG00000010607	incmpl	incmpl	0,
585	ENSMEUT00000004047	Scaffold10	+	101030	105738	101030	105738	9	101030,101110,101117,101130,101141,102865,104981,105542,105736,	101108,101116,101129,101139,101225,102957,105135,105735,105738,	ENSMEUG00000004037	cmpl	cmpl	0,0,0,0,0,0,2,0,1,
585	ENSMEUT00000004068	Scaffold10	-	107964	124135	107964	124135	7	107964,108193,108883,112065,113966,114688,124062,	108065,108385,109009,112171,114101,114775,124135,	ENSMEUG00000004053	incmpl	cmpl	1,1,1,0,0,0,0,
585	ENSMEUT00000016218	Scaffold100	+	74384	74449	74384	74449	1	74384,	74449,	ENSMEUG00000016181	incmpl	incmpl	0,
585	ENSMEUT00000011549	Scaffold100	+	81831	86704	81831	86704	2	81831,86550,	81906,86704,	ENSMEUG00000011515	cmpl	incmpl	0,0,
585	ENSMEUT00000004961	Scaffold10000	+	33012	33870	33012	33870	3	33012,33628,33765,	33627,33744,33870,	ENSMEUG00000004951	cmpl	incmpl	1,1,0,
585	ENSMEUT00000010342	Scaffold100008	-	7465	7527	7465	7527	1	7465,	7527,	ENSMEUG00000010297	incmpl	cmpl	0,
585	ENSMEUT00000012944	Scaffold100022	-	10076	10196	10076	10196	1	10076,	10196,	ENSMEUG00000012905	cmpl	incmpl	0,
585	ENSMEUT00000003433	Scaffold100027	+	809	8878	809	8878	4	809,3035,3199,8703,	938,3197,3286,8878,	ENSMEUG00000003404	incmpl	incmpl	0,0,0,0,
585	ENSMEUT00000012187	Scaffold10003	+	27830	27867	27830	27867	1	27830,	27867,	ENSMEUG00000012163	cmpl	cmpl	2,

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

Ensembl Genes (ensGene) Track Description


	Description These gene predictions were generated by Ensembl. For more information on the different gene tracks, see our Genes FAQ. Methods For a description of the methods used in Ensembl gene predictions, please refer to Hubbard et al. (2002), also listed in the References section below. Data access Ensembl Gene data can be explored interactively using the Table Browser or the Data Integrator. For local downloads, the genePred format files for hg19 are available in our downloads directory as ensGene.txt.gz or in our genes download directory in GTF format. For programmatic access, the data can be queried from the REST API or directly from our public MySQL servers. Instructions on this method are available on our MySQL help page and on our blog. Previous versions of this track can be found on our archive download server. Credits We would like to thank Ensembl for providing these gene annotations. For more information, please see Ensembl's genome annotation page. References Hubbard T, Barker D, Birney E, Cameron G, Chen Y, Clark L, Cox T, Cuff J, Curwen V, Down T et al. The Ensembl genome database project. Nucleic Acids Res. 2002 Jan 1;30(1):38-41. PMID: 11752248; PMC: PMC99161

Description

Methods

Data access

Credits

References