Schema for wgEncodeGencodeUniProtV46lift37
  Database: hg19    Primary Table: wgEncodeGencodeUniProtV46lift37    Row Count: 123,764   Data last updated: 2024-05-13
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_4varchar(255) values GENCODE transcript identifier
acc A4D0Z3varchar(255) values UniProt/Swiss-Prot accession
name A4D0Z3.134varchar(255) values UniProt/Swiss-Prot entry name
dataset TrEMBLenum('SwissProt', 'TrEMBL') values UniProt dataset

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV46lift37.transcriptId (via wgEncodeGencodeUniProtV46lift37.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.10_4A4D0Z3A4D0Z3.134TrEMBL
ENST00000000233.10_4P84085P84085.177SwissProt
ENST00000000412.3F5GXE0F5GXE0_HUMANTrEMBL
ENST00000000412.3F5GXU0F5GXU0_HUMANTrEMBL
ENST00000000412.3F5H4U1F5H4U1_HUMANTrEMBL
ENST00000000412.3P20645MPRD_HUMANSwissProt
ENST00000000412.3Q96AH2Q96AH2_HUMANTrEMBL
ENST00000000442.11_8P11474P11474.237SwissProt
ENST00000000442.11_8Q569H8Q569H8.170TrEMBL
ENST00000001008.6_4Q02790Q02790.240SwissProt

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