Schema for wgEncodeGencodeUniProtVM24
  Database: mm10    Primary Table: wgEncodeGencodeUniProtVM24    Row Count: 71,149   Data last updated: 2020-01-16
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENSMUST00000000001.4varchar(255) values GENCODE transcript identifier
acc Q9DC51varchar(255) values UniProt/Swiss-Prot accession
name Q9DC51varchar(255) values UniProt/Swiss-Prot entry name
dataset SwissProtenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        mm10.wgEncodeGencodeAttrsVM24.transcriptId (via wgEncodeGencodeUniProtVM24.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENSMUST00000000001.4Q9DC51Q9DC51SwissProt
ENSMUST00000000003.13O08976O08976SwissProt
ENSMUST00000000003.13Q3UV89Q3UV89TrEMBL
ENSMUST00000000010.8P20615P20615SwissProt
ENSMUST00000000028.13Q3UI99Q3UI99TrEMBL
ENSMUST00000000028.13Q9Z1X9Q9Z1X9SwissProt
ENSMUST00000000033.11P09535P09535SwissProt
ENSMUST00000000049.5Q01339Q01339SwissProt
ENSMUST00000000058.6Q9WVC3Q9WVC3SwissProt
ENSMUST00000000080.7Q8BPQ2Q8BPQ2TrEMBL

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