SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc ORDER BY chem, organism LIMIT 50;

[ Date: 2026-08-03 15:52:43 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207881')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 15:31:51 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 16:59:18 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 17:00:54 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 17:00:28 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 16:59:27 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208350')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 15:30:40 - Bind query: yes ]

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd JOIN anatomy a1 ON a1.chem_conc_id = cc.id JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1429606') GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

[ Date: 2026-08-05 16:42:40 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

[ Date: 2026-08-04 15:43:58 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

[ Date: 2026-08-04 16:19:17 - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50;

[ Date: 2026-08-04 16:18:08 - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50;

[ Date: 2026-08-04 15:44:54 - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50;

[ Date: 2026-08-04 15:51:25 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50;

[ Date: 2026-08-04 16:18:17 - Database: ctddev51 - User: pubeu - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207989')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50;

[ Date: 2026-08-04 15:21:36 - Database: ctddev51 - User: pubeu - Bind query: yes ]

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 /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN term_label li ON li.term_id = pi.ancestor_object_id WHERE UPPER(li.nm) LIKE 'APOPTOSIS' AND li.object_type_id = 5)) ORDER BY g.nm_sort, g.id LIMIT 50;

[ Date: 2026-08-02 08:51:58 - Bind query: yes ]

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd JOIN anatomy a1 ON a1.chem_conc_id = cc.id JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids JOIN anatomy a3 ON a2.chem_conc_id = cc2.id AND a3.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in (2207489)) GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc;

[ Date: 2026-08-04 16:14:10 ]

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2.*, refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd JOIN anatomy a1 ON a1.chem_conc_id = cc.id JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids JOIN anatomy a3 ON a2.chem_conc_id = cc2.id AND a3.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in (2207489)) GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc;

[ Date: 2026-08-04 16:14:42 ]

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, ( 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 r.acc_txt, '|')) as references, 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 INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.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: 2026-08-02 08:52:49 - Bind query: yes ]

SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refAcc, COUNT(DISTINCT cc.reference_id) referenceCount, COUNT(*) OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;

[ Date: 2026-08-03 16:06:22 - Bind query: yes ]