Schema for wgEncodeGencodeAttrsV26
  Database: hg38    Primary Table: wgEncodeGencodeAttrsV26    Row Count: 215,473   Data last updated: 2017-03-29
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  varchar(255) values
transcriptId ENST00000456328.2varchar(255) values
transcriptName DDX11L1-002varchar(255) values
transcriptType processed_transcriptvarchar(255) values
transcriptStatus  varchar(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.wgEncodeGencodeGeneSourceV26.geneId (via wgEncodeGencodeAttrsV26.geneId)
      hg38.wgEncodeGencodeAnnotationRemarkV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeBasicV26.name (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeCompV26.name (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeExonSupportV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodePdbV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodePseudoGeneV26.name (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodePubMedV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeRefSeqV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeTagV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeTranscriptSourceV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeTranscriptSupportV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeTranscriptionSupportLevelV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)
      hg38.wgEncodeGencodeUniProtV26.transcriptId (via wgEncodeGencodeAttrsV26.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClass
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneENST00000456328.2DDX11L1-002processed_transcriptOTTHUMG00000000961.2OTTHUMT00000362751.12pseudo
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneENST00000450305.2DDX11L1-001transcribed_unprocessed_pseudogeneOTTHUMG00000000961.2OTTHUMT00000002844.22pseudo
ENSG00000227232.5WASH7Punprocessed_pseudogeneENST00000488147.1WASH7P-001unprocessed_pseudogeneOTTHUMG00000000958.1OTTHUMT00000002839.12pseudo
ENSG00000278267.1MIR6859-1miRNAENST00000619216.1MIR6859-1-201miRNA3nonCoding
ENSG00000243485.5MIR1302-2HGlincRNAENST00000473358.1MIR1302-2HG-001lincRNAOTTHUMG00000000959.2OTTHUMT00000002840.12nonCoding
ENSG00000243485.5MIR1302-2HGlincRNAENST00000469289.1MIR1302-2HG-002lincRNAOTTHUMG00000000959.2OTTHUMT00000002841.22nonCoding
ENSG00000284332.1MIR1302-2miRNAENST00000607096.1MIR1302-2-201miRNA3nonCoding
ENSG00000237613.2FAM138AlincRNAENST00000417324.1FAM138A-001lincRNAOTTHUMG00000000960.1OTTHUMT00000002842.12nonCoding
ENSG00000237613.2FAM138AlincRNAENST00000461467.1FAM138A-002lincRNAOTTHUMG00000000960.1OTTHUMT00000002843.12nonCoding
ENSG00000268020.3OR4G4Punprocessed_pseudogeneENST00000606857.1OR4G4P-001unprocessed_pseudogeneOTTHUMG00000185779.1OTTHUMT00000471235.12pseudo

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