Schema for omimPhenotype
  Database: hg38    Primary Table: omimPhenotype    Row Count: 8,442   Data last updated: 2022-06-15
Format description: OMIM Phenotype
fieldexampleSQL type info description
omimId 606788int(11) range OMIM ID
description {Anorexia nervosa, suscepti...blob values phenotype description
phenotypeId 606788int(11) range phenotype ID
omimPhenoMapKey 2int(1) range phenotype class
inhMode  varchar(255) values Inheritance mode of phenotype, can be empty

Connected Tables and Joining Fields
        hg38.omim2gene.omimId (via omimPhenotype.omimId)
      hg38.omimAv.omimId (via omimPhenotype.omimId)
      hg38.omimGene2.name (via omimPhenotype.omimId)
      hg38.omimGeneMap.omimId (via omimPhenotype.omimId)
      hg38.omimGeneMap2.omimId (via omimPhenotype.omimId)
      hg38.omimGeneSymbol.omimId (via omimPhenotype.omimId)
      hgFixed.refLink.omimId (via omimPhenotype.omimId)

Sample Rows
 
omimIddescriptionphenotypeIdomimPhenoMapKeyinhMode
606788{Anorexia nervosa, susceptibility to, 1}6067882
618815Chromosome 1p36.33 duplication syndrome, ATAD3 gene cluster6188154Autosomal dominant
115665Cataract 8, multiple types1156652Autosomal dominant
605606{Psoriasis susceptibility 7}6056062
147571Immunodeficiency 386161263Autosomal recessive
103320Myasthenic syndrome, congenital, 8, with pre- and postsynaptic defects6151203Autosomal recessive
600315?Immunodeficiency 166155933Autosomal recessive
615291Ehlers-Danlos syndrome, spondylodysplastic type, 26153493Autosomal recessive
615291Spondyloepimetaphyseal dysplasia with joint laxity, type 1, with or without fractures2716403Autosomal recessive
615291Al-Gazali syndrome6094653Autosomal recessive

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