Schema for wgEncodeGencodeUniProtV48

Database: hg38 Primary Table: wgEncodeGencodeUniProtV48 Row Count: 129,564 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`	ENST00000000233.10	`varchar(255)`	values	GENCODE transcript identifier
`acc`	A4D0Z3	`varchar(255)`	values	UniProt/Swiss-Prot accession
`name`	A4D0Z3.139	`varchar(255)`	values	UniProt/Swiss-Prot entry name
`dataset`	TrEMBL	`enum('SwissProt', 'TrEMBL')`	values	UniProt dataset

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV48.transcriptId (via wgEncodeGencodeUniProtV48.transcriptId)

Sample Rows

transcriptId	acc	name	dataset
ENST00000000233.10	A4D0Z3	A4D0Z3.139	TrEMBL
ENST00000000233.10	P84085	P84085.182	SwissProt
ENST00000000412.8	P20645	P20645.212	SwissProt
ENST00000000442.11	P11474	P11474.241	SwissProt
ENST00000000442.11	Q569H8	Q569H8.175	TrEMBL
ENST00000001008.6	Q02790	Q02790.245	SwissProt
ENST00000001146.7	Q9NR63	Q9NR63.188	SwissProt
ENST00000002125.9	Q7L592	Q7L592.150	SwissProt
ENST00000002165.11	Q9BTY2	Q9BTY2.171	SwissProt
ENST00000002501.11	Q9H9R9	Q9H9R9.127	SwissProt

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