Schema for wgEncodeGencodeUniProtVM37

Database: mm39 Primary Table: wgEncodeGencodeUniProtVM37 Row Count: 70,656 Data last updated: 2025-05-31
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`transcriptId`	ENSMUST00000000001.5	`varchar(255)`	values	GENCODE transcript identifier
`acc`	Q9DC51	`varchar(255)`	values	UniProt/Swiss-Prot accession
`name`	Q9DC51.187	`varchar(255)`	values	UniProt/Swiss-Prot entry name
`dataset`	SwissProt	`enum('SwissProt', 'TrEMBL')`	values	UniProt dataset

Connected Tables and Joining Fields


	mm39.wgEncodeGencodeAttrsVM37.transcriptId (via wgEncodeGencodeUniProtVM37.transcriptId)

Sample Rows

transcriptId	acc	name	dataset
ENSMUST00000000001.5	Q9DC51	Q9DC51.187	SwissProt
ENSMUST00000000003.14	O08976	O08976.153	SwissProt
ENSMUST00000000003.14	Q3UV89	Q3UV89.132	TrEMBL
ENSMUST00000000010.9	P20615	P20615.176	SwissProt
ENSMUST00000000028.14	Q3UI99	Q3UI99.123	TrEMBL
ENSMUST00000000028.14	Q9Z1X9	Q9Z1X9.152	SwissProt
ENSMUST00000000033.12	P09535	P09535.191	SwissProt
ENSMUST00000000049.6	Q01339	Q01339.181	SwissProt
ENSMUST00000000058.7	Q9WVC3	Q9WVC3.168	SwissProt
ENSMUST00000000080.8	Q8BPQ2	Q8BPQ2.165	TrEMBL

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