Schema for wgEncodeGencodeAttrsV28
  Database: hg38    Primary Table: wgEncodeGencodeAttrsV28    Row Count: 219,992   Data last updated: 2020-06-30
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 RP11-34P13.1-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
proteinId  varchar(255) values

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeGeneSourceV28.geneId (via wgEncodeGencodeAttrsV28.geneId)
      hg38.wgEncodeGencodeAnnotationRemarkV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeBasicV28.name (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeCompV28.name (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeExonSupportV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodePdbV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodePubMedV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeRefSeqV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeTagV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeTranscriptSourceV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeTranscriptSupportV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeTranscriptionSupportLevelV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)
      hg38.wgEncodeGencodeUniProtV28.transcriptId (via wgEncodeGencodeAttrsV28.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneENST00000456328.2RP11-34P13.1-002processed_transcriptOTTHUMG00000000961.2OTTHUMT00000362751.12pseudo
ENSG00000223972.5DDX11L1transcribed_unprocessed_pseudogeneENST00000450305.2RP11-34P13.1-001transcribed_unprocessed_pseudogeneOTTHUMG00000000961.2OTTHUMT00000002844.22pseudo
ENSG00000227232.5WASH7Punprocessed_pseudogeneENST00000488147.1RP11-34P13.2-001unprocessed_pseudogeneOTTHUMG00000000958.1OTTHUMT00000002839.12pseudo
ENSG00000278267.1MIR6859-1miRNAENST00000619216.1MIR6859-1-201miRNA3nonCoding
ENSG00000243485.5RP11-34P13.3lincRNAENST00000473358.1RP11-34P13.3-001lincRNAOTTHUMG00000000959.2OTTHUMT00000002840.12nonCoding
ENSG00000243485.5RP11-34P13.3lincRNAENST00000469289.1RP11-34P13.3-002lincRNAOTTHUMG00000000959.2OTTHUMT00000002841.22nonCoding
ENSG00000284332.1MIR1302-2miRNAENST00000607096.1MIR1302-2-201miRNA3nonCoding
ENSG00000237613.2FAM138AlincRNAENST00000417324.1RP11-34P13.4-001lincRNAOTTHUMG00000000960.1OTTHUMT00000002842.12nonCoding
ENSG00000237613.2FAM138AlincRNAENST00000461467.1RP11-34P13.4-002lincRNAOTTHUMG00000000960.1OTTHUMT00000002843.12nonCoding
ENSG00000268020.3OR4G4Punprocessed_pseudogeneENST00000606857.1RP11-34P13.17-001unprocessed_pseudogeneOTTHUMG00000185779.1OTTHUMT00000471235.12pseudo

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