Advertisement
lerakaneva

Untitled

May 30th, 2025
289
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.96 KB | None | 0 0
  1. MATCH (n0:`biolink:ChemicalEntity`)-[r0]-(n1:`biolink:ChemicalEntity`)-[r1]-(n2:`biolink:DiseaseOrPhenotypicFeature`) WHERE toLower(n1.name) IN ['rosuvastatin'] AND toLower(n0.name) IN ['voxilaprevir'] AND toLower(n2.name) IN ['blood cholesterol abnormal'] CALL{WITH n0, r0 MATCH(n0)-[r0]-(t) RETURN apoc.node.degree(n0, '`'+TYPE(r0)+'`') AS esnd_n0_r0} CALL{WITH n1, r0 MATCH(n1)-[r0]-(t) RETURN apoc.node.degree(n1, '`'+TYPE(r0)+'`') AS esnd_n1_r0} CALL{WITH n1, r1 MATCH(n1)-[r1]-(t) RETURN apoc.node.degree(n1, '`'+TYPE(r1)+'`') AS esnd_n1_r1} CALL{WITH n2, r1 MATCH(n2)-[r1]-(t) RETURN apoc.node.degree(n2, '`'+TYPE(r1)+'`') AS esnd_n2_r1} RETURN n0.name AS n0, esnd_n0_r0, TYPE(r0) AS r0, apoc.text.JOIN([r0.qualified_predicate,r0.object_direction,r0.object_aspect],' ') AS r0_qual_pred, n1.name AS n1, esnd_n1_r0, esnd_n1_r1, TYPE(r1) AS r1, apoc.text.JOIN([r1.qualified_predicate,r1.object_direction,r1.object_aspect],' ') AS r1_qual_pred, n2.name AS n2, esnd_n2_r1 LIMIT 10000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement