Times Reported Time consuming queries #1

x Hide

[ User: pubeu - Total duration: 20s686ms - Times executed: 6 ]

x Hide

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '594729' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-01-22 05:45:13
Duration: 3s701ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '594729' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-01-22 11:34:19
Duration: 3s556ms
Database: ctddev51
User: pubeu
Bind query: yes

WITH recursive sub_node ( object_id, id, path, lvl ) AS ( SELECT n.object_id, n.id, ARRAY[n.nm_sort], 1 FROM dag_node n WHERE n.object_id = '594729' UNION ALL SELECT n.object_id, n.id, CAST(path || n.nm_sort AS varchar(600)[]), sn.lvl + 1 FROM dag_node n INNER JOIN sub_node sn ON (n.parent_id = sn.id)) SELECT /* TreeTermBasicsDAO.getDescendants */ DISTINCT t.nm priNm, t.nm_html priNmHtml, t.secondary_nm secondaryNm, t.acc_db_cd accDbCd, t.acc_txt termAcc, t.is_leaf isLeaf, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_genes hasGenes, sn.lvl, sn.path, MAX(sn.lvl) OVER () maxLvl, t.has_phenotypes hasPhenotypes FROM sub_node sn INNER JOIN term t ON sn.object_id = t.id WHERE sn.lvl <= 2 ORDER BY sn.path;

Date: 2025-01-22 11:33:11
Duration: 3s543ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: pub2 - Total duration: 8s825ms - Times executed: 1 ]

x Hide

select distinct geneTerm.acc_txt ,geneTerm.nm ,'gene' ,chemTerm.acc_txt ,chemTerm.nm ,'chemical' from pub2.GENE_CHEM_REFERENCE gcr ,pub2.TERM geneTerm ,pub2.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id and ( gcr.chem_id IN ( SELECT id FROM term WHERE nm IN ( -- genes 'NOG' ,'TNF' ,'INS' ,'CASP3' ,'IL1B' ,'IL6' ,'MAPK1' ,'NFE2L2' ,'MAPK3' ,'HMOX1' ,'AHR' ,'CYP1A1' ,'PTGS2' ,'PPARA' ,'BCL2' ,'CAT' ,'ESR1' ,'BAX' ,'NOS2' ,'RELA' ,'TGFB1' ,'TP53' ,'RORA' ,'AKT1' ,'CXCL8' ,'PPARG' ,'IFNG' ,'AR' ,'INS1' ,'ACHE' ,'PARP1' ,'CASP9' ,'CCL2' ,'NQO1' ,'CDKN1A' ,'CYP3A4' ,'MMP9' ,'SOD2' ,'APP' ,'VEGFA' ,'CYP1A2' ,'CCND1' ,'FOS' ,'NFKBIA' ,'SOD1' ,'HIF1A' ,'DDIT3' ,'ESR2' ,'JUN' ,'IL10' ,'AGT' ,'FGF2' ,'ABCB1' ,'CYP2E1' ,'GPT' ,'NR1I3' ,'CYP1B1' ,'CASP8' ,'NR1I2' ,'MAPK8' ,'EGF' ,'SIRT1' ,'GSR' ,'ACTA2' ,'MPO' ,'MYC' ,'ICAM1' ,'HSPA5' ,'MMP2' ,'G3BP1' ,'STAT3' ,'SQSTM1' ,'EGFR' ,'IL4' ,'NFKB1' ,'TLR4' ,'CASP1' ,'ALB' ,'RX3' ,'CTNNB1' ,'NOS3' ,'IGF1' ,'BCL2L1' ,'COL1A1' ,'GCLC' ,'NLRP3' ,'MAP1LC3B' ,'CDH1' ,'SREBF1' ,'GSK3B' ,'MTOR' ,'FASN' ,'PCNA' ,'ABCC2' ,'STAR' ,'PGR' ,'BDNF' ,'PPARGC1A' ,'CYP19A1' ,'GPX1' ,'H2AX' ,'LEP' ,'VIM' ,'IL18' ,'OGA' ,'GSTP1' ,'ADIPOQ' ,'BECN1' ,'IL1A' ,'TRP53' ,'FAS' ,'EGR1' ,'VCAM1' ,'NR1H4' ,'NR3C1' ,'APOE' ,'ABCG2' ,'FN1' ,'MYD88' ,'IL2' ,'CXCL1' ,'FSHB' ,'CREB1' ,'EDN1' ,'BIRC5' ,'SERPINE1' ,'ABCC1' ,'CNR1' ,'ABCB11' ,'CYCS' ,'CD36' ,'TIMP1' ,'GCLM' ,'CYP2C9' ,'TNFSF10' ,'LHB' ,'TH' ,'CXCL2' ,'FABP4' ,'BCHE' ,'ATF4' ,'PON1' ,'CYP11A1' ,'SPP1' ,'CASP7' ,'HMGCR' ,'MAPK9' ,'IL12B' ,'CYP17A1' ,'CCNB1' ,'CDKN1B' ,'CYP2B6' ,'RB1' ,'PRL' ,'MAPK14' ,'CEBPB' ,'CXCL10' ,'TIPARP' ,'GADD45A' ,'XBP1' ,'ATF3' ,'TRPV1' ,'CDK1' ,'MT1' ,'LPL' ,'GJA1' ,'MKI67' ,'MAPT' ,'ADRB2' ,'PTEN' ,'TXNRD1' ,'CPT1A' ,'KEAP1' ,'CYP7A1' ,'SLC2A1' ,'CCL5' ,'RPS6KB1' ,'ACACA' ,'KCNH2' ,'CEBPA' ,'STAT1' ,'INHBA' ,'MCL1' ,'BMP4' ,'CCN2' ,'SRC' ,'CSF2' ,'PTGS1' ,'EIF2AK3' ,'XDH' ,'SNCA' ,'ABCA1' ,'CDK2' ,'GPX4' ,'THRB' ,'CNR2' ,'DRD2' ,'LDLR' ,'GSTM1' ,'ABCC3' -- chemicals ,'bisphenol A' ,'Tetrachlorodibenzodioxin' ,'Benzo(a)pyrene' ,'Valproic Acid' ,'sodium arsenite' ,'Lipopolysaccharides' ,'Estradiol' ,'Acetaminophen' ,'4-(5-benzo(1,3)dioxol-5-yl-4-pyridin-2-yl-1H-imidazol-2-yl)benzamide' ,'dorsomorphin' ,'Particulate Matter' ,'Dexamethasone' ,'Cadmium Chloride' ,'titanium dioxide' ,'Aflatoxin B1' ,'Air Pollutants' ,'Cisplatin' ,'Tobacco Smoke Pollution' ,'Carbon Tetrachloride' ,'Resveratrol' ,'Doxorubicin' ,'pirinixic acid' ,'Ethinyl Estradiol' ,'Ozone' ,'Tretinoin' ,'Ethanol' ,'Dietary Fats' ,'Thioacetamide' ,'Cyclosporine' ,'Nanotubes, Carbon' ,'perfluorooctane sulfonic acid' ,'bisphenol S' ,'Folic Acid' ,'Vehicle Emissions' ,'1,2-Dimethylhydrazine' ,'Oxygen' ,'trichostatin A' ,'1-Methyl-3-isobutylxanthine' ,'Silicon Dioxide' ,'Indomethacin' ,'bisphenol F' ,'CGP 52608' ,'Atrazine' ,'Arsenic Trioxide' ,'methylmercuric chloride' ,'Cadmium' ,'Phenobarbital' ,'arsenite' ,'decamethrin' ,'Paraquat' ,'Tetradecanoylphorbol Acetate' ,'Quercetin' ,'Propylthiouracil' ,'Hydrogen Peroxide' ,'perfluorooctanoic acid' ,'Glucose' ,'Copper' ,'Smoke' ,'Chlorpyrifos' ,'triphenyl phosphate' ,'Gentamicins' ,'Diethylhexyl Phthalate' ,'Arsenic' ,'Rotenone' ,'Diethylnitrosamine' ,'Testosterone' ,'Acrylamide' ,'Phenylmercuric Acetate' ,'Dibutyl Phthalate' ,'Streptozocin' ,'Progesterone' ,'Plant Extracts' ,'Trichloroethylene' ,'aristolochic acid I' ,'Copper Sulfate' ,'cobaltous chloride' ,'Methyl Methanesulfonate' ,'Methamphetamine' ,'(+)-JQ1 compound' ,'jinfukang' ,'deoxynivalenol' ,'vinclozolin' ,'abrine' ,'Nickel' ,'Dioxins' ,'Genistein' ,'Fulvestrant' ,'Clofibrate' ,'Rosiglitazone' ,'Soot' ,'Cocaine' ,'Sunitinib' ,'Dronabinol' ,'Methotrexate' ,'JP8 aviation fuel' ,'triptonide' ,'entinostat' ,'2,2'',4,4''-tetrabromodiphenyl ether' ,'Tamoxifen' ,'Acetylcysteine' ,'1-Methyl-4-phenylpyridinium' ,'Calcitriol' ,'Acrolein' ,'di-n-butylphosphoric acid' ,'Thiram' ,'Endosulfan' ,'Zinc' ,'Ammonium Chloride' ,'Choline' ,'Ionomycin' ,'Formaldehyde' ,'tris(1,3-dichloro-2-propyl)phosphate' ,'Caffeine' ,'potassium chromate(VI)' ,'Methionine' ,'lead acetate' ,'perfluorooctanesulfonamide' ,'lipopolysaccharide, E coli O55-B5' ,'Flutamide' ,'Vorinostat' ,'furan' ,'Ivermectin' ,'Curcumin' ,'Lead' ,'Urethane' ,'Troglitazone' ,'S-(1,2-dichlorovinyl)cysteine' ,'Fluorouracil' ,'Fenretinide' ,'ethylene dichloride' ,'Dextran Sulfate' ,'hexabromocyclododecane' ,'Asbestos, Crocidolite' ,'7,8-Dihydro-7,8-dihydroxybenzo(a)pyrene 9,10-oxide' ,'sodium arsenate' ,'manganese chloride' ,'lipopolysaccharide, Escherichia coli O111 B4' ,'Cuprizone' ,'Methapyrilene' ,'Topotecan' ,'Isoproterenol' ,'epoxiconazole' ,'FR900359' ,'Methimazole' ,'Nicotine' ,'Antirheumatic Agents' ,'3,4,5,3'',4''-pentachlorobiphenyl' ,'methacrylaldehyde' ,'chromium hexavalent ion' ,'Triclosan' ,'Glyphosate' ,'N-Methyl-3,4-methylenedioxyamphetamine' ,'mono-(2-ethylhexyl)phthalate' ,'Aluminum' ,'Oxaliplatin' ,'T-2 Toxin' ,'Cellulose' ,'Decitabine' ,'acetamide' ,'Amitrole' ,'beta-lapachone' ,'Cyclophosphamide' ,'butyraldehyde' ,'Selenium' ,'alpha-pinene' ,'Temozolomide' ,'Amiodarone' ,'4,4''-diaminodiphenylmethane' ,'1,4-bis(2-(3,5-dichloropyridyloxy))benzene' ,'Panobinostat' ,'Diethylstilbestrol' ,'decabromobiphenyl ether' ,'Tunicamycin' ,'Carbamazepine' ,'Lactic Acid' ,'Sodium Fluoride' ,'Cannabidiol' ,'ochratoxin A' ,'epigallocatechin gallate' ,'1-Naphthylisothiocyanate' ,'fipronil' ,'Mercuric Chloride' ,'Coumestrol' ,'Paclitaxel' ,'bisphenol AF' ,'tert-Butylhydroperoxide' ,'dicrotophos' ,'sulforaphane' ,'Enzyme Inhibitors' ,'Dichlorodiphenyl Dichloroethylene' ,'1H,1H,10H,10H-perfluorodecane-1,10-diol' ,'Methoxychlor' ,'Thapsigargin' ,'Leflunomide' ,'Haloperidol' ,'2,4,5,2'',4'',5''-hexachlorobiphenyl' ,'9,10-Dimethyl-1,2-benzanthracene' ,'Silver' -- diseases ,'Chemical and Drug Induced Liver Injury' ,'Seizures' ,'Hypertension' ,'Hypotension' ,'Kidney Diseases' ,'Pain' ,'Acute Kidney Injury' ,'Breast Neoplasms' ,'Necrosis' ,'Weight Loss' ,'Inflammation' ,'Drug-Related Side Effects and Adverse Reactions' ,'Cocaine-Related Disorders' ,'Heart Failure' ,'Substance Withdrawal Syndrome' ,'Depressive Disorder' ,'Bradycardia' ,'Prostatic Neoplasms' ,'Hyperalgesia' ,'Prenatal Exposure Delayed Effects' ,'Myocardial Infarction' ,'Catalepsy' ,'Liver Cirrhosis, Experimental' ,'Hyperkinesis' ,'Edema' ,'Arrhythmias, Cardiac' ,'Carcinoma, Hepatocellular' ,'Dyskinesia, Drug-Induced' ,'Nausea' ,'Vomiting' ,'Lung Neoplasms' ,'Disease Models, Animal' ,'Hyperglycemia' ,'Hepatomegaly' ,'Weight Gain' ,'Cardiomyopathies' ,'Tachycardia' ,'Headache' ,'Bipolar Disorder' ,'Nerve Degeneration' ,'Proteinuria' ,'Diabetes Mellitus, Experimental' ,'Anemia' ,'Memory Disorders' ,'Tremor' ,'Peripheral Nervous System Diseases' ,'Fatty Liver' ,'Parkinson Disease' ,'Liver Neoplasms' ,'Status Epilepticus' ,'Schizophrenia' ,'Thrombocytopenia' ,'Liver Neoplasms, Experimental' ,'Cognition Disorders' ,'Heart Diseases' ,'Hemorrhage' ,'Arthritis, Rheumatoid' ,'Renal Insufficiency' ,'Fever' ,'Asthma' ,'Cholestasis' ,'Insulin Resistance' ,'Urinary Bladder Neoplasms' ,'Obesity' ,'Nervous System Diseases' ,'Liver Cirrhosis' ,'Poisoning' ,'Muscular Diseases' ,'Diarrhea' ,'Neoplasms, Experimental' ,'Colorectal Neoplasms' ,'Atrial Fibrillation' ,'Neutropenia' ,'Tachycardia, Ventricular' ,'Anxiety Disorders' ,'Colonic Neoplasms' ,'Epilepsy' ,'Myocardial Ischemia' ,'Stomach Neoplasms' ,'Amnesia' ,'Cardiomegaly' ,'Brain Injuries' ,'Parkinsonian Disorders' ,'Diabetes Mellitus, Type 2' ,'Neoplasm Metastasis' ,'Melanoma' ,'Neoplasm Invasiveness' ,'Torsades de Pointes' ,'Neoplasms' ,'Long QT Syndrome' ,'Ventricular Dysfunction, Left' ,'Cell Transformation, Neoplastic' ,'Thrombosis' ,'Pain, Postoperative' ,'Movement Disorders' ,'Hallucinations' ,'Dystonia' ,'Nephritis, Interstitial' ,'Stomach Ulcer' ,'Carcinoma, Non-Small-Cell Lung' ,'Pulmonary Fibrosis' ,'Brain Diseases' ,'Fibrosis' ,'Learning Disabilities' ,'Heart Arrest' ,'Drug Hypersensitivity' ,'Liver Diseases' ,'Psychoses, Substance-Induced' ,'Dizziness' ,'Cardiovascular Diseases' ,'Hypokalemia' ,'Ventricular Fibrillation' ,'Autistic Disorder' ,'Precursor Cell Lymphoblastic Leukemia-Lymphoma' ,'Myoclonus' ,'Hyperplasia' ,'Precancerous Conditions' ,'Multiple Myeloma' ,'Angina Pectoris' ,'Neurotoxicity Syndromes' ,'Liver Failure, Acute' ,'Leukemia, Promyelocytic, Acute' ,'Adenocarcinoma' ,'Basal Ganglia Diseases' ,'Cystitis' ,'Hepatitis B' ,'Hepatitis' ,'Dermatitis, Allergic Contact' ,'Leukemia, Myeloid, Acute' ,'Lung Injury' ,'HIV Infections' ,'Ataxia' ,'Ovarian Neoplasms' ,'Atherosclerosis' ,'Mammary Neoplasms, Experimental' ,'Abnormalities, Drug-Induced' ,'Confusion' ,'Staphylococcal Infections' ,'Autism Spectrum Disorder' ,'Stroke' ,'Leukopenia' ,'Testicular Diseases' ,'Reperfusion Injury' ,'Colitis' ,'Alzheimer Disease' ,'Carcinoma' ,'Glucose Intolerance' ,'Skin Neoplasms' ,'Anemia, Hemolytic' ,'Exanthema' ,'Hypertension, Pulmonary' ,'Muscle Rigidity' ,'Psychotic Disorders' ,'Hypercholesterolemia' ,'Angioedema' ,'Delirium' ,'Non-alcoholic Fatty Liver Disease' ,'Paralysis' ,'Apnea' ,'Pulmonary Edema' ,'Pneumonia' ,'Micronuclei, Chromosome-Defective' ,'Venous Thrombosis' ,'Parkinson Disease, Secondary' ,'Nephrotic Syndrome' ,'Muscle Weakness' ,'Pruritus' ,'Drug Eruptions' ,'Acute Lung Injury' ,'Hypothermia' ,'Pancreatic Neoplasms' ,'Diabetic Nephropathies' ,'Gastrointestinal Diseases' ,'Substance-Related Disorders' ,'Coma' ,'Epilepsy, Tonic-Clonic' ,'Craniofacial Abnormalities' ,'Stevens-Johnson Syndrome' ,'Migraine Disorders' ,'Vision Disorders' ,'Jaundice' ,'Paresthesia' ,'Carcinoma, Squamous Cell' ,'Fatigue' ,'Cerebral Hemorrhage' ,'Hypercalcemia' ,'Skin Diseases' ,'Hypotension, Orthostatic' ,'Urticaria' ,'Hematuria' ,'Erectile Dysfunction' ,'Colitis, Ulcerative' ,'Mammary Neoplasms, Animal' ,'Lung Diseases' ,'Rhabdomyolysis' ,'Oligospermia' ,'Depressive Disorder, Major' ,'Anemia, Aplastic' ,'Anorexia' ,'Hyperlipidemias' -- phenotypes ,'apoptotic process' ,'cell population proliferation' ,'cellular metabolic process' ,'lipid oxidation' ,'glutathione metabolic process' ,'reactive oxygen species metabolic process' ,'lipid catabolic process' ,'cell death' ,'detection of oxidative stress' ,'positive regulation of apoptotic process' ,'superoxide dismutase activity' ,'positive regulation of reactive oxygen species biosynthetic process' ,'positive regulation of cell death' ,'regulation of blood pressure' ,'reactive oxygen species biosynthetic process' ,'negative regulation of cell population proliferation' ,'regulation of mitochondrial membrane potential' ,'vasoconstriction' ,'glutathione biosynthetic process' ,'membrane lipid catabolic process' ,'glutathione peroxidase activity' ,'cellular response to DNA damage stimulus' ,'cholesterol metabolic process' ,'positive regulation of cell population proliferation' ,'triglyceride metabolic process' ,'response to oxidative stress' ,'regulation of heart rate' ,'negative regulation of mitotic cell cycle' ,'vasodilation' ,'ATP metabolic process' ,'cell growth' ,'cellular calcium ion homeostasis' ,'leukocyte migration involved in inflammatory response' ,'nitric oxide metabolic process' ,'creatinine metabolic process' ,'apoptotic DNA fragmentation' ,'lipid droplet formation' ,'ncRNA transcription' ,'protein oxidation' ,'mitotic cell cycle process' ,'DNA modification' ,'inflammatory response' ,'cholesterol homeostasis' ,'glutathione transferase activity' ,'autophagy' ,'fat cell differentiation' ,'triglyceride homeostasis' ,'lipid metabolic process' ,'necrotic cell death' ,'xenobiotic metabolic process' ,'negative regulation of superoxide dismutase activity' ,'triglyceride biosynthetic process' ,'cell migration' ,'cell redox homeostasis' ,'bile acid metabolic process' ,'nitric oxide biosynthetic process' ,'superoxide anion generation' ,'lactate dehydrogenase activity' ,'cell cycle' ,'amino acid metabolic process' ,'testosterone biosynthetic process' ,'activation of protein kinase B activity' ,'L-aspartate:2-oxoglutarate aminotransferase activity' ,'positive regulation of nitric oxide biosynthetic process' ,'cholesterol biosynthetic process' ,'protein import into nucleus' ,'positive regulation of protein import into nucleus' ,'wound healing, spreading of cells' ,'alkaline phosphatase activity' ,'positive regulation of cytosolic calcium ion concentration' ,'glucose homeostasis' ,'positive regulation of mitochondrial membrane potential' ,'fatty acid metabolic process' ,'cell chemotaxis' ,'positive regulation of vasoconstriction' ,'spermatogenesis' ,'positive regulation of neuron death' ,'positive regulation of superoxide dismutase activity' ,'collagen fibril organization' ,'cell differentiation' ,'histone H3-K9 acetylation' ,'mitochondrion organization' ,'positive regulation of protein localization to nucleus' ,'positive regulation of p38MAPK cascade' ,'ATP biosynthetic process' ,'metabolic process' ,'locomotion involved in locomotory behavior' ,'urate metabolic process' ,'dopamine metabolic process' ,'positive regulation of NF-kappaB transcription factor activity' ,'embryo development' ,'lipid biosynthetic process' ,'protein lipidation' ,'histamine secretion mediated by immunoglobulin' ,'glucose metabolic process' ,'negative regulation of mitochondrial membrane potential' ,'release of cytochrome c from mitochondria' ,'DNA catabolic process, endonucleolytic' ,'cellular respiration' ,'calcium ion homeostasis' ,'positive regulation of cell migration' ,'regulation of cellular metabolic process' ,'reactive nitrogen species metabolic process' ,'positive regulation of inflammatory response' ,'establishment of protein localization to plasma membrane' ,'lipid homeostasis' ,'response to antineoplastic agent' ,'glucose import' ,'urea metabolic process' ,'positive regulation of ERK1 and ERK2 cascade' ,'positive regulation of necrotic cell death' ,'memory' ,'negative regulation of glutathione peroxidase activity' ,'positive regulation of apoptotic DNA fragmentation' ,'mitochondrial depolarization' ,'G2/M transition of mitotic cell cycle' ,'cAMP metabolic process' ,'mitotic S phase' ,'hydrogen peroxide biosynthetic process' ,'positive regulation of superoxide anion generation' ,'positive regulation of autophagy' ,'protein modification process' ,'regulation of metabolic process' ,'cellular iron ion homeostasis' ,'lactate metabolic process' ,'DNA methylation on cytosine within a CG sequence' ,'apoptotic chromosome condensation' ,'serotonin metabolic process' ,'cellular lipid metabolic process' ,'positive regulation of glutathione peroxidase activity' ,'transepithelial transport' ,'positive regulation of lipid storage' ,'hydrogen peroxide metabolic process' ,'G0 to G1 transition' ,'positive regulation of collagen biosynthetic process' ,'iron ion homeostasis' ,'positive regulation of cytolysis' ,'gluconeogenesis' ,'micronucleus organization' ,'microglial cell activation' ,'positive regulation of autophagosome assembly' ,'positive regulation of NIK/NF-kappaB signaling' ,'calcium-mediated signaling' ,'positive regulation of cytokine production involved in inflammatory response' ,'cellular senescence' ,'neuron death' ,'macrophage activation' ,'cAMP biosynthetic process' ,'positive regulation of lipid catabolic process' ,'negative regulation of response to drug' ,'calcium ion import' ,'behavioral response to pain' ,'positive regulation of intracellular estrogen receptor signaling pathway' ,'regulation of bile acid metabolic process' ,'mitotic cell cycle' ,'autophagosome assembly' ,'prostaglandin metabolic process' ,'protein poly-ADP-ribosylation' ,'DNA methylation' ,'glycolytic process' ,'positive regulation of fat cell differentiation' ,'protein lipidation involved in autophagosome assembly' ,'estrogen metabolic process' ,'thyroid hormone metabolic process' ,'positive regulation of organ growth' ,'neutrophil migration' ,'NADH dehydrogenase (ubiquinone) activity' ,'prostaglandin biosynthetic process' ,'negative regulation of ATP biosynthetic process' ,'adipose tissue development' ,'larval development' ,'androgen metabolic process' ,'amino acid biosynthetic process' ,'aerobic respiration' ,'positive regulation of cellular extravasation' ,'positive regulation of neutrophil extravasation' ,'negative regulation of cell migration' ,'carbohydrate metabolic process' ,'positive regulation of JNK cascade' ,'positive regulation of neuron apoptotic process' ,'positive regulation of release of cytochrome c from mitochondria' ,'cognition' ,'vacuole organization' ,'renal sodium excretion' ,'osteoclast differentiation' ,'positive regulation of epithelial to mesenchymal transition' ,'glutathione derivative biosynthetic process' ,'arachidonic acid metabolic process' ,'neurotransmitter metabolic process' ,'stress granule assembly' ,'sperm motility' ,'hepatocyte differentiation' ,'AMP-activated protein kinase activity' ,'swimming behavior' ,'negative regulation of monooxygenase activity' ,'fatty acid homeostasis' ,'L-ascorbic acid metabolic process' ,'pyroptosis' ,'response to xenobiotic stimulus' ,'positive regulation of prostaglandin biosynthetic process' ) ) or gcr.gene_id IN ( SELECT id FROM term WHERE nm IN ( -- genes 'NOG' ,'TNF' ,'INS' ,'CASP3' ,'IL1B' ,'IL6' ,'MAPK1' ,'NFE2L2' ,'MAPK3' ,'HMOX1' ,'AHR' ,'CYP1A1' ,'PTGS2' ,'PPARA' ,'BCL2' ,'CAT' ,'ESR1' ,'BAX' ,'NOS2' ,'RELA' ,'TGFB1' ,'TP53' ,'RORA' ,'AKT1' ,'CXCL8' ,'PPARG' ,'IFNG' ,'AR' ,'INS1' ,'ACHE' ,'PARP1' ,'CASP9' ,'CCL2' ,'NQO1' ,'CDKN1A' ,'CYP3A4' ,'MMP9' ,'SOD2' ,'APP' ,'VEGFA' ,'CYP1A2' ,'CCND1' ,'FOS' ,'NFKBIA' ,'SOD1' ,'HIF1A' ,'DDIT3' ,'ESR2' ,'JUN' ,'IL10' ,'AGT' ,'FGF2' ,'ABCB1' ,'CYP2E1' ,'GPT' ,'NR1I3' ,'CYP1B1' ,'CASP8' ,'NR1I2' ,'MAPK8' ,'EGF' ,'SIRT1' ,'GSR' ,'ACTA2' ,'MPO' ,'MYC' ,'ICAM1' ,'HSPA5' ,'MMP2' ,'G3BP1' ,'STAT3' ,'SQSTM1' ,'EGFR' ,'IL4' ,'NFKB1' ,'TLR4' ,'CASP1' ,'ALB' ,'RX3' ,'CTNNB1' ,'NOS3' ,'IGF1' ,'BCL2L1' ,'COL1A1' ,'GCLC' ,'NLRP3' ,'MAP1LC3B' ,'CDH1' ,'SREBF1' ,'GSK3B' ,'MTOR' ,'FASN' ,'PCNA' ,'ABCC2' ,'STAR' ,'PGR' ,'BDNF' ,'PPARGC1A' ,'CYP19A1' ,'GPX1' ,'H2AX' ,'LEP' ,'VIM' ,'IL18' ,'OGA' ,'GSTP1' ,'ADIPOQ' ,'BECN1' ,'IL1A' ,'TRP53' ,'FAS' ,'EGR1' ,'VCAM1' ,'NR1H4' ,'NR3C1' ,'APOE' ,'ABCG2' ,'FN1' ,'MYD88' ,'IL2' ,'CXCL1' ,'FSHB' ,'CREB1' ,'EDN1' ,'BIRC5' ,'SERPINE1' ,'ABCC1' ,'CNR1' ,'ABCB11' ,'CYCS' ,'CD36' ,'TIMP1' ,'GCLM' ,'CYP2C9' ,'TNFSF10' ,'LHB' ,'TH' ,'CXCL2' ,'FABP4' ,'BCHE' ,'ATF4' ,'PON1' ,'CYP11A1' ,'SPP1' ,'CASP7' ,'HMGCR' ,'MAPK9' ,'IL12B' ,'CYP17A1' ,'CCNB1' ,'CDKN1B' ,'CYP2B6' ,'RB1' ,'PRL' ,'MAPK14' ,'CEBPB' ,'CXCL10' ,'TIPARP' ,'GADD45A' ,'XBP1' ,'ATF3' ,'TRPV1' ,'CDK1' ,'MT1' ,'LPL' ,'GJA1' ,'MKI67' ,'MAPT' ,'ADRB2' ,'PTEN' ,'TXNRD1' ,'CPT1A' ,'KEAP1' ,'CYP7A1' ,'SLC2A1' ,'CCL5' ,'RPS6KB1' ,'ACACA' ,'KCNH2' ,'CEBPA' ,'STAT1' ,'INHBA' ,'MCL1' ,'BMP4' ,'CCN2' ,'SRC' ,'CSF2' ,'PTGS1' ,'EIF2AK3' ,'XDH' ,'SNCA' ,'ABCA1' ,'CDK2' ,'GPX4' ,'THRB' ,'CNR2' ,'DRD2' ,'LDLR' ,'GSTM1' ,'ABCC3' -- chemicals ,'bisphenol A' ,'Tetrachlorodibenzodioxin' ,'Benzo(a)pyrene' ,'Valproic Acid' ,'sodium arsenite' ,'Lipopolysaccharides' ,'Estradiol' ,'Acetaminophen' ,'4-(5-benzo(1,3)dioxol-5-yl-4-pyridin-2-yl-1H-imidazol-2-yl)benzamide' ,'dorsomorphin' ,'Particulate Matter' ,'Dexamethasone' ,'Cadmium Chloride' ,'titanium dioxide' ,'Aflatoxin B1' ,'Air Pollutants' ,'Cisplatin' ,'Tobacco Smoke Pollution' ,'Carbon Tetrachloride' ,'Resveratrol' ,'Doxorubicin' ,'pirinixic acid' ,'Ethinyl Estradiol' ,'Ozone' ,'Tretinoin' ,'Ethanol' ,'Dietary Fats' ,'Thioacetamide' ,'Cyclosporine' ,'Nanotubes, Carbon' ,'perfluorooctane sulfonic acid' ,'bisphenol S' ,'Folic Acid' ,'Vehicle Emissions' ,'1,2-Dimethylhydrazine' ,'Oxygen' ,'trichostatin A' ,'1-Methyl-3-isobutylxanthine' ,'Silicon Dioxide' ,'Indomethacin' ,'bisphenol F' ,'CGP 52608' ,'Atrazine' ,'Arsenic Trioxide' ,'methylmercuric chloride' ,'Cadmium' ,'Phenobarbital' ,'arsenite' ,'decamethrin' ,'Paraquat' ,'Tetradecanoylphorbol Acetate' ,'Quercetin' ,'Propylthiouracil' ,'Hydrogen Peroxide' ,'perfluorooctanoic acid' ,'Glucose' ,'Copper' ,'Smoke' ,'Chlorpyrifos' ,'triphenyl phosphate' ,'Gentamicins' ,'Diethylhexyl Phthalate' ,'Arsenic' ,'Rotenone' ,'Diethylnitrosamine' ,'Testosterone' ,'Acrylamide' ,'Phenylmercuric Acetate' ,'Dibutyl Phthalate' ,'Streptozocin' ,'Progesterone' ,'Plant Extracts' ,'Trichloroethylene' ,'aristolochic acid I' ,'Copper Sulfate' ,'cobaltous chloride' ,'Methyl Methanesulfonate' ,'Methamphetamine' ,'(+)-JQ1 compound' ,'jinfukang' ,'deoxynivalenol' ,'vinclozolin' ,'abrine' ,'Nickel' ,'Dioxins' ,'Genistein' ,'Fulvestrant' ,'Clofibrate' ,'Rosiglitazone' ,'Soot' ,'Cocaine' ,'Sunitinib' ,'Dronabinol' ,'Methotrexate' ,'JP8 aviation fuel' ,'triptonide' ,'entinostat' ,'2,2'',4,4''-tetrabromodiphenyl ether' ,'Tamoxifen' ,'Acetylcysteine' ,'1-Methyl-4-phenylpyridinium' ,'Calcitriol' ,'Acrolein' ,'di-n-butylphosphoric acid' ,'Thiram' ,'Endosulfan' ,'Zinc' ,'Ammonium Chloride' ,'Choline' ,'Ionomycin' ,'Formaldehyde' ,'tris(1,3-dichloro-2-propyl)phosphate' ,'Caffeine' ,'potassium chromate(VI)' ,'Methionine' ,'lead acetate' ,'perfluorooctanesulfonamide' ,'lipopolysaccharide, E coli O55-B5' ,'Flutamide' ,'Vorinostat' ,'furan' ,'Ivermectin' ,'Curcumin' ,'Lead' ,'Urethane' ,'Troglitazone' ,'S-(1,2-dichlorovinyl)cysteine' ,'Fluorouracil' ,'Fenretinide' ,'ethylene dichloride' ,'Dextran Sulfate' ,'hexabromocyclododecane' ,'Asbestos, Crocidolite' ,'7,8-Dihydro-7,8-dihydroxybenzo(a)pyrene 9,10-oxide' ,'sodium arsenate' ,'manganese chloride' ,'lipopolysaccharide, Escherichia coli O111 B4' ,'Cuprizone' ,'Methapyrilene' ,'Topotecan' ,'Isoproterenol' ,'epoxiconazole' ,'FR900359' ,'Methimazole' ,'Nicotine' ,'Antirheumatic Agents' ,'3,4,5,3'',4''-pentachlorobiphenyl' ,'methacrylaldehyde' ,'chromium hexavalent ion' ,'Triclosan' ,'Glyphosate' ,'N-Methyl-3,4-methylenedioxyamphetamine' ,'mono-(2-ethylhexyl)phthalate' ,'Aluminum' ,'Oxaliplatin' ,'T-2 Toxin' ,'Cellulose' ,'Decitabine' ,'acetamide' ,'Amitrole' ,'beta-lapachone' ,'Cyclophosphamide' ,'butyraldehyde' ,'Selenium' ,'alpha-pinene' ,'Temozolomide' ,'Amiodarone' ,'4,4''-diaminodiphenylmethane' ,'1,4-bis(2-(3,5-dichloropyridyloxy))benzene' ,'Panobinostat' ,'Diethylstilbestrol' ,'decabromobiphenyl ether' ,'Tunicamycin' ,'Carbamazepine' ,'Lactic Acid' ,'Sodium Fluoride' ,'Cannabidiol' ,'ochratoxin A' ,'epigallocatechin gallate' ,'1-Naphthylisothiocyanate' ,'fipronil' ,'Mercuric Chloride' ,'Coumestrol' ,'Paclitaxel' ,'bisphenol AF' ,'tert-Butylhydroperoxide' ,'dicrotophos' ,'sulforaphane' ,'Enzyme Inhibitors' ,'Dichlorodiphenyl Dichloroethylene' ,'1H,1H,10H,10H-perfluorodecane-1,10-diol' ,'Methoxychlor' ,'Thapsigargin' ,'Leflunomide' ,'Haloperidol' ,'2,4,5,2'',4'',5''-hexachlorobiphenyl' ,'9,10-Dimethyl-1,2-benzanthracene' ,'Silver' -- diseases ,'Chemical and Drug Induced Liver Injury' ,'Seizures' ,'Hypertension' ,'Hypotension' ,'Kidney Diseases' ,'Pain' ,'Acute Kidney Injury' ,'Breast Neoplasms' ,'Necrosis' ,'Weight Loss' ,'Inflammation' ,'Drug-Related Side Effects and Adverse Reactions' ,'Cocaine-Related Disorders' ,'Heart Failure' ,'Substance Withdrawal Syndrome' ,'Depressive Disorder' ,'Bradycardia' ,'Prostatic Neoplasms' ,'Hyperalgesia' ,'Prenatal Exposure Delayed Effects' ,'Myocardial Infarction' ,'Catalepsy' ,'Liver Cirrhosis, Experimental' ,'Hyperkinesis' ,'Edema' ,'Arrhythmias, Cardiac' ,'Carcinoma, Hepatocellular' ,'Dyskinesia, Drug-Induced' ,'Nausea' ,'Vomiting' ,'Lung Neoplasms' ,'Disease Models, Animal' ,'Hyperglycemia' ,'Hepatomegaly' ,'Weight Gain' ,'Cardiomyopathies' ,'Tachycardia' ,'Headache' ,'Bipolar Disorder' ,'Nerve Degeneration' ,'Proteinuria' ,'Diabetes Mellitus, Experimental' ,'Anemia' ,'Memory Disorders' ,'Tremor' ,'Peripheral Nervous System Diseases' ,'Fatty Liver' ,'Parkinson Disease' ,'Liver Neoplasms' ,'Status Epilepticus' ,'Schizophrenia' ,'Thrombocytopenia' ,'Liver Neoplasms, Experimental' ,'Cognition Disorders' ,'Heart Diseases' ,'Hemorrhage' ,'Arthritis, Rheumatoid' ,'Renal Insufficiency' ,'Fever' ,'Asthma' ,'Cholestasis' ,'Insulin Resistance' ,'Urinary Bladder Neoplasms' ,'Obesity' ,'Nervous System Diseases' ,'Liver Cirrhosis' ,'Poisoning' ,'Muscular Diseases' ,'Diarrhea' ,'Neoplasms, Experimental' ,'Colorectal Neoplasms' ,'Atrial Fibrillation' ,'Neutropenia' ,'Tachycardia, Ventricular' ,'Anxiety Disorders' ,'Colonic Neoplasms' ,'Epilepsy' ,'Myocardial Ischemia' ,'Stomach Neoplasms' ,'Amnesia' ,'Cardiomegaly' ,'Brain Injuries' ,'Parkinsonian Disorders' ,'Diabetes Mellitus, Type 2' ,'Neoplasm Metastasis' ,'Melanoma' ,'Neoplasm Invasiveness' ,'Torsades de Pointes' ,'Neoplasms' ,'Long QT Syndrome' ,'Ventricular Dysfunction, Left' ,'Cell Transformation, Neoplastic' ,'Thrombosis' ,'Pain, Postoperative' ,'Movement Disorders' ,'Hallucinations' ,'Dystonia' ,'Nephritis, Interstitial' ,'Stomach Ulcer' ,'Carcinoma, Non-Small-Cell Lung' ,'Pulmonary Fibrosis' ,'Brain Diseases' ,'Fibrosis' ,'Learning Disabilities' ,'Heart Arrest' ,'Drug Hypersensitivity' ,'Liver Diseases' ,'Psychoses, Substance-Induced' ,'Dizziness' ,'Cardiovascular Diseases' ,'Hypokalemia' ,'Ventricular Fibrillation' ,'Autistic Disorder' ,'Precursor Cell Lymphoblastic Leukemia-Lymphoma' ,'Myoclonus' ,'Hyperplasia' ,'Precancerous Conditions' ,'Multiple Myeloma' ,'Angina Pectoris' ,'Neurotoxicity Syndromes' ,'Liver Failure, Acute' ,'Leukemia, Promyelocytic, Acute' ,'Adenocarcinoma' ,'Basal Ganglia Diseases' ,'Cystitis' ,'Hepatitis B' ,'Hepatitis' ,'Dermatitis, Allergic Contact' ,'Leukemia, Myeloid, Acute' ,'Lung Injury' ,'HIV Infections' ,'Ataxia' ,'Ovarian Neoplasms' ,'Atherosclerosis' ,'Mammary Neoplasms, Experimental' ,'Abnormalities, Drug-Induced' ,'Confusion' ,'Staphylococcal Infections' ,'Autism Spectrum Disorder' ,'Stroke' ,'Leukopenia' ,'Testicular Diseases' ,'Reperfusion Injury' ,'Colitis' ,'Alzheimer Disease' ,'Carcinoma' ,'Glucose Intolerance' ,'Skin Neoplasms' ,'Anemia, Hemolytic' ,'Exanthema' ,'Hypertension, Pulmonary' ,'Muscle Rigidity' ,'Psychotic Disorders' ,'Hypercholesterolemia' ,'Angioedema' ,'Delirium' ,'Non-alcoholic Fatty Liver Disease' ,'Paralysis' ,'Apnea' ,'Pulmonary Edema' ,'Pneumonia' ,'Micronuclei, Chromosome-Defective' ,'Venous Thrombosis' ,'Parkinson Disease, Secondary' ,'Nephrotic Syndrome' ,'Muscle Weakness' ,'Pruritus' ,'Drug Eruptions' ,'Acute Lung Injury' ,'Hypothermia' ,'Pancreatic Neoplasms' ,'Diabetic Nephropathies' ,'Gastrointestinal Diseases' ,'Substance-Related Disorders' ,'Coma' ,'Epilepsy, Tonic-Clonic' ,'Craniofacial Abnormalities' ,'Stevens-Johnson Syndrome' ,'Migraine Disorders' ,'Vision Disorders' ,'Jaundice' ,'Paresthesia' ,'Carcinoma, Squamous Cell' ,'Fatigue' ,'Cerebral Hemorrhage' ,'Hypercalcemia' ,'Skin Diseases' ,'Hypotension, Orthostatic' ,'Urticaria' ,'Hematuria' ,'Erectile Dysfunction' ,'Colitis, Ulcerative' ,'Mammary Neoplasms, Animal' ,'Lung Diseases' ,'Rhabdomyolysis' ,'Oligospermia' ,'Depressive Disorder, Major' ,'Anemia, Aplastic' ,'Anorexia' ,'Hyperlipidemias' -- phenotypes ,'apoptotic process' ,'cell population proliferation' ,'cellular metabolic process' ,'lipid oxidation' ,'glutathione metabolic process' ,'reactive oxygen species metabolic process' ,'lipid catabolic process' ,'cell death' ,'detection of oxidative stress' ,'positive regulation of apoptotic process' ,'superoxide dismutase activity' ,'positive regulation of reactive oxygen species biosynthetic process' ,'positive regulation of cell death' ,'regulation of blood pressure' ,'reactive oxygen species biosynthetic process' ,'negative regulation of cell population proliferation' ,'regulation of mitochondrial membrane potential' ,'vasoconstriction' ,'glutathione biosynthetic process' ,'membrane lipid catabolic process' ,'glutathione peroxidase activity' ,'cellular response to DNA damage stimulus' ,'cholesterol metabolic process' ,'positive regulation of cell population proliferation' ,'triglyceride metabolic process' ,'response to oxidative stress' ,'regulation of heart rate' ,'negative regulation of mitotic cell cycle' ,'vasodilation' ,'ATP metabolic process' ,'cell growth' ,'cellular calcium ion homeostasis' ,'leukocyte migration involved in inflammatory response' ,'nitric oxide metabolic process' ,'creatinine metabolic process' ,'apoptotic DNA fragmentation' ,'lipid droplet formation' ,'ncRNA transcription' ,'protein oxidation' ,'mitotic cell cycle process' ,'DNA modification' ,'inflammatory response' ,'cholesterol homeostasis' ,'glutathione transferase activity' ,'autophagy' ,'fat cell differentiation' ,'triglyceride homeostasis' ,'lipid metabolic process' ,'necrotic cell death' ,'xenobiotic metabolic process' ,'negative regulation of superoxide dismutase activity' ,'triglyceride biosynthetic process' ,'cell migration' ,'cell redox homeostasis' ,'bile acid metabolic process' ,'nitric oxide biosynthetic process' ,'superoxide anion generation' ,'lactate dehydrogenase activity' ,'cell cycle' ,'amino acid metabolic process' ,'testosterone biosynthetic process' ,'activation of protein kinase B activity' ,'L-aspartate:2-oxoglutarate aminotransferase activity' ,'positive regulation of nitric oxide biosynthetic process' ,'cholesterol biosynthetic process' ,'protein import into nucleus' ,'positive regulation of protein import into nucleus' ,'wound healing, spreading of cells' ,'alkaline phosphatase activity' ,'positive regulation of cytosolic calcium ion concentration' ,'glucose homeostasis' ,'positive regulation of mitochondrial membrane potential' ,'fatty acid metabolic process' ,'cell chemotaxis' ,'positive regulation of vasoconstriction' ,'spermatogenesis' ,'positive regulation of neuron death' ,'positive regulation of superoxide dismutase activity' ,'collagen fibril organization' ,'cell differentiation' ,'histone H3-K9 acetylation' ,'mitochondrion organization' ,'positive regulation of protein localization to nucleus' ,'positive regulation of p38MAPK cascade' ,'ATP biosynthetic process' ,'metabolic process' ,'locomotion involved in locomotory behavior' ,'urate metabolic process' ,'dopamine metabolic process' ,'positive regulation of NF-kappaB transcription factor activity' ,'embryo development' ,'lipid biosynthetic process' ,'protein lipidation' ,'histamine secretion mediated by immunoglobulin' ,'glucose metabolic process' ,'negative regulation of mitochondrial membrane potential' ,'release of cytochrome c from mitochondria' ,'DNA catabolic process, endonucleolytic' ,'cellular respiration' ,'calcium ion homeostasis' ,'positive regulation of cell migration' ,'regulation of cellular metabolic process' ,'reactive nitrogen species metabolic process' ,'positive regulation of inflammatory response' ,'establishment of protein localization to plasma membrane' ,'lipid homeostasis' ,'response to antineoplastic agent' ,'glucose import' ,'urea metabolic process' ,'positive regulation of ERK1 and ERK2 cascade' ,'positive regulation of necrotic cell death' ,'memory' ,'negative regulation of glutathione peroxidase activity' ,'positive regulation of apoptotic DNA fragmentation' ,'mitochondrial depolarization' ,'G2/M transition of mitotic cell cycle' ,'cAMP metabolic process' ,'mitotic S phase' ,'hydrogen peroxide biosynthetic process' ,'positive regulation of superoxide anion generation' ,'positive regulation of autophagy' ,'protein modification process' ,'regulation of metabolic process' ,'cellular iron ion homeostasis' ,'lactate metabolic process' ,'DNA methylation on cytosine within a CG sequence' ,'apoptotic chromosome condensation' ,'serotonin metabolic process' ,'cellular lipid metabolic process' ,'positive regulation of glutathione peroxidase activity' ,'transepithelial transport' ,'positive regulation of lipid storage' ,'hydrogen peroxide metabolic process' ,'G0 to G1 transition' ,'positive regulation of collagen biosynthetic process' ,'iron ion homeostasis' ,'positive regulation of cytolysis' ,'gluconeogenesis' ,'micronucleus organization' ,'microglial cell activation' ,'positive regulation of autophagosome assembly' ,'positive regulation of NIK/NF-kappaB signaling' ,'calcium-mediated signaling' ,'positive regulation of cytokine production involved in inflammatory response' ,'cellular senescence' ,'neuron death' ,'macrophage activation' ,'cAMP biosynthetic process' ,'positive regulation of lipid catabolic process' ,'negative regulation of response to drug' ,'calcium ion import' ,'behavioral response to pain' ,'positive regulation of intracellular estrogen receptor signaling pathway' ,'regulation of bile acid metabolic process' ,'mitotic cell cycle' ,'autophagosome assembly' ,'prostaglandin metabolic process' ,'protein poly-ADP-ribosylation' ,'DNA methylation' ,'glycolytic process' ,'positive regulation of fat cell differentiation' ,'protein lipidation involved in autophagosome assembly' ,'estrogen metabolic process' ,'thyroid hormone metabolic process' ,'positive regulation of organ growth' ,'neutrophil migration' ,'NADH dehydrogenase (ubiquinone) activity' ,'prostaglandin biosynthetic process' ,'negative regulation of ATP biosynthetic process' ,'adipose tissue development' ,'larval development' ,'androgen metabolic process' ,'amino acid biosynthetic process' ,'aerobic respiration' ,'positive regulation of cellular extravasation' ,'positive regulation of neutrophil extravasation' ,'negative regulation of cell migration' ,'carbohydrate metabolic process' ,'positive regulation of JNK cascade' ,'positive regulation of neuron apoptotic process' ,'positive regulation of release of cytochrome c from mitochondria' ,'cognition' ,'vacuole organization' ,'renal sodium excretion' ,'osteoclast differentiation' ,'positive regulation of epithelial to mesenchymal transition' ,'glutathione derivative biosynthetic process' ,'arachidonic acid metabolic process' ,'neurotransmitter metabolic process' ,'stress granule assembly' ,'sperm motility' ,'hepatocyte differentiation' ,'AMP-activated protein kinase activity' ,'swimming behavior' ,'negative regulation of monooxygenase activity' ,'fatty acid homeostasis' ,'L-ascorbic acid metabolic process' ,'pyroptosis' ,'response to xenobiotic stimulus' ,'positive regulation of prostaglandin biosynthetic process' ) ) ) and ( gcr.chem_id, gcr.gene_id ) in ( select chem_id, gene_id from tetramer );

