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/
{ "source": { "id": 34056, "identifier": "3481", "identifier_type": "int", "name": "IGF2", "properties": { "url": "http://identifiers.org/ncbigene/3481", "source": "Entrez Gene", "license": "CC0 1.0", "chromosome": "11", "description": "insulin-like growth factor 2" }, "metanode": "Gene" }, "target": { "id": 21262, "identifier": "PC7_5330", "identifier_type": "str", "name": "Metabolism of proteins", "properties": { "source": "Reactome via Pathway Commons", "license": "CC BY 4.0" }, "metanode": "Pathway" }, "path_counts": [ { "id": 150292156, "adjusted_p_value": 1.9548307522039344e-27, "path_count": 16649, "dwpc": 2.935360920095415, "p_value": 4.1592143663913495e-29, "reversed": false, "metapath_abbreviation": "GeAeGpPW", "metapath_name": "Gene–expresses–Anatomy–expresses–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.8626309999999999, "metapath_path_count_mean": 665.92, "metapath_path_count_max": 55830, "metapath_dwpc_raw_mean": 7.12822e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GeAeGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "expresses", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 32231965, "dgp_source_degree": 40, "dgp_target_degree": 683, "dgp_n_dwpcs": 53400, "dgp_n_nonzero_dwpcs": 53400, "dgp_nonzero_mean": 2.6514462416333306, "dgp_nonzero_sd": 0.02464348141004852, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:EXPRESSES_AeG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 74801183, "adjusted_p_value": 1.3823706670430702e-14, "path_count": 1538, "dwpc": 3.2862679818739813, "p_value": 2.941214185198022e-16, "reversed": false, "metapath_abbreviation": "GuAuGpPW", "metapath_name": "Gene–upregulates–Anatomy–upregulates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.7365649999999999, "metapath_path_count_mean": 39.2263, "metapath_path_count_max": 5985, "metapath_dwpc_raw_mean": 6.212270000000001e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GuAuGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 36287967, "dgp_source_degree": 13, "dgp_target_degree": 683, "dgp_n_dwpcs": 57600, "dgp_n_nonzero_dwpcs": 57600, "dgp_nonzero_mean": 2.974283927578841, "dgp_nonzero_sd": 0.03730385726707176, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:UPREGULATES_AuG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 45061191, "adjusted_p_value": 7.018033837961165e-12, "path_count": 1186, "dwpc": 3.1340422253961484, "p_value": 1.4931986889279075e-13, "reversed": false, "metapath_abbreviation": "GdAdGpPW", "metapath_name": "Gene–downregulates–Anatomy–downregulates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.7038840000000001, "metapath_path_count_mean": 45.172, "metapath_path_count_max": 8841, "metapath_dwpc_raw_mean": 5.79283e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GdAdGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 31366959, "dgp_source_degree": 9, "dgp_target_degree": 683, "dgp_n_dwpcs": 163400, "dgp_n_nonzero_dwpcs": 163400, "dgp_nonzero_mean": 2.792176362650437, "dgp_nonzero_sd": 0.04510932365389436, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:DOWNREGULATES_AdG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 132505177, "adjusted_p_value": 2.8443620860343e-11, "path_count": 148, "dwpc": 4.419073492870612, "p_value": 6.051834225604894e-13, "reversed": false, "metapath_abbreviation": "GpPWpGpPW", "metapath_name": "Gene–participates–Pathway–participates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.25538099999999997, "metapath_path_count_mean": 13.3274, "metapath_path_count_max": 13858, "metapath_dwpc_raw_mean": 6.406720000000001e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GpPWpGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Pathway", "participates", "both" ], [ "Pathway", "Gene", "participates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 35214185, "dgp_source_degree": 14, "dgp_target_degree": 683, "dgp_n_dwpcs": 23000, "dgp_n_nonzero_dwpcs": 23000, "dgp_nonzero_mean": 3.4364808462506327, "dgp_nonzero_sd": 0.12718436994642593, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:PARTICIPATES_GpPW]-(n1)-[:PARTICIPATES_GpPW]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2 AND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(n1)),\nsize((n1)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 141549585, "adjusted_p_value": 3.473123553261309e-10, "path_count": 73, "dwpc": 4.199392613987517, "p_value": 7.389624581407041e-12, "reversed": false, "metapath_abbreviation": "GiGiGpPW", "metapath_name": "Gene–interacts–Gene–interacts–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.5673199999999999, "metapath_path_count_mean": 27.5284, "metapath_path_count_max": 51458, "metapath_dwpc_raw_mean": 5.97122e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GiGiGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 33771653, "dgp_source_degree": 22, "dgp_target_degree": 683, "dgp_n_dwpcs": 28200, "dgp_n_nonzero_dwpcs": 28200, "dgp_nonzero_mean": 2.8693390308695728, "dgp_nonzero_sd": 0.1733598498454655, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:INTERACTS_GiG]-(n1)-[:INTERACTS_GiG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n1 AND n0 <> n2 AND n1 <> n2\nWITH\n[\nsize((n0)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n1)),\nsize((n1)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 133829161, "adjusted_p_value": 1.3102415076149468e-09, "path_count": 5398, "dwpc": 3.3440077967339366, "p_value": 2.78774788854244e-11, "reversed": false, "metapath_abbreviation": "GuAeGpPW", "metapath_name": "Gene–upregulates–Anatomy–expresses–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.75776, "metapath_path_count_mean": 131.376, "metapath_path_count_max": 21793, "metapath_dwpc_raw_mean": 4.89196e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GuAeGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "expresses", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 36244967, "dgp_source_degree": 13, "dgp_target_degree": 683, "dgp_n_dwpcs": 57600, "dgp_n_nonzero_dwpcs": 57600, "dgp_nonzero_mean": 3.056094202593748, "dgp_nonzero_sd": 0.042646599374802065, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:UPREGULATES_AuG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 147772042, "adjusted_p_value": 1.2321880761981702e-08, "path_count": 3826, "dwpc": 3.243759300863752, "p_value": 2.621676757868447e-10, "reversed": false, "metapath_abbreviation": "GeAuGpPW", "metapath_name": "Gene–expresses–Anatomy–upregulates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.8334219999999999, "metapath_path_count_mean": 123.65899999999999, "metapath_path_count_max": 8985, "metapath_dwpc_raw_mean": 4.93454e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GeAuGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 32386765, "dgp_source_degree": 40, "dgp_target_degree": 683, "dgp_n_dwpcs": 53400, "dgp_n_nonzero_dwpcs": 53400, "dgp_nonzero_mean": 2.695395131703452, "dgp_nonzero_sd": 0.08305183543185327, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:EXPRESSES_AeG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 116648604, "adjusted_p_value": 4.4249037605938335e-06, "path_count": 1009, "dwpc": 3.134007107826408, "p_value": 9.414688852327305e-08, "reversed": false, "metapath_abbreviation": "GdAuGpPW", "metapath_name": "Gene–downregulates–Anatomy–upregulates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.699182, "metapath_path_count_mean": 40.9905, "metapath_path_count_max": 7787, "metapath_dwpc_raw_mean": 5.90416e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GdAuGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 31474159, "dgp_source_degree": 9, "dgp_target_degree": 683, "dgp_n_dwpcs": 163400, "dgp_n_nonzero_dwpcs": 163400, "dgp_nonzero_mean": 2.8050581875828464, "dgp_nonzero_sd": 0.06090363282824931, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:DOWNREGULATES_AdG]-(n1)-[:UPREGULATES_AuG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 13255691, "adjusted_p_value": 1.788061424761189e-05, "path_count": 3295, "dwpc": 3.1402254539998338, "p_value": 3.8043860101301894e-07, "reversed": false, "metapath_abbreviation": "GeAdGpPW", "metapath_name": "Gene–expresses–Anatomy–downregulates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.8381299999999999, "metapath_path_count_mean": 124.3, "metapath_path_count_max": 10352, "metapath_dwpc_raw_mean": 4.688e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GeAdGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 32085265, "dgp_source_degree": 40, "dgp_target_degree": 683, "dgp_n_dwpcs": 53400, "dgp_n_nonzero_dwpcs": 53400, "dgp_nonzero_mean": 2.678793847493541, "dgp_nonzero_sd": 0.08862864514403862, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:EXPRESSES_AeG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 86505834, "adjusted_p_value": 0.0011176161145126816, "path_count": 3914, "dwpc": 3.2005566836457473, "p_value": 2.3779066266227268e-05, "reversed": false, "metapath_abbreviation": "GdAeGpPW", "metapath_name": "Gene–downregulates–Anatomy–expresses–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.717892, "metapath_path_count_mean": 134.732, "metapath_path_count_max": 28551, "metapath_dwpc_raw_mean": 4.59137e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GdAeGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "expresses", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 31419119, "dgp_source_degree": 9, "dgp_target_degree": 683, "dgp_n_dwpcs": 163400, "dgp_n_nonzero_dwpcs": 163400, "dgp_nonzero_mean": 2.886678069753136, "dgp_nonzero_sd": 0.0746959923567636, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:DOWNREGULATES_AdG]-(n1)-[:EXPRESSES_AeG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n1)),\nsize((n1)-[:EXPRESSES_AeG]-()),\nsize(()-[:EXPRESSES_AeG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 108804757, "adjusted_p_value": 0.0028048953878080083, "path_count": 1355, "dwpc": 3.170228265632515, "p_value": 5.967862527251082e-05, "reversed": false, "metapath_abbreviation": "GuAdGpPW", "metapath_name": "Gene–upregulates–Anatomy–downregulates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.743047, "metapath_path_count_mean": 40.0691, "metapath_path_count_max": 6224, "metapath_dwpc_raw_mean": 5.9686800000000006e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GuAdGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 36204217, "dgp_source_degree": 13, "dgp_target_degree": 683, "dgp_n_dwpcs": 57600, "dgp_n_nonzero_dwpcs": 57600, "dgp_nonzero_mean": 2.951089686755839, "dgp_nonzero_sd": 0.05569573376388019, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:UPREGULATES_AuG]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(n1)),\nsize((n1)-[:DOWNREGULATES_AdG]-()),\nsize(()-[:DOWNREGULATES_AdG]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 19661523, "adjusted_p_value": 0.01966376714316207, "path_count": 113, "dwpc": 3.7209248509858206, "p_value": 0.0004183780243225973, "reversed": false, "metapath_abbreviation": "GpCCpGpPW", "metapath_name": "Gene–participates–Cellular Component–participates–Gene–participates–Pathway", "metapath_length": 3, "metapath_path_count_density": 0.284981, "metapath_path_count_mean": 5.62291, "metapath_path_count_max": 3291, "metapath_dwpc_raw_mean": 5.4673900000000005e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0005654360906725609, "metapath_id": "GpCCpGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Cellular Component", "participates", "both" ], [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 35121741, "dgp_source_degree": 7, "dgp_target_degree": 683, "dgp_n_dwpcs": 128000, "dgp_n_nonzero_dwpcs": 128000, "dgp_nonzero_mean": 2.9906377463363665, "dgp_nonzero_sd": 0.20436974979272116, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:PARTICIPATES_GpCC]-(n1)-[:PARTICIPATES_GpCC]-(n2)-[:PARTICIPATES_GpPW]-(n3:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n3.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n2\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(n1)),\nsize((n1)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(n2)),\nsize((n2)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 89862282, "adjusted_p_value": 0.019965862759489434, "path_count": 7, "dwpc": 5.61010428858039, "p_value": 0.0049914656898723585, "reversed": false, "metapath_abbreviation": "GiGpPW", "metapath_name": "Gene–interacts–Gene–participates–Pathway", "metapath_length": 2, "metapath_path_count_density": 0.0842118, "metapath_path_count_mean": 0.166929, "metapath_path_count_max": 930, "metapath_dwpc_raw_mean": 5.8892200000000005e-05, "metapath_n_similar": 4, "metapath_p_threshold": 0.006643874065402591, "metapath_id": "GiGpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Gene", "interacts", "both" ], [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 5543736, "dgp_source_degree": 22, "dgp_target_degree": 683, "dgp_n_dwpcs": 28200, "dgp_n_nonzero_dwpcs": 27370, "dgp_nonzero_mean": 2.478000510710514, "dgp_nonzero_sd": 0.9573978199424175, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:INTERACTS_GiG]-(n1)-[:PARTICIPATES_GpPW]-(n2:Pathway)\nUSING JOIN ON n1\nWHERE n0.identifier = 3481 // IGF2\nAND n2.identifier = 'PC7_5330' // Metabolism of proteins\nAND n0 <> n1\nWITH\n[\nsize((n0)-[:INTERACTS_GiG]-()),\nsize(()-[:INTERACTS_GiG]-(n1)),\nsize((n1)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(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": 14837595, "adjusted_p_value": 0.12330434782608696, "path_count": 1, "dwpc": 5.620396764257756, "p_value": 0.12330434782608696, "reversed": false, "metapath_abbreviation": "GpPW", "metapath_name": "Gene–participates–Pathway", "metapath_length": 1, "metapath_path_count_density": 0.0022109, "metapath_path_count_mean": 0.0022109, "metapath_path_count_max": 1, "metapath_dwpc_raw_mean": 7.410609999999999e-05, "metapath_n_similar": 1, "metapath_p_threshold": 1.0, "metapath_id": "GpPW", "metapath_reversed": false, "metapath_metaedges": [ [ "Gene", "Pathway", "participates", "both" ] ], "dgp_id": 630106, "dgp_source_degree": 14, "dgp_target_degree": 683, "dgp_n_dwpcs": 23000, "dgp_n_nonzero_dwpcs": 2836, "dgp_nonzero_mean": 5.620396764257749, "dgp_nonzero_sd": 0.0, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:Gene)-[:PARTICIPATES_GpPW]-(n1:Pathway)\nUSING JOIN ON n0\nWHERE n0.identifier = 3481 // IGF2\nAND n1.identifier = 'PC7_5330' // Metabolism of proteins\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpPW]-()),\nsize(()-[:PARTICIPATES_GpPW]-(n1))\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": 14, "pathcount_table_random_id": 45061191, "pathcount_table_max_id": 169602979 }