Schema for wgEncodeGencodeAttrsVM18
  Database: mm10    Primary Table: wgEncodeGencodeAttrsVM18    Row Count: 136,630   Data last updated: 2018-08-03
On download server: MariaDB table dump directory
fieldexampleSQL type info
geneId ENSMUSG00000102693.1varchar(255) values
geneName RP23-271O17.1varchar(255) values
geneType TECvarchar(255) values
geneStatus  varchar(255) values
transcriptId ENSMUST00000193812.1varchar(255) values
transcriptName RP23-271O17.1-001varchar(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.wgEncodeGencodeGeneSourceVM18.geneId (via wgEncodeGencodeAttrsVM18.geneId)
      mm10.wgEncodeGencodeAnnotationRemarkVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeBasicVM18.name (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeCompVM18.name (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeExonSupportVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodePdbVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodePseudoGeneVM18.name (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodePubMedVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeRefSeqVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeTagVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeTranscriptSourceVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeTranscriptSupportVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeTranscriptionSupportLevelVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)
      mm10.wgEncodeGencodeUniProtVM18.transcriptId (via wgEncodeGencodeAttrsVM18.transcriptId)

Sample Rows
 
geneIdgeneNamegeneTypegeneStatustranscriptIdtranscriptNametranscriptTypetranscriptStatushavanaGeneIdhavanaTranscriptIdccdsIdleveltranscriptClassproteinId
ENSMUSG00000102693.1RP23-271O17.1TECENSMUST00000193812.1RP23-271O17.1-001TECOTTMUSG00000049935.1OTTMUST00000127109.12problem
ENSMUSG00000064842.1Gm26206snRNAENSMUST00000082908.1Gm26206-201snRNA3nonCoding
ENSMUSG00000051951.5Xkr4protein_codingENSMUST00000162897.1AC157543.1-003processed_transcriptOTTMUSG00000026353.2OTTMUST00000086625.12nonCoding
ENSMUSG00000051951.5Xkr4protein_codingENSMUST00000159265.1AC157543.1-002processed_transcriptOTTMUSG00000026353.2OTTMUST00000086624.12nonCoding
ENSMUSG00000051951.5Xkr4protein_codingENSMUST00000070533.4AC157543.1-001protein_codingOTTMUSG00000026353.2OTTMUST00000065166.1CCDS14803.12codingENSMUSP00000070648.4
ENSMUSG00000102851.1RP23-317L18.1processed_pseudogeneENSMUST00000192857.1RP23-317L18.1-001processed_pseudogeneOTTMUSG00000049958.1OTTMUST00000127143.11pseudo
ENSMUSG00000103377.1RP23-317L18.4TECENSMUST00000195335.1RP23-317L18.4-001TECOTTMUSG00000049960.1OTTMUST00000127145.12problem
ENSMUSG00000104017.1RP23-317L18.3TECENSMUST00000192336.1RP23-317L18.3-001TECOTTMUSG00000049961.1OTTMUST00000127146.12problem
ENSMUSG00000103025.1RP23-115I1.6TECENSMUST00000194099.1RP23-115I1.6-001TECOTTMUSG00000049930.1OTTMUST00000127101.12problem
ENSMUSG00000089699.1RP23-115I1.1antisenseENSMUST00000161581.1RP23-115I1.1-001antisenseOTTMUSG00000026352.1OTTMUST00000065165.12nonCoding

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