Skip to main content
Schema for wgEncodeGencodeEntrezGeneV31lift37
  Database: hg19    Primary Table: wgEncodeGencodeEntrezGeneV31lift37    Row Count: 152,906   Data last updated: 2019-07-05
Format description: The NCBI Entrez gene id associated with GENCODE transcript annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_2varchar(255) values GENCODE transcript identifier
entrezGeneId 381int(11) range Entrez gene id

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV31lift37.transcriptId (via wgEncodeGencodeEntrezGeneV31lift37.transcriptId)

Sample Rows
 
transcriptIdentrezGeneId
ENST00000000233.10_2381
ENST00000000442.11_22101
ENST00000001008.6_22288
ENST00000001146.6_156603
ENST00000002125.9_255471
ENST00000002165.10_12519
ENST00000002501.10_179007
ENST00000002596.6_29957
ENST00000002829.8_36405
ENST00000003084.10_11080

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