Schema for wgEncodeGencodeAttrsV25
  Database: hg38    Primary Table: wgEncodeGencodeAttrsV25    Row Count: 214,303   Data last updated: 2016-07-23
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.wgEncodeGencodeGeneSourceV25.geneId (via wgEncodeGencodeAttrsV25.geneId)
      hg38.wgEncodeGencodeAnnotationRemarkV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeBasicV25.name (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeCompV25.name (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeExonSupportV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodePdbV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodePseudoGeneV25.name (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodePubMedV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeRefSeqV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeTagV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeTranscriptSourceV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeTranscriptSupportV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeTranscriptionSupportLevelV25.transcriptId (via wgEncodeGencodeAttrsV25.transcriptId)
      hg38.wgEncodeGencodeUniProtV25.transcriptId (via wgEncodeGencodeAttrsV25.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.4MIR1302-2lincRNAKNOWNENST00000473358.1MIR1302-2-001lincRNAKNOWNOTTHUMG00000000959.2OTTHUMT00000002840.12nonCoding
ENSG00000243485.4MIR1302-2lincRNAKNOWNENST00000469289.1MIR1302-2-002lincRNAKNOWNOTTHUMG00000000959.2OTTHUMT00000002841.22nonCoding
ENSG00000243485.4MIR1302-2lincRNAKNOWNENST00000607096.1MIR1302-2-201miRNAKNOWNOTTHUMG00000000959.23nonCoding
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.