Schema for wgEncodeGencodeAttrsV34lift37
  Database: hg19    Primary Table: wgEncodeGencodeAttrsV34lift37    Row Count: 229,670   Data last updated: 2020-04-29
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSG00000223972.5_3varchar(255) values
geneName DDX11L1varchar(255) values
geneType transcribed_unprocessed_pse...varchar(255) values
geneStatus  varchar(255) values
transcriptId ENST00000456328.2_1varchar(255) values
transcriptName DDX11L1-202varchar(255) values
transcriptType processed_transcriptvarchar(255) values
transcriptStatus  varchar(255) values
havanaGeneId OTTHUMG00000000961.1_3varchar(255) values
havanaTranscriptId OTTHUMT00000362751.1_1varchar(255) values
ccdsId  varchar(255) values
level 2int(11) range
transcriptClass pseudovarchar(255) values
proteinId  varchar(255) values

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeGeneSourceV34lift37.geneId (via wgEncodeGencodeAttrsV34lift37.geneId)
      hg19.wgEncodeGencodeAnnotationRemarkV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeBasicV34lift37.name (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeCompV34lift37.name (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeGeneSymbolV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodePdbV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodePseudoGeneV34lift37.name (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodePubMedV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeRefSeqV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeTagV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSourceV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSupportV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptionSupportLevelV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)
      hg19.wgEncodeGencodeUniProtV34lift37.transcriptId (via wgEncodeGencodeAttrsV34lift37.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSG00000223972.5_3DDX11L1transcribed_unprocessed_pseudogeneENST00000456328.2_1DDX11L1-202processed_transcriptOTTHUMG00000000961.1_3OTTHUMT00000362751.1_12pseudo
ENSG00000223972.5_3DDX11L1transcribed_unprocessed_pseudogeneENST00000450305.2_1DDX11L1-201transcribed_unprocessed_pseudogeneOTTHUMG00000000961.1_3OTTHUMT00000002844.1_12pseudo
ENSG00000227232.5_3WASH7Punprocessed_pseudogeneENST00000488147.1_2WASH7P-201unprocessed_pseudogeneOTTHUMG00000000958.1_3OTTHUMT00000002839.1_22pseudo
ENSG00000243485.5_7MIR1302-2HGlncRNAENST00000473358.1_1MIR1302-2HG-202lncRNAOTTHUMG00000000959.1_7OTTHUMT00000002840.1_12nonCoding
ENSG00000243485.5_7MIR1302-2HGlncRNAENST00000469289.1_1MIR1302-2HG-201lncRNAOTTHUMG00000000959.1_7OTTHUMT00000002841.1_12nonCoding
ENSG00000237613.2_4FAM138AlncRNAENST00000417324.1_2FAM138A-201lncRNAOTTHUMG00000000960.1_4OTTHUMT00000002842.1_22nonCoding
ENSG00000237613.2_4FAM138AlncRNAENST00000461467.1_2FAM138A-202lncRNAOTTHUMG00000000960.1_4OTTHUMT00000002843.1_22nonCoding
ENSG00000268020.3_4OR4G4Punprocessed_pseudogeneENST00000606857.1_1OR4G4P-201unprocessed_pseudogeneOTTHUMG00000185779.1_4OTTHUMT00000471235.1_12pseudo
ENSG00000240361.2_4OR4G11Ptranscribed_unprocessed_pseudogeneENST00000642116.1_1OR4G11P-202processed_transcriptOTTHUMG00000001095.1_4OTTHUMT00000492680.1_12pseudo
ENSG00000240361.2_4OR4G11Ptranscribed_unprocessed_pseudogeneENST00000492842.2_2OR4G11P-201transcribed_unprocessed_pseudogeneOTTHUMG00000001095.1_4OTTHUMT00000003224.1_22pseudo

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