Schema for wgEncodeGencodeAttrsVM30
  Database: mm39    Primary Table: wgEncodeGencodeAttrsVM30    Row Count: 149,478   Data last updated: 2022-07-12
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSMUSG00000000001.5varchar(255) values
geneName Gnai3varchar(255) values
geneType protein_codingvarchar(255) values
geneStatus  varchar(255) values
transcriptId ENSMUST00000000001.5varchar(255) values
transcriptName Gnai3-201varchar(255) values
transcriptType protein_codingvarchar(255) values
transcriptStatus  varchar(255) values
havanaGeneId OTTMUSG00000007197.1varchar(255) values
havanaTranscriptId OTTMUST00000016610.1varchar(255) values
ccdsId CCDS17751.1varchar(255) values
level 2int(11) range
transcriptClass codingvarchar(255) values
proteinId ENSMUSP00000000001.5varchar(255) values

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeGeneSourceVM30.geneId (via wgEncodeGencodeAttrsVM30.geneId)
      mm39.wgEncodeGencodeAnnotationRemarkVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeBasicVM30.name (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeCompVM30.name (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeExonSupportVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeGeneSymbolVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodePdbVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodePseudoGeneVM30.name (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodePubMedVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeRefSeqVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeTagVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeTranscriptSourceVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeTranscriptSupportVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeTranscriptionSupportLevelVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)
      mm39.wgEncodeGencodeUniProtVM30.transcriptId (via wgEncodeGencodeAttrsVM30.transcriptId)

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

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