Schema for wgEncodeGencodeAttrsVM32
  Database: mm39    Primary Table: wgEncodeGencodeAttrsVM32    Row Count: 149,443   Data last updated: 2023-02-13
Format description: Basic set of attributes associated with all Gencode transcripts.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSMUSG00000000001.5varchar(255) values Gene identifier
geneName Gnai3varchar(255) values Gene name
geneType protein_codingvarchar(255) values BioType of gene
geneStatus  varchar(255) values Status of gene (obsolete)
transcriptId ENSMUST00000000001.5varchar(255) values Transcript identifier
transcriptName Gnai3-201varchar(255) values Transcript name
transcriptType protein_codingvarchar(255) values BioType of transcript
transcriptStatus  varchar(255) values Status of transcript (obsolete)
havanaGeneId OTTMUSG00000007197.1varchar(255) values HAVANA identifier if gene is in HAVANA
havanaTranscriptId OTTMUST00000016610.1varchar(255) values HAVANA identifier if transcript is in HAVANA
ccdsId CCDS17751.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 ENSMUSP00000000001.5varchar(255) values Protein identifier (not loaded on many older versions of GENCODE)
transcriptRank 1int(11) range Rank of transcript within the gene, smaller is more preferred

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeGeneSourceVM32.geneId (via wgEncodeGencodeAttrsVM32.geneId)
      mm39.wgEncodeGencodeAnnotationRemarkVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeBasicVM32.name (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeCompVM32.name (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeExonSupportVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeGeneSymbolVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodePdbVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodePseudoGeneVM32.name (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodePubMedVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeRefSeqVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeTagVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeTranscriptSourceVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeTranscriptSupportVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeTranscriptionSupportLevelVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)
      mm39.wgEncodeGencodeUniProtVM32.transcriptId (via wgEncodeGencodeAttrsVM32.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinIdtranscriptRank
ENSMUSG00000000001.5Gnai3protein_codingENSMUST00000000001.5Gnai3-201protein_codingOTTMUSG00000007197.1OTTMUST00000016610.1CCDS17751.12codingENSMUSP00000000001.51
ENSMUSG00000000003.16Pbsnprotein_codingENSMUST00000000003.14Pbsn-201protein_codingOTTMUSG00000017891.1OTTMUST00000043268.1CCDS30249.12codingENSMUSP00000000003.81
ENSMUSG00000020875.10Hoxb9protein_codingENSMUST00000000010.9Hoxb9-201protein_codingOTTMUSG00000001991.3OTTMUST00000003997.2CCDS25292.12codingENSMUSP00000000010.91
ENSMUSG00000000028.16Cdc45protein_codingENSMUST00000000028.14Cdc45-201protein_codingOTTMUSG00000026176.4OTTMUST00000064673.1CCDS28027.12codingENSMUSP00000000028.81
ENSMUSG00000048583.17Igf2protein_codingENSMUST00000000033.12Igf2-201protein_codingOTTMUSG00000035324.10OTTMUST00000035617.4CCDS52458.12codingENSMUSP00000000033.62
ENSMUSG00000000049.12Apohprotein_codingENSMUST00000000049.6Apoh-201protein_codingOTTMUSG00000003129.2OTTMUST00000006445.1CCDS25574.12codingENSMUSP00000000049.61
ENSMUSG00000000058.7Cav2protein_codingENSMUST00000000058.7Cav2-201protein_codingOTTMUSG00000024026.1OTTMUST00000058748.1CCDS19923.12codingENSMUSP00000000058.71
ENSMUSG00000000078.8Klf6protein_codingENSMUST00000000080.8Klf6-201protein_codingOTTMUSG00000066476.1OTTMUST00000161492.1CCDS26229.12codingENSMUSP00000000080.71
ENSMUSG00000000085.17Scmh1protein_codingENSMUST00000000087.13Scmh1-201protein_codingOTTMUSG00000008809.2OTTMUST00000020044.1CCDS18589.12codingENSMUSP00000000087.72
ENSMUSG00000000088.8Cox5aprotein_codingENSMUST00000000090.8Cox5a-201protein_codingOTTMUSG00000063187.1OTTMUST00000153851.1CCDS23223.12codingENSMUSP00000000090.71

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