Schema for wgEncodeGencodePubMedV49

Database: hg38 Primary Table: wgEncodeGencodePubMedV49 Row Count: 542,147 Data last updated: 2025-09-08
Format description: Gencode metadata table of PubMed identifier of published experimental data associated with Gencode Genes
On download server: MariaDB table dump directory

field	example	SQL type	description
`transcriptId`	ENST00000511072.5	`varchar(255)`	GENCODE transcript identifier
`pubMedId`	11050005	`int(11)`	PubMed identifier of supporting literature

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV49.transcriptId (via wgEncodeGencodePubMedV49.transcriptId)

Sample Rows

transcriptId	pubMedId
ENST00000511072.5	11050005
ENST00000511072.5	22939622
ENST00000511072.5	27151440
ENST00000607632.1	11050005
ENST00000607632.1	22939622
ENST00000607632.1	27151440
ENST00000378391.6	11050005
ENST00000378391.6	22939622
ENST00000378391.6	27151440
ENST00000514189.5	11050005

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