Schema for wgEncodeGencodeUniProtV43lift37
  Database: hg19    Primary Table: wgEncodeGencodeUniProtV43lift37    Row Count: 119,565   Data last updated: 2023-02-15
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_3varchar(255) values GENCODE transcript identifier
acc A4D0Z3varchar(255) values UniProt/Swiss-Prot accession
name A4D0Z3.128varchar(255) values UniProt/Swiss-Prot entry name
dataset TrEMBLenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV43lift37.transcriptId (via wgEncodeGencodeUniProtV43lift37.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.10_3A4D0Z3A4D0Z3.128TrEMBL
ENST00000000233.10_3P84085P84085.171SwissProt
ENST00000000412.3F5GXE0F5GXE0_HUMANTrEMBL
ENST00000000412.3F5GXU0F5GXU0_HUMANTrEMBL
ENST00000000412.3F5H4U1F5H4U1_HUMANTrEMBL
ENST00000000412.3P20645MPRD_HUMANSwissProt
ENST00000000412.3Q96AH2Q96AH2_HUMANTrEMBL
ENST00000000442.11_6P11474P11474.231SwissProt
ENST00000000442.11_6Q569H8Q569H8.164TrEMBL
ENST00000001008.6_3Q02790Q02790.234SwissProt

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