Schema for wgEncodeGencodeAttrsV40
  Database: hg38    Primary Table: wgEncodeGencodeAttrsV40    Row Count: 267,577   Data last updated: 2022-04-21
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSG00000004059.11varchar(255) values
geneName ARF5varchar(255) values
geneType protein_codingvarchar(255) values
geneStatus  varchar(255) values
transcriptId ENST00000000233.10varchar(255) values
transcriptName ARF5-201varchar(255) values
transcriptType protein_codingvarchar(255) values
transcriptStatus  varchar(255) values
havanaGeneId OTTHUMG00000023246.7varchar(255) values
havanaTranscriptId OTTHUMT00000059567.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
        hg38.wgEncodeGencodeGeneSourceV40.geneId (via wgEncodeGencodeAttrsV40.geneId)
      hg38.wgEncodeGencodeAnnotationRemarkV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeBasicV40.name (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeCompV40.name (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeExonSupportV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeGeneSymbolV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodePdbV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodePseudoGeneV40.name (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodePubMedV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeRefSeqV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeTagV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeTranscriptSourceV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeTranscriptSupportV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeTranscriptionSupportLevelV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)
      hg38.wgEncodeGencodeUniProtV40.transcriptId (via wgEncodeGencodeAttrsV40.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSG00000004059.11ARF5protein_codingENST00000000233.10ARF5-201protein_codingOTTHUMG00000023246.7OTTHUMT00000059567.3CCDS34745.12codingENSP00000000233.5
ENSG00000003056.8M6PRprotein_codingENST00000000412.8M6PR-201protein_codingOTTHUMG00000168276.4OTTHUMT00000399130.2CCDS8598.12codingENSP00000000412.3
ENSG00000173153.17ESRRAprotein_codingENST00000000442.11ESRRA-201protein_codingOTTHUMG00000150641.9OTTHUMT00000319303.3CCDS41667.12codingENSP00000000442.6
ENSG00000004478.8FKBP4protein_codingENST00000001008.6FKBP4-201protein_codingOTTHUMG00000090429.4OTTHUMT00000206861.3CCDS8512.12codingENSP00000001008.4
ENSG00000003137.9CYP26B1protein_codingENST00000001146.7CYP26B1-201protein_codingOTTHUMG00000129756.5OTTHUMT00000251969.1CCDS1919.12codingENSP00000001146.2
ENSG00000003509.16NDUFAF7protein_codingENST00000002125.9NDUFAF7-201protein_codingOTTHUMG00000128468.7OTTHUMT00000250267.2CCDS1788.12codingENSP00000002125.4
ENSG00000001036.14FUCA2protein_codingENST00000002165.11FUCA2-201protein_codingOTTHUMG00000015728.3OTTHUMT00000042521.3CCDS5200.12codingENSP00000002165.5
ENSG00000003249.15DBNDD1protein_codingENST00000002501.11DBNDD1-201protein_codingOTTHUMG00000138984.4OTTHUMT00000272872.2CCDS42223.12codingENSP00000002501.6
ENSG00000002587.10HS3ST1protein_codingENST00000002596.6HS3ST1-201protein_codingOTTHUMG00000090547.7OTTHUMT00000207073.4CCDS3408.12codingENSP00000002596.5
ENSG00000001617.12SEMA3Fprotein_codingENST00000002829.8SEMA3F-201protein_codingOTTHUMG00000156806.9OTTHUMT00000345929.2CCDS2811.12codingENSP00000002829.3

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