Human Phenotype Ontology

Hello! Guest! Please Login or Register! Clinician Mode

Examples Gene: MT-ND1, POLG, Region: M:1-1000 Variant: m.8993T>G, 1:g.10042757T>C rs3888511 MSCV_0000006, ClinVar: RCV000000015, Disease: Leigh syndrome, Phenotype: Retinopathy

Grandparent Node:
Phenotypic abnormality (HP:0000118)

Parent Node:
Abnormality of metabolism/homeostasis (HP:0001939)

..Starting node
..Abnormal circulating porphyrin concentration (HP:0010472)

Term ID:	10472
Name:	Abnormal circulating porphyrin concentration
Synonym:
Definition:	An abnormality in the synthesis or catabolism of heme. Heme is composed of ferrous iron and protoporphyrin IX and is an essential molecule as the prosthetic group of hemeproteins such as hemoglobin, myoglobin, mitochondrial and microsomal cytochromes.
Comments:
Reference:	HP:0010472
Genes and Diseases:	SELECT DISTINCT 'HP:0010472' AS Input, t2.acc as HPO_ID, t2.name as HPO_term, g.Distance, t1.Entrez_gene AS Gene, t1.Entrez_gene_id AS Gene_id_entrez, t1.HGNC_ID, t1.DiseaseId, t1.DiseaseName, t1.Frequency, t1.Onset #, t1.ConceptID, Source, t1.Typical_association , h.Variants AS HGMD_variants, c.variants AS ClinVar_variants FROM hpo202212.graph_path AS g, hpo202212.term AS t, hpo202212.term AS t2 LEFT JOIN hpo202212.hpo_phenotype_to_genes as t1 ON (t1.HPO = t2.acc) LEFT JOIN gb_exome.clinvar_variation_latest_sum AS c ON ( c.Gene = t1.Entrez_Gene) LEFT JOIN gb_exome.hgmd_allmumt_sum_latest AS h ON (h.gene = t1.Entrez_Gene ) WHERE (t.acc ='HP:0010472' AND g.term1_id = t.id AND g.distance <=20 AND t2.id = g.term2_id) order by g.distance, gene, DiseaseName;