Schema for wgEncodeGencodeAttrsV40lift37
  Database: hg19    Primary Table: wgEncodeGencodeAttrsV40lift37    Row Count: 248,067   Data last updated: 2022-04-28
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSG00000004059.11_8varchar(255) values
geneName ARF5varchar(255) values
geneType protein_codingvarchar(255) values
geneStatus  varchar(255) values
transcriptId ENST00000000233.10_3varchar(255) values
transcriptName ARF5-201varchar(255) values
transcriptType protein_codingvarchar(255) values
transcriptStatus  varchar(255) values
havanaGeneId OTTHUMG00000023246.7_8varchar(255) values
havanaTranscriptId OTTHUMT00000059567.3_3varchar(255) values
ccdsId CCDS34745.1varchar(255) values
level 2int(11) range
transcriptClass codingvarchar(255) values
proteinId ENSP00000000233.5varchar(255) values

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeGeneSourceV40lift37.geneId (via wgEncodeGencodeAttrsV40lift37.geneId)
      hg19.wgEncodeGencodeAnnotationRemarkV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeBasicV40lift37.name (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeCompV40lift37.name (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeGeneSymbolV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodePdbV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodePseudoGeneV40lift37.name (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodePubMedV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeRefSeqV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeTagV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSourceV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSupportV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptionSupportLevelV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)
      hg19.wgEncodeGencodeUniProtV40lift37.transcriptId (via wgEncodeGencodeAttrsV40lift37.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSG00000004059.11_8ARF5protein_codingENST00000000233.10_3ARF5-201protein_codingOTTHUMG00000023246.7_8OTTHUMT00000059567.3_3CCDS34745.12codingENSP00000000233.5
ENSG00000003056.3M6PRprotein_codingENST00000000412.3M6PR-001protein_codingOTTHUMG00000168276.1OTTHUMT00000399130.1CCDS8598.12codingENSP00000000412.3
ENSG00000173153.17_10ESRRAprotein_codingENST00000000442.11_6ESRRA-201protein_codingOTTHUMG00000150641.9_10OTTHUMT00000319303.3_6CCDS41667.12codingENSP00000000442.6
ENSG00000004478.8_8FKBP4protein_codingENST00000001008.6_3FKBP4-201protein_codingOTTHUMG00000090429.4_8OTTHUMT00000206861.3_3CCDS8512.12codingENSP00000001008.4
ENSG00000003137.9_10CYP26B1protein_codingENST00000001146.7_5CYP26B1-201protein_codingOTTHUMG00000129756.5_10OTTHUMT00000251969.1_5CCDS1919.12codingENSP00000001146.2
ENSG00000003509.16_11NDUFAF7protein_codingENST00000002125.9_3NDUFAF7-201protein_codingOTTHUMG00000128468.7_11OTTHUMT00000250267.2_3CCDS1788.12codingENSP00000002125.4
ENSG00000001036.14_8FUCA2protein_codingENST00000002165.11_5FUCA2-201protein_codingOTTHUMG00000015728.3_8OTTHUMT00000042521.3_5CCDS5200.12codingENSP00000002165.5
ENSG00000003249.15_8DBNDD1protein_codingENST00000002501.11_4DBNDD1-201protein_codingOTTHUMG00000138984.4_8OTTHUMT00000272872.2_4CCDS42223.12codingENSP00000002501.6
ENSG00000002587.10_10HS3ST1protein_codingENST00000002596.6_5HS3ST1-201protein_codingOTTHUMG00000090547.7_10OTTHUMT00000207073.4_5CCDS3408.12codingENSP00000002596.5
ENSG00000001617.12_9SEMA3Fprotein_codingENST00000002829.8_5SEMA3F-201protein_codingOTTHUMG00000156806.9_9OTTHUMT00000345929.2_5CCDS2811.12codingENSP00000002829.3

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