Skip to main content
Schema for wgEncodeGencodeUniProtVM38
  Database: mm39    Primary Table: wgEncodeGencodeUniProtVM38    Row Count: 70,727   Data last updated: 2025-09-09
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENSMUST00000000001.5varchar(255) values GENCODE transcript identifier
acc Q9DC51varchar(255) values UniProt/Swiss-Prot accession
name Q9DC51.190varchar(255) values UniProt/Swiss-Prot entry name
dataset SwissProtenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM38.transcriptId (via wgEncodeGencodeUniProtVM38.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENSMUST00000000001.5Q9DC51Q9DC51.190SwissProt
ENSMUST00000000003.14O08976O08976.156SwissProt
ENSMUST00000000003.14Q3UV89Q3UV89.135TrEMBL
ENSMUST00000000010.9P20615P20615.179SwissProt
ENSMUST00000000028.14Q3UI99Q3UI99.126TrEMBL
ENSMUST00000000028.14Q9Z1X9Q9Z1X9.155SwissProt
ENSMUST00000000033.12P09535P09535.194SwissProt
ENSMUST00000000049.6Q01339Q01339.184SwissProt
ENSMUST00000000058.7Q9WVC3Q9WVC3.171SwissProt
ENSMUST00000000080.8Q8BPQ2Q8BPQ2.168TrEMBL

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