Schema for wgEncodeGencodeEntrezGeneV42

Database: hg38 Primary Table: wgEncodeGencodeEntrezGeneV42 Row Count: 216,186 Data last updated: 2022-11-04
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.10	`varchar(255)`	values	GENCODE transcript identifier
`entrezGeneId`	381	`int(11)`	range	Entrez gene id

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV42.transcriptId (via wgEncodeGencodeEntrezGeneV42.transcriptId)

Sample Rows

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

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