Schema for wgEncodeGencodeUniProtV24lift37
  Database: hg19    Primary Table: wgEncodeGencodeUniProtV24lift37    Row Count: 105,091   Data last updated: 2016-03-02
Format description: GENCODE transcript to UniProt peptide mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.9varchar(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
        hg19.wgEncodeGencodeAttrsV24lift37.transcriptId (via wgEncodeGencodeUniProtV24lift37.transcriptId)

Sample Rows
 
transcriptIdaccnamedataset
ENST00000000233.9A4D0Z3A4D0Z3TrEMBL
ENST00000000233.9P84085P84085SwissProt
ENST00000000412.3F5GXE0F5GXE0_HUMANTrEMBL
ENST00000000412.3F5GXU0F5GXU0_HUMANTrEMBL
ENST00000000412.3F5H4U1F5H4U1_HUMANTrEMBL
ENST00000000412.3P20645MPRD_HUMANSwissProt
ENST00000000412.3Q96AH2Q96AH2_HUMANTrEMBL
ENST00000000442.10P11474P11474SwissProt
ENST00000000442.10Q569H8Q569H8TrEMBL
ENST00000001008.5Q02790Q02790SwissProt

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