Schema for wgEncodeGencodeAttrsV42lift37
  Database: hg19    Primary Table: wgEncodeGencodeAttrsV42lift37    Row Count: 253,737   Data last updated: 2022-11-03
Format description: Basic set of attributes associated with all Gencode transcripts.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000004059.11_8varchar(255) values Gene identifier
geneName ARF5varchar(255) values Gene name
geneType protein_codingvarchar(255) values BioType of gene
geneStatus  varchar(255) values Status of gene (obsolete)
transcriptId ENST00000000233.10_3varchar(255) values Transcript identifier
transcriptName ARF5-201varchar(255) values Transcript name
transcriptType protein_codingvarchar(255) values BioType of transcript
transcriptStatus  varchar(255) values Status of transcript (obsolete)
havanaGeneId OTTHUMG00000023246.7_8varchar(255) values HAVANA identifier if gene is in HAVANA
havanaTranscriptId OTTHUMT00000059567.3_3varchar(255) values HAVANA identifier if transcript is in HAVANA
ccdsId CCDS34745.1varchar(255) values CCDS identifier if transcript is in CCDS
level 2int(11) range GENCODE level: 1 = experimental confirmed, 2 = manual, 3 = automated
transcriptClass codingvarchar(255) values high level type of transcript
proteinId ENSP00000000233.5varchar(255) values Protein identifier (not loaded on many older versions of GENCODE)
transcriptRank 0int(11) range Rank of transcript within the gene, smaller is more preferred

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeGeneSourceV42lift37.geneId (via wgEncodeGencodeAttrsV42lift37.geneId)
      hg19.wgEncodeGencodeAnnotationRemarkV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeBasicV42lift37.name (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeCompV42lift37.name (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeGeneSymbolV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodePdbV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodePseudoGeneV42lift37.name (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodePubMedV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeRefSeqV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeTagV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSourceV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptSupportV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeTranscriptionSupportLevelV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)
      hg19.wgEncodeGencodeUniProtV42lift37.transcriptId (via wgEncodeGencodeAttrsV42lift37.transcriptId)

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

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