Date: 2025-01-22 12:35:34
Duration: 8s825ms
Database: ctddev51
User: pub2
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: pub2 - Total duration: 6s375ms - Times executed: 1 ]

x Hide

select distinct geneTerm.acc_txt ,geneTerm.nm ,'gene' ,chemTerm.acc_txt ,chemTerm.nm ,'chemical' from pub2.GENE_CHEM_REFERENCE gcr ,pub2.TERM geneTerm ,pub2.TERM chemTerm where gcr.gene_id = geneTerm.id and gcr.chem_id = chemTerm.id and ( gcr.chem_id IN ( SELECT id FROM term WHERE nm IN ( -- genes 'NOG' ,'TNF' ,'INS' ,'CASP3' ,'IL1B' ,'IL6' ,'MAPK1' ,'NFE2L2' ,'MAPK3' ,'HMOX1' ,'AHR' ,'CYP1A1' ,'PTGS2' ,'PPARA' ,'BCL2' ,'CAT' ,'ESR1' ,'BAX' ,'NOS2' ,'RELA' ,'TGFB1' ,'TP53' ,'RORA' ,'AKT1' ,'CXCL8' ,'PPARG' ,'IFNG' ,'AR' ,'INS1' ,'ACHE' ,'PARP1' ,'CASP9' ,'CCL2' ,'NQO1' ,'CDKN1A' ,'CYP3A4' ,'MMP9' ,'SOD2' ,'APP' ,'VEGFA' ,'CYP1A2' ,'CCND1' ,'FOS' ,'NFKBIA' ,'SOD1' ,'HIF1A' ,'DDIT3' ,'ESR2' ,'JUN' ,'IL10' ,'AGT' ,'FGF2' ,'ABCB1' ,'CYP2E1' ,'GPT' ,'NR1I3' ,'CYP1B1' ,'CASP8' ,'NR1I2' ,'MAPK8' ,'EGF' ,'SIRT1' ,'GSR' ,'ACTA2' ,'MPO' ,'MYC' ,'ICAM1' ,'HSPA5' ,'MMP2' ,'G3BP1' ,'STAT3' ,'SQSTM1' ,'EGFR' ,'IL4' ,'NFKB1' ,'TLR4' ,'CASP1' ,'ALB' ,'RX3' ,'CTNNB1' ,'NOS3' ,'IGF1' ,'BCL2L1' ,'COL1A1' ,'GCLC' ,'NLRP3' ,'MAP1LC3B' ,'CDH1' ,'SREBF1' ,'GSK3B' ,'MTOR' ,'FASN' ,'PCNA' ,'ABCC2' ,'STAR' ,'PGR' ,'BDNF' ,'PPARGC1A' ,'CYP19A1' ,'GPX1' ,'H2AX' ,'LEP' ,'VIM' ,'IL18' ,'OGA' ,'GSTP1' ,'ADIPOQ' ,'BECN1' ,'IL1A' ,'TRP53' ,'FAS' ,'EGR1' ,'VCAM1' ,'NR1H4' ,'NR3C1' ,'APOE' ,'ABCG2' ,'FN1' ,'MYD88' ,'IL2' ,'CXCL1' ,'FSHB' ,'CREB1' ,'EDN1' ,'BIRC5' ,'SERPINE1' ,'ABCC1' ,'CNR1' ,'ABCB11' ,'CYCS' ,'CD36' ,'TIMP1' ,'GCLM' ,'CYP2C9' ,'TNFSF10' ,'LHB' ,'TH' ,'CXCL2' ,'FABP4' ,'BCHE' ,'ATF4' ,'PON1' ,'CYP11A1' ,'SPP1' ,'CASP7' ,'HMGCR' ,'MAPK9' ,'IL12B' ,'CYP17A1' ,'CCNB1' ,'CDKN1B' ,'CYP2B6' ,'RB1' ,'PRL' ,'MAPK14' ,'CEBPB' ,'CXCL10' ,'TIPARP' ,'GADD45A' ,'XBP1' ,'ATF3' ,'TRPV1' ,'CDK1' ,'MT1' ,'LPL' ,'GJA1' ,'MKI67' ,'MAPT' ,'ADRB2' ,'PTEN' ,'TXNRD1' ,'CPT1A' ,'KEAP1' ,'CYP7A1' ,'SLC2A1' ,'CCL5' ,'RPS6KB1' ,'ACACA' ,'KCNH2' ,'CEBPA' ,'STAT1' ,'INHBA' ,'MCL1' ,'BMP4' ,'CCN2' ,'SRC' ,'CSF2' ,'PTGS1' ,'EIF2AK3' ,'XDH' ,'SNCA' ,'ABCA1' ,'CDK2' ,'GPX4' ,'THRB' ,'CNR2' ,'DRD2' ,'LDLR' ,'GSTM1' ,'ABCC3' -- chemicals ,'bisphenol A' ,'Tetrachlorodibenzodioxin' ,'Benzo(a)pyrene' ,'Valproic Acid' ,'sodium arsenite' ,'Lipopolysaccharides' ,'Estradiol' ,'Acetaminophen' ,'4-(5-benzo(1,3)dioxol-5-yl-4-pyridin-2-yl-1H-imidazol-2-yl)benzamide' ,'dorsomorphin' ,'Particulate Matter' ,'Dexamethasone' ,'Cadmium Chloride' ,'titanium dioxide' ,'Aflatoxin B1' ,'Air Pollutants' ,'Cisplatin' ,'Tobacco Smoke Pollution' ,'Carbon Tetrachloride' ,'Resveratrol' ,'Doxorubicin' ,'pirinixic acid' ,'Ethinyl Estradiol' ,'Ozone' ,'Tretinoin' ,'Ethanol' ,'Dietary Fats' ,'Thioacetamide' ,'Cyclosporine' ,'Nanotubes, Carbon' ,'perfluorooctane sulfonic acid' ,'bisphenol S' ,'Folic Acid' ,'Vehicle Emissions' ,'1,2-Dimethylhydrazine' ,'Oxygen' ,'trichostatin A' ,'1-Methyl-3-isobutylxanthine' ,'Silicon Dioxide' ,'Indomethacin' ,'bisphenol F' ,'CGP 52608' ,'Atrazine' ,'Arsenic Trioxide' ,'methylmercuric chloride' ,'Cadmium' ,'Phenobarbital' ,'arsenite' ,'decamethrin' ,'Paraquat' ,'Tetradecanoylphorbol Acetate' ,'Quercetin' ,'Propylthiouracil' ,'Hydrogen Peroxide' ,'perfluorooctanoic acid' ,'Glucose' ,'Copper' ,'Smoke' ,'Chlorpyrifos' ,'triphenyl phosphate' ,'Gentamicins' ,'Diethylhexyl Phthalate' ,'Arsenic' ,'Rotenone' ,'Diethylnitrosamine' ,'Testosterone' ,'Acrylamide' ,'Phenylmercuric Acetate' ,'Dibutyl Phthalate' ,'Streptozocin' ,'Progesterone' ,'Plant Extracts' ,'Trichloroethylene' ,'aristolochic acid I' ,'Copper Sulfate' ,'cobaltous chloride' ,'Methyl Methanesulfonate' ,'Methamphetamine' ,'(+)-JQ1 compound' ,'jinfukang' ,'deoxynivalenol' ,'vinclozolin' ,'abrine' ,'Nickel' ,'Dioxins' ,'Genistein' ,'Fulvestrant' ,'Clofibrate' ,'Rosiglitazone' ,'Soot' ,'Cocaine' ,'Sunitinib' ,'Dronabinol' ,'Methotrexate' ,'JP8 aviation fuel' ,'triptonide' ,'entinostat' ,'2,2'',4,4''-tetrabromodiphenyl ether' ,'Tamoxifen' ,'Acetylcysteine' ,'1-Methyl-4-phenylpyridinium' ,'Calcitriol' ,'Acrolein' ,'di-n-butylphosphoric acid' ,'Thiram' ,'Endosulfan' ,'Zinc' ,'Ammonium Chloride' ,'Choline' ,'Ionomycin' ,'Formaldehyde' ,'tris(1,3-dichloro-2-propyl)phosphate' ,'Caffeine' ,'potassium chromate(VI)' ,'Methionine' ,'lead acetate' ,'perfluorooctanesulfonamide' ,'lipopolysaccharide, E coli O55-B5' ,'Flutamide' ,'Vorinostat' ,'furan' ,'Ivermectin' ,'Curcumin' ,'Lead' ,'Urethane' ,'Troglitazone' ,'S-(1,2-dichlorovinyl)cysteine' ,'Fluorouracil' ,'Fenretinide' ,'ethylene dichloride' ,'Dextran Sulfate' ,'hexabromocyclododecane' ,'Asbestos, Crocidolite' ,'7,8-Dihydro-7,8-dihydroxybenzo(a)pyrene 9,10-oxide' ,'sodium arsenate' ,'manganese chloride' ,'lipopolysaccharide, Escherichia coli O111 B4' ,'Cuprizone' ,'Methapyrilene' ,'Topotecan' ,'Isoproterenol' ,'epoxiconazole' ,'FR900359' ,'Methimazole' ,'Nicotine' ,'Antirheumatic Agents' ,'3,4,5,3'',4''-pentachlorobiphenyl' ,'methacrylaldehyde' ,'chromium hexavalent ion' ,'Triclosan' ,'Glyphosate' ,'N-Methyl-3,4-methylenedioxyamphetamine' ,'mono-(2-ethylhexyl)phthalate' ,'Aluminum' ,'Oxaliplatin' ,'T-2 Toxin' ,'Cellulose' ,'Decitabine' ,'acetamide' ,'Amitrole' ,'beta-lapachone' ,'Cyclophosphamide' ,'butyraldehyde' ,'Selenium' ,'alpha-pinene' ,'Temozolomide' ,'Amiodarone' ,'4,4''-diaminodiphenylmethane' ,'1,4-bis(2-(3,5-dichloropyridyloxy))benzene' ,'Panobinostat' ,'Diethylstilbestrol' ,'decabromobiphenyl ether' ,'Tunicamycin' ,'Carbamazepine' ,'Lactic Acid' ,'Sodium Fluoride' ,'Cannabidiol' ,'ochratoxin A' ,'epigallocatechin gallate' ,'1-Naphthylisothiocyanate' ,'fipronil' ,'Mercuric Chloride' ,'Coumestrol' ,'Paclitaxel' ,'bisphenol AF' ,'tert-Butylhydroperoxide' ,'dicrotophos' ,'sulforaphane' ,'Enzyme Inhibitors' ,'Dichlorodiphenyl Dichloroethylene' ,'1H,1H,10H,10H-perfluorodecane-1,10-diol' ,'Methoxychlor' ,'Thapsigargin' ,'Leflunomide' ,'Haloperidol' ,'2,4,5,2'',4'',5''-hexachlorobiphenyl' ,'9,10-Dimethyl-1,2-benzanthracene' ,'Silver' -- diseases ,'Chemical and Drug Induced Liver Injury' ,'Seizures' ,'Hypertension' ,'Hypotension' ,'Kidney Diseases' ,'Pain' ,'Acute Kidney Injury' ,'Breast Neoplasms' ,'Necrosis' ,'Weight Loss' ,'Inflammation' ,'Drug-Related Side Effects and Adverse Reactions' ,'Cocaine-Related Disorders' ,'Heart Failure' ,'Substance Withdrawal Syndrome' ,'Depressive Disorder' ,'Bradycardia' ,'Prostatic Neoplasms' ,'Hyperalgesia' ,'Prenatal Exposure Delayed Effects' ,'Myocardial Infarction' ,'Catalepsy' ,'Liver Cirrhosis, Experimental' ,'Hyperkinesis' ,'Edema' ,'Arrhythmias, Cardiac' ,'Carcinoma, Hepatocellular' ,'Dyskinesia, Drug-Induced' ,'Nausea' ,'Vomiting' ,'Lung Neoplasms' ,'Disease Models, Animal' ,'Hyperglycemia' ,'Hepatomegaly' ,'Weight Gain' ,'Cardiomyopathies' ,'Tachycardia' ,'Headache' ,'Bipolar Disorder' ,'Nerve Degeneration' ,'Proteinuria' ,'Diabetes Mellitus, Experimental' ,'Anemia' ,'Memory Disorders' ,'Tremor' ,'Peripheral Nervous System Diseases' ,'Fatty Liver' ,'Parkinson Disease' ,'Liver Neoplasms' ,'Status Epilepticus' ,'Schizophrenia' ,'Thrombocytopenia' ,'Liver Neoplasms, Experimental' ,'Cognition Disorders' ,'Heart Diseases' ,'Hemorrhage' ,'Arthritis, Rheumatoid' ,'Renal Insufficiency' ,'Fever' ,'Asthma' ,'Cholestasis' ,'Insulin Resistance' ,'Urinary Bladder Neoplasms' ,'Obesity' ,'Nervous System Diseases' ,'Liver Cirrhosis' ,'Poisoning' ,'Muscular Diseases' ,'Diarrhea' ,'Neoplasms, Experimental' ,'Colorectal Neoplasms' ,'Atrial Fibrillation' ,'Neutropenia' ,'Tachycardia, Ventricular' ,'Anxiety Disorders' ,'Colonic Neoplasms' ,'Epilepsy' ,'Myocardial Ischemia' ,'Stomach Neoplasms' ,'Amnesia' ,'Cardiomegaly' ,'Brain Injuries' ,'Parkinsonian Disorders' ,'Diabetes Mellitus, Type 2' ,'Neoplasm Metastasis' ,'Melanoma' ,'Neoplasm Invasiveness' ,'Torsades de Pointes' ,'Neoplasms' ,'Long QT Syndrome' ,'Ventricular Dysfunction, Left' ,'Cell Transformation, Neoplastic' ,'Thrombosis' ,'Pain, Postoperative' ,'Movement Disorders' ,'Hallucinations' ,'Dystonia' ,'Nephritis, Interstitial' ,'Stomach Ulcer' ,'Carcinoma, Non-Small-Cell Lung' ,'Pulmonary Fibrosis' ,'Brain Diseases' ,'Fibrosis' ,'Learning Disabilities' ,'Heart Arrest' ,'Drug Hypersensitivity' ,'Liver Diseases' ,'Psychoses, Substance-Induced' ,'Dizziness' ,'Cardiovascular Diseases' ,'Hypokalemia' ,'Ventricular Fibrillation' ,'Autistic Disorder' ,'Precursor Cell Lymphoblastic Leukemia-Lymphoma' ,'Myoclonus' ,'Hyperplasia' ,'Precancerous Conditions' ,'Multiple Myeloma' ,'Angina Pectoris' ,'Neurotoxicity Syndromes' ,'Liver Failure, Acute' ,'Leukemia, Promyelocytic, Acute' ,'Adenocarcinoma' ,'Basal Ganglia Diseases' ,'Cystitis' ,'Hepatitis B' ,'Hepatitis' ,'Dermatitis, Allergic Contact' ,'Leukemia, Myeloid, Acute' ,'Lung Injury' ,'HIV Infections' ,'Ataxia' ,'Ovarian Neoplasms' ,'Atherosclerosis' ,'Mammary Neoplasms, Experimental' ,'Abnormalities, Drug-Induced' ,'Confusion' ,'Staphylococcal Infections' ,'Autism Spectrum Disorder' ,'Stroke' ,'Leukopenia' ,'Testicular Diseases' ,'Reperfusion Injury' ,'Colitis' ,'Alzheimer Disease' ,'Carcinoma' ,'Glucose Intolerance' ,'Skin Neoplasms' ,'Anemia, Hemolytic' ,'Exanthema' ,'Hypertension, Pulmonary' ,'Muscle Rigidity' ,'Psychotic Disorders' ,'Hypercholesterolemia' ,'Angioedema' ,'Delirium' ,'Non-alcoholic Fatty Liver Disease' ,'Paralysis' ,'Apnea' ,'Pulmonary Edema' ,'Pneumonia' ,'Micronuclei, Chromosome-Defective' ,'Venous Thrombosis' ,'Parkinson Disease, Secondary' ,'Nephrotic Syndrome' ,'Muscle Weakness' ,'Pruritus' ,'Drug Eruptions' ,'Acute Lung Injury' ,'Hypothermia' ,'Pancreatic Neoplasms' ,'Diabetic Nephropathies' ,'Gastrointestinal Diseases' ,'Substance-Related Disorders' ,'Coma' ,'Epilepsy, Tonic-Clonic' ,'Craniofacial Abnormalities' ,'Stevens-Johnson Syndrome' ,'Migraine Disorders' ,'Vision Disorders' ,'Jaundice' ,'Paresthesia' ,'Carcinoma, Squamous Cell' ,'Fatigue' ,'Cerebral Hemorrhage' ,'Hypercalcemia' ,'Skin Diseases' ,'Hypotension, Orthostatic' ,'Urticaria' ,'Hematuria' ,'Erectile Dysfunction' ,'Colitis, Ulcerative' ,'Mammary Neoplasms, Animal' ,'Lung Diseases' ,'Rhabdomyolysis' ,'Oligospermia' ,'Depressive Disorder, Major' ,'Anemia, Aplastic' ,'Anorexia' ,'Hyperlipidemias' -- phenotypes ,'apoptotic process' ,'cell population proliferation' ,'cellular metabolic process' ,'lipid oxidation' ,'glutathione metabolic process' ,'reactive oxygen species metabolic process' ,'lipid catabolic process' ,'cell death' ,'detection of oxidative stress' ,'positive regulation of apoptotic process' ,'superoxide dismutase activity' ,'positive regulation of reactive oxygen species biosynthetic process' ,'positive regulation of cell death' ,'regulation of blood pressure' ,'reactive oxygen species biosynthetic process' ,'negative regulation of cell population proliferation' ,'regulation of mitochondrial membrane potential' ,'vasoconstriction' ,'glutathione biosynthetic process' ,'membrane lipid catabolic process' ,'glutathione peroxidase activity' ,'cellular response to DNA damage stimulus' ,'cholesterol metabolic process' ,'positive regulation of cell population proliferation' ,'triglyceride metabolic process' ,'response to oxidative stress' ,'regulation of heart rate' ,'negative regulation of mitotic cell cycle' ,'vasodilation' ,'ATP metabolic process' ,'cell growth' ,'cellular calcium ion homeostasis' ,'leukocyte migration involved in inflammatory response' ,'nitric oxide metabolic process' ,'creatinine metabolic process' ,'apoptotic DNA fragmentation' ,'lipid droplet formation' ,'ncRNA transcription' ,'protein oxidation' ,'mitotic cell cycle process' ,'DNA modification' ,'inflammatory response' ,'cholesterol homeostasis' ,'glutathione transferase activity' ,'autophagy' ,'fat cell differentiation' ,'triglyceride homeostasis' ,'lipid metabolic process' ,'necrotic cell death' ,'xenobiotic metabolic process' ,'negative regulation of superoxide dismutase activity' ,'triglyceride biosynthetic process' ,'cell migration' ,'cell redox homeostasis' ,'bile acid metabolic process' ,'nitric oxide biosynthetic process' ,'superoxide anion generation' ,'lactate dehydrogenase activity' ,'cell cycle' ,'amino acid metabolic process' ,'testosterone biosynthetic process' ,'activation of protein kinase B activity' ,'L-aspartate:2-oxoglutarate aminotransferase activity' ,'positive regulation of nitric oxide biosynthetic process' ,'cholesterol biosynthetic process' ,'protein import into nucleus' ,'positive regulation of protein import into nucleus' ,'wound healing, spreading of cells' ,'alkaline phosphatase activity' ,'positive regulation of cytosolic calcium ion concentration' ,'glucose homeostasis' ,'positive regulation of mitochondrial membrane potential' ,'fatty acid metabolic process' ,'cell chemotaxis' ,'positive regulation of vasoconstriction' ,'spermatogenesis' ,'positive regulation of neuron death' ,'positive regulation of superoxide dismutase activity' ,'collagen fibril organization' ,'cell differentiation' ,'histone H3-K9 acetylation' ,'mitochondrion organization' ,'positive regulation of protein localization to nucleus' ,'positive regulation of p38MAPK cascade' ,'ATP biosynthetic process' ,'metabolic process' ,'locomotion involved in locomotory behavior' ,'urate metabolic process' ,'dopamine metabolic process' ,'positive regulation of NF-kappaB transcription factor activity' ,'embryo development' ,'lipid biosynthetic process' ,'protein lipidation' ,'histamine secretion mediated by immunoglobulin' ,'glucose metabolic process' ,'negative regulation of mitochondrial membrane potential' ,'release of cytochrome c from mitochondria' ,'DNA catabolic process, endonucleolytic' ,'cellular respiration' ,'calcium ion homeostasis' ,'positive regulation of cell migration' ,'regulation of cellular metabolic process' ,'reactive nitrogen species metabolic process' ,'positive regulation of inflammatory response' ,'establishment of protein localization to plasma membrane' ,'lipid homeostasis' ,'response to antineoplastic agent' ,'glucose import' ,'urea metabolic process' ,'positive regulation of ERK1 and ERK2 cascade' ,'positive regulation of necrotic cell death' ,'memory' ,'negative regulation of glutathione peroxidase activity' ,'positive regulation of apoptotic DNA fragmentation' ,'mitochondrial depolarization' ,'G2/M transition of mitotic cell cycle' ,'cAMP metabolic process' ,'mitotic S phase' ,'hydrogen peroxide biosynthetic process' ,'positive regulation of superoxide anion generation' ,'positive regulation of autophagy' ,'protein modification process' ,'regulation of metabolic process' ,'cellular iron ion homeostasis' ,'lactate metabolic process' ,'DNA methylation on cytosine within a CG sequence' ,'apoptotic chromosome condensation' ,'serotonin metabolic process' ,'cellular lipid metabolic process' ,'positive regulation of glutathione peroxidase activity' ,'transepithelial transport' ,'positive regulation of lipid storage' ,'hydrogen peroxide metabolic process' ,'G0 to G1 transition' ,'positive regulation of collagen biosynthetic process' ,'iron ion homeostasis' ,'positive regulation of cytolysis' ,'gluconeogenesis' ,'micronucleus organization' ,'microglial cell activation' ,'positive regulation of autophagosome assembly' ,'positive regulation of NIK/NF-kappaB signaling' ,'calcium-mediated signaling' ,'positive regulation of cytokine production involved in inflammatory response' ,'cellular senescence' ,'neuron death' ,'macrophage activation' ,'cAMP biosynthetic process' ,'positive regulation of lipid catabolic process' ,'negative regulation of response to drug' ,'calcium ion import' ,'behavioral response to pain' ,'positive regulation of intracellular estrogen receptor signaling pathway' ,'regulation of bile acid metabolic process' ,'mitotic cell cycle' ,'autophagosome assembly' ,'prostaglandin metabolic process' ,'protein poly-ADP-ribosylation' ,'DNA methylation' ,'glycolytic process' ,'positive regulation of fat cell differentiation' ,'protein lipidation involved in autophagosome assembly' ,'estrogen metabolic process' ,'thyroid hormone metabolic process' ,'positive regulation of organ growth' ,'neutrophil migration' ,'NADH dehydrogenase (ubiquinone) activity' ,'prostaglandin biosynthetic process' ,'negative regulation of ATP biosynthetic process' ,'adipose tissue development' ,'larval development' ,'androgen metabolic process' ,'amino acid biosynthetic process' ,'aerobic respiration' ,'positive regulation of cellular extravasation' ,'positive regulation of neutrophil extravasation' ,'negative regulation of cell migration' ,'carbohydrate metabolic process' ,'positive regulation of JNK cascade' ,'positive regulation of neuron apoptotic process' ,'positive regulation of release of cytochrome c from mitochondria' ,'cognition' ,'vacuole organization' ,'renal sodium excretion' ,'osteoclast differentiation' ,'positive regulation of epithelial to mesenchymal transition' ,'glutathione derivative biosynthetic process' ,'arachidonic acid metabolic process' ,'neurotransmitter metabolic process' ,'stress granule assembly' ,'sperm motility' ,'hepatocyte differentiation' ,'AMP-activated protein kinase activity' ,'swimming behavior' ,'negative regulation of monooxygenase activity' ,'fatty acid homeostasis' ,'L-ascorbic acid metabolic process' ,'pyroptosis' ,'response to xenobiotic stimulus' ,'positive regulation of prostaglandin biosynthetic process' ) ) and gcr.gene_id IN ( SELECT id FROM term WHERE nm IN ( -- genes 'NOG' ,'TNF' ,'INS' ,'CASP3' ,'IL1B' ,'IL6' ,'MAPK1' ,'NFE2L2' ,'MAPK3' ,'HMOX1' ,'AHR' ,'CYP1A1' ,'PTGS2' ,'PPARA' ,'BCL2' ,'CAT' ,'ESR1' ,'BAX' ,'NOS2' ,'RELA' ,'TGFB1' ,'TP53' ,'RORA' ,'AKT1' ,'CXCL8' ,'PPARG' ,'IFNG' ,'AR' ,'INS1' ,'ACHE' ,'PARP1' ,'CASP9' ,'CCL2' ,'NQO1' ,'CDKN1A' ,'CYP3A4' ,'MMP9' ,'SOD2' ,'APP' ,'VEGFA' ,'CYP1A2' ,'CCND1' ,'FOS' ,'NFKBIA' ,'SOD1' ,'HIF1A' ,'DDIT3' ,'ESR2' ,'JUN' ,'IL10' ,'AGT' ,'FGF2' ,'ABCB1' ,'CYP2E1' ,'GPT' ,'NR1I3' ,'CYP1B1' ,'CASP8' ,'NR1I2' ,'MAPK8' ,'EGF' ,'SIRT1' ,'GSR' ,'ACTA2' ,'MPO' ,'MYC' ,'ICAM1' ,'HSPA5' ,'MMP2' ,'G3BP1' ,'STAT3' ,'SQSTM1' ,'EGFR' ,'IL4' ,'NFKB1' ,'TLR4' ,'CASP1' ,'ALB' ,'RX3' ,'CTNNB1' ,'NOS3' ,'IGF1' ,'BCL2L1' ,'COL1A1' ,'GCLC' ,'NLRP3' ,'MAP1LC3B' ,'CDH1' ,'SREBF1' ,'GSK3B' ,'MTOR' ,'FASN' ,'PCNA' ,'ABCC2' ,'STAR' ,'PGR' ,'BDNF' ,'PPARGC1A' ,'CYP19A1' ,'GPX1' ,'H2AX' ,'LEP' ,'VIM' ,'IL18' ,'OGA' ,'GSTP1' ,'ADIPOQ' ,'BECN1' ,'IL1A' ,'TRP53' ,'FAS' ,'EGR1' ,'VCAM1' ,'NR1H4' ,'NR3C1' ,'APOE' ,'ABCG2' ,'FN1' ,'MYD88' ,'IL2' ,'CXCL1' ,'FSHB' ,'CREB1' ,'EDN1' ,'BIRC5' ,'SERPINE1' ,'ABCC1' ,'CNR1' ,'ABCB11' ,'CYCS' ,'CD36' ,'TIMP1' ,'GCLM' ,'CYP2C9' ,'TNFSF10' ,'LHB' ,'TH' ,'CXCL2' ,'FABP4' ,'BCHE' ,'ATF4' ,'PON1' ,'CYP11A1' ,'SPP1' ,'CASP7' ,'HMGCR' ,'MAPK9' ,'IL12B' ,'CYP17A1' ,'CCNB1' ,'CDKN1B' ,'CYP2B6' ,'RB1' ,'PRL' ,'MAPK14' ,'CEBPB' ,'CXCL10' ,'TIPARP' ,'GADD45A' ,'XBP1' ,'ATF3' ,'TRPV1' ,'CDK1' ,'MT1' ,'LPL' ,'GJA1' ,'MKI67' ,'MAPT' ,'ADRB2' ,'PTEN' ,'TXNRD1' ,'CPT1A' ,'KEAP1' ,'CYP7A1' ,'SLC2A1' ,'CCL5' ,'RPS6KB1' ,'ACACA' ,'KCNH2' ,'CEBPA' ,'STAT1' ,'INHBA' ,'MCL1' ,'BMP4' ,'CCN2' ,'SRC' ,'CSF2' ,'PTGS1' ,'EIF2AK3' ,'XDH' ,'SNCA' ,'ABCA1' ,'CDK2' ,'GPX4' ,'THRB' ,'CNR2' ,'DRD2' ,'LDLR' ,'GSTM1' ,'ABCC3' -- chemicals ,'bisphenol A' ,'Tetrachlorodibenzodioxin' ,'Benzo(a)pyrene' ,'Valproic Acid' ,'sodium arsenite' ,'Lipopolysaccharides' ,'Estradiol' ,'Acetaminophen' ,'4-(5-benzo(1,3)dioxol-5-yl-4-pyridin-2-yl-1H-imidazol-2-yl)benzamide' ,'dorsomorphin' ,'Particulate Matter' ,'Dexamethasone' ,'Cadmium Chloride' ,'titanium dioxide' ,'Aflatoxin B1' ,'Air Pollutants' ,'Cisplatin' ,'Tobacco Smoke Pollution' ,'Carbon Tetrachloride' ,'Resveratrol' ,'Doxorubicin' ,'pirinixic acid' ,'Ethinyl Estradiol' ,'Ozone' ,'Tretinoin' ,'Ethanol' ,'Dietary Fats' ,'Thioacetamide' ,'Cyclosporine' ,'Nanotubes, Carbon' ,'perfluorooctane sulfonic acid' ,'bisphenol S' ,'Folic Acid' ,'Vehicle Emissions' ,'1,2-Dimethylhydrazine' ,'Oxygen' ,'trichostatin A' ,'1-Methyl-3-isobutylxanthine' ,'Silicon Dioxide' ,'Indomethacin' ,'bisphenol F' ,'CGP 52608' ,'Atrazine' ,'Arsenic Trioxide' ,'methylmercuric chloride' ,'Cadmium' ,'Phenobarbital' ,'arsenite' ,'decamethrin' ,'Paraquat' ,'Tetradecanoylphorbol Acetate' ,'Quercetin' ,'Propylthiouracil' ,'Hydrogen Peroxide' ,'perfluorooctanoic acid' ,'Glucose' ,'Copper' ,'Smoke' ,'Chlorpyrifos' ,'triphenyl phosphate' ,'Gentamicins' ,'Diethylhexyl Phthalate' ,'Arsenic' ,'Rotenone' ,'Diethylnitrosamine' ,'Testosterone' ,'Acrylamide' ,'Phenylmercuric Acetate' ,'Dibutyl Phthalate' ,'Streptozocin' ,'Progesterone' ,'Plant Extracts' ,'Trichloroethylene' ,'aristolochic acid I' ,'Copper Sulfate' ,'cobaltous chloride' ,'Methyl Methanesulfonate' ,'Methamphetamine' ,'(+)-JQ1 compound' ,'jinfukang' ,'deoxynivalenol' ,'vinclozolin' ,'abrine' ,'Nickel' ,'Dioxins' ,'Genistein' ,'Fulvestrant' ,'Clofibrate' ,'Rosiglitazone' ,'Soot' ,'Cocaine' ,'Sunitinib' ,'Dronabinol' ,'Methotrexate' ,'JP8 aviation fuel' ,'triptonide' ,'entinostat' ,'2,2'',4,4''-tetrabromodiphenyl ether' ,'Tamoxifen' ,'Acetylcysteine' ,'1-Methyl-4-phenylpyridinium' ,'Calcitriol' ,'Acrolein' ,'di-n-butylphosphoric acid' ,'Thiram' ,'Endosulfan' ,'Zinc' ,'Ammonium Chloride' ,'Choline' ,'Ionomycin' ,'Formaldehyde' ,'tris(1,3-dichloro-2-propyl)phosphate' ,'Caffeine' ,'potassium chromate(VI)' ,'Methionine' ,'lead acetate' ,'perfluorooctanesulfonamide' ,'lipopolysaccharide, E coli O55-B5' ,'Flutamide' ,'Vorinostat' ,'furan' ,'Ivermectin' ,'Curcumin' ,'Lead' ,'Urethane' ,'Troglitazone' ,'S-(1,2-dichlorovinyl)cysteine' ,'Fluorouracil' ,'Fenretinide' ,'ethylene dichloride' ,'Dextran Sulfate' ,'hexabromocyclododecane' ,'Asbestos, Crocidolite' ,'7,8-Dihydro-7,8-dihydroxybenzo(a)pyrene 9,10-oxide' ,'sodium arsenate' ,'manganese chloride' ,'lipopolysaccharide, Escherichia coli O111 B4' ,'Cuprizone' ,'Methapyrilene' ,'Topotecan' ,'Isoproterenol' ,'epoxiconazole' ,'FR900359' ,'Methimazole' ,'Nicotine' ,'Antirheumatic Agents' ,'3,4,5,3'',4''-pentachlorobiphenyl' ,'methacrylaldehyde' ,'chromium hexavalent ion' ,'Triclosan' ,'Glyphosate' ,'N-Methyl-3,4-methylenedioxyamphetamine' ,'mono-(2-ethylhexyl)phthalate' ,'Aluminum' ,'Oxaliplatin' ,'T-2 Toxin' ,'Cellulose' ,'Decitabine' ,'acetamide' ,'Amitrole' ,'beta-lapachone' ,'Cyclophosphamide' ,'butyraldehyde' ,'Selenium' ,'alpha-pinene' ,'Temozolomide' ,'Amiodarone' ,'4,4''-diaminodiphenylmethane' ,'1,4-bis(2-(3,5-dichloropyridyloxy))benzene' ,'Panobinostat' ,'Diethylstilbestrol' ,'decabromobiphenyl ether' ,'Tunicamycin' ,'Carbamazepine' ,'Lactic Acid' ,'Sodium Fluoride' ,'Cannabidiol' ,'ochratoxin A' ,'epigallocatechin gallate' ,'1-Naphthylisothiocyanate' ,'fipronil' ,'Mercuric Chloride' ,'Coumestrol' ,'Paclitaxel' ,'bisphenol AF' ,'tert-Butylhydroperoxide' ,'dicrotophos' ,'sulforaphane' ,'Enzyme Inhibitors' ,'Dichlorodiphenyl Dichloroethylene' ,'1H,1H,10H,10H-perfluorodecane-1,10-diol' ,'Methoxychlor' ,'Thapsigargin' ,'Leflunomide' ,'Haloperidol' ,'2,4,5,2'',4'',5''-hexachlorobiphenyl' ,'9,10-Dimethyl-1,2-benzanthracene' ,'Silver' -- diseases ,'Chemical and Drug Induced Liver Injury' ,'Seizures' ,'Hypertension' ,'Hypotension' ,'Kidney Diseases' ,'Pain' ,'Acute Kidney Injury' ,'Breast Neoplasms' ,'Necrosis' ,'Weight Loss' ,'Inflammation' ,'Drug-Related Side Effects and Adverse Reactions' ,'Cocaine-Related Disorders' ,'Heart Failure' ,'Substance Withdrawal Syndrome' ,'Depressive Disorder' ,'Bradycardia' ,'Prostatic Neoplasms' ,'Hyperalgesia' ,'Prenatal Exposure Delayed Effects' ,'Myocardial Infarction' ,'Catalepsy' ,'Liver Cirrhosis, Experimental' ,'Hyperkinesis' ,'Edema' ,'Arrhythmias, Cardiac' ,'Carcinoma, Hepatocellular' ,'Dyskinesia, Drug-Induced' ,'Nausea' ,'Vomiting' ,'Lung Neoplasms' ,'Disease Models, Animal' ,'Hyperglycemia' ,'Hepatomegaly' ,'Weight Gain' ,'Cardiomyopathies' ,'Tachycardia' ,'Headache' ,'Bipolar Disorder' ,'Nerve Degeneration' ,'Proteinuria' ,'Diabetes Mellitus, Experimental' ,'Anemia' ,'Memory Disorders' ,'Tremor' ,'Peripheral Nervous System Diseases' ,'Fatty Liver' ,'Parkinson Disease' ,'Liver Neoplasms' ,'Status Epilepticus' ,'Schizophrenia' ,'Thrombocytopenia' ,'Liver Neoplasms, Experimental' ,'Cognition Disorders' ,'Heart Diseases' ,'Hemorrhage' ,'Arthritis, Rheumatoid' ,'Renal Insufficiency' ,'Fever' ,'Asthma' ,'Cholestasis' ,'Insulin Resistance' ,'Urinary Bladder Neoplasms' ,'Obesity' ,'Nervous System Diseases' ,'Liver Cirrhosis' ,'Poisoning' ,'Muscular Diseases' ,'Diarrhea' ,'Neoplasms, Experimental' ,'Colorectal Neoplasms' ,'Atrial Fibrillation' ,'Neutropenia' ,'Tachycardia, Ventricular' ,'Anxiety Disorders' ,'Colonic Neoplasms' ,'Epilepsy' ,'Myocardial Ischemia' ,'Stomach Neoplasms' ,'Amnesia' ,'Cardiomegaly' ,'Brain Injuries' ,'Parkinsonian Disorders' ,'Diabetes Mellitus, Type 2' ,'Neoplasm Metastasis' ,'Melanoma' ,'Neoplasm Invasiveness' ,'Torsades de Pointes' ,'Neoplasms' ,'Long QT Syndrome' ,'Ventricular Dysfunction, Left' ,'Cell Transformation, Neoplastic' ,'Thrombosis' ,'Pain, Postoperative' ,'Movement Disorders' ,'Hallucinations' ,'Dystonia' ,'Nephritis, Interstitial' ,'Stomach Ulcer' ,'Carcinoma, Non-Small-Cell Lung' ,'Pulmonary Fibrosis' ,'Brain Diseases' ,'Fibrosis' ,'Learning Disabilities' ,'Heart Arrest' ,'Drug Hypersensitivity' ,'Liver Diseases' ,'Psychoses, Substance-Induced' ,'Dizziness' ,'Cardiovascular Diseases' ,'Hypokalemia' ,'Ventricular Fibrillation' ,'Autistic Disorder' ,'Precursor Cell Lymphoblastic Leukemia-Lymphoma' ,'Myoclonus' ,'Hyperplasia' ,'Precancerous Conditions' ,'Multiple Myeloma' ,'Angina Pectoris' ,'Neurotoxicity Syndromes' ,'Liver Failure, Acute' ,'Leukemia, Promyelocytic, Acute' ,'Adenocarcinoma' ,'Basal Ganglia Diseases' ,'Cystitis' ,'Hepatitis B' ,'Hepatitis' ,'Dermatitis, Allergic Contact' ,'Leukemia, Myeloid, Acute' ,'Lung Injury' ,'HIV Infections' ,'Ataxia' ,'Ovarian Neoplasms' ,'Atherosclerosis' ,'Mammary Neoplasms, Experimental' ,'Abnormalities, Drug-Induced' ,'Confusion' ,'Staphylococcal Infections' ,'Autism Spectrum Disorder' ,'Stroke' ,'Leukopenia' ,'Testicular Diseases' ,'Reperfusion Injury' ,'Colitis' ,'Alzheimer Disease' ,'Carcinoma' ,'Glucose Intolerance' ,'Skin Neoplasms' ,'Anemia, Hemolytic' ,'Exanthema' ,'Hypertension, Pulmonary' ,'Muscle Rigidity' ,'Psychotic Disorders' ,'Hypercholesterolemia' ,'Angioedema' ,'Delirium' ,'Non-alcoholic Fatty Liver Disease' ,'Paralysis' ,'Apnea' ,'Pulmonary Edema' ,'Pneumonia' ,'Micronuclei, Chromosome-Defective' ,'Venous Thrombosis' ,'Parkinson Disease, Secondary' ,'Nephrotic Syndrome' ,'Muscle Weakness' ,'Pruritus' ,'Drug Eruptions' ,'Acute Lung Injury' ,'Hypothermia' ,'Pancreatic Neoplasms' ,'Diabetic Nephropathies' ,'Gastrointestinal Diseases' ,'Substance-Related Disorders' ,'Coma' ,'Epilepsy, Tonic-Clonic' ,'Craniofacial Abnormalities' ,'Stevens-Johnson Syndrome' ,'Migraine Disorders' ,'Vision Disorders' ,'Jaundice' ,'Paresthesia' ,'Carcinoma, Squamous Cell' ,'Fatigue' ,'Cerebral Hemorrhage' ,'Hypercalcemia' ,'Skin Diseases' ,'Hypotension, Orthostatic' ,'Urticaria' ,'Hematuria' ,'Erectile Dysfunction' ,'Colitis, Ulcerative' ,'Mammary Neoplasms, Animal' ,'Lung Diseases' ,'Rhabdomyolysis' ,'Oligospermia' ,'Depressive Disorder, Major' ,'Anemia, Aplastic' ,'Anorexia' ,'Hyperlipidemias' -- phenotypes ,'apoptotic process' ,'cell population proliferation' ,'cellular metabolic process' ,'lipid oxidation' ,'glutathione metabolic process' ,'reactive oxygen species metabolic process' ,'lipid catabolic process' ,'cell death' ,'detection of oxidative stress' ,'positive regulation of apoptotic process' ,'superoxide dismutase activity' ,'positive regulation of reactive oxygen species biosynthetic process' ,'positive regulation of cell death' ,'regulation of blood pressure' ,'reactive oxygen species biosynthetic process' ,'negative regulation of cell population proliferation' ,'regulation of mitochondrial membrane potential' ,'vasoconstriction' ,'glutathione biosynthetic process' ,'membrane lipid catabolic process' ,'glutathione peroxidase activity' ,'cellular response to DNA damage stimulus' ,'cholesterol metabolic process' ,'positive regulation of cell population proliferation' ,'triglyceride metabolic process' ,'response to oxidative stress' ,'regulation of heart rate' ,'negative regulation of mitotic cell cycle' ,'vasodilation' ,'ATP metabolic process' ,'cell growth' ,'cellular calcium ion homeostasis' ,'leukocyte migration involved in inflammatory response' ,'nitric oxide metabolic process' ,'creatinine metabolic process' ,'apoptotic DNA fragmentation' ,'lipid droplet formation' ,'ncRNA transcription' ,'protein oxidation' ,'mitotic cell cycle process' ,'DNA modification' ,'inflammatory response' ,'cholesterol homeostasis' ,'glutathione transferase activity' ,'autophagy' ,'fat cell differentiation' ,'triglyceride homeostasis' ,'lipid metabolic process' ,'necrotic cell death' ,'xenobiotic metabolic process' ,'negative regulation of superoxide dismutase activity' ,'triglyceride biosynthetic process' ,'cell migration' ,'cell redox homeostasis' ,'bile acid metabolic process' ,'nitric oxide biosynthetic process' ,'superoxide anion generation' ,'lactate dehydrogenase activity' ,'cell cycle' ,'amino acid metabolic process' ,'testosterone biosynthetic process' ,'activation of protein kinase B activity' ,'L-aspartate:2-oxoglutarate aminotransferase activity' ,'positive regulation of nitric oxide biosynthetic process' ,'cholesterol biosynthetic process' ,'protein import into nucleus' ,'positive regulation of protein import into nucleus' ,'wound healing, spreading of cells' ,'alkaline phosphatase activity' ,'positive regulation of cytosolic calcium ion concentration' ,'glucose homeostasis' ,'positive regulation of mitochondrial membrane potential' ,'fatty acid metabolic process' ,'cell chemotaxis' ,'positive regulation of vasoconstriction' ,'spermatogenesis' ,'positive regulation of neuron death' ,'positive regulation of superoxide dismutase activity' ,'collagen fibril organization' ,'cell differentiation' ,'histone H3-K9 acetylation' ,'mitochondrion organization' ,'positive regulation of protein localization to nucleus' ,'positive regulation of p38MAPK cascade' ,'ATP biosynthetic process' ,'metabolic process' ,'locomotion involved in locomotory behavior' ,'urate metabolic process' ,'dopamine metabolic process' ,'positive regulation of NF-kappaB transcription factor activity' ,'embryo development' ,'lipid biosynthetic process' ,'protein lipidation' ,'histamine secretion mediated by immunoglobulin' ,'glucose metabolic process' ,'negative regulation of mitochondrial membrane potential' ,'release of cytochrome c from mitochondria' ,'DNA catabolic process, endonucleolytic' ,'cellular respiration' ,'calcium ion homeostasis' ,'positive regulation of cell migration' ,'regulation of cellular metabolic process' ,'reactive nitrogen species metabolic process' ,'positive regulation of inflammatory response' ,'establishment of protein localization to plasma membrane' ,'lipid homeostasis' ,'response to antineoplastic agent' ,'glucose import' ,'urea metabolic process' ,'positive regulation of ERK1 and ERK2 cascade' ,'positive regulation of necrotic cell death' ,'memory' ,'negative regulation of glutathione peroxidase activity' ,'positive regulation of apoptotic DNA fragmentation' ,'mitochondrial depolarization' ,'G2/M transition of mitotic cell cycle' ,'cAMP metabolic process' ,'mitotic S phase' ,'hydrogen peroxide biosynthetic process' ,'positive regulation of superoxide anion generation' ,'positive regulation of autophagy' ,'protein modification process' ,'regulation of metabolic process' ,'cellular iron ion homeostasis' ,'lactate metabolic process' ,'DNA methylation on cytosine within a CG sequence' ,'apoptotic chromosome condensation' ,'serotonin metabolic process' ,'cellular lipid metabolic process' ,'positive regulation of glutathione peroxidase activity' ,'transepithelial transport' ,'positive regulation of lipid storage' ,'hydrogen peroxide metabolic process' ,'G0 to G1 transition' ,'positive regulation of collagen biosynthetic process' ,'iron ion homeostasis' ,'positive regulation of cytolysis' ,'gluconeogenesis' ,'micronucleus organization' ,'microglial cell activation' ,'positive regulation of autophagosome assembly' ,'positive regulation of NIK/NF-kappaB signaling' ,'calcium-mediated signaling' ,'positive regulation of cytokine production involved in inflammatory response' ,'cellular senescence' ,'neuron death' ,'macrophage activation' ,'cAMP biosynthetic process' ,'positive regulation of lipid catabolic process' ,'negative regulation of response to drug' ,'calcium ion import' ,'behavioral response to pain' ,'positive regulation of intracellular estrogen receptor signaling pathway' ,'regulation of bile acid metabolic process' ,'mitotic cell cycle' ,'autophagosome assembly' ,'prostaglandin metabolic process' ,'protein poly-ADP-ribosylation' ,'DNA methylation' ,'glycolytic process' ,'positive regulation of fat cell differentiation' ,'protein lipidation involved in autophagosome assembly' ,'estrogen metabolic process' ,'thyroid hormone metabolic process' ,'positive regulation of organ growth' ,'neutrophil migration' ,'NADH dehydrogenase (ubiquinone) activity' ,'prostaglandin biosynthetic process' ,'negative regulation of ATP biosynthetic process' ,'adipose tissue development' ,'larval development' ,'androgen metabolic process' ,'amino acid biosynthetic process' ,'aerobic respiration' ,'positive regulation of cellular extravasation' ,'positive regulation of neutrophil extravasation' ,'negative regulation of cell migration' ,'carbohydrate metabolic process' ,'positive regulation of JNK cascade' ,'positive regulation of neuron apoptotic process' ,'positive regulation of release of cytochrome c from mitochondria' ,'cognition' ,'vacuole organization' ,'renal sodium excretion' ,'osteoclast differentiation' ,'positive regulation of epithelial to mesenchymal transition' ,'glutathione derivative biosynthetic process' ,'arachidonic acid metabolic process' ,'neurotransmitter metabolic process' ,'stress granule assembly' ,'sperm motility' ,'hepatocyte differentiation' ,'AMP-activated protein kinase activity' ,'swimming behavior' ,'negative regulation of monooxygenase activity' ,'fatty acid homeostasis' ,'L-ascorbic acid metabolic process' ,'pyroptosis' ,'response to xenobiotic stimulus' ,'positive regulation of prostaglandin biosynthetic process' ) ) ) and ( gcr.chem_id, gcr.gene_id ) in ( select chem_id, gene_id from tetramer );

