Schema for wgEncodeGencodeEntrezGeneV27lift37

Database: hg19 Primary Table: wgEncodeGencodeEntrezGeneV27lift37 Row Count: 157,006 Data last updated: 2017-09-15
Format description: The NCBI Entrez gene id associated with GENCODE transcript annotation
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`transcriptId`	ENST00000000233.9	`varchar(255)`	values	GENCODE transcript identifier
`entrezGeneId`	381	`int(11)`	range	Entrez gene id

Connected Tables and Joining Fields


	hg19.wgEncodeGencodeAttrsV27lift37.transcriptId (via wgEncodeGencodeEntrezGeneV27lift37.transcriptId)

Sample Rows

transcriptId	entrezGeneId
ENST00000000233.9	381
ENST00000000442.10	2101
ENST00000001008.5	2288
ENST00000001146.6	56603
ENST00000002125.8	55471
ENST00000002165.10	2519
ENST00000002501.10	79007
ENST00000002596.5	9957
ENST00000002829.7	6405
ENST00000003084.10	1080

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