Schema for wgEncodeGencodeAttrsV24
  Database: hg38    Primary Table: wgEncodeGencodeAttrsV24    Row Count: 215,966   Data last updated: 2015-12-08
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSG00000223972.5varchar(255) values
geneName DDX11L1varchar(255) values
geneType transcribed_unprocessed_pse...varchar(255) values
geneStatus KNOWNvarchar(255) values
transcriptId ENST00000456328.2varchar(255) values
transcriptName DDX11L1-002varchar(255) values
transcriptType processed_transcriptvarchar(255) values
transcriptStatus KNOWNvarchar(255) values
havanaGeneId OTTHUMG00000000961.2varchar(255) values
havanaTranscriptId OTTHUMT00000362751.1varchar(255) values
ccdsId  varchar(255) values
level 2int(11) range
transcriptClass pseudovarchar(255) values

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeGeneSourceV24.geneId (via wgEncodeGencodeAttrsV24.geneId)
      hg38.wgEncodeGencodeAnnotationRemarkV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeBasicV24.name (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeCompV24.name (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeExonSupportV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodePdbV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodePseudoGeneV24.name (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodePubMedV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeRefSeqV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeTagV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeTranscriptSourceV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeTranscriptSupportV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeTranscriptionSupportLevelV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)
      hg38.wgEncodeGencodeUniProtV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClass
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneKNOWNENST00000456328.2DDX11L1-002processed_transcriptKNOWNOTTHUMG00000000961.2OTTHUMT00000362751.12pseudo
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneKNOWNENST00000450305.2DDX11L1-001transcribed_unprocessed_pseudogeneKNOWNOTTHUMG00000000961.2OTTHUMT00000002844.22pseudo
ENSG00000227232.5WASH7Punprocessed_pseudogeneKNOWNENST00000488147.1WASH7P-001unprocessed_pseudogeneKNOWNOTTHUMG00000000958.1OTTHUMT00000002839.12pseudo
ENSG00000278267.1MIR6859-1miRNAKNOWNENST00000619216.1MIR6859-1-201miRNAKNOWN3nonCoding
ENSG00000243485.3RP11-34P13.3lincRNAKNOWNENST00000473358.1RP11-34P13.3-001lincRNAKNOWNOTTHUMG00000000959.2OTTHUMT00000002840.12nonCoding
ENSG00000243485.3RP11-34P13.3lincRNAKNOWNENST00000469289.1RP11-34P13.3-002lincRNAKNOWNOTTHUMG00000000959.2OTTHUMT00000002841.22nonCoding
ENSG00000274890.1MIR1302-2miRNAKNOWNENST00000607096.1MIR1302-2-201miRNAKNOWN3nonCoding
ENSG00000237613.2FAM138AlincRNAKNOWNENST00000417324.1FAM138A-001lincRNAKNOWNOTTHUMG00000000960.1OTTHUMT00000002842.12nonCoding
ENSG00000237613.2FAM138AlincRNAKNOWNENST00000461467.1FAM138A-002lincRNAKNOWNOTTHUMG00000000960.1OTTHUMT00000002843.12nonCoding
ENSG00000268020.3OR4G4Punprocessed_pseudogeneKNOWNENST00000606857.1OR4G4P-001unprocessed_pseudogeneKNOWNOTTHUMG00000185779.1OTTHUMT00000471235.12pseudo

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