Query Metapaths Random Nodes
Return metapaths for a random source and target node for which at least one metapath with path count information exists in the database.
GET /v1/metapaths/random-nodes/?format=api
{ "source": { "id": 17198, "identifier": "DB00188", "identifier_type": "str", "name": "Bortezomib", "properties": { "url": "http://www.drugbank.ca/drugs/DB00188", "inchi": "InChI=1S/C19H25BN4O4/c1-13(2)10-17(20(27)28)24-18(25)15(11-14-6-4-3-5-7-14)23-19(26)16-12-21-8-9-22-16/h3-9,12-13,15,17,27-28H,10-11H2,1-2H3,(H,23,26)(H,24,25)/t15-,17-/m0/s1", "source": "DrugBank", "license": "CC BY-NC 4.0", "inchikey": "InChIKey=GXJABQQUPOEUTA-RDJZCZTQSA-N" }, "metanode": "Compound" }, "target": { "id": 26218, "identifier": "7001", "identifier_type": "int", "name": "PRDX2", "properties": { "url": "http://identifiers.org/ncbigene/7001", "source": "Entrez Gene", "license": "CC0 1.0", "chromosome": "19", "description": "peroxiredoxin 2" }, "metanode": "Gene" }, "path_counts": [ { "id": 32105542, "adjusted_p_value": 4.203324208724886e-09, "path_count": 645, "dwpc": 4.202552148873038, "p_value": 1.945983429965225e-11, "reversed": false, "metapath_abbreviation": "CdGuAuG", "metapath_name": "Compound–downregulates–Gene–upregulates–Anatomy–upregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.318444, "metapath_path_count_mean": 12.1958, "metapath_path_count_max": 1280, "metapath_dwpc_raw_mean": 1.95731e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGuAuG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ] ], "dgp_id": 23222693, "dgp_source_degree": 250, "dgp_target_degree": 12, "dgp_n_dwpcs": 3009600, "dgp_n_nonzero_dwpcs": 3009600, "dgp_nonzero_mean": 3.756686613674397, "dgp_nonzero_sd": 0.06502996109014979, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:UPREGULATES_AuG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(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": 26502464, "adjusted_p_value": 1.3627960260524595e-07, "path_count": 2161, "dwpc": 4.117816660407295, "p_value": 6.309240861353979e-10, "reversed": false, "metapath_abbreviation": "CdGeAuG", "metapath_name": "Compound–downregulates–Gene–expresses–Anatomy–upregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.357483, "metapath_path_count_mean": 46.5212, "metapath_path_count_max": 4775, "metapath_dwpc_raw_mean": 1.70848e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGeAuG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ] ], "dgp_id": 22809593, "dgp_source_degree": 250, "dgp_target_degree": 12, "dgp_n_dwpcs": 3009600, "dgp_n_nonzero_dwpcs": 3009600, "dgp_nonzero_mean": 3.773694592562344, "dgp_nonzero_sd": 0.05507928115362429, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:UPREGULATES_AuG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(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": 92873732, "adjusted_p_value": 7.6927425626481e-06, "path_count": 1591, "dwpc": 3.906467026894685, "p_value": 3.561454890114861e-08, "reversed": false, "metapath_abbreviation": "CdGuAeG", "metapath_name": "Compound–downregulates–Gene–upregulates–Anatomy–expresses–Gene", "metapath_length": 3, "metapath_path_count_density": 0.37206, "metapath_path_count_mean": 37.9129, "metapath_path_count_max": 1823, "metapath_dwpc_raw_mean": 1.54582e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGuAeG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "expresses", "both" ] ], "dgp_id": 23215668, "dgp_source_degree": 250, "dgp_target_degree": 72, "dgp_n_dwpcs": 235600, "dgp_n_nonzero_dwpcs": 235600, "dgp_nonzero_mean": 3.5690201727778996, "dgp_nonzero_sd": 0.06082082475232318, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:EXPRESSES_AeG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(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": 11088604, "adjusted_p_value": 1.0578706266934357e-05, "path_count": 1563, "dwpc": 4.032305551124571, "p_value": 4.8975491976547945e-08, "reversed": false, "metapath_abbreviation": "CdGeAdG", "metapath_name": "Compound–downregulates–Gene–expresses–Anatomy–downregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.338472, "metapath_path_count_mean": 47.6728, "metapath_path_count_max": 6216, "metapath_dwpc_raw_mean": 1.59676e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGeAdG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ] ], "dgp_id": 22794462, "dgp_source_degree": 250, "dgp_target_degree": 8, "dgp_n_dwpcs": 7448000, "dgp_n_nonzero_dwpcs": 7448000, "dgp_nonzero_mean": 3.587094439403078, "dgp_nonzero_sd": 0.08040829936991722, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:DOWNREGULATES_AdG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(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": 153454842, "adjusted_p_value": 0.001236723232836155, "path_count": 1524, "dwpc": 3.8660867244563693, "p_value": 5.725570522389607e-06, "reversed": false, "metapath_abbreviation": "CdGdAeG", "metapath_name": "Compound–downregulates–Gene–downregulates–Anatomy–expresses–Gene", "metapath_length": 3, "metapath_path_count_density": 0.375019, "metapath_path_count_mean": 35.836999999999996, "metapath_path_count_max": 1791, "metapath_dwpc_raw_mean": 1.4065e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGdAeG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "expresses", "both" ] ], "dgp_id": 22718958, "dgp_source_degree": 250, "dgp_target_degree": 72, "dgp_n_dwpcs": 235600, "dgp_n_nonzero_dwpcs": 235600, "dgp_nonzero_mean": 3.5786019967840965, "dgp_nonzero_sd": 0.06392894099066317, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:EXPRESSES_AeG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(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": 51311877, "adjusted_p_value": 0.0021867417116258037, "path_count": 2208, "dwpc": 4.116434190311139, "p_value": 1.0123804220489832e-05, "reversed": false, "metapath_abbreviation": "CuGeAuG", "metapath_name": "Compound–upregulates–Gene–expresses–Anatomy–upregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.33971, "metapath_path_count_mean": 42.3612, "metapath_path_count_max": 4642, "metapath_dwpc_raw_mean": 1.7481099999999998e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CuGeAuG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ] ], "dgp_id": 24379125, "dgp_source_degree": 250, "dgp_target_degree": 12, "dgp_n_dwpcs": 2376000, "dgp_n_nonzero_dwpcs": 2376000, "dgp_nonzero_mean": 3.8888733109883784, "dgp_nonzero_sd": 0.05243898085427243, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:UPREGULATES_AuG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(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": 118749010, "adjusted_p_value": 0.0024935399359138073, "path_count": 1593, "dwpc": 4.044253369004711, "p_value": 1.154416636997133e-05, "reversed": false, "metapath_abbreviation": "CuGeAdG", "metapath_name": "Compound–upregulates–Gene–expresses–Anatomy–downregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.32149099999999997, "metapath_path_count_mean": 43.3972, "metapath_path_count_max": 6068, "metapath_dwpc_raw_mean": 1.63435e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CuGeAdG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "upregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ] ], "dgp_id": 24363322, "dgp_source_degree": 250, "dgp_target_degree": 8, "dgp_n_dwpcs": 5880000, "dgp_n_nonzero_dwpcs": 5880000, "dgp_nonzero_mean": 3.701898567054029, "dgp_nonzero_sd": 0.07864660774900031, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:UPREGULATES_CuG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:DOWNREGULATES_AdG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(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": 169003180, "adjusted_p_value": 0.005928261927506559, "path_count": 10253, "dwpc": 4.065836774785284, "p_value": 2.7445657071789626e-05, "reversed": false, "metapath_abbreviation": "CdGeAeG", "metapath_name": "Compound–downregulates–Gene–expresses–Anatomy–expresses–Gene", "metapath_length": 3, "metapath_path_count_density": 0.407763, "metapath_path_count_mean": 229.726, "metapath_path_count_max": 11995, "metapath_dwpc_raw_mean": 2.37148e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGeAeG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "expresses", "both" ] ], "dgp_id": 22802568, "dgp_source_degree": 250, "dgp_target_degree": 72, "dgp_n_dwpcs": 235600, "dgp_n_nonzero_dwpcs": 235600, "dgp_nonzero_mean": 3.8224353667407867, "dgp_nonzero_sd": 0.05918117766131624, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:EXPRESSES_AeG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(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": 52759901, "adjusted_p_value": 0.02439751977715277, "path_count": 588, "dwpc": 4.054389358274148, "p_value": 0.00011295148044978134, "reversed": false, "metapath_abbreviation": "CdGdAuG", "metapath_name": "Compound–downregulates–Gene–downregulates–Anatomy–upregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.321561, "metapath_path_count_mean": 11.6508, "metapath_path_count_max": 1041, "metapath_dwpc_raw_mean": 1.8036500000000003e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdGdAuG", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ] ], "dgp_id": 22725983, "dgp_source_degree": 250, "dgp_target_degree": 12, "dgp_n_dwpcs": 3009600, "dgp_n_nonzero_dwpcs": 3009600, "dgp_nonzero_mean": 3.749441881498194, "dgp_nonzero_sd": 0.08069840030312177, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:UPREGULATES_AuG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(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": 98707554, "adjusted_p_value": 0.026179896571649666, "path_count": 147, "dwpc": 4.207577506884614, "p_value": 0.00012120322486874846, "reversed": false, "metapath_abbreviation": "CdG<rGr>G", "metapath_name": "Compound–downregulates–Gene←regulates←Gene→regulates→Gene", "metapath_length": 3, "metapath_path_count_density": 0.140489, "metapath_path_count_mean": 14.8586, "metapath_path_count_max": 29807, "metapath_dwpc_raw_mean": 2.67287e-05, "metapath_n_similar": 216, "metapath_p_threshold": 0.00012909952034589114, "metapath_id": "CdG<rGr>G", "metapath_reversed": false, "metapath_metaedges": [ [ "Compound", "Gene", "downregulates", "both" ], [ "Gene", "Gene", "regulates", "backward" ], [ "Gene", "Gene", "regulates", "forward" ] ], "dgp_id": 22457109, "dgp_source_degree": 250, "dgp_target_degree": 8, "dgp_n_dwpcs": 2584000, "dgp_n_nonzero_dwpcs": 2584000, "dgp_nonzero_mean": 3.4989944050571293, "dgp_nonzero_sd": 0.18223363873766435, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Compound)-[:DOWNREGULATES_CdG]-(n1)<-[:REGULATES_GrG]-(n2)-[:REGULATES_GrG]->(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DB00188' // Bortezomib\nAND n3.identifier = 7001 // PRDX2\nAND n1 <> n2 AND n1 <> n3 AND n2 <> n3\nWITH\n[\nsize((n0)-[:DOWNREGULATES_CdG]-()),\nsize(()-[:DOWNREGULATES_CdG]-(n1)),\nsize((n1)<-[:REGULATES_GrG]-()),\nsize(()<-[:REGULATES_GrG]-(n2)),\nsize((n2)-[:REGULATES_GrG]->()),\nsize(()-[:REGULATES_GrG]->(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" } ], "n_metapaths": 10, "pathcount_table_random_id": 169003180, "pathcount_table_max_id": 169602979 }