Schema for wgEncodeGencodeAttrsV24lift37
  Database: hg19    Primary Table: wgEncodeGencodeAttrsV24lift37    Row Count: 198,710   Data last updated: 2016-03-02
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
        hg19.wgEncodeGencodeGeneSourceV24lift37.geneId (via wgEncodeGencodeAttrsV24lift37.geneId)
      hg19.wgEncodeGencodeAnnotationRemarkV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeBasicV24lift37.name (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeCompV24lift37.name (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodePdbV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodePseudoGeneV24lift37.name (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodePubMedV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeRefSeqV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeTagV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSourceV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSupportV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptionSupportLevelV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.transcriptId)
      hg19.wgEncodeGencodeUniProtV24lift37.transcriptId (via wgEncodeGencodeAttrsV24lift37.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
ENSG00000243485.3RP11-34P13.3lincRNAKNOWNENST00000473358.1RP11-34P13.3-001lincRNAKNOWNOTTHUMG00000000959.2OTTHUMT00000002840.12nonCoding
ENSG00000243485.3RP11-34P13.3lincRNAKNOWNENST00000469289.1RP11-34P13.3-002lincRNAKNOWNOTTHUMG00000000959.2OTTHUMT00000002841.22nonCoding
ENSG00000237613.2FAM138AlincRNAKNOWNENST00000417324.1FAM138A-001lincRNAKNOWNOTTHUMG00000000960.1OTTHUMT00000002842.12nonCoding
ENSG00000237613.2FAM138AlincRNAKNOWNENST00000461467.1FAM138A-002lincRNAKNOWNOTTHUMG00000000960.1OTTHUMT00000002843.12nonCoding
ENSG00000268020.3OR4G4Punprocessed_pseudogeneKNOWNENST00000606857.1OR4G4P-001unprocessed_pseudogeneKNOWNOTTHUMG00000185779.1OTTHUMT00000471235.12pseudo
ENSG00000240361.1OR4G11Punprocessed_pseudogeneKNOWNENST00000492842.1OR4G11P-001unprocessed_pseudogeneKNOWNOTTHUMG00000001095.2OTTHUMT00000003224.22pseudo
ENSG00000186092.4OR4F5protein_codingKNOWNENST00000335137.3OR4F5-001protein_codingKNOWNOTTHUMG00000001094.2OTTHUMT00000003223.2CCDS30547.12coding

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