Schema for wgEncodeGencodeAttrsVM22
  Database: mm10    Primary Table: wgEncodeGencodeAttrsVM22    Row Count: 142,333   Data last updated: 2019-07-03
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSMUSG00000102693.1varchar(255) values
geneName 4933401J01Rikvarchar(255) values
geneType TECvarchar(255) values
geneStatus  varchar(255) values
transcriptId ENSMUST00000193812.1varchar(255) values
transcriptName 4933401J01Rik-201varchar(255) values
transcriptType TECvarchar(255) values
transcriptStatus  varchar(255) values
havanaGeneId OTTMUSG00000049935.1varchar(255) values
havanaTranscriptId OTTMUST00000127109.1varchar(255) values
ccdsId  varchar(255) values
level 2int(11) range
transcriptClass problemvarchar(255) values
proteinId  varchar(255) values

Connected Tables and Joining Fields
        mm10.wgEncodeGencodeGeneSourceVM22.geneId (via wgEncodeGencodeAttrsVM22.geneId)
      mm10.wgEncodeGencodeAnnotationRemarkVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeBasicVM22.name (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeCompVM22.name (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeExonSupportVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeGeneSymbolVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodePdbVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodePseudoGeneVM22.name (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodePubMedVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeRefSeqVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeTagVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeTranscriptSourceVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeTranscriptSupportVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeTranscriptionSupportLevelVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)
      mm10.wgEncodeGencodeUniProtVM22.transcriptId (via wgEncodeGencodeAttrsVM22.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSMUSG00000102693.14933401J01RikTECENSMUST00000193812.14933401J01Rik-201TECOTTMUSG00000049935.1OTTMUST00000127109.12problem
ENSMUSG00000064842.1Gm26206snRNAENSMUST00000082908.1Gm26206-201snRNA3nonCoding
ENSMUSG00000051951.5Xkr4protein_codingENSMUST00000162897.1Xkr4-203lncRNAOTTMUSG00000026353.2OTTMUST00000086625.12nonCoding
ENSMUSG00000051951.5Xkr4protein_codingENSMUST00000159265.1Xkr4-202lncRNAOTTMUSG00000026353.2OTTMUST00000086624.12nonCoding
ENSMUSG00000051951.5Xkr4protein_codingENSMUST00000070533.4Xkr4-201protein_codingOTTMUSG00000026353.2OTTMUST00000065166.1CCDS14803.12codingENSMUSP00000070648.4
ENSMUSG00000102851.1Gm18956processed_pseudogeneENSMUST00000192857.1Gm18956-201processed_pseudogeneOTTMUSG00000049958.1OTTMUST00000127143.11pseudo
ENSMUSG00000103377.1Gm37180TECENSMUST00000195335.1Gm37180-201TECOTTMUSG00000049960.1OTTMUST00000127145.12problem
ENSMUSG00000104017.1Gm37363TECENSMUST00000192336.1Gm37363-201TECOTTMUSG00000049961.1OTTMUST00000127146.12problem
ENSMUSG00000103025.1Gm37686TECENSMUST00000194099.1Gm37686-201TECOTTMUSG00000049930.1OTTMUST00000127101.12problem
ENSMUSG00000089699.1Gm1992lncRNAENSMUST00000161581.1Gm1992-201lncRNAOTTMUSG00000026352.1OTTMUST00000065165.12nonCoding

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