Schema for wgEncodeGencodeUniProtVM32
  Database: mm39    Primary Table: wgEncodeGencodeUniProtVM32    Row Count: 70,952   Data last updated: 2023-02-13
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.176varchar(255) values UniProt/Swiss-Prot entry name
dataset SwissProtenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM32.transcriptId (via wgEncodeGencodeUniProtVM32.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENSMUST00000000001.5Q9DC51Q9DC51.176SwissProt
ENSMUST00000000003.14O08976O08976.144SwissProt
ENSMUST00000000003.14Q3UV89Q3UV89.125TrEMBL
ENSMUST00000000010.9P20615P20615.166SwissProt
ENSMUST00000000028.14Q3UI99Q3UI99.112TrEMBL
ENSMUST00000000028.14Q9Z1X9Q9Z1X9.141SwissProt
ENSMUST00000000033.12P09535P09535.180SwissProt
ENSMUST00000000049.6Q01339Q01339.170SwissProt
ENSMUST00000000058.7Q9WVC3Q9WVC3.157SwissProt
ENSMUST00000000080.8Q8BPQ2Q8BPQ2.154TrEMBL

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