Query Metapaths
Return metapaths between a given source and target node whose path count information is stored in the database.
Specify complete
to also return metapaths of unknown significance whose path count information is not stored in the database.
If not specified, limit
defaults to returning all metapaths (i.e. without limit).
The database only stores a single orientation of a metapath. For example, if GpPpGaD is stored between the given source and target node, DaGpPpG would not also be stored. Therefore, both orientations of a metapath are searched against the PathCount table.
GET /v1/metapaths/source/17054/target/6602/?format=api
http://www.drugbank.ca/drugs/DB00331", "inchi": "InChI=1S/C4H11N5/c1-9(2)4(7)8-3(5)6/h1-2H3,(H5,5,6,7,8)", "source": "DrugBank", "license": "CC BY-NC 4.0", "inchikey": "InChIKey=XZWYZXLIPXDOLR-UHFFFAOYSA-N" }, "metanode": "Compound" }, "target": { "id": 6602, "identifier": "DOID:1612", "identifier_type": "str", "name": "breast cancer", "properties": { "url": "http://purl.obolibrary.org/obo/DOID_1612", "source": "Disease Ontology", "license": "CC BY 3.0" }, "metanode": "Disease" }, "path_counts": [ { "id": 77513331, "adjusted_p_value": 0.003951112689446279, "path_count": 484, "dwpc": 3.5346993748913973, "p_value": 3.2653823879721316e-05, "reversed": false, "metapath_abbreviation": "CbGeAlD", "metapath_name": "Compound–binds–Gene–expresses–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.800046, "metapath_path_count_mean": 17.3173, "metapath_path_count_max": 1670, "metapath_dwpc_raw_mean": 0.000259132, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGeAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 21810569, "dgp_source_degree": 56, "dgp_target_degree": 39, "dgp_n_dwpcs": 800, "dgp_n_nonzero_dwpcs": 800, "dgp_nonzero_mean": 1.9215512456202535, "dgp_nonzero_sd": 0.33090308109283123, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 26911811, "adjusted_p_value": 0.034321317684374276, "path_count": 14, "dwpc": 4.563918531032985, "p_value": 0.00028364725358987007, "reversed": false, "metapath_abbreviation": "CtDlAlD", "metapath_name": "Compound–treats–Disease–localizes–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.18212, "metapath_path_count_mean": 1.29946, "metapath_path_count_max": 279, "metapath_dwpc_raw_mean": 0.000563455, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDlAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Anatomy", "localizes", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 23793754, "dgp_source_degree": 3, "dgp_target_degree": 39, "dgp_n_dwpcs": 15200, "dgp_n_nonzero_dwpcs": 15194, "dgp_nonzero_mean": 2.552159071387449, "dgp_nonzero_sd": 0.48489767303472786, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:LOCALIZES_DlA]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 72430549, "adjusted_p_value": 0.045993636486382335, "path_count": 126, "dwpc": 4.386227813718969, "p_value": 0.0003801126982345647, "reversed": false, "metapath_abbreviation": "CbGdAlD", "metapath_name": "Compound–binds–Gene–downregulates–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.590437, "metapath_path_count_mean": 4.04788, "metapath_path_count_max": 372, "metapath_dwpc_raw_mean": 0.000121205, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGdAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 21763190, "dgp_source_degree": 56, "dgp_target_degree": 39, "dgp_n_dwpcs": 800, "dgp_n_nonzero_dwpcs": 791, "dgp_nonzero_mean": 2.1106664913501048, "dgp_nonzero_sd": 0.5350022943256412, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 113108500, "adjusted_p_value": 0.04698025324807386, "path_count": 42, "dwpc": 4.140063444985263, "p_value": 0.00038826655576920546, "reversed": false, "metapath_abbreviation": "CbGiGaD", "metapath_name": "Compound–binds–Gene–interacts–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.348183, "metapath_path_count_mean": 2.23582, "metapath_path_count_max": 809, "metapath_dwpc_raw_mean": 0.00019613400000000002, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGiGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 21828791, "dgp_source_degree": 56, "dgp_target_degree": 540, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 200, "dgp_nonzero_mean": 2.686698590200101, "dgp_nonzero_sd": 0.37751699541244615, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:INTERACTS_GiG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 67500273, "adjusted_p_value": 0.10051956724479168, "path_count": 163, "dwpc": 4.699608393014548, "p_value": 0.0008307402251635675, "reversed": false, "metapath_abbreviation": "CbGr>GaD", "metapath_name": "Compound–binds–Gene→regulates→Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.32456799999999997, "metapath_path_count_mean": 1.8491900000000001, "metapath_path_count_max": 755, "metapath_dwpc_raw_mean": 7.56952e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGr>GaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 21960830, "dgp_source_degree": 56, "dgp_target_degree": 540, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 200, "dgp_nonzero_mean": 3.2657197245645078, "dgp_nonzero_sd": 0.40759580920134286, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:REGULATES_GrG]->(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 142020565, "adjusted_p_value": 0.1005235732343783, "path_count": 103, "dwpc": 5.097303896409291, "p_value": 0.0008307733325155232, "reversed": false, "metapath_abbreviation": "CbGr>GuD", "metapath_name": "Compound–binds–Gene→regulates→Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.146992, "metapath_path_count_mean": 1.0096100000000001, "metapath_path_count_max": 526, "metapath_dwpc_raw_mean": 5.89699e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGr>GuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 22043084, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5400, "dgp_nonzero_mean": 3.501803136530045, "dgp_nonzero_sd": 0.4518997502518118, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:REGULATES_GrG]->(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 114205387, "adjusted_p_value": 0.1248117671211756, "path_count": 59, "dwpc": 4.921895497900556, "p_value": 0.0010315022076130215, "reversed": false, "metapath_abbreviation": "CbG<rGaD", "metapath_name": "Compound–binds–Gene←regulates←Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.20608200000000002, "metapath_path_count_mean": 1.36917, "metapath_path_count_max": 304, "metapath_dwpc_raw_mean": 6.28947e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbG<rGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 21530747, "dgp_source_degree": 56, "dgp_target_degree": 540, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 200, "dgp_nonzero_mean": 3.109850461985937, "dgp_nonzero_sd": 0.5104605505797233, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)<-[:REGULATES_GrG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 112488887, "adjusted_p_value": 0.3013641844647006, "path_count": 16, "dwpc": 5.390652904661932, "p_value": 0.0024906130947495914, "reversed": false, "metapath_abbreviation": "CtDaGuD", "metapath_name": "Compound–treats–Disease–associates–Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0567904, "metapath_path_count_mean": 0.570303, "metapath_path_count_max": 159, "metapath_dwpc_raw_mean": 0.0001389, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDaGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "associates", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 23755239, "dgp_source_degree": 3, "dgp_target_degree": 250, "dgp_n_dwpcs": 102600, "dgp_n_nonzero_dwpcs": 102339, "dgp_nonzero_mean": 3.7252708618200967, "dgp_nonzero_sd": 0.5311944537003014, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:ASSOCIATES_DaG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 678248, "adjusted_p_value": 0.653270938930521, "path_count": 99, "dwpc": 4.140174738675961, "p_value": 0.005398933379591082, "reversed": false, "metapath_abbreviation": "CtDaGaD", "metapath_name": "Compound–treats–Disease–associates–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.193196, "metapath_path_count_mean": 4.464180000000001, "metapath_path_count_max": 876, "metapath_dwpc_raw_mean": 0.000403948, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDaGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "associates", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 23724358, "dgp_source_degree": 3, "dgp_target_degree": 540, "dgp_n_dwpcs": 3800, "dgp_n_nonzero_dwpcs": 3800, "dgp_nonzero_mean": 3.2800660008843163, "dgp_nonzero_sd": 0.31563132652903, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:ASSOCIATES_DaG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 96988112, "adjusted_p_value": 1.0, "path_count": 512, "dwpc": 3.089869181245992, "p_value": 0.009034196756478506, "reversed": false, "metapath_abbreviation": "CdG<rGaD", "metapath_name": "Compound–downregulates–Gene←regulates←Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.395604, "metapath_path_count_mean": 37.7055, "metapath_path_count_max": 4309, "metapath_dwpc_raw_mean": 0.00028245, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdG<rGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 22316810, "dgp_source_degree": 22, "dgp_target_degree": 540, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1200, "dgp_nonzero_mean": 2.6872787862396263, "dgp_nonzero_sd": 0.16384687978846307, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)<-[:REGULATES_GrG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 10892498, "adjusted_p_value": 1.0, "path_count": 21, "dwpc": 5.071665342675126, "p_value": 0.013791674143867196, "reversed": false, "metapath_abbreviation": "CtDaGdD", "metapath_name": "Compound–treats–Disease–associates–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.055718100000000007, "metapath_path_count_mean": 0.44149799999999995, "metapath_path_count_max": 109, "metapath_dwpc_raw_mean": 0.000124723, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDaGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "associates", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 23731785, "dgp_source_degree": 3, "dgp_target_degree": 250, "dgp_n_dwpcs": 98800, "dgp_n_nonzero_dwpcs": 98160, "dgp_nonzero_mean": 3.690298347018518, "dgp_nonzero_sd": 0.5762794425175636, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:ASSOCIATES_DaG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 48876787, "adjusted_p_value": 1.0, "path_count": 3, "dwpc": 4.070490832162907, "p_value": 0.016564731132729372, "reversed": false, "metapath_abbreviation": "CbGdDrD", "metapath_name": "Compound–binds–Gene–downregulates–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.135798, "metapath_path_count_mean": 0.221795, "metapath_path_count_max": 19, "metapath_dwpc_raw_mean": 9.828280000000001e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGdDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Disease", "downregulates", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 21801239, "dgp_source_degree": 56, "dgp_target_degree": 3, "dgp_n_dwpcs": 2800, "dgp_n_nonzero_dwpcs": 812, "dgp_nonzero_mean": 2.2979944741830063, "dgp_nonzero_sd": 1.0081734776406486, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:DOWNREGULATES_DdG]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 167522760, "adjusted_p_value": 1.0, "path_count": 90, "dwpc": 4.020134446208101, "p_value": 0.017607793196850408, "reversed": false, "metapath_abbreviation": "CuGr>GuD", "metapath_name": "Compound–upregulates–Gene→regulates→Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.10528900000000001, "metapath_path_count_mean": 4.58855, "metapath_path_count_max": 1129, "metapath_dwpc_raw_mean": 8.77319e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGr>GuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 24772971, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 145800, "dgp_n_nonzero_dwpcs": 145621, "dgp_nonzero_mean": 2.4665584981776765, "dgp_nonzero_sd": 0.6488129682333391, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:REGULATES_GrG]->(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 167154176, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 6.475597896851278, "p_value": 0.01837763565445217, "reversed": false, "metapath_abbreviation": "CtDpCpD", "metapath_name": "Compound–treats–Disease–palliates–Compound–palliates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.00812232, "metapath_path_count_mean": 0.021248799999999998, "metapath_path_count_max": 31, "metapath_dwpc_raw_mean": 0.00010631, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDpCpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Compound", "palliates", "both" ], [ "Compound", "Disease", "palliates", "both" ] ], "dgp_id": 23804058, "dgp_source_degree": 3, "dgp_target_degree": 14, "dgp_n_dwpcs": 7600, "dgp_n_nonzero_dwpcs": 3345, "dgp_nonzero_mean": 4.210930443126998, "dgp_nonzero_sd": 1.1903616501345484, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:PALLIATES_CpD]-(n2)-[:PALLIATES_CpD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2 AND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n2)),\nsize((n2)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 112893663, "adjusted_p_value": 1.0, "path_count": 7, "dwpc": 5.418669178433626, "p_value": 0.019138619393998163, "reversed": false, "metapath_abbreviation": "CtDdGdD", "metapath_name": "Compound–treats–Disease–downregulates–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0313934, "metapath_path_count_mean": 0.241022, "metapath_path_count_max": 123, "metapath_dwpc_raw_mean": 6.82525e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDdGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 23767659, "dgp_source_degree": 3, "dgp_target_degree": 250, "dgp_n_dwpcs": 98800, "dgp_n_nonzero_dwpcs": 84060, "dgp_nonzero_mean": 3.6635602586740057, "dgp_nonzero_sd": 0.7927141924002727, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:DOWNREGULATES_DdG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 15113069, "adjusted_p_value": 1.0, "path_count": 117, "dwpc": 3.4991699833130117, "p_value": 0.023317287337446795, "reversed": false, "metapath_abbreviation": "CuGr>GaD", "metapath_name": "Compound–upregulates–Gene→regulates→Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.261612, "metapath_path_count_mean": 8.08893, "metapath_path_count_max": 1529, "metapath_dwpc_raw_mean": 0.000111195, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGr>GaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 24632918, "dgp_source_degree": 8, "dgp_target_degree": 540, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5399, "dgp_nonzero_mean": 2.3121920739351287, "dgp_nonzero_sd": 0.5373848327056929, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:REGULATES_GrG]->(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 97531640, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 3.8332261091694466, "p_value": 0.02448539719597531, "reversed": false, "metapath_abbreviation": "CtDrDrD", "metapath_name": "Compound–treats–Disease–resembles–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.055972, "metapath_path_count_mean": 0.28526399999999996, "metapath_path_count_max": 144, "metapath_dwpc_raw_mean": 0.000430315, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDrDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Disease", "resembles", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 23808511, "dgp_source_degree": 3, "dgp_target_degree": 3, "dgp_n_dwpcs": 53200, "dgp_n_nonzero_dwpcs": 30074, "dgp_nonzero_mean": 2.517955090636328, "dgp_nonzero_sd": 0.7006119113977642, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:RESEMBLES_DrD]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2 AND n1 <> n3 AND n2 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 167119847, "adjusted_p_value": 1.0, "path_count": 86, "dwpc": 3.480260005364498, "p_value": 0.02961801201131862, "reversed": false, "metapath_abbreviation": "CdGdCtD", "metapath_name": "Compound–downregulates–Gene–downregulates–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.17690899999999998, "metapath_path_count_mean": 4.51441, "metapath_path_count_max": 1651, "metapath_dwpc_raw_mean": 0.000341563, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGdCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Compound", "downregulates", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 22773547, "dgp_source_degree": 22, "dgp_target_degree": 29, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1200, "dgp_nonzero_mean": 2.73636530998999, "dgp_nonzero_sd": 0.372141580199267, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:DOWNREGULATES_CdG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 73961466, "adjusted_p_value": 1.0, "path_count": 5, "dwpc": 5.188576435472119, "p_value": 0.031145617104940834, "reversed": false, "metapath_abbreviation": "CtDuGdD", "metapath_name": "Compound–treats–Disease–upregulates–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0302882, "metapath_path_count_mean": 0.139354, "metapath_path_count_max": 59, "metapath_dwpc_raw_mean": 8.325969999999999e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDuGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 23832603, "dgp_source_degree": 3, "dgp_target_degree": 250, "dgp_n_dwpcs": 98800, "dgp_n_nonzero_dwpcs": 80129, "dgp_nonzero_mean": 3.6899331737695023, "dgp_nonzero_sd": 0.7840126846658535, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:UPREGULATES_DuG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 142552339, "adjusted_p_value": 1.0, "path_count": 13, "dwpc": 4.6019606799462744, "p_value": 0.03989373143005087, "reversed": false, "metapath_abbreviation": "CbG<rGuD", "metapath_name": "Compound–binds–Gene←regulates←Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0818487, "metapath_path_count_mean": 0.5210229999999999, "metapath_path_count_max": 125, "metapath_dwpc_raw_mean": 3.37004e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbG<rGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 21615602, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5356, "dgp_nonzero_mean": 3.306938793575428, "dgp_nonzero_sd": 0.6880789483314713, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)<-[:REGULATES_GrG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 51026471, "adjusted_p_value": 1.0, "path_count": 100, "dwpc": 3.368403036173284, "p_value": 0.041419841119016906, "reversed": false, "metapath_abbreviation": "CuGiGaD", "metapath_name": "Compound–upregulates–Gene–interacts–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.23424899999999999, "metapath_path_count_mean": 5.42903, "metapath_path_count_max": 1114, "metapath_dwpc_raw_mean": 0.000138883, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGiGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 24402806, "dgp_source_degree": 8, "dgp_target_degree": 540, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5390, "dgp_nonzero_mean": 2.1110526346677996, "dgp_nonzero_sd": 0.6544400882432083, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:INTERACTS_GiG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 117620294, "adjusted_p_value": 1.0, "path_count": 5, "dwpc": 4.255349947963811, "p_value": 0.04278717173688437, "reversed": false, "metapath_abbreviation": "CdGcGaD", "metapath_name": "Compound–downregulates–Gene–covaries–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0824883, "metapath_path_count_mean": 0.291049, "metapath_path_count_max": 68, "metapath_dwpc_raw_mean": 4.7755e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGcGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "covaries", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 22557200, "dgp_source_degree": 22, "dgp_target_degree": 540, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1061, "dgp_nonzero_mean": 2.4442059675365, "dgp_nonzero_sd": 0.9731386488165376, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:COVARIES_GcG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:COVARIES_GcG]-()),\nsize(()-[:COVARIES_GcG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 128191287, "adjusted_p_value": 1.0, "path_count": 14, "dwpc": 4.585979496774474, "p_value": 0.04822840626688617, "reversed": false, "metapath_abbreviation": "CbG<rGdD", "metapath_name": "Compound–binds–Gene←regulates←Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0809927, "metapath_path_count_mean": 0.456999, "metapath_path_count_max": 91, "metapath_dwpc_raw_mean": 3.22661e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbG<rGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 21549149, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5200, "dgp_n_nonzero_dwpcs": 5165, "dgp_nonzero_mean": 3.2983814490263295, "dgp_nonzero_sd": 0.7243648371072513, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)<-[:REGULATES_GrG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 333993, "adjusted_p_value": 1.0, "path_count": 25, "dwpc": 4.05177679704909, "p_value": 0.04904336728138025, "reversed": false, "metapath_abbreviation": "CuGiGdD", "metapath_name": "Compound–upregulates–Gene–interacts–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0794924, "metapath_path_count_mean": 1.44274, "metapath_path_count_max": 315, "metapath_dwpc_raw_mean": 6.63879e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGiGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 24429213, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 140400, "dgp_n_nonzero_dwpcs": 131603, "dgp_nonzero_mean": 2.415469444970876, "dgp_nonzero_sd": 0.9097945399183445, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:INTERACTS_GiG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 97958430, "adjusted_p_value": 1.0, "path_count": 3, "dwpc": 4.934129306471353, "p_value": 0.056586229771279854, "reversed": false, "metapath_abbreviation": "CtDdGuD", "metapath_name": "Compound–treats–Disease–downregulates–Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.028566900000000003, "metapath_path_count_mean": 0.143733, "metapath_path_count_max": 70, "metapath_dwpc_raw_mean": 8.00549e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDdGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 23791113, "dgp_source_degree": 3, "dgp_target_degree": 250, "dgp_n_dwpcs": 102600, "dgp_n_nonzero_dwpcs": 82840, "dgp_nonzero_mean": 3.708172897358525, "dgp_nonzero_sd": 0.7911141310816485, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:DOWNREGULATES_DdG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 51600505, "adjusted_p_value": 1.0, "path_count": 7, "dwpc": 3.3844578774229146, "p_value": 0.05921053603971112, "reversed": false, "metapath_abbreviation": "CtDpSpD", "metapath_name": "Compound–treats–Disease–presents–Symptom–presents–Disease", "metapath_length": 3, "metapath_path_count_density": 0.181701, "metapath_path_count_mean": 1.43773, "metapath_path_count_max": 297, "metapath_dwpc_raw_mean": 0.000537409, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDpSpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Symptom", "presents", "both" ], [ "Symptom", "Disease", "presents", "both" ] ], "dgp_id": 23806197, "dgp_source_degree": 3, "dgp_target_degree": 34, "dgp_n_dwpcs": 15200, "dgp_n_nonzero_dwpcs": 15197, "dgp_nonzero_mean": 2.508896042956027, "dgp_nonzero_sd": 0.5295295813881706, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:PRESENTS_DpS]-(n2)-[:PRESENTS_DpS]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:PRESENTS_DpS]-()),\nsize(()-[:PRESENTS_DpS]-(n2)),\nsize((n2)-[:PRESENTS_DpS]-()),\nsize(()-[:PRESENTS_DpS]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 50670435, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 2.3928704143429207, "p_value": 0.061041853515744426, "reversed": false, "metapath_abbreviation": "CuGdDrD", "metapath_name": "Compound–upregulates–Gene–downregulates–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.104146, "metapath_path_count_mean": 0.431654, "metapath_path_count_max": 82, "metapath_dwpc_raw_mean": 0.000103826, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGdDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "downregulates", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 24357165, "dgp_source_degree": 8, "dgp_target_degree": 3, "dgp_n_dwpcs": 75600, "dgp_n_nonzero_dwpcs": 6398, "dgp_nonzero_mean": 2.8647348775578405, "dgp_nonzero_sd": 0.742271377546388, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:DOWNREGULATES_DdG]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 168738058, "adjusted_p_value": 1.0, "path_count": 28, "dwpc": 3.1851014648233953, "p_value": 0.06353826772564779, "reversed": false, "metapath_abbreviation": "CuGuCtD", "metapath_name": "Compound–upregulates–Gene–upregulates–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.148356, "metapath_path_count_mean": 2.92613, "metapath_path_count_max": 1209, "metapath_dwpc_raw_mean": 0.000310118, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGuCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Compound", "upregulates", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 24842591, "dgp_source_degree": 8, "dgp_target_degree": 29, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5397, "dgp_nonzero_mean": 2.202899800153523, "dgp_nonzero_sd": 0.6021415430197289, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:UPREGULATES_CuG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 106228526, "adjusted_p_value": 1.0, "path_count": 27, "dwpc": 3.5570771307610203, "p_value": 0.06723033943632191, "reversed": false, "metapath_abbreviation": "CuGr>GdD", "metapath_name": "Compound–upregulates–Gene→regulates→Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.100356, "metapath_path_count_mean": 3.3594199999999996, "metapath_path_count_max": 516, "metapath_dwpc_raw_mean": 7.62999e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGr>GdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 24659325, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 140400, "dgp_n_nonzero_dwpcs": 139901, "dgp_nonzero_mean": 2.4296323563709636, "dgp_nonzero_sd": 0.7058168339413708, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:REGULATES_GrG]->(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 132731078, "adjusted_p_value": 1.0, "path_count": 144, "dwpc": 2.7594640937243136, "p_value": 0.06901256130115166, "reversed": false, "metapath_abbreviation": "CuG<rGaD", "metapath_name": "Compound–upregulates–Gene←regulates←Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.362697, "metapath_path_count_mean": 22.6443, "metapath_path_count_max": 2888, "metapath_dwpc_raw_mean": 0.000240837, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuG<rGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 23879978, "dgp_source_degree": 8, "dgp_target_degree": 540, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5400, "dgp_nonzero_mean": 2.268755273327611, "dgp_nonzero_sd": 0.3195654025078137, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)<-[:REGULATES_GrG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 51714672, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 3.654587805413775, "p_value": 0.07636997413702667, "reversed": false, "metapath_abbreviation": "CdGbCtD", "metapath_name": "Compound–downregulates–Gene–binds–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.025434599999999998, "metapath_path_count_mean": 0.08076230000000001, "metapath_path_count_max": 42, "metapath_dwpc_raw_mean": 3.85005e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGbCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Compound", "binds", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 22525597, "dgp_source_degree": 22, "dgp_target_degree": 29, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 288, "dgp_nonzero_mean": 3.2494598868343867, "dgp_nonzero_sd": 1.0707393905520752, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:BINDS_CbG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 126627871, "adjusted_p_value": 1.0, "path_count": 25, "dwpc": 2.6019552338863337, "p_value": 0.07665678971694347, "reversed": false, "metapath_abbreviation": "CdGdAlD", "metapath_name": "Compound–downregulates–Gene–downregulates–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.319762, "metapath_path_count_mean": 7.40641, "metapath_path_count_max": 945, "metapath_dwpc_raw_mean": 9.026700000000001e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGdAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 22720175, "dgp_source_degree": 22, "dgp_target_degree": 39, "dgp_n_dwpcs": 4800, "dgp_n_nonzero_dwpcs": 4732, "dgp_nonzero_mean": 1.7575179531740346, "dgp_nonzero_sd": 0.5599656729038113, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 20791062, "adjusted_p_value": 1.0, "path_count": 85, "dwpc": 3.447797409851131, "p_value": 0.0856786500783511, "reversed": false, "metapath_abbreviation": "CdGr>GuD", "metapath_name": "Compound–downregulates–Gene→regulates→Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.115462, "metapath_path_count_mean": 5.24488, "metapath_path_count_max": 1107, "metapath_dwpc_raw_mean": 9.533129999999999e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGr>GuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 23203499, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 32400, "dgp_n_nonzero_dwpcs": 32400, "dgp_nonzero_mean": 2.885580043810075, "dgp_nonzero_sd": 0.40033663152163457, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:REGULATES_GrG]->(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 4269517, "adjusted_p_value": 1.0, "path_count": 134, "dwpc": 3.1776015317859327, "p_value": 0.08635278747636652, "reversed": false, "metapath_abbreviation": "CdGr>GaD", "metapath_name": "Compound–downregulates–Gene→regulates→Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.29232800000000003, "metapath_path_count_mean": 9.07357, "metapath_path_count_max": 1393, "metapath_dwpc_raw_mean": 0.00011774700000000001, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGr>GaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 23062010, "dgp_source_degree": 22, "dgp_target_degree": 540, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1200, "dgp_nonzero_mean": 2.7050547748859497, "dgp_nonzero_sd": 0.3384201984272396, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:REGULATES_GrG]->(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 98054384, "adjusted_p_value": 1.0, "path_count": 4, "dwpc": 3.2308571218969195, "p_value": 0.09191255105717275, "reversed": false, "metapath_abbreviation": "CuGuCpD", "metapath_name": "Compound–upregulates–Gene–upregulates–Compound–palliates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0656135, "metapath_path_count_mean": 0.5202140000000001, "metapath_path_count_max": 303, "metapath_dwpc_raw_mean": 0.000135634, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGuCpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Compound", "upregulates", "both" ], [ "Compound", "Disease", "palliates", "both" ] ], "dgp_id": 24840575, "dgp_source_degree": 8, "dgp_target_degree": 14, "dgp_n_dwpcs": 10800, "dgp_n_nonzero_dwpcs": 7843, "dgp_nonzero_mean": 2.176696644105656, "dgp_nonzero_sd": 0.9136133445678573, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:UPREGULATES_CuG]-(n2)-[:PALLIATES_CpD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n2)),\nsize((n2)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 142515870, "adjusted_p_value": 1.0, "path_count": 18, "dwpc": 3.6336547322859323, "p_value": 0.09329130704265634, "reversed": false, "metapath_abbreviation": "CdGuCtD", "metapath_name": "Compound–downregulates–Gene–upregulates–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0889599, "metapath_path_count_mean": 0.837563, "metapath_path_count_max": 321, "metapath_dwpc_raw_mean": 0.000136586, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGuCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Compound", "upregulates", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 23270257, "dgp_source_degree": 22, "dgp_target_degree": 29, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1183, "dgp_nonzero_mean": 2.5112520337865583, "dgp_nonzero_sd": 0.8188444755623576, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_CuG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 98339282, "adjusted_p_value": 1.0, "path_count": 36, "dwpc": 4.148527682259019, "p_value": 0.09651902561245157, "reversed": false, "metapath_abbreviation": "CbGr>GdD", "metapath_name": "Compound–binds–Gene→regulates→Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.138244, "metapath_path_count_mean": 0.758997, "metapath_path_count_max": 256, "metapath_dwpc_raw_mean": 5.0237799999999995e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGr>GdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 21976631, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5200, "dgp_n_nonzero_dwpcs": 5200, "dgp_nonzero_mean": 3.4973056056969827, "dgp_nonzero_sd": 0.4895431979920396, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:REGULATES_GrG]->(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 106995726, "adjusted_p_value": 1.0, "path_count": 2, "dwpc": 2.2208486272592425, "p_value": 0.09746749157070841, "reversed": false, "metapath_abbreviation": "CdGuDrD", "metapath_name": "Compound–downregulates–Gene–upregulates–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.125959, "metapath_path_count_mean": 0.625508, "metapath_path_count_max": 79, "metapath_dwpc_raw_mean": 0.000116155, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGuDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "upregulates", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 23285651, "dgp_source_degree": 22, "dgp_target_degree": 3, "dgp_n_dwpcs": 16800, "dgp_n_nonzero_dwpcs": 4208, "dgp_nonzero_mean": 2.093911119617837, "dgp_nonzero_sd": 0.8484643387829551, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_DuG]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 141417483, "adjusted_p_value": 1.0, "path_count": 3, "dwpc": 3.252331054134336, "p_value": 0.0975771845917332, "reversed": false, "metapath_abbreviation": "CuGdCtD", "metapath_name": "Compound–upregulates–Gene–downregulates–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0854936, "metapath_path_count_mean": 1.00547, "metapath_path_count_max": 387, "metapath_dwpc_raw_mean": 0.000139589, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGdCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Compound", "downregulates", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 24341101, "dgp_source_degree": 8, "dgp_target_degree": 29, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 4723, "dgp_nonzero_mean": 2.066805145380311, "dgp_nonzero_sd": 0.9462586620512786, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:DOWNREGULATES_CdG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 27252246, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 4.069441046819882, "p_value": 0.1007583684652619, "reversed": false, "metapath_abbreviation": "CuGuD", "metapath_name": "Compound–upregulates–Gene–upregulates–Disease", "metapath_length": 2, "metapath_path_count_density": 0.0262717, "metapath_path_count_mean": 0.06692569999999999, "metapath_path_count_max": 22, "metapath_dwpc_raw_mean": 0.000135124, "metapath_n_similar": 13, "metapath_p_threshold": 1.0, "metapath_id": "CuGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 4124216, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 145800, "dgp_n_nonzero_dwpcs": 26669, "dgp_nonzero_mean": 4.183802261684422, "dgp_nonzero_sd": 0.6438989025236784, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:UPREGULATES_DuG]-(n2:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n2.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n2))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 112967029, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 2.169914922408736, "p_value": 0.109664276566758, "reversed": false, "metapath_abbreviation": "CbGaDrD", "metapath_name": "Compound–binds–Gene–associates–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.410128, "metapath_path_count_mean": 1.46755, "metapath_path_count_max": 59, "metapath_dwpc_raw_mean": 0.00044245199999999997, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGaDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Disease", "associates", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 21620954, "dgp_source_degree": 56, "dgp_target_degree": 3, "dgp_n_dwpcs": 2800, "dgp_n_nonzero_dwpcs": 2508, "dgp_nonzero_mean": 1.2949397042821509, "dgp_nonzero_sd": 0.7478259649977236, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:ASSOCIATES_DaG]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 128214864, "adjusted_p_value": 1.0, "path_count": 35, "dwpc": 2.3764149601937445, "p_value": 0.11940455530163151, "reversed": false, "metapath_abbreviation": "CdGuAlD", "metapath_name": "Compound–downregulates–Gene–upregulates–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.317575, "metapath_path_count_mean": 7.33656, "metapath_path_count_max": 690, "metapath_dwpc_raw_mean": 0.00010222600000000001, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGuAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 23216885, "dgp_source_degree": 22, "dgp_target_degree": 39, "dgp_n_dwpcs": 4800, "dgp_n_nonzero_dwpcs": 4738, "dgp_nonzero_mean": 1.7284541892784524, "dgp_nonzero_sd": 0.5441426925484705, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 47594528, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 1.6357682430587739, "p_value": 0.11982495003093771, "reversed": false, "metapath_abbreviation": "CuGaDrD", "metapath_name": "Compound–upregulates–Gene–associates–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.178484, "metapath_path_count_mean": 1.17964, "metapath_path_count_max": 112, "metapath_dwpc_raw_mean": 0.00018600799999999998, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGaDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "associates", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 24038129, "dgp_source_degree": 8, "dgp_target_degree": 3, "dgp_n_dwpcs": 75600, "dgp_n_nonzero_dwpcs": 17893, "dgp_nonzero_mean": 1.78641790772731, "dgp_nonzero_sd": 0.8656172759174137, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:ASSOCIATES_DaG]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 64864711, "adjusted_p_value": 1.0, "path_count": 230, "dwpc": 2.279945188763921, "p_value": 0.1319402342911689, "reversed": false, "metapath_abbreviation": "CdGeAlD", "metapath_name": "Compound–downregulates–Gene–expresses–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.44580600000000004, "metapath_path_count_mean": 51.614, "metapath_path_count_max": 4247, "metapath_dwpc_raw_mean": 0.000181137, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGeAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 22803785, "dgp_source_degree": 22, "dgp_target_degree": 39, "dgp_n_dwpcs": 4800, "dgp_n_nonzero_dwpcs": 4800, "dgp_nonzero_mean": 1.8900053433921868, "dgp_nonzero_sd": 0.3461661191449261, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 73879, "adjusted_p_value": 1.0, "path_count": 14, "dwpc": 2.01776356103161, "p_value": 0.13670783137847875, "reversed": false, "metapath_abbreviation": "CuGuAlD", "metapath_name": "Compound–upregulates–Gene–upregulates–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.30537, "metapath_path_count_mean": 7.793880000000001, "metapath_path_count_max": 777, "metapath_dwpc_raw_mean": 0.00011132, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGuAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 24786427, "dgp_source_degree": 8, "dgp_target_degree": 39, "dgp_n_dwpcs": 21600, "dgp_n_nonzero_dwpcs": 21130, "dgp_nonzero_mean": 1.400384079226118, "dgp_nonzero_sd": 0.5740793704418491, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 112227249, "adjusted_p_value": 1.0, "path_count": 10, "dwpc": 3.2187553611741118, "p_value": 0.1560923088085931, "reversed": false, "metapath_abbreviation": "CdGdCpD", "metapath_name": "Compound–downregulates–Gene–downregulates–Compound–palliates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0834948, "metapath_path_count_mean": 0.7409979999999999, "metapath_path_count_max": 274, "metapath_dwpc_raw_mean": 0.000159982, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGdCpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Compound", "downregulates", "both" ], [ "Compound", "Disease", "palliates", "both" ] ], "dgp_id": 22771559, "dgp_source_degree": 22, "dgp_target_degree": 14, "dgp_n_dwpcs": 2400, "dgp_n_nonzero_dwpcs": 2306, "dgp_nonzero_mean": 2.4727680216941046, "dgp_nonzero_sd": 0.7728072706112241, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:DOWNREGULATES_CdG]-(n2)-[:PALLIATES_CpD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n2)),\nsize((n2)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 153582364, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 3.3841179009927735, "p_value": 0.15825413537409552, "reversed": false, "metapath_abbreviation": "CdGuCpD", "metapath_name": "Compound–downregulates–Gene–upregulates–Compound–palliates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.029832, "metapath_path_count_mean": 0.163171, "metapath_path_count_max": 100, "metapath_dwpc_raw_mean": 4.82592e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGuCpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Compound", "upregulates", "both" ], [ "Compound", "Disease", "palliates", "both" ] ], "dgp_id": 23268269, "dgp_source_degree": 22, "dgp_target_degree": 14, "dgp_n_dwpcs": 2400, "dgp_n_nonzero_dwpcs": 1201, "dgp_nonzero_mean": 2.991566023798353, "dgp_nonzero_sd": 1.035278794448917, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_CuG]-(n2)-[:PALLIATES_CpD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n2)),\nsize((n2)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 50983018, "adjusted_p_value": 1.0, "path_count": 25, "dwpc": 3.1789727051704726, "p_value": 0.16187615509879097, "reversed": false, "metapath_abbreviation": "CuGiGuD", "metapath_name": "Compound–upregulates–Gene–interacts–Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0832832, "metapath_path_count_mean": 1.66419, "metapath_path_count_max": 362, "metapath_dwpc_raw_mean": 7.02848e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGiGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 24551695, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 145800, "dgp_n_nonzero_dwpcs": 137268, "dgp_nonzero_mean": 2.368401382693425, "dgp_nonzero_sd": 0.8894867737327051, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:INTERACTS_GiG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 125134131, "adjusted_p_value": 1.0, "path_count": 13, "dwpc": 3.6743826941725644, "p_value": 0.18654460466613315, "reversed": false, "metapath_abbreviation": "CbGiGuD", "metapath_name": "Compound–binds–Gene–interacts–Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.12237999999999999, "metapath_path_count_mean": 0.633955, "metapath_path_count_max": 256, "metapath_dwpc_raw_mean": 7.86445e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGiGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 21913646, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 5400, "dgp_nonzero_mean": 3.2302504766562627, "dgp_nonzero_sd": 0.506914377182348, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:INTERACTS_GiG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 38559959, "adjusted_p_value": 1.0, "path_count": 30, "dwpc": 2.8572059585754754, "p_value": 0.18927724306716082, "reversed": false, "metapath_abbreviation": "CuG<rGdD", "metapath_name": "Compound–upregulates–Gene←regulates←Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.125861, "metapath_path_count_mean": 7.313839999999999, "metapath_path_count_max": 869, "metapath_dwpc_raw_mean": 0.000126069, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuG<rGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 23906385, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 140400, "dgp_n_nonzero_dwpcs": 140393, "dgp_nonzero_mean": 2.4469292425792974, "dgp_nonzero_sd": 0.4769438560142937, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)<-[:REGULATES_GrG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 111348878, "adjusted_p_value": 1.0, "path_count": 17, "dwpc": 1.8691182320613013, "p_value": 0.19546391364633822, "reversed": false, "metapath_abbreviation": "CuGdAlD", "metapath_name": "Compound–upregulates–Gene–downregulates–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.307628, "metapath_path_count_mean": 7.848910000000001, "metapath_path_count_max": 1010, "metapath_dwpc_raw_mean": 0.000102115, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGdAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 24284937, "dgp_source_degree": 8, "dgp_target_degree": 39, "dgp_n_dwpcs": 21600, "dgp_n_nonzero_dwpcs": 21058, "dgp_nonzero_mean": 1.4147376069386606, "dgp_nonzero_sd": 0.5865791641579736, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 110948989, "adjusted_p_value": 1.0, "path_count": 19, "dwpc": 2.512300944054508, "p_value": 0.19718206577757708, "reversed": false, "metapath_abbreviation": "CbGuAlD", "metapath_name": "Compound–binds–Gene–upregulates–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.566498, "metapath_path_count_mean": 3.22439, "metapath_path_count_max": 358, "metapath_dwpc_raw_mean": 0.00012054299999999999, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGuAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 22051850, "dgp_source_degree": 56, "dgp_target_degree": 39, "dgp_n_dwpcs": 800, "dgp_n_nonzero_dwpcs": 791, "dgp_nonzero_mean": 2.0818765150733842, "dgp_nonzero_sd": 0.5315761322514894, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 128487525, "adjusted_p_value": 1.0, "path_count": 13, "dwpc": 3.617353906528588, "p_value": 0.21161944380965836, "reversed": false, "metapath_abbreviation": "CbGiGdD", "metapath_name": "Compound–binds–Gene–interacts–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.12430899999999999, "metapath_path_count_mean": 0.605571, "metapath_path_count_max": 221, "metapath_dwpc_raw_mean": 8.088e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGiGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 21847193, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5200, "dgp_n_nonzero_dwpcs": 5200, "dgp_nonzero_mean": 3.2209791541614377, "dgp_nonzero_sd": 0.5092010318492808, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:INTERACTS_GiG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 39335778, "adjusted_p_value": 1.0, "path_count": 5, "dwpc": 3.88546192742891, "p_value": 0.2138298621659708, "reversed": false, "metapath_abbreviation": "CtDuGaD", "metapath_name": "Compound–treats–Disease–upregulates–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.07452589999999999, "metapath_path_count_mean": 0.407038, "metapath_path_count_max": 153, "metapath_dwpc_raw_mean": 0.000145009, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDuGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 23825176, "dgp_source_degree": 3, "dgp_target_degree": 540, "dgp_n_dwpcs": 3800, "dgp_n_nonzero_dwpcs": 3316, "dgp_nonzero_mean": 3.345148180814123, "dgp_nonzero_sd": 0.8465984699717739, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:UPREGULATES_DuG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 92028899, "adjusted_p_value": 1.0, "path_count": 65, "dwpc": 1.8071704062278153, "p_value": 0.2213157519800908, "reversed": false, "metapath_abbreviation": "CuGeAlD", "metapath_name": "Compound–upregulates–Gene–expresses–Anatomy–localizes–Disease", "metapath_length": 3, "metapath_path_count_density": 0.42071899999999995, "metapath_path_count_mean": 46.7934, "metapath_path_count_max": 4139, "metapath_dwpc_raw_mean": 0.000187564, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuGeAlD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Disease", "localizes", "both" ] ], "dgp_id": 24372263, "dgp_source_degree": 8, "dgp_target_degree": 39, "dgp_n_dwpcs": 21600, "dgp_n_nonzero_dwpcs": 21600, "dgp_nonzero_mean": 1.523426559007508, "dgp_nonzero_sd": 0.39207925987959674, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:LOCALIZES_DlA]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:LOCALIZES_DlA]-()),\nsize(()-[:LOCALIZES_DlA]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 97068679, "adjusted_p_value": 1.0, "path_count": 37, "dwpc": 2.758675641807037, "p_value": 0.24799313274981613, "reversed": false, "metapath_abbreviation": "CuG<rGuD", "metapath_name": "Compound–upregulates–Gene←regulates←Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.125174, "metapath_path_count_mean": 8.39182, "metapath_path_count_max": 1157, "metapath_dwpc_raw_mean": 0.000129796, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CuG<rGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 24028867, "dgp_source_degree": 8, "dgp_target_degree": 250, "dgp_n_dwpcs": 145800, "dgp_n_nonzero_dwpcs": 145793, "dgp_nonzero_mean": 2.466108205679185, "dgp_nonzero_sd": 0.45450215653664644, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)<-[:REGULATES_GrG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 140162570, "adjusted_p_value": 1.0, "path_count": 98, "dwpc": 3.074182176638355, "p_value": 0.2541460447587177, "reversed": false, "metapath_abbreviation": "CdG<rGdD", "metapath_name": "Compound–downregulates–Gene←regulates←Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.134604, "metapath_path_count_mean": 12.6584, "metapath_path_count_max": 1435, "metapath_dwpc_raw_mean": 0.00014880700000000001, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdG<rGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 22349129, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 31200, "dgp_n_nonzero_dwpcs": 31200, "dgp_nonzero_mean": 2.9136595729648556, "dgp_nonzero_sd": 0.2490247971331263, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)<-[:REGULATES_GrG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 51009514, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 3.4137832337946725, "p_value": 0.25617549219911806, "reversed": false, "metapath_abbreviation": "CbGcGdD", "metapath_name": "Compound–binds–Gene–covaries–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.055445299999999996, "metapath_path_count_mean": 0.09039900000000001, "metapath_path_count_max": 14, "metapath_dwpc_raw_mean": 3.7215599999999997e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGcGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "covaries", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 21687971, "dgp_source_degree": 56, "dgp_target_degree": 250, "dgp_n_dwpcs": 5200, "dgp_n_nonzero_dwpcs": 4835, "dgp_nonzero_mean": 2.863715802712182, "dgp_nonzero_sd": 1.1049867982806023, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:COVARIES_GcG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:COVARIES_GcG]-()),\nsize(()-[:COVARIES_GcG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 106965472, "adjusted_p_value": 1.0, "path_count": 138, "dwpc": 3.0739067397545172, "p_value": 0.26221771349077744, "reversed": false, "metapath_abbreviation": "CdG<rGuD", "metapath_name": "Compound–downregulates–Gene←regulates←Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.134298, "metapath_path_count_mean": 14.4964, "metapath_path_count_max": 1760, "metapath_dwpc_raw_mean": 0.00015340700000000002, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdG<rGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 22466399, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 32400, "dgp_n_nonzero_dwpcs": 32400, "dgp_nonzero_mean": 2.923714133934038, "dgp_nonzero_sd": 0.24252700384158532, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)<-[:REGULATES_GrG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 97374812, "adjusted_p_value": 1.0, "path_count": 4, "dwpc": 3.669901367808035, "p_value": 0.2823030189749168, "reversed": false, "metapath_abbreviation": "CtDdGaD", "metapath_name": "Compound–treats–Disease–downregulates–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0677816, "metapath_path_count_mean": 0.312585, "metapath_path_count_max": 105, "metapath_dwpc_raw_mean": 0.000126174, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDdGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 23760232, "dgp_source_degree": 3, "dgp_target_degree": 540, "dgp_n_dwpcs": 3800, "dgp_n_nonzero_dwpcs": 3281, "dgp_nonzero_mean": 3.338927143537274, "dgp_nonzero_sd": 0.8907299516824313, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:DOWNREGULATES_DdG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 118862164, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 1.0629602031696488, "p_value": 0.30267238986391565, "reversed": false, "metapath_abbreviation": "CdGaDrD", "metapath_name": "Compound–downregulates–Gene–associates–Disease–resembles–Disease", "metapath_length": 3, "metapath_path_count_density": 0.15983599999999998, "metapath_path_count_mean": 1.05379, "metapath_path_count_max": 100, "metapath_dwpc_raw_mean": 0.00015224, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGaDrD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "associates", "both" ], [ "Disease", "Disease", "resembles", "both" ] ], "dgp_id": 22475381, "dgp_source_degree": 22, "dgp_target_degree": 3, "dgp_n_dwpcs": 16800, "dgp_n_nonzero_dwpcs": 6475, "dgp_nonzero_mean": 1.7436141844499888, "dgp_nonzero_sd": 0.833774955434589, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:ASSOCIATES_DaG]-(n2)-[:RESEMBLES_DrD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2)),\nsize((n2)-[:RESEMBLES_DrD]-()),\nsize(()-[:RESEMBLES_DrD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 32420519, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 2.324917695548423, "p_value": 0.3045405147015436, "reversed": false, "metapath_abbreviation": "CuGaD", "metapath_name": "Compound–upregulates–Gene–associates–Disease", "metapath_length": 2, "metapath_path_count_density": 0.0649691, "metapath_path_count_mean": 0.15582000000000001, "metapath_path_count_max": 33, "metapath_dwpc_raw_mean": 0.000207821, "metapath_n_similar": 13, "metapath_p_threshold": 1.0, "metapath_id": "CuGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 3975327, "dgp_source_degree": 8, "dgp_target_degree": 540, "dgp_n_dwpcs": 5400, "dgp_n_nonzero_dwpcs": 2464, "dgp_nonzero_mean": 2.7664725888771544, "dgp_nonzero_sd": 0.8673842884232502, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:ASSOCIATES_DaG]-(n2:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n2.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 39284847, "adjusted_p_value": 1.0, "path_count": 2, "dwpc": 3.222020521239936, "p_value": 0.31039008868724677, "reversed": false, "metapath_abbreviation": "CbGuCtD", "metapath_name": "Compound–binds–Gene–upregulates–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0495899, "metapath_path_count_mean": 0.11945499999999999, "metapath_path_count_max": 78, "metapath_dwpc_raw_mean": 6.17764e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGuCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Compound", "upregulates", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 22081150, "dgp_source_degree": 56, "dgp_target_degree": 29, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 186, "dgp_nonzero_mean": 2.870577430113162, "dgp_nonzero_sd": 1.1298787882697428, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:UPREGULATES_CuG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 167156566, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 3.12813835938026, "p_value": 0.32107133973873814, "reversed": false, "metapath_abbreviation": "CdGuD", "metapath_name": "Compound–downregulates–Gene–upregulates–Disease", "metapath_length": 2, "metapath_path_count_density": 0.028811400000000004, "metapath_path_count_mean": 0.0840122, "metapath_path_count_max": 52, "metapath_dwpc_raw_mean": 0.000135751, "metapath_n_similar": 13, "metapath_p_threshold": 1.0, "metapath_id": "CdGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 3914194, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 32400, "dgp_n_nonzero_dwpcs": 15572, "dgp_nonzero_mean": 3.5167398600218798, "dgp_nonzero_sd": 0.7914823800758259, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_DuG]-(n2:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n2.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n2))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 47634798, "adjusted_p_value": 1.0, "path_count": 103, "dwpc": 2.917945723916972, "p_value": 0.39090323334525856, "reversed": false, "metapath_abbreviation": "CdGiGaD", "metapath_name": "Compound–downregulates–Gene–interacts–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.253739, "metapath_path_count_mean": 6.4632, "metapath_path_count_max": 1289, "metapath_dwpc_raw_mean": 0.00012271, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGiGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 22833590, "dgp_source_degree": 22, "dgp_target_degree": 540, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1200, "dgp_nonzero_mean": 2.82635194827898, "dgp_nonzero_sd": 0.39273048786427595, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:INTERACTS_GiG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 42389097, "adjusted_p_value": 1.0, "path_count": 31, "dwpc": 2.965792779701133, "p_value": 0.4021955172807161, "reversed": false, "metapath_abbreviation": "CdGr>GdD", "metapath_name": "Compound–downregulates–Gene→regulates→Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.11066, "metapath_path_count_mean": 3.81032, "metapath_path_count_max": 532, "metapath_dwpc_raw_mean": 8.182380000000001e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGr>GdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "forward" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 23086229, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 31200, "dgp_n_nonzero_dwpcs": 31200, "dgp_nonzero_mean": 2.878837938038893, "dgp_nonzero_sd": 0.4365387333757429, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:REGULATES_GrG]->(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 44857409, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 2.626693938487515, "p_value": 0.4520702881561719, "reversed": false, "metapath_abbreviation": "CbGcGaD", "metapath_name": "Compound–binds–Gene–covaries–Gene–associates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.11458299999999999, "metapath_path_count_mean": 0.16275699999999999, "metapath_path_count_max": 19, "metapath_dwpc_raw_mean": 5.6889300000000004e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGcGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Gene", "covaries", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 21669569, "dgp_source_degree": 56, "dgp_target_degree": 540, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 199, "dgp_nonzero_mean": 2.6332139410418485, "dgp_nonzero_sd": 0.9569058517840653, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:COVARIES_GcG]-(n2)-[:ASSOCIATES_DaG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:COVARIES_GcG]-()),\nsize(()-[:COVARIES_GcG]-(n2)),\nsize((n2)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 50633205, "adjusted_p_value": 1.0, "path_count": 28, "dwpc": 2.9747754916204725, "p_value": 0.5011721774180102, "reversed": false, "metapath_abbreviation": "CdGiGdD", "metapath_name": "Compound–downregulates–Gene–interacts–Gene–downregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0915325, "metapath_path_count_mean": 1.99215, "metapath_path_count_max": 504, "metapath_dwpc_raw_mean": 6.66671e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGiGdD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "downregulates", "both" ] ], "dgp_id": 22865909, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 31200, "dgp_n_nonzero_dwpcs": 31197, "dgp_nonzero_mean": 3.0148882152507985, "dgp_nonzero_sd": 0.5894240282429568, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:INTERACTS_GiG]-(n2)-[:DOWNREGULATES_DdG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:DOWNREGULATES_DdG]-()),\nsize(()-[:DOWNREGULATES_DdG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 142009408, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 3.420518101231946, "p_value": 0.5096620686295852, "reversed": false, "metapath_abbreviation": "CtDuGuD", "metapath_name": "Compound–treats–Disease–upregulates–Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.033049, "metapath_path_count_mean": 0.291745, "metapath_path_count_max": 163, "metapath_dwpc_raw_mean": 7.55878e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CtDuGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Disease", "treats", "both" ], [ "Disease", "Gene", "upregulates", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 23856057, "dgp_source_degree": 3, "dgp_target_degree": 250, "dgp_n_dwpcs": 102600, "dgp_n_nonzero_dwpcs": 88964, "dgp_nonzero_mean": 3.6512621395041713, "dgp_nonzero_sd": 0.7986845957034281, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:TREATS_CtD]-(n1)-[:UPREGULATES_DuG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n1)),\nsize((n1)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 65071150, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 2.808719698969872, "p_value": 0.5194154101338885, "reversed": false, "metapath_abbreviation": "CbGaD", "metapath_name": "Compound–binds–Gene–associates–Disease", "metapath_length": 2, "metapath_path_count_density": 0.129327, "metapath_path_count_mean": 0.22018200000000002, "metapath_path_count_max": 17, "metapath_dwpc_raw_mean": 0.000492032, "metapath_n_similar": 13, "metapath_p_threshold": 1.0, "metapath_id": "CbGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 3546793, "dgp_source_degree": 56, "dgp_target_degree": 540, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 200, "dgp_nonzero_mean": 2.8799611669781537, "dgp_nonzero_sd": 0.6043977102968453, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:ASSOCIATES_DaG]-(n2:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n2.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 68245162, "adjusted_p_value": 1.0, "path_count": 627, "dwpc": 2.642584893576034, "p_value": 0.5233118308199263, "reversed": false, "metapath_abbreviation": "CcSEcCpD", "metapath_name": "Compound–causes–Side Effect–causes–Compound–palliates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.24537199999999998, "metapath_path_count_mean": 85.6848, "metapath_path_count_max": 5401, "metapath_dwpc_raw_mean": 0.000400305, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CcSEcCpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Side Effect", "causes", "both" ], [ "Side Effect", "Compound", "causes", "both" ], [ "Compound", "Disease", "palliates", "both" ] ], "dgp_id": 22258796, "dgp_source_degree": 139, "dgp_target_degree": 14, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 1200, "dgp_nonzero_mean": 2.654568073101843, "dgp_nonzero_sd": 0.1541842558927804, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:CAUSES_CcSE]-(n1)-[:CAUSES_CcSE]-(n2)-[:PALLIATES_CpD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:CAUSES_CcSE]-()),\nsize(()-[:CAUSES_CcSE]-(n1)),\nsize((n1)-[:CAUSES_CcSE]-()),\nsize(()-[:CAUSES_CcSE]-(n2)),\nsize((n2)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 97095112, "adjusted_p_value": 1.0, "path_count": 1, "dwpc": 2.107733492156172, "p_value": 0.5498069779901729, "reversed": false, "metapath_abbreviation": "CdGaD", "metapath_name": "Compound–downregulates–Gene–associates–Disease", "metapath_length": 2, "metapath_path_count_density": 0.0543965, "metapath_path_count_mean": 0.129247, "metapath_path_count_max": 62, "metapath_dwpc_raw_mean": 0.000168682, "metapath_n_similar": 13, "metapath_p_threshold": 1.0, "metapath_id": "CdGaD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Disease", "associates", "both" ] ], "dgp_id": 3764605, "dgp_source_degree": 22, "dgp_target_degree": 540, "dgp_n_dwpcs": 1200, "dgp_n_nonzero_dwpcs": 826, "dgp_nonzero_mean": 2.8313251950826324, "dgp_nonzero_sd": 0.847768764664304, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:ASSOCIATES_DaG]-(n2:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n2.identifier = 'DOID:1612' // breast cancer\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n2))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 48854515, "adjusted_p_value": 1.0, "path_count": 27, "dwpc": 2.8601539373754448, "p_value": 0.5681367868494877, "reversed": false, "metapath_abbreviation": "CdGiGuD", "metapath_name": "Compound–downregulates–Gene–interacts–Gene–upregulates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.0933385, "metapath_path_count_mean": 2.29914, "metapath_path_count_max": 664, "metapath_dwpc_raw_mean": 6.89717e-05, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CdGiGuD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Disease", "upregulates", "both" ] ], "dgp_id": 22983179, "dgp_source_degree": 22, "dgp_target_degree": 250, "dgp_n_dwpcs": 32400, "dgp_n_nonzero_dwpcs": 32399, "dgp_nonzero_mean": 2.9937325587204735, "dgp_nonzero_sd": 0.5747370000868853, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:INTERACTS_GiG]-(n2)-[:UPREGULATES_DuG]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n1 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:UPREGULATES_DuG]-()),\nsize(()-[:UPREGULATES_DuG]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 108601103, "adjusted_p_value": 1.0, "path_count": 1367, "dwpc": 2.2363318477976017, "p_value": 0.9898650141772094, "reversed": false, "metapath_abbreviation": "CcSEcCtD", "metapath_name": "Compound–causes–Side Effect–causes–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.38648000000000005, "metapath_path_count_mean": 139.04399999999998, "metapath_path_count_max": 6460, "metapath_dwpc_raw_mean": 0.0005849609999999999, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CcSEcCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Side Effect", "causes", "both" ], [ "Side Effect", "Compound", "causes", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 22266292, "dgp_source_degree": 139, "dgp_target_degree": 29, "dgp_n_dwpcs": 600, "dgp_n_nonzero_dwpcs": 600, "dgp_nonzero_mean": 2.482680921586012, "dgp_nonzero_sd": 0.10915828891309523, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:CAUSES_CcSE]-(n1)-[:CAUSES_CcSE]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:CAUSES_CcSE]-()),\nsize(()-[:CAUSES_CcSE]-(n1)),\nsize((n1)-[:CAUSES_CcSE]-()),\nsize(()-[:CAUSES_CcSE]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 68766558, "adjusted_p_value": 1.0, "path_count": 7, "dwpc": 2.1435211643467356, "p_value": 0.9995290849496753, "reversed": false, "metapath_abbreviation": "CbGbCtD", "metapath_name": "Compound–binds–Gene–binds–Compound–treats–Disease", "metapath_length": 3, "metapath_path_count_density": 0.283896, "metapath_path_count_mean": 3.38381, "metapath_path_count_max": 215, "metapath_dwpc_raw_mean": 0.000546079, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGbCtD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Compound", "binds", "both" ], [ "Compound", "Disease", "treats", "both" ] ], "dgp_id": 21649384, "dgp_source_degree": 56, "dgp_target_degree": 29, "dgp_n_dwpcs": 200, "dgp_n_nonzero_dwpcs": 200, "dgp_nonzero_mean": 3.0123063100018, "dgp_nonzero_sd": 0.2903843172307362, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:BINDS_CbG]-(n2)-[:TREATS_CtD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n2)),\nsize((n2)-[:TREATS_CtD]-()),\nsize(()-[:TREATS_CtD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" }, { "id": 100427380, "adjusted_p_value": 1.0, "path_count": 5, "dwpc": 1.4124432500181578, "p_value": 0.999999999785775, "reversed": false, "metapath_abbreviation": "CbGbCpD", "metapath_name": "Compound–binds–Gene–binds–Compound–palliates–Disease", "metapath_length": 3, "metapath_path_count_density": 0.186823, "metapath_path_count_mean": 2.5267, "metapath_path_count_max": 359, "metapath_dwpc_raw_mean": 0.00041236, "metapath_n_similar": 121, "metapath_p_threshold": 1.0, "metapath_id": "CbGbCpD", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "binds", "both" ], [ "Gene", "Compound", "binds", "both" ], [ "Compound", "Disease", "palliates", "both" ] ], "dgp_id": 21648119, "dgp_source_degree": 56, "dgp_target_degree": 14, "dgp_n_dwpcs": 400, "dgp_n_nonzero_dwpcs": 400, "dgp_nonzero_mean": 3.1124787212818323, "dgp_nonzero_sd": 0.3460175642057741, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:BINDS_CbG]-(n1)-[:BINDS_CbG]-(n2)-[:PALLIATES_CpD]-(n3:Disease)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00331' // Metformin\nAND n3.identifier = 'DOID:1612' // breast cancer\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n1)),\nsize((n1)-[:BINDS_CbG]-()),\nsize(()-[:BINDS_CbG]-(n2)),\nsize((n2)-[:PALLIATES_CpD]-()),\nsize(()-[:PALLIATES_CpD]-(n3))\n] AS degrees, path\nWITH path, reduce(pdp = 1.0, d in degrees| pdp * d ^ -0.5) AS PDP\nWITH collect({paths: path, PDPs: PDP}) AS data_maps, count(path) AS PC, sum(PDP) AS DWPC\nUNWIND data_maps AS data_map\nWITH data_map.paths AS path, data_map.PDPs AS PDP, PC, DWPC\nRETURN\n path AS neo4j_path,\n substring(reduce(s = '', node IN nodes(path)| s + '–' + node.name), 1) AS path,\n PDP,\n 100 * (PDP / DWPC) AS percent_of_DWPC\nORDER BY percent_of_DWPC DESC\nLIMIT 10" } ] }{ "source": { "id": 17054, "identifier": "DB00331", "identifier_type": "str", "name": "Metformin", "properties": { "url": "