Schema for wgEncodeGencodeUniProtV35
  Database: hg38    Primary Table: wgEncodeGencodeUniProtV35    Row Count: 118,277   Data last updated: 2021-02-22
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10varchar(255) values GENCODE transcript identifier
acc A4D0Z3varchar(255) values UniProt/Swiss-Prot accession
name A4D0Z3varchar(255) values UniProt/Swiss-Prot entry name
dataset TrEMBLenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV35.transcriptId (via wgEncodeGencodeUniProtV35.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.10A4D0Z3A4D0Z3TrEMBL
ENST00000000233.10P84085P84085SwissProt
ENST00000000412.8P20645P20645SwissProt
ENST00000000442.11P11474P11474SwissProt
ENST00000000442.11Q569H8Q569H8TrEMBL
ENST00000001008.6Q02790Q02790SwissProt
ENST00000001146.6Q9NR63Q9NR63SwissProt
ENST00000002125.9Q7L592Q7L592SwissProt
ENST00000002165.11Q9BTY2Q9BTY2SwissProt
ENST00000002501.11Q9H9R9Q9H9R9SwissProt

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