Schema for wgEncodeGencodeUniProtV38lift37
  Database: hg19    Primary Table: wgEncodeGencodeUniProtV38lift37    Row Count: 112,334   Data last updated: 2021-06-29
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_1varchar(255) values GENCODE transcript identifier
acc A4D0Z3varchar(255) values UniProt/Swiss-Prot accession
name A4D0Z3.121varchar(255) values UniProt/Swiss-Prot entry name
dataset TrEMBLenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV38lift37.transcriptId (via wgEncodeGencodeUniProtV38lift37.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.10_1A4D0Z3A4D0Z3.121TrEMBL
ENST00000000233.10_1P84085P84085.164SwissProt
ENST00000000412.3F5GXE0F5GXE0_HUMANTrEMBL
ENST00000000412.3F5GXU0F5GXU0_HUMANTrEMBL
ENST00000000412.3F5H4U1F5H4U1_HUMANTrEMBL
ENST00000000412.3P20645MPRD_HUMANSwissProt
ENST00000000412.3Q96AH2Q96AH2_HUMANTrEMBL
ENST00000000442.11_1P11474P11474.224SwissProt
ENST00000000442.11_1Q569H8Q569H8.157TrEMBL
ENST00000001008.6_1Q02790Q02790.227SwissProt

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