Schema for wgEncodeGencodeAttrsV38
  Database: hg38    Primary Table: wgEncodeGencodeAttrsV38    Row Count: 257,986   Data last updated: 2021-09-25
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-202varchar(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
proteinId  varchar(255) values

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeGeneSourceV38.geneId (via wgEncodeGencodeAttrsV38.geneId)
      hg38.wgEncodeGencodeAnnotationRemarkV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeBasicV38.name (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeCompV38.name (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeExonSupportV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeGeneSymbolV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodePdbV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodePseudoGeneV38.name (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodePubMedV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeRefSeqV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeTagV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeTranscriptSourceV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeTranscriptSupportV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeTranscriptionSupportLevelV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)
      hg38.wgEncodeGencodeUniProtV38.transcriptId (via wgEncodeGencodeAttrsV38.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneENST00000456328.2DDX11L1-202processed_transcriptOTTHUMG00000000961.2OTTHUMT00000362751.12pseudo
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneENST00000450305.2DDX11L1-201transcribed_unprocessed_pseudogeneOTTHUMG00000000961.2OTTHUMT00000002844.22pseudo
ENSG00000227232.5WASH7Punprocessed_pseudogeneENST00000488147.1WASH7P-201unprocessed_pseudogeneOTTHUMG00000000958.1OTTHUMT00000002839.12pseudo
ENSG00000278267.1MIR6859-1miRNAENST00000619216.1MIR6859-1-201miRNA3nonCoding
ENSG00000243485.5MIR1302-2HGlncRNAENST00000473358.1MIR1302-2HG-202lncRNAOTTHUMG00000000959.2OTTHUMT00000002840.12nonCoding
ENSG00000243485.5MIR1302-2HGlncRNAENST00000469289.1MIR1302-2HG-201lncRNAOTTHUMG00000000959.2OTTHUMT00000002841.22nonCoding
ENSG00000284332.1MIR1302-2miRNAENST00000607096.1MIR1302-2-201miRNA3nonCoding
ENSG00000237613.2FAM138AlncRNAENST00000417324.1FAM138A-201lncRNAOTTHUMG00000000960.1OTTHUMT00000002842.12nonCoding
ENSG00000237613.2FAM138AlncRNAENST00000461467.1FAM138A-202lncRNAOTTHUMG00000000960.1OTTHUMT00000002843.12nonCoding
ENSG00000268020.3OR4G4Punprocessed_pseudogeneENST00000606857.1OR4G4P-201unprocessed_pseudogeneOTTHUMG00000185779.1OTTHUMT00000471235.12pseudo

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