Schema for wgEncodeGencodeUniProtVM39

Database: mm39 Primary Table: wgEncodeGencodeUniProtVM39 Row Count: 77,527 Data last updated: 2026-04-24
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


	mm39.wgEncodeGencodeAttrsVM39.transcriptId (via wgEncodeGencodeUniProtVM39.transcriptId)

Sample Rows

transcriptId	acc	name	dataset
ENSMUST00000000001.6	Q9DC51	Q9DC51.192	SwissProt
ENSMUST00000000003.14	O08976	O08976.158	SwissProt
ENSMUST00000000003.14	Q3UV89	Q3UV89.136	TrEMBL
ENSMUST00000000010.10	P20615	P20615.180	SwissProt
ENSMUST00000000028.15	Q3UI99	Q3UI99.128	TrEMBL
ENSMUST00000000028.15	Q9Z1X9	Q9Z1X9.157	SwissProt
ENSMUST00000000033.12	P09535	P09535.196	SwissProt
ENSMUST00000000049.7	Q01339	Q01339.186	SwissProt
ENSMUST00000000058.8	Q9WVC3	Q9WVC3.172	SwissProt
ENSMUST00000000080.8	Q8BPQ2	Q8BPQ2.170	TrEMBL

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