Date: 2025-01-22 12:53:18
Duration: 6s375ms
Database: ctddev51
User: pub2
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;

Date: 2025-01-22 05:48:56
Duration: 6s237ms
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;

Date: 2025-01-22 05:48:49
Duration: 6s231ms
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1302084)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;

Date: 2025-01-22 05:48:28
Duration: 4s347ms
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

select distinct chemTerm.acc_txt #015 ,chemTerm.nm #015 ,'chemical' #015 ,phenotypeTerm.acc_txt #015 ,phenotypeTerm.nm #015 ,'phenotype' #015 from pub2.PHENOTYPE_TERM_REFERENCE ptr #015 ,pub2.TERM chemTerm #015 ,pub2.TERM phenotypeTerm #015 where ptr.phenotype_id = phenotypeTerm.id #015 and ptr.term_id = chemTerm.id #015 and ( ptr.term_id IN ( SELECT id FROM term WHERE nm IN ( -- genes 'NOG' ,'TNF' ,'INS' ,'CASP3' ,'IL1B' ,'IL6' ,'MAPK1' ,'NFE2L2' ,'MAPK3' ,'HMOX1' ,'AHR' ,'CYP1A1' ,'PTGS2' ,'PPARA' ,'BCL2' ,'CAT' ,'ESR1' ,'BAX' ,'NOS2' ,'RELA' ,'TGFB1' ,'TP53' ,'RORA' ,'AKT1' ,'CXCL8' ,'PPARG' ,'IFNG' ,'AR' ,'INS1' ,'ACHE' ,'PARP1' ,'CASP9' ,'CCL2' ,'NQO1' ,'CDKN1A' ,'CYP3A4' ,'MMP9' ,'SOD2' ,'APP' ,'VEGFA' ,'CYP1A2' ,'CCND1' ,'FOS' ,'NFKBIA' ,'SOD1' ,'HIF1A' ,'DDIT3' ,'ESR2' ,'JUN' ,'IL10' ,'AGT' ,'FGF2' ,'ABCB1' ,'CYP2E1' ,'GPT' ,'NR1I3' ,'CYP1B1' ,'CASP8' ,'NR1I2' ,'MAPK8' ,'EGF' ,'SIRT1' ,'GSR' ,'ACTA2' ,'MPO' ,'MYC' ,'ICAM1' ,'HSPA5' ,'MMP2' ,'G3BP1' ,'STAT3' ,'SQSTM1' ,'EGFR' ,'IL4' ,'NFKB1' ,'TLR4' ,'CASP1' ,'ALB' ,'RX3' ,'CTNNB1' ,'NOS3' ,'IGF1' ,'BCL2L1' ,'COL1A1' ,'GCLC' ,'NLRP3' ,'MAP1LC3B' ,'CDH1' ,'SREBF1' ,'GSK3B' ,'MTOR' ,'FASN' ,'PCNA' ,'ABCC2' ,'STAR' ,'PGR' ,'BDNF' ,'PPARGC1A' ,'CYP19A1' ,'GPX1' ,'H2AX' ,'LEP' ,'VIM' ,'IL18' ,'OGA' ,'GSTP1' ,'ADIPOQ' ,'BECN1' ,'IL1A' ,'TRP53' ,'FAS' ,'EGR1' ,'VCAM1' ,'NR1H4' ,'NR3C1' ,'APOE' ,'ABCG2' ,'FN1' ,'MYD88' ,'IL2' ,'CXCL1' ,'FSHB' ,'CREB1' ,'EDN1' ,'BIRC5' ,'SERPINE1' ,'ABCC1' ,'CNR1' ,'ABCB11' ,'CYCS' ,'CD36' ,'TIMP1' ,'GCLM' ,'CYP2C9' ,'TNFSF10' ,'LHB' ,'TH' ,'CXCL2' ,'FABP4' ,'BCHE' ,'ATF4' ,'PON1' ,'CYP11A1' ,'SPP1' ,'CASP7' ,'HMGCR' ,'MAPK9' ,'IL12B' ,'CYP17A1' ,'CCNB1' ,'CDKN1B' ,'CYP2B6' ,'RB1' ,'PRL' ,'MAPK14' ,'CEBPB' ,'CXCL10' ,'TIPARP' ,'GADD45A' ,'XBP1' ,'ATF3' ,'TRPV1' ,'CDK1' ,'MT1' ,'LPL' ,'GJA1' ,'MKI67' ,'MAPT' ,'ADRB2' ,'PTEN' ,'TXNRD1' ,'CPT1A' ,'KEAP1' ,'CYP7A1' ,'SLC2A1' ,'CCL5' ,'RPS6KB1' ,'ACACA' ,'KCNH2' ,'CEBPA' ,'STAT1' ,'INHBA' ,'MCL1' ,'BMP4' ,'CCN2' ,'SRC' ,'CSF2' ,'PTGS1' ,'EIF2AK3' ,'XDH' ,'SNCA' ,'ABCA1' ,'CDK2' ,'GPX4' ,'THRB' ,'CNR2' ,'DRD2' ,'LDLR' ,'GSTM1' ,'ABCC3' -- chemicals ,'bisphenol A' ,'Tetrachlorodibenzodioxin' ,'Benzo(a)pyrene' ,'Valproic Acid' ,'sodium arsenite' ,'Lipopolysaccharides' ,'Estradiol' ,'Acetaminophen' ,'4-(5-benzo(1,3)dioxol-5-yl-4-pyridin-2-yl-1H-imidazol-2-yl)benzamide' ,'dorsomorphin' ,'Particulate Matter' ,'Dexamethasone' ,'Cadmium Chloride' ,'titanium dioxide' ,'Aflatoxin B1' ,'Air Pollutants' ,'Cisplatin' ,'Tobacco Smoke Pollution' ,'Carbon Tetrachloride' ,'Resveratrol' ,'Doxorubicin' ,'pirinixic acid' ,'Ethinyl Estradiol' ,'Ozone' ,'Tretinoin' ,'Ethanol' ,'Dietary Fats' ,'Thioacetamide' ,'Cyclosporine' ,'Nanotubes, Carbon' ,'perfluorooctane sulfonic acid' ,'bisphenol S' ,'Folic Acid' ,'Vehicle Emissions' ,'1,2-Dimethylhydrazine' ,'Oxygen' ,'trichostatin A' ,'1-Methyl-3-isobutylxanthine' ,'Silicon Dioxide' ,'Indomethacin' ,'bisphenol F' ,'CGP 52608' ,'Atrazine' ,'Arsenic Trioxide' ,'methylmercuric chloride' ,'Cadmium' ,'Phenobarbital' ,'arsenite' ,'decamethrin' ,'Paraquat' ,'Tetradecanoylphorbol Acetate' ,'Quercetin' ,'Propylthiouracil' ,'Hydrogen Peroxide' ,'perfluorooctanoic acid' ,'Glucose' ,'Copper' ,'Smoke' ,'Chlorpyrifos' ,'triphenyl phosphate' ,'Gentamicins' ,'Diethylhexyl Phthalate' ,'Arsenic' ,'Rotenone' ,'Diethylnitrosamine' ,'Testosterone' ,'Acrylamide' ,'Phenylmercuric Acetate' ,'Dibutyl Phthalate' ,'Streptozocin' ,'Progesterone' ,'Plant Extracts' ,'Trichloroethylene' ,'aristolochic acid I' ,'Copper Sulfate' ,'cobaltous chloride' ,'Methyl Methanesulfonate' ,'Methamphetamine' ,'(+)-JQ1 compound' ,'jinfukang' ,'deoxynivalenol' ,'vinclozolin' ,'abrine' ,'Nickel' ,'Dioxins' ,'Genistein' ,'Fulvestrant' ,'Clofibrate' ,'Rosiglitazone' ,'Soot' ,'Cocaine' ,'Sunitinib' ,'Dronabinol' ,'Methotrexate' ,'JP8 aviation fuel' ,'triptonide' ,'entinostat' ,'2,2'',4,4''-tetrabromodiphenyl ether' ,'Tamoxifen' ,'Acetylcysteine' ,'1-Methyl-4-phenylpyridinium' ,'Calcitriol' ,'Acrolein' ,'di-n-butylphosphoric acid' ,'Thiram' ,'Endosulfan' ,'Zinc' ,'Ammonium Chloride' ,'Choline' ,'Ionomycin' ,'Formaldehyde' ,'tris(1,3-dichloro-2-propyl)phosphate' ,'Caffeine' ,'potassium chromate(VI)' ,'Methionine' ,'lead acetate' ,'perfluorooctanesulfonamide' ,'lipopolysaccharide, E coli O55-B5' ,'Flutamide' ,'Vorinostat' ,'furan' ,'Ivermectin' ,'Curcumin' ,'Lead' ,'Urethane' ,'Troglitazone' ,'S-(1,2-dichlorovinyl)cysteine' ,'Fluorouracil' ,'Fenretinide' ,'ethylene dichloride' ,'Dextran Sulfate' ,'hexabromocyclododecane' ,'Asbestos, Crocidolite' ,'7,8-Dihydro-7,8-dihydroxybenzo(a)pyrene 9,10-oxide' ,'sodium arsenate' ,'manganese chloride' ,'lipopolysaccharide, Escherichia coli O111 B4' ,'Cuprizone' ,'Methapyrilene' ,'Topotecan' ,'Isoproterenol' ,'epoxiconazole' ,'FR900359' ,'Methimazole' ,'Nicotine' ,'Antirheumatic Agents' ,'3,4,5,3'',4''-pentachlorobiphenyl' ,'methacrylaldehyde' ,'chromium hexavalent ion' ,'Triclosan' ,'Glyphosate' ,'N-Methyl-3,4-methylenedioxyamphetamine' ,'mono-(2-ethylhexyl)phthalate' ,'Aluminum' ,'Oxaliplatin' ,'T-2 Toxin' ,'Cellulose' ,'Decitabine' ,'acetamide' ,'Amitrole' ,'beta-lapachone' ,'Cyclophosphamide' ,'butyraldehyde' ,'Selenium' ,'alpha-pinene' ,'Temozolomide' ,'Amiodarone' ,'4,4''-diaminodiphenylmethane' ,'1,4-bis(2-(3,5-dichloropyridyloxy))benzene' ,'Panobinostat' ,'Diethylstilbestrol' ,'decabromobiphenyl ether' ,'Tunicamycin' ,'Carbamazepine' ,'Lactic Acid' ,'Sodium Fluoride' ,'Cannabidiol' ,'ochratoxin A' ,'epigallocatechin gallate' ,'1-Naphthylisothiocyanate' ,'fipronil' ,'Mercuric Chloride' ,'Coumestrol' ,'Paclitaxel' ,'bisphenol AF' ,'tert-Butylhydroperoxide' ,'dicrotophos' ,'sulforaphane' ,'Enzyme Inhibitors' ,'Dichlorodiphenyl Dichloroethylene' ,'1H,1H,10H,10H-perfluorodecane-1,10-diol' ,'Methoxychlor' ,'Thapsigargin' ,'Leflunomide' ,'Haloperidol' ,'2,4,5,2'',4'',5''-hexachlorobiphenyl' ,'9,10-Dimethyl-1,2-benzanthracene' ,'Silver' -- diseases ,'Chemical and Drug Induced Liver Injury' ,'Seizures' ,'Hypertension' ,'Hypotension' ,'Kidney Diseases' ,'Pain' ,'Acute Kidney Injury' ,'Breast Neoplasms' ,'Necrosis' ,'Weight Loss' ,'Inflammation' ,'Drug-Related Side Effects and Adverse Reactions' ,'Cocaine-Related Disorders' ,'Heart Failure' ,'Substance Withdrawal Syndrome' ,'Depressive Disorder' ,'Bradycardia' ,'Prostatic Neoplasms' ,'Hyperalgesia' ,'Prenatal Exposure Delayed Effects' ,'Myocardial Infarction' ,'Catalepsy' ,'Liver Cirrhosis, Experimental' ,'Hyperkinesis' ,'Edema' ,'Arrhythmias, Cardiac' ,'Carcinoma, Hepatocellular' ,'Dyskinesia, Drug-Induced' ,'Nausea' ,'Vomiting' ,'Lung Neoplasms' ,'Disease Models, Animal' ,'Hyperglycemia' ,'Hepatomegaly' ,'Weight Gain' ,'Cardiomyopathies' ,'Tachycardia' ,'Headache' ,'Bipolar Disorder' ,'Nerve Degeneration' ,'Proteinuria' ,'Diabetes Mellitus, Experimental' ,'Anemia' ,'Memory Disorders' ,'Tremor' ,'Peripheral Nervous System Diseases' ,'Fatty Liver' ,'Parkinson Disease' ,'Liver Neoplasms' ,'Status Epilepticus' ,'Schizophrenia' ,'Thrombocytopenia' ,'Liver Neoplasms, Experimental' ,'Cognition Disorders' ,'Heart Diseases' ,'Hemorrhage' ,'Arthritis, Rheumatoid' ,'Renal Insufficiency' ,'Fever' ,'Asthma' ,'Cholestasis' ,'Insulin Resistance' ,'Urinary Bladder Neoplasms' ,'Obesity' ,'Nervous System Diseases' ,'Liver Cirrhosis' ,'Poisoning' ,'Muscular Diseases' ,'Diarrhea' ,'Neoplasms, Experimental' ,'Colorectal Neoplasms' ,'Atrial Fibrillation' ,'Neutropenia' ,'Tachycardia, Ventricular' ,'Anxiety Disorders' ,'Colonic Neoplasms' ,'Epilepsy' ,'Myocardial Ischemia' ,'Stomach Neoplasms' ,'Amnesia' ,'Cardiomegaly' ,'Brain Injuries' ,'Parkinsonian Disorders' ,'Diabetes Mellitus, Type 2' ,'Neoplasm Metastasis' ,'Melanoma' ,'Neoplasm Invasiveness' ,'Torsades de Pointes' ,'Neoplasms' ,'Long QT Syndrome' ,'Ventricular Dysfunction, Left' ,'Cell Transformation, Neoplastic' ,'Thrombosis' ,'Pain, Postoperative' ,'Movement Disorders' ,'Hallucinations' ,'Dystonia' ,'Nephritis, Interstitial' ,'Stomach Ulcer' ,'Carcinoma, Non-Small-Cell Lung' ,'Pulmonary Fibrosis' ,'Brain Diseases' ,'Fibrosis' ,'Learning Disabilities' ,'Heart Arrest' ,'Drug Hypersensitivity' ,'Liver Diseases' ,'Psychoses, Substance-Induced' ,'Dizziness' ,'Cardiovascular Diseases' ,'Hypokalemia' ,'Ventricular Fibrillation' ,'Autistic Disorder' ,'Precursor Cell Lymphoblastic Leukemia-Lymphoma' ,'Myoclonus' ,'Hyperplasia' ,'Precancerous Conditions' ,'Multiple Myeloma' ,'Angina Pectoris' ,'Neurotoxicity Syndromes' ,'Liver Failure, Acute' ,'Leukemia, Promyelocytic, Acute' ,'Adenocarcinoma' ,'Basal Ganglia Diseases' ,'Cystitis' ,'Hepatitis B' ,'Hepatitis' ,'Dermatitis, Allergic Contact' ,'Leukemia, Myeloid, Acute' ,'Lung Injury' ,'HIV Infections' ,'Ataxia' ,'Ovarian Neoplasms' ,'Atherosclerosis' ,'Mammary Neoplasms, Experimental' ,'Abnormalities, Drug-Induced' ,'Confusion' ,'Staphylococcal Infections' ,'Autism Spectrum Disorder' ,'Stroke' ,'Leukopenia' ,'Testicular Diseases' ,'Reperfusion Injury' ,'Colitis' ,'Alzheimer Disease' ,'Carcinoma' ,'Glucose Intolerance' ,'Skin Neoplasms' ,'Anemia, Hemolytic' ,'Exanthema' ,'Hypertension, Pulmonary' ,'Muscle Rigidity' ,'Psychotic Disorders' ,'Hypercholesterolemia' ,'Angioedema' ,'Delirium' ,'Non-alcoholic Fatty Liver Disease' ,'Paralysis' ,'Apnea' ,'Pulmonary Edema' ,'Pneumonia' ,'Micronuclei, Chromosome-Defective' ,'Venous Thrombosis' ,'Parkinson Disease, Secondary' ,'Nephrotic Syndrome' ,'Muscle Weakness' ,'Pruritus' ,'Drug Eruptions' ,'Acute Lung Injury' ,'Hypothermia' ,'Pancreatic Neoplasms' ,'Diabetic Nephropathies' ,'Gastrointestinal Diseases' ,'Substance-Related Disorders' ,'Coma' ,'Epilepsy, Tonic-Clonic' ,'Craniofacial Abnormalities' ,'Stevens-Johnson Syndrome' ,'Migraine Disorders' ,'Vision Disorders' ,'Jaundice' ,'Paresthesia' ,'Carcinoma, Squamous Cell' ,'Fatigue' ,'Cerebral Hemorrhage' ,'Hypercalcemia' ,'Skin Diseases' ,'Hypotension, Orthostatic' ,'Urticaria' ,'Hematuria' ,'Erectile Dysfunction' ,'Colitis, Ulcerative' ,'Mammary Neoplasms, Animal' ,'Lung Diseases' ,'Rhabdomyolysis' ,'Oligospermia' ,'Depressive Disorder, Major' ,'Anemia, Aplastic' ,'Anorexia' ,'Hyperlipidemias' -- phenotypes ,'apoptotic process' ,'cell population proliferation' ,'cellular metabolic process' ,'lipid oxidation' ,'glutathione metabolic process' ,'reactive oxygen species metabolic process' ,'lipid catabolic process' ,'cell death' ,'detection of oxidative stress' ,'positive regulation of apoptotic process' ,'superoxide dismutase activity' ,'positive regulation of reactive oxygen species biosynthetic process' ,'positive regulation of cell death' ,'regulation of blood pressure' ,'reactive oxygen species biosynthetic process' ,'negative regulation of cell population proliferation' ,'regulation of mitochondrial membrane potential' ,'vasoconstriction' ,'glutathione biosynthetic process' ,'membrane lipid catabolic process' ,'glutathione peroxidase activity' ,'cellular response to DNA damage stimulus' ,'cholesterol metabolic process' ,'positive regulation of cell population proliferation' ,'triglyceride metabolic process' ,'response to oxidative stress' ,'regulation of heart rate' ,'negative regulation of mitotic cell cycle' ,'vasodilation' ,'ATP metabolic process' ,'cell growth' ,'cellular calcium ion homeostasis' ,'leukocyte migration involved in inflammatory response' ,'nitric oxide metabolic process' ,'creatinine metabolic process' ,'apoptotic DNA fragmentation' ,'lipid droplet formation' ,'ncRNA transcription' ,'protein oxidation' ,'mitotic cell cycle process' ,'DNA modification' ,'inflammatory response' ,'cholesterol homeostasis' ,'glutathione transferase activity' ,'autophagy' ,'fat cell differentiation' ,'triglyceride homeostasis' ,'lipid metabolic process' ,'necrotic cell death' ,'xenobiotic metabolic process' ,'negative regulation of superoxide dismutase activity' ,'triglyceride biosynthetic process' ,'cell migration' ,'cell redox homeostasis' ,'bile acid metabolic process' ,'nitric oxide biosynthetic process' ,'superoxide anion generation' ,'lactate dehydrogenase activity' ,'cell cycle' ,'amino acid metabolic process' ,'testosterone biosynthetic process' ,'activation of protein kinase B activity' ,'L-aspartate:2-oxoglutarate aminotransferase activity' ,'positive regulation of nitric oxide biosynthetic process' ,'cholesterol biosynthetic process' ,'protein import into nucleus' ,'positive regulation of protein import into nucleus' ,'wound healing, spreading of cells' ,'alkaline phosphatase activity' ,'positive regulation of cytosolic calcium ion concentration' ,'glucose homeostasis' ,'positive regulation of mitochondrial membrane potential' ,'fatty acid metabolic process' ,'cell chemotaxis' ,'positive regulation of vasoconstriction' ,'spermatogenesis' ,'positive regulation of neuron death' ,'positive regulation of superoxide dismutase activity' ,'collagen fibril organization' ,'cell differentiation' ,'histone H3-K9 acetylation' ,'mitochondrion organization' ,'positive regulation of protein localization to nucleus' ,'positive regulation of p38MAPK cascade' ,'ATP biosynthetic process' ,'metabolic process' ,'locomotion involved in locomotory behavior' ,'urate metabolic process' ,'dopamine metabolic process' ,'positive regulation of NF-kappaB transcription factor activity' ,'embryo development' ,'lipid biosynthetic process' ,'protein lipidation' ,'histamine secretion mediated by immunoglobulin' ,'glucose metabolic process' ,'negative regulation of mitochondrial membrane potential' ,'release of cytochrome c from mitochondria' ,'DNA catabolic process, endonucleolytic' ,'cellular respiration' ,'calcium ion homeostasis' ,'positive regulation of cell migration' ,'regulation of cellular metabolic process' ,'reactive nitrogen species metabolic process' ,'positive regulation of inflammatory response' ,'establishment of protein localization to plasma membrane' ,'lipid homeostasis' ,'response to antineoplastic agent' ,'glucose import' ,'urea metabolic process' ,'positive regulation of ERK1 and ERK2 cascade' ,'positive regulation of necrotic cell death' ,'memory' ,'negative regulation of glutathione peroxidase activity' ,'positive regulation of apoptotic DNA fragmentation' ,'mitochondrial depolarization' ,'G2/M transition of mitotic cell cycle' ,'cAMP metabolic process' ,'mitotic S phase' ,'hydrogen peroxide biosynthetic process' ,'positive regulation of superoxide anion generation' ,'positive regulation of autophagy' ,'protein modification process' ,'regulation of metabolic process' ,'cellular iron ion homeostasis' ,'lactate metabolic process' ,'DNA methylation on cytosine within a CG sequence' ,'apoptotic chromosome condensation' ,'serotonin metabolic process' ,'cellular lipid metabolic process' ,'positive regulation of glutathione peroxidase activity' ,'transepithelial transport' ,'positive regulation of lipid storage' ,'hydrogen peroxide metabolic process' ,'G0 to G1 transition' ,'positive regulation of collagen biosynthetic process' ,'iron ion homeostasis' ,'positive regulation of cytolysis' ,'gluconeogenesis' ,'micronucleus organization' ,'microglial cell activation' ,'positive regulation of autophagosome assembly' ,'positive regulation of NIK/NF-kappaB signaling' ,'calcium-mediated signaling' ,'positive regulation of cytokine production involved in inflammatory response' ,'cellular senescence' ,'neuron death' ,'macrophage activation' ,'cAMP biosynthetic process' ,'positive regulation of lipid catabolic process' ,'negative regulation of response to drug' ,'calcium ion import' ,'behavioral response to pain' ,'positive regulation of intracellular estrogen receptor signaling pathway' ,'regulation of bile acid metabolic process' ,'mitotic cell cycle' ,'autophagosome assembly' ,'prostaglandin metabolic process' ,'protein poly-ADP-ribosylation' ,'DNA methylation' ,'glycolytic process' ,'positive regulation of fat cell differentiation' ,'protein lipidation involved in autophagosome assembly' ,'estrogen metabolic process' ,'thyroid hormone metabolic process' ,'positive regulation of organ growth' ,'neutrophil migration' ,'NADH dehydrogenase (ubiquinone) activity' ,'prostaglandin biosynthetic process' ,'negative regulation of ATP biosynthetic process' ,'adipose tissue development' ,'larval development' ,'androgen metabolic process' ,'amino acid biosynthetic process' ,'aerobic respiration' ,'positive regulation of cellular extravasation' ,'positive regulation of neutrophil extravasation' ,'negative regulation of cell migration' ,'carbohydrate metabolic process' ,'positive regulation of JNK cascade' ,'positive regulation of neuron apoptotic process' ,'positive regulation of release of cytochrome c from mitochondria' ,'cognition' ,'vacuole organization' ,'renal sodium excretion' ,'osteoclast differentiation' ,'positive regulation of epithelial to mesenchymal transition' ,'glutathione derivative biosynthetic process' ,'arachidonic acid metabolic process' ,'neurotransmitter metabolic process' ,'stress granule assembly' ,'sperm motility' ,'hepatocyte differentiation' ,'AMP-activated protein kinase activity' ,'swimming behavior' ,'negative regulation of monooxygenase activity' ,'fatty acid homeostasis' ,'L-ascorbic acid metabolic process' ,'pyroptosis' ,'response to xenobiotic stimulus' ,'positive regulation of prostaglandin biosynthetic process' ) ) or ptr.phenotype_id IN ( SELECT id FROM term WHERE nm IN ( -- genes 'NOG' ,'TNF' ,'INS' ,'CASP3' ,'IL1B' ,'IL6' ,'MAPK1' ,'NFE2L2' ,'MAPK3' ,'HMOX1' ,'AHR' ,'CYP1A1' ,'PTGS2' ,'PPARA' ,'BCL2' ,'CAT' ,'ESR1' ,'BAX' ,'NOS2' ,'RELA' ,'TGFB1' ,'TP53' ,'RORA' ,'AKT1' ,'CXCL8' ,'PPARG' ,'IFNG' ,'AR' ,'INS1' ,'ACHE' ,'PARP1' ,'CASP9' ,'CCL2' ,'NQO1' ,'CDKN1A' ,'CYP3A4' ,'MMP9' ,'SOD2' ,'APP' ,'VEGFA' ,'CYP1A2' ,'CCND1' ,'FOS' ,'NFKBIA' ,'SOD1' ,'HIF1A' ,'DDIT3' ,'ESR2' ,'JUN' ,'IL10' ,'AGT' ,'FGF2' ,'ABCB1' ,'CYP2E1' ,'GPT' ,'NR1I3' ,'CYP1B1' ,'CASP8' ,'NR1I2' ,'MAPK8' ,'EGF' ,'SIRT1' ,'GSR' ,'ACTA2' ,'MPO' ,'MYC' ,'ICAM1' ,'HSPA5' ,'MMP2' ,'G3BP1' ,'STAT3' ,'SQSTM1' ,'EGFR' ,'IL4' ,'NFKB1' ,'TLR4' ,'CASP1' ,'ALB' ,'RX3' ,'CTNNB1' ,'NOS3' ,'IGF1' ,'BCL2L1' ,'COL1A1' ,'GCLC' ,'NLRP3' ,'MAP1LC3B' ,'CDH1' ,'SREBF1' ,'GSK3B' ,'MTOR' ,'FASN' ,'PCNA' ,'ABCC2' ,'STAR' ,'PGR' ,'BDNF' ,'PPARGC1A' ,'CYP19A1' ,'GPX1' ,'H2AX' ,'LEP' ,'VIM' ,'IL18' ,'OGA' ,'GSTP1' ,'ADIPOQ' ,'BECN1' ,'IL1A' ,'TRP53' ,'FAS' ,'EGR1' ,'VCAM1' ,'NR1H4' ,'NR3C1' ,'APOE' ,'ABCG2' ,'FN1' ,'MYD88' ,'IL2' ,'CXCL1' ,'FSHB' ,'CREB1' ,'EDN1' ,'BIRC5' ,'SERPINE1' ,'ABCC1' ,'CNR1' ,'ABCB11' ,'CYCS' ,'CD36' ,'TIMP1' ,'GCLM' ,'CYP2C9' ,'TNFSF10' ,'LHB' ,'TH' ,'CXCL2' ,'FABP4' ,'BCHE' ,'ATF4' ,'PON1' ,'CYP11A1' ,'SPP1' ,'CASP7' ,'HMGCR' ,'MAPK9' ,'IL12B' ,'CYP17A1' ,'CCNB1' ,'CDKN1B' ,'CYP2B6' ,'RB1' ,'PRL' ,'MAPK14' ,'CEBPB' ,'CXCL10' ,'TIPARP' ,'GADD45A' ,'XBP1' ,'ATF3' ,'TRPV1' ,'CDK1' ,'MT1' ,'LPL' ,'GJA1' ,'MKI67' ,'MAPT' ,'ADRB2' ,'PTEN' ,'TXNRD1' ,'CPT1A' ,'KEAP1' ,'CYP7A1' ,'SLC2A1' ,'CCL5' ,'RPS6KB1' ,'ACACA' ,'KCNH2' ,'CEBPA' ,'STAT1' ,'INHBA' ,'MCL1' ,'BMP4' ,'CCN2' ,'SRC' ,'CSF2' ,'PTGS1' ,'EIF2AK3' ,'XDH' ,'SNCA' ,'ABCA1' ,'CDK2' ,'GPX4' ,'THRB' ,'CNR2' ,'DRD2' ,'LDLR' ,'GSTM1' ,'ABCC3' -- chemicals ,'bisphenol A' ,'Tetrachlorodibenzodioxin' ,'Benzo(a)pyrene' ,'Valproic Acid' ,'sodium arsenite' ,'Lipopolysaccharides' ,'Estradiol' ,'Acetaminophen' ,'4-(5-benzo(1,3)dioxol-5-yl-4-pyridin-2-yl-1H-imidazol-2-yl)benzamide' ,'dorsomorphin' ,'Particulate Matter' ,'Dexamethasone' ,'Cadmium Chloride' ,'titanium dioxide' ,'Aflatoxin B1' ,'Air Pollutants' ,'Cisplatin' ,'Tobacco Smoke Pollution' ,'Carbon Tetrachloride' ,'Resveratrol' ,'Doxorubicin' ,'pirinixic acid' ,'Ethinyl Estradiol' ,'Ozone' ,'Tretinoin' ,'Ethanol' ,'Dietary Fats' ,'Thioacetamide' ,'Cyclosporine' ,'Nanotubes, Carbon' ,'perfluorooctane sulfonic acid' ,'bisphenol S' ,'Folic Acid' ,'Vehicle Emissions' ,'1,2-Dimethylhydrazine' ,'Oxygen' ,'trichostatin A' ,'1-Methyl-3-isobutylxanthine' ,'Silicon Dioxide' ,'Indomethacin' ,'bisphenol F' ,'CGP 52608' ,'Atrazine' ,'Arsenic Trioxide' ,'methylmercuric chloride' ,'Cadmium' ,'Phenobarbital' ,'arsenite' ,'decamethrin' ,'Paraquat' ,'Tetradecanoylphorbol Acetate' ,'Quercetin' ,'Propylthiouracil' ,'Hydrogen Peroxide' ,'perfluorooctanoic acid' ,'Glucose' ,'Copper' ,'Smoke' ,'Chlorpyrifos' ,'triphenyl phosphate' ,'Gentamicins' ,'Diethylhexyl Phthalate' ,'Arsenic' ,'Rotenone' ,'Diethylnitrosamine' ,'Testosterone' ,'Acrylamide' ,'Phenylmercuric Acetate' ,'Dibutyl Phthalate' ,'Streptozocin' ,'Progesterone' ,'Plant Extracts' ,'Trichloroethylene' ,'aristolochic acid I' ,'Copper Sulfate' ,'cobaltous chloride' ,'Methyl Methanesulfonate' ,'Methamphetamine' ,'(+)-JQ1 compound' ,'jinfukang' ,'deoxynivalenol' ,'vinclozolin' ,'abrine' ,'Nickel' ,'Dioxins' ,'Genistein' ,'Fulvestrant' ,'Clofibrate' ,'Rosiglitazone' ,'Soot' ,'Cocaine' ,'Sunitinib' ,'Dronabinol' ,'Methotrexate' ,'JP8 aviation fuel' ,'triptonide' ,'entinostat' ,'2,2'',4,4''-tetrabromodiphenyl ether' ,'Tamoxifen' ,'Acetylcysteine' ,'1-Methyl-4-phenylpyridinium' ,'Calcitriol' ,'Acrolein' ,'di-n-butylphosphoric acid' ,'Thiram' ,'Endosulfan' ,'Zinc' ,'Ammonium Chloride' ,'Choline' ,'Ionomycin' ,'Formaldehyde' ,'tris(1,3-dichloro-2-propyl)phosphate' ,'Caffeine' ,'potassium chromate(VI)' ,'Methionine' ,'lead acetate' ,'perfluorooctanesulfonamide' ,'lipopolysaccharide, E coli O55-B5' ,'Flutamide' ,'Vorinostat' ,'furan' ,'Ivermectin' ,'Curcumin' ,'Lead' ,'Urethane' ,'Troglitazone' ,'S-(1,2-dichlorovinyl)cysteine' ,'Fluorouracil' ,'Fenretinide' ,'ethylene dichloride' ,'Dextran Sulfate' ,'hexabromocyclododecane' ,'Asbestos, Crocidolite' ,'7,8-Dihydro-7,8-dihydroxybenzo(a)pyrene 9,10-oxide' ,'sodium arsenate' ,'manganese chloride' ,'lipopolysaccharide, Escherichia coli O111 B4' ,'Cuprizone' ,'Methapyrilene' ,'Topotecan' ,'Isoproterenol' ,'epoxiconazole' ,'FR900359' ,'Methimazole' ,'Nicotine' ,'Antirheumatic Agents' ,'3,4,5,3'',4''-pentachlorobiphenyl' ,'methacrylaldehyde' ,'chromium hexavalent ion' ,'Triclosan' ,'Glyphosate' ,'N-Methyl-3,4-methylenedioxyamphetamine' ,'mono-(2-ethylhexyl)phthalate' ,'Aluminum' ,'Oxaliplatin' ,'T-2 Toxin' ,'Cellulose' ,'Decitabine' ,'acetamide' ,'Amitrole' ,'beta-lapachone' ,'Cyclophosphamide' ,'butyraldehyde' ,'Selenium' ,'alpha-pinene' ,'Temozolomide' ,'Amiodarone' ,'4,4''-diaminodiphenylmethane' ,'1,4-bis(2-(3,5-dichloropyridyloxy))benzene' ,'Panobinostat' ,'Diethylstilbestrol' ,'decabromobiphenyl ether' ,'Tunicamycin' ,'Carbamazepine' ,'Lactic Acid' ,'Sodium Fluoride' ,'Cannabidiol' ,'ochratoxin A' ,'epigallocatechin gallate' ,'1-Naphthylisothiocyanate' ,'fipronil' ,'Mercuric Chloride' ,'Coumestrol' ,'Paclitaxel' ,'bisphenol AF' ,'tert-Butylhydroperoxide' ,'dicrotophos' ,'sulforaphane' ,'Enzyme Inhibitors' ,'Dichlorodiphenyl Dichloroethylene' ,'1H,1H,10H,10H-perfluorodecane-1,10-diol' ,'Methoxychlor' ,'Thapsigargin' ,'Leflunomide' ,'Haloperidol' ,'2,4,5,2'',4'',5''-hexachlorobiphenyl' ,'9,10-Dimethyl-1,2-benzanthracene' ,'Silver' -- diseases ,'Chemical and Drug Induced Liver Injury' ,'Seizures' ,'Hypertension' ,'Hypotension' ,'Kidney Diseases' ,'Pain' ,'Acute Kidney Injury' ,'Breast Neoplasms' ,'Necrosis' ,'Weight Loss' ,'Inflammation' ,'Drug-Related Side Effects and Adverse Reactions' ,'Cocaine-Related Disorders' ,'Heart Failure' ,'Substance Withdrawal Syndrome' ,'Depressive Disorder' ,'Bradycardia' ,'Prostatic Neoplasms' ,'Hyperalgesia' ,'Prenatal Exposure Delayed Effects' ,'Myocardial Infarction' ,'Catalepsy' ,'Liver Cirrhosis, Experimental' ,'Hyperkinesis' ,'Edema' ,'Arrhythmias, Cardiac' ,'Carcinoma, Hepatocellular' ,'Dyskinesia, Drug-Induced' ,'Nausea' ,'Vomiting' ,'Lung Neoplasms' ,'Disease Models, Animal' ,'Hyperglycemia' ,'Hepatomegaly' ,'Weight Gain' ,'Cardiomyopathies' ,'Tachycardia' ,'Headache' ,'Bipolar Disorder' ,'Nerve Degeneration' ,'Proteinuria' ,'Diabetes Mellitus, Experimental' ,'Anemia' ,'Memory Disorders' ,'Tremor' ,'Peripheral Nervous System Diseases' ,'Fatty Liver' ,'Parkinson Disease' ,'Liver Neoplasms' ,'Status Epilepticus' ,'Schizophrenia' ,'Thrombocytopenia' ,'Liver Neoplasms, Experimental' ,'Cognition Disorders' ,'Heart Diseases' ,'Hemorrhage' ,'Arthritis, Rheumatoid' ,'Renal Insufficiency' ,'Fever' ,'Asthma' ,'Cholestasis' ,'Insulin Resistance' ,'Urinary Bladder Neoplasms' ,'Obesity' ,'Nervous System Diseases' ,'Liver Cirrhosis' ,'Poisoning' ,'Muscular Diseases' ,'Diarrhea' ,'Neoplasms, Experimental' ,'Colorectal Neoplasms' ,'Atrial Fibrillation' ,'Neutropenia' ,'Tachycardia, Ventricular' ,'Anxiety Disorders' ,'Colonic Neoplasms' ,'Epilepsy' ,'Myocardial Ischemia' ,'Stomach Neoplasms' ,'Amnesia' ,'Cardiomegaly' ,'Brain Injuries' ,'Parkinsonian Disorders' ,'Diabetes Mellitus, Type 2' ,'Neoplasm Metastasis' ,'Melanoma' ,'Neoplasm Invasiveness' ,'Torsades de Pointes' ,'Neoplasms' ,'Long QT Syndrome' ,'Ventricular Dysfunction, Left' ,'Cell Transformation, Neoplastic' ,'Thrombosis' ,'Pain, Postoperative' ,'Movement Disorders' ,'Hallucinations' ,'Dystonia' ,'Nephritis, Interstitial' ,'Stomach Ulcer' ,'Carcinoma, Non-Small-Cell Lung' ,'Pulmonary Fibrosis' ,'Brain Diseases' ,'Fibrosis' ,'Learning Disabilities' ,'Heart Arrest' ,'Drug Hypersensitivity' ,'Liver Diseases' ,'Psychoses, Substance-Induced' ,'Dizziness' ,'Cardiovascular Diseases' ,'Hypokalemia' ,'Ventricular Fibrillation' ,'Autistic Disorder' ,'Precursor Cell Lymphoblastic Leukemia-Lymphoma' ,'Myoclonus' ,'Hyperplasia' ,'Precancerous Conditions' ,'Multiple Myeloma' ,'Angina Pectoris' ,'Neurotoxicity Syndromes' ,'Liver Failure, Acute' ,'Leukemia, Promyelocytic, Acute' ,'Adenocarcinoma' ,'Basal Ganglia Diseases' ,'Cystitis' ,'Hepatitis B' ,'Hepatitis' ,'Dermatitis, Allergic Contact' ,'Leukemia, Myeloid, Acute' ,'Lung Injury' ,'HIV Infections' ,'Ataxia' ,'Ovarian Neoplasms' ,'Atherosclerosis' ,'Mammary Neoplasms, Experimental' ,'Abnormalities, Drug-Induced' ,'Confusion' ,'Staphylococcal Infections' ,'Autism Spectrum Disorder' ,'Stroke' ,'Leukopenia' ,'Testicular Diseases' ,'Reperfusion Injury' ,'Colitis' ,'Alzheimer Disease' ,'Carcinoma' ,'Glucose Intolerance' ,'Skin Neoplasms' ,'Anemia, Hemolytic' ,'Exanthema' ,'Hypertension, Pulmonary' ,'Muscle Rigidity' ,'Psychotic Disorders' ,'Hypercholesterolemia' ,'Angioedema' ,'Delirium' ,'Non-alcoholic Fatty Liver Disease' ,'Paralysis' ,'Apnea' ,'Pulmonary Edema' ,'Pneumonia' ,'Micronuclei, Chromosome-Defective' ,'Venous Thrombosis' ,'Parkinson Disease, Secondary' ,'Nephrotic Syndrome' ,'Muscle Weakness' ,'Pruritus' ,'Drug Eruptions' ,'Acute Lung Injury' ,'Hypothermia' ,'Pancreatic Neoplasms' ,'Diabetic Nephropathies' ,'Gastrointestinal Diseases' ,'Substance-Related Disorders' ,'Coma' ,'Epilepsy, Tonic-Clonic' ,'Craniofacial Abnormalities' ,'Stevens-Johnson Syndrome' ,'Migraine Disorders' ,'Vision Disorders' ,'Jaundice' ,'Paresthesia' ,'Carcinoma, Squamous Cell' ,'Fatigue' ,'Cerebral Hemorrhage' ,'Hypercalcemia' ,'Skin Diseases' ,'Hypotension, Orthostatic' ,'Urticaria' ,'Hematuria' ,'Erectile Dysfunction' ,'Colitis, Ulcerative' ,'Mammary Neoplasms, Animal' ,'Lung Diseases' ,'Rhabdomyolysis' ,'Oligospermia' ,'Depressive Disorder, Major' ,'Anemia, Aplastic' ,'Anorexia' ,'Hyperlipidemias' -- phenotypes ,'apoptotic process' ,'cell population proliferation' ,'cellular metabolic process' ,'lipid oxidation' ,'glutathione metabolic process' ,'reactive oxygen species metabolic process' ,'lipid catabolic process' ,'cell death' ,'detection of oxidative stress' ,'positive regulation of apoptotic process' ,'superoxide dismutase activity' ,'positive regulation of reactive oxygen species biosynthetic process' ,'positive regulation of cell death' ,'regulation of blood pressure' ,'reactive oxygen species biosynthetic process' ,'negative regulation of cell population proliferation' ,'regulation of mitochondrial membrane potential' ,'vasoconstriction' ,'glutathione biosynthetic process' ,'membrane lipid catabolic process' ,'glutathione peroxidase activity' ,'cellular response to DNA damage stimulus' ,'cholesterol metabolic process' ,'positive regulation of cell population proliferation' ,'triglyceride metabolic process' ,'response to oxidative stress' ,'regulation of heart rate' ,'negative regulation of mitotic cell cycle' ,'vasodilation' ,'ATP metabolic process' ,'cell growth' ,'cellular calcium ion homeostasis' ,'leukocyte migration involved in inflammatory response' ,'nitric oxide metabolic process' ,'creatinine metabolic process' ,'apoptotic DNA fragmentation' ,'lipid droplet formation' ,'ncRNA transcription' ,'protein oxidation' ,'mitotic cell cycle process' ,'DNA modification' ,'inflammatory response' ,'cholesterol homeostasis' ,'glutathione transferase activity' ,'autophagy' ,'fat cell differentiation' ,'triglyceride homeostasis' ,'lipid metabolic process' ,'necrotic cell death' ,'xenobiotic metabolic process' ,'negative regulation of superoxide dismutase activity' ,'triglyceride biosynthetic process' ,'cell migration' ,'cell redox homeostasis' ,'bile acid metabolic process' ,'nitric oxide biosynthetic process' ,'superoxide anion generation' ,'lactate dehydrogenase activity' ,'cell cycle' ,'amino acid metabolic process' ,'testosterone biosynthetic process' ,'activation of protein kinase B activity' ,'L-aspartate:2-oxoglutarate aminotransferase activity' ,'positive regulation of nitric oxide biosynthetic process' ,'cholesterol biosynthetic process' ,'protein import into nucleus' ,'positive regulation of protein import into nucleus' ,'wound healing, spreading of cells' ,'alkaline phosphatase activity' ,'positive regulation of cytosolic calcium ion concentration' ,'glucose homeostasis' ,'positive regulation of mitochondrial membrane potential' ,'fatty acid metabolic process' ,'cell chemotaxis' ,'positive regulation of vasoconstriction' ,'spermatogenesis' ,'positive regulation of neuron death' ,'positive regulation of superoxide dismutase activity' ,'collagen fibril organization' ,'cell differentiation' ,'histone H3-K9 acetylation' ,'mitochondrion organization' ,'positive regulation of protein localization to nucleus' ,'positive regulation of p38MAPK cascade' ,'ATP biosynthetic process' ,'metabolic process' ,'locomotion involved in locomotory behavior' ,'urate metabolic process' ,'dopamine metabolic process' ,'positive regulation of NF-kappaB transcription factor activity' ,'embryo development' ,'lipid biosynthetic process' ,'protein lipidation' ,'histamine secretion mediated by immunoglobulin' ,'glucose metabolic process' ,'negative regulation of mitochondrial membrane potential' ,'release of cytochrome c from mitochondria' ,'DNA catabolic process, endonucleolytic' ,'cellular respiration' ,'calcium ion homeostasis' ,'positive regulation of cell migration' ,'regulation of cellular metabolic process' ,'reactive nitrogen species metabolic process' ,'positive regulation of inflammatory response' ,'establishment of protein localization to plasma membrane' ,'lipid homeostasis' ,'response to antineoplastic agent' ,'glucose import' ,'urea metabolic process' ,'positive regulation of ERK1 and ERK2 cascade' ,'positive regulation of necrotic cell death' ,'memory' ,'negative regulation of glutathione peroxidase activity' ,'positive regulation of apoptotic DNA fragmentation' ,'mitochondrial depolarization' ,'G2/M transition of mitotic cell cycle' ,'cAMP metabolic process' ,'mitotic S phase' ,'hydrogen peroxide biosynthetic process' ,'positive regulation of superoxide anion generation' ,'positive regulation of autophagy' ,'protein modification process' ,'regulation of metabolic process' ,'cellular iron ion homeostasis' ,'lactate metabolic process' ,'DNA methylation on cytosine within a CG sequence' ,'apoptotic chromosome condensation' ,'serotonin metabolic process' ,'cellular lipid metabolic process' ,'positive regulation of glutathione peroxidase activity' ,'transepithelial transport' ,'positive regulation of lipid storage' ,'hydrogen peroxide metabolic process' ,'G0 to G1 transition' ,'positive regulation of collagen biosynthetic process' ,'iron ion homeostasis' ,'positive regulation of cytolysis' ,'gluconeogenesis' ,'micronucleus organization' ,'microglial cell activation' ,'positive regulation of autophagosome assembly' ,'positive regulation of NIK/NF-kappaB signaling' ,'calcium-mediated signaling' ,'positive regulation of cytokine production involved in inflammatory response' ,'cellular senescence' ,'neuron death' ,'macrophage activation' ,'cAMP biosynthetic process' ,'positive regulation of lipid catabolic process' ,'negative regulation of response to drug' ,'calcium ion import' ,'behavioral response to pain' ,'positive regulation of intracellular estrogen receptor signaling pathway' ,'regulation of bile acid metabolic process' ,'mitotic cell cycle' ,'autophagosome assembly' ,'prostaglandin metabolic process' ,'protein poly-ADP-ribosylation' ,'DNA methylation' ,'glycolytic process' ,'positive regulation of fat cell differentiation' ,'protein lipidation involved in autophagosome assembly' ,'estrogen metabolic process' ,'thyroid hormone metabolic process' ,'positive regulation of organ growth' ,'neutrophil migration' ,'NADH dehydrogenase (ubiquinone) activity' ,'prostaglandin biosynthetic process' ,'negative regulation of ATP biosynthetic process' ,'adipose tissue development' ,'larval development' ,'androgen metabolic process' ,'amino acid biosynthetic process' ,'aerobic respiration' ,'positive regulation of cellular extravasation' ,'positive regulation of neutrophil extravasation' ,'negative regulation of cell migration' ,'carbohydrate metabolic process' ,'positive regulation of JNK cascade' ,'positive regulation of neuron apoptotic process' ,'positive regulation of release of cytochrome c from mitochondria' ,'cognition' ,'vacuole organization' ,'renal sodium excretion' ,'osteoclast differentiation' ,'positive regulation of epithelial to mesenchymal transition' ,'glutathione derivative biosynthetic process' ,'arachidonic acid metabolic process' ,'neurotransmitter metabolic process' ,'stress granule assembly' ,'sperm motility' ,'hepatocyte differentiation' ,'AMP-activated protein kinase activity' ,'swimming behavior' ,'negative regulation of monooxygenase activity' ,'fatty acid homeostasis' ,'L-ascorbic acid metabolic process' ,'pyroptosis' ,'response to xenobiotic stimulus' ,'positive regulation of prostaglandin biosynthetic process' ) ) )#015 and ( ptr.term_id, ptr.phenotype_id ) in ( select chem_id, phenotype_id from tetramer ) #015 and source_cd = 'C' #015 and term_object_type_id = 2 --chemical #015 #015;

Date: 2025-01-22 12:35:43
Duration: 4s322ms
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: pubeu - Total duration: 4s238ms - Times executed: 1 ]

x Hide

SELECT /* CIQH.getIxnCacheQuery */ gcr.ixn_id, NULL, NULL, NULL FROM gene_chem_reference gcr WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'ASTHMA' AND t.object_type_id = 3))) AND gcr.id IN ( SELECT gcra.gene_chem_reference_id FROM gene_chem_reference_axn gcra WHERE (gcra.action_degree_type_nm = 'increases'));

Date: 2025-01-22 05:47:20
Duration: 4s238ms
Database: ctddev51
User: pubeu
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN ( SELECT gcr.gene_id FROM gene_chem_reference gcr WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'ASTHMA' AND t.object_type_id = 3))) AND gcr.id IN ( SELECT gcra.gene_chem_reference_id FROM gene_chem_reference_axn gcra WHERE (gcra.action_degree_type_nm = 'increases'))) ORDER BY g.nm_sort, g.id LIMIT 50;

Date: 2025-01-22 05:47:25
Duration: 4s18ms
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* IQH.getMasterPathwayWhereEquals.Name */ tp.term_id FROM term_pathway tp WHERE UPPER(tp.pathway_nm) LIKE 'METABOLISM' AND tp.object_type_id = 4))) AND gcr.id IN ( SELECT gcra.gene_chem_reference_id FROM gene_chem_reference_axn gcra WHERE (gcra.action_degree_type_nm = 'increases')) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY g.nm_sort, c.nm_sort, i.sort_txt LIMIT 50;

Date: 2025-01-22 05:47:34
Duration: 3s605ms
Bind query: yes