Schema for wgEncodeGencodeUniProtV44lift37
  Database: hg19    Primary Table: wgEncodeGencodeUniProtV44lift37    Row Count: 122,498   Data last updated: 2023-08-07
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.130varchar(255) values UniProt/Swiss-Prot entry name
dataset TrEMBLenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV44lift37.transcriptId (via wgEncodeGencodeUniProtV44lift37.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.10_3A4D0Z3A4D0Z3.130TrEMBL
ENST00000000233.10_3P84085P84085.173SwissProt
ENST00000000412.3F5GXE0F5GXE0_HUMANTrEMBL
ENST00000000412.3F5GXU0F5GXU0_HUMANTrEMBL
ENST00000000412.3F5H4U1F5H4U1_HUMANTrEMBL
ENST00000000412.3P20645MPRD_HUMANSwissProt
ENST00000000412.3Q96AH2Q96AH2_HUMANTrEMBL
ENST00000000442.11_7P11474P11474.233SwissProt
ENST00000000442.11_7Q569H8Q569H8.166TrEMBL
ENST00000001008.6_3Q02790Q02790.236SwissProt

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