Schema for wgEncodeGencodePubMedV38

Database: hg38 Primary Table: wgEncodeGencodePubMedV38 Row Count: 272,045 Data last updated: 2021-09-26
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	info	description
`transcriptId`	ENST00000456328.2	`varchar(255)`	values	GENCODE transcript identifier
`pubMedId`	19476624	`int(11)`	range	PubMed identifier of supporting literature

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV38.transcriptId (via wgEncodeGencodePubMedV38.transcriptId)

Sample Rows

transcriptId	pubMedId
ENST00000456328.2	19476624
ENST00000450305.2	19476624
ENST00000488147.1	18159949
ENST00000417324.1	11779631
ENST00000417324.1	15233989
ENST00000461467.1	11779631
ENST00000461467.1	15233989
ENST00000458203.2	19123937
ENST00000426406.4	14983052
ENST00000473798.1	12477932

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