Skip to main content
Schema for wgEncodeGencodeEntrezGeneV42lift37
  Database: hg19    Primary Table: wgEncodeGencodeEntrezGeneV42lift37    Row Count: 196,714   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
fieldexampleSQL type info description
transcriptId ENST00000000233.10_3varchar(255) values GENCODE transcript identifier
entrezGeneId 381int(11) range Entrez gene id

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV42lift37.transcriptId (via wgEncodeGencodeEntrezGeneV42lift37.transcriptId)

Sample Rows
 
transcriptIdentrezGeneId
ENST00000000233.10_3381
ENST00000000442.11_62101
ENST00000001008.6_32288
ENST00000001146.7_556603
ENST00000002125.9_355471
ENST00000002165.11_52519
ENST00000002501.11_479007
ENST00000002596.6_59957
ENST00000002829.8_56405
ENST00000003084.11_41080

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