Skip to main content
Schema for wgEncodeGencodeUniProtV50
  Database: hg38    Primary Table: wgEncodeGencodeUniProtV50    Row Count: 141,653   Data last updated: 2026-04-24
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10varchar(255) values GENCODE transcript identifier
acc A4D0Z3varchar(255) values UniProt/Swiss-Prot accession
name A4D0Z3.144varchar(255) values UniProt/Swiss-Prot entry name
dataset TrEMBLenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV50.transcriptId (via wgEncodeGencodeUniProtV50.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.10A4D0Z3A4D0Z3.144TrEMBL
ENST00000000233.10P84085P84085.187SwissProt
ENST00000000412.8P20645P20645.217SwissProt
ENST00000000442.11P11474P11474.246SwissProt
ENST00000000442.11Q569H8Q569H8.180TrEMBL
ENST00000001008.6Q02790Q02790.250SwissProt
ENST00000001146.7Q9NR63Q9NR63.193SwissProt
ENST00000002125.9Q7L592Q7L592.155SwissProt
ENST00000002165.11Q9BTY2Q9BTY2.176SwissProt
ENST00000002501.11Q9H9R9Q9H9R9.132SwissProt

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