Schema for wgEncodeGencodeUniProtV49

Database: hg38 Primary Table: wgEncodeGencodeUniProtV49 Row Count: 138,013 Data last updated: 2025-09-08
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV49.transcriptId (via wgEncodeGencodeUniProtV49.transcriptId)

Sample Rows

transcriptId	acc	name	dataset
ENST00000000233.10	A4D0Z3	A4D0Z3.142	TrEMBL
ENST00000000233.10	P84085	P84085.185	SwissProt
ENST00000000412.8	P20645	P20645.215	SwissProt
ENST00000000442.11	P11474	P11474.244	SwissProt
ENST00000000442.11	Q569H8	Q569H8.178	TrEMBL
ENST00000001008.6	Q02790	Q02790.248	SwissProt
ENST00000001146.7	Q9NR63	Q9NR63.191	SwissProt
ENST00000002125.9	Q7L592	Q7L592.153	SwissProt
ENST00000002165.11	Q9BTY2	Q9BTY2.174	SwissProt
ENST00000002501.11	Q9H9R9	Q9H9R9.130	SwissProt

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