Schema for omimGeneMap2
  Database: hg38    Primary Table: omimGeneMap2    Row Count: 17,958   Data last updated: 2022-06-15
Format description: This table contains the same data as the genemap2.txt file downloaded from OMIM
Note: genome-wide queries are not available for this table.
fieldexampleSQL type info description
location 1pvarchar(255) values Cyto Location
compCtyoLoc  varchar(255) values Computed Cyto Location
omimId 606788int(11) range Mim Number
geneSymbol ANON1varchar(255) values Gene Symbol(s)
geneName Anorexia nervosa, susceptib...longblob   Gene Name
approvedSymbol  varchar(255) values Approved Symbol
entrez 171514varchar(255) values Entrez Gene ID
ensGeneId  varchar(255) values Ensembl Gene ID
comments  longblob   Comments
phenotypes {Anorexia nervosa, suscepti...longblob   Phenotypes
mmGeneId  longblob   Mouse Gene Symbol/ID

Connected Tables and Joining Fields
        hg38.kgXref.geneSymbol (via omimGeneMap2.geneSymbol)
      hg38.omimGeneMap.geneSymbol (via omimGeneMap2.geneSymbol) Note: genome-wide queries are not available for this table.
      hgFixed.ggGeneClass.gene (via omimGeneMap2.geneSymbol)
      hgFixed.ggGeneName.gene (via omimGeneMap2.geneSymbol)
      hgFixed.ggLink.gene1 (via omimGeneMap2.geneSymbol)
      hgFixed.ggLink.gene2 (via omimGeneMap2.geneSymbol)
      hg38.omim2gene.omimId (via omimGeneMap2.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGene2.name (via omimGeneMap2.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGeneMap.omimId (via omimGeneMap2.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimLocation.name (via omimGeneMap2.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimPhenotype.omimId (via omimGeneMap2.omimId) Note: genome-wide queries are not available for this table.
      hgFixed.refLink.omimId (via omimGeneMap2.omimId)

Sample Rows
 
locationcompCtyoLocomimIdgeneSymbolgeneNameapprovedSymbolentrezensGeneIdcommentsphenotypesmmGeneId
1p606788ANON1Anorexia nervosa, susceptibility to, 1171514{Anorexia nervosa, susceptibility to, 1}, 606788 (2)
1p36.33618815C1DUPp36.33, DUP1p36.33Chromosome 1p36.33 duplication syndrome, ATAD3 gene clusterChromosome 1p36.33 duplication syndrome, ATAD3 gene cluster, 618815 (4), Autosomal dominant
1pter-p36.13115665CTRCT8, CCVCataract, congenital, Volkmann type7792linked to Rh in Scottish familyCataract 8, multiple types, 115665 (2), Autosomal dominant
1pter-p36131190ERPL1, HLM2Endogenous retroviral pol gene-like sequence 1 (oncogene HLM2)
1p605606PSORS7Psoriasis susceptibility 765245{Psoriasis susceptibility 7}, 605606 (2)
1pter-p22.1154280SAI1, MTS1, TFS1Suppression of anchorage independence-1 (malignant transformation suppression-1)6298
1p36.331p36.33616765SAMD11, MRSSterile alpha motif domain-containing protein 11SAMD11148398ENSG00000187634Samd11 (MGI:2446220)
1p36.331p36.33610770NOC2L, NIRNOC2-like nucleolar-associated transcriptional repressorNOC2L26155ENSG00000188976Noc2l (MGI:1931051)
1p36.331p36.33619262KLHL17, AFKelch-like 17KLHL17339451ENSG00000187961Klhl17 (MGI:2678948)
1p36.331p36.33615921PERM1, C1orf170PPARGC1-and ESRR-induced regulator, muscle, 1PERM184808ENSG00000187642Perm1 (MGI:1921433)

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