Schema for wgEncodeGencodePubMedV28
  Database: hg38    Primary Table: wgEncodeGencodePubMedV28    Row Count: 229,992   Data last updated: 2020-06-30
fieldexampleSQL type info
transcriptId ENST00000456328.2varchar(255) values
pubMedId 19476624int(11) range

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV28.transcriptId (via wgEncodeGencodePubMedV28.transcriptId)

Sample Rows
 
transcriptIdpubMedId
ENST00000456328.219476624
ENST00000450305.219476624
ENST00000488147.118159949
ENST00000417324.111779631
ENST00000417324.115233989
ENST00000461467.111779631
ENST00000461467.115233989
ENST00000458203.219123937
ENST00000426406.314983052
ENST00000473798.112477932

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