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": 4983, "identifier": "GO:0005788", "identifier_type": "str", "name": "endoplasmic reticulum lumen", "properties": { "url": "http://purl.obolibrary.org/obo/GO_0005788", "source": "Gene Ontology", "license": "CC BY 4.0" }, "metanode": "Cellular Component" }, "target": { "id": 41238, "identifier": "399979", "identifier_type": "int", "name": "SNX19", "properties": { "url": "http://identifiers.org/ncbigene/399979", "source": "Entrez Gene", "license": "CC0 1.0", "chromosome": "11", "description": "sorting nexin 19" }, "metanode": "Gene" }, "path_counts": [ { "id": 94879044, "adjusted_p_value": 1.8126931688372656e-18, "path_count": 4876, "dwpc": 2.575831853756317, "p_value": 3.856793976249501e-20, "reversed": false, "metapath_abbreviation": "CCpGeAeG", "metapath_name": "Cellular Component–participates–Gene–expresses–Anatomy–expresses–Gene", "metapath_length": 3, "metapath_path_count_density": 0.8615139999999999, "metapath_path_count_mean": 745.4119999999999, "metapath_path_count_max": 33011, "metapath_dwpc_raw_mean": 7.8784e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGeAeG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "expresses", "both" ] ], "dgp_id": 20119746, "dgp_source_degree": 202, "dgp_target_degree": 44, "dgp_n_dwpcs": 59000, "dgp_n_nonzero_dwpcs": 59000, "dgp_nonzero_mean": 2.152007603575844, "dgp_nonzero_sd": 0.04377566404667656, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:EXPRESSES_AeG]-(n2)-[:EXPRESSES_AeG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(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": 142194107, "adjusted_p_value": 2.982569734311657e-14, "path_count": 435, "dwpc": 2.939510374566444, "p_value": 6.345893051726929e-16, "reversed": false, "metapath_abbreviation": "CCpGuAdG", "metapath_name": "Cellular Component–participates–Gene–upregulates–Anatomy–downregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.6718649999999999, "metapath_path_count_mean": 48.0861, "metapath_path_count_max": 5370, "metapath_dwpc_raw_mean": 6.54443e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGuAdG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ] ], "dgp_id": 21282601, "dgp_source_degree": 202, "dgp_target_degree": 8, "dgp_n_dwpcs": 196000, "dgp_n_nonzero_dwpcs": 196000, "dgp_nonzero_mean": 2.2095781588058463, "dgp_nonzero_sd": 0.0829259906399968, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:UPREGULATES_AuG]-(n2)-[:DOWNREGULATES_AdG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(n1)),\nsize((n1)-[:UPREGULATES_AuG]-()),\nsize(()-[:UPREGULATES_AuG]-(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": 116238682, "adjusted_p_value": 1.511535329134801e-11, "path_count": 401, "dwpc": 2.875226668259003, "p_value": 3.2160326151804274e-13, "reversed": false, "metapath_abbreviation": "CCpGdAuG", "metapath_name": "Cellular Component–participates–Gene–downregulates–Anatomy–upregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.708364, "metapath_path_count_mean": 49.438, "metapath_path_count_max": 5394, "metapath_dwpc_raw_mean": 6.599810000000001e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGdAuG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ] ], "dgp_id": 19907519, "dgp_source_degree": 202, "dgp_target_degree": 7, "dgp_n_dwpcs": 295200, "dgp_n_nonzero_dwpcs": 295200, "dgp_nonzero_mean": 2.1339417079923475, "dgp_nonzero_sd": 0.09328816839700389, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:UPREGULATES_AuG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(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": 1003023, "adjusted_p_value": 1.9080782317260643e-07, "path_count": 973, "dwpc": 2.785073418374439, "p_value": 4.059740918566094e-09, "reversed": false, "metapath_abbreviation": "CCpGeAdG", "metapath_name": "Cellular Component–participates–Gene–expresses–Anatomy–downregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.715659, "metapath_path_count_mean": 153.58700000000002, "metapath_path_count_max": 17610, "metapath_dwpc_raw_mean": 5.2511899999999994e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGeAdG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "downregulates", "both" ] ], "dgp_id": 20103606, "dgp_source_degree": 202, "dgp_target_degree": 8, "dgp_n_dwpcs": 196000, "dgp_n_nonzero_dwpcs": 196000, "dgp_nonzero_mean": 2.247867942940982, "dgp_nonzero_sd": 0.08682578326065328, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:EXPRESSES_AeG]-(n2)-[:DOWNREGULATES_AdG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(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": 41773455, "adjusted_p_value": 4.425796414278618e-05, "path_count": 865, "dwpc": 2.504187189637776, "p_value": 9.416588115486421e-07, "reversed": false, "metapath_abbreviation": "CCpGeAuG", "metapath_name": "Cellular Component–participates–Gene–expresses–Anatomy–upregulates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.755686, "metapath_path_count_mean": 149.95600000000002, "metapath_path_count_max": 13442, "metapath_dwpc_raw_mean": 5.6072e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGeAuG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "expresses", "both" ], [ "Anatomy", "Gene", "upregulates", "both" ] ], "dgp_id": 20143694, "dgp_source_degree": 202, "dgp_target_degree": 7, "dgp_n_dwpcs": 295200, "dgp_n_nonzero_dwpcs": 295200, "dgp_nonzero_mean": 2.1659689749088833, "dgp_nonzero_sd": 0.06772739781864723, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:EXPRESSES_AeG]-(n2)-[:UPREGULATES_AuG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(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": 96506817, "adjusted_p_value": 7.611633550333899e-05, "path_count": 1007, "dwpc": 2.5855998541916376, "p_value": 1.6194965000710425e-06, "reversed": false, "metapath_abbreviation": "CCpGuAeG", "metapath_name": "Cellular Component–participates–Gene–upregulates–Anatomy–expresses–Gene", "metapath_length": 3, "metapath_path_count_density": 0.817075, "metapath_path_count_mean": 145.012, "metapath_path_count_max": 5974, "metapath_dwpc_raw_mean": 5.4813500000000006e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGuAeG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "upregulates", "both" ], [ "Anatomy", "Gene", "expresses", "both" ] ], "dgp_id": 21298741, "dgp_source_degree": 202, "dgp_target_degree": 44, "dgp_n_dwpcs": 59000, "dgp_n_nonzero_dwpcs": 59000, "dgp_nonzero_mean": 2.1863473639099853, "dgp_nonzero_sd": 0.08125405088206927, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:UPREGULATES_AuG]-(n2)-[:EXPRESSES_AeG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(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": 48568380, "adjusted_p_value": 0.0006103889903631765, "path_count": 948, "dwpc": 2.59123904220012, "p_value": 1.2986999794961202e-05, "reversed": false, "metapath_abbreviation": "CCpGdAeG", "metapath_name": "Cellular Component–participates–Gene–downregulates–Anatomy–expresses–Gene", "metapath_length": 3, "metapath_path_count_density": 0.815055, "metapath_path_count_mean": 152.89700000000002, "metapath_path_count_max": 7613, "metapath_dwpc_raw_mean": 5.15742e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGdAeG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Anatomy", "downregulates", "both" ], [ "Anatomy", "Gene", "expresses", "both" ] ], "dgp_id": 19883571, "dgp_source_degree": 202, "dgp_target_degree": 44, "dgp_n_dwpcs": 59000, "dgp_n_nonzero_dwpcs": 59000, "dgp_nonzero_mean": 2.2045497295463763, "dgp_nonzero_sd": 0.08731975990243133, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:DOWNREGULATES_AdG]-(n2)-[:EXPRESSES_AeG]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(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": 127678987, "adjusted_p_value": 0.025931246851363388, "path_count": 174, "dwpc": 2.6591176320111334, "p_value": 0.000551728656411987, "reversed": false, "metapath_abbreviation": "CCpGpBPpG", "metapath_name": "Cellular Component–participates–Gene–participates–Biological Process–participates–Gene", "metapath_length": 3, "metapath_path_count_density": 0.460679, "metapath_path_count_mean": 48.3325, "metapath_path_count_max": 25228, "metapath_dwpc_raw_mean": 7.24431e-05, "metapath_n_similar": 47, "metapath_p_threshold": 0.0006131262328590808, "metapath_id": "CCpGpBPpG", "metapath_reversed": false, "metapath_metaedges": [ [ "Cellular Component", "Gene", "participates", "both" ], [ "Gene", "Biological Process", "participates", "both" ], [ "Biological Process", "Gene", "participates", "both" ] ], "dgp_id": 20723779, "dgp_source_degree": 202, "dgp_target_degree": 21, "dgp_n_dwpcs": 46800, "dgp_n_nonzero_dwpcs": 46800, "dgp_nonzero_mean": 1.8799128971307266, "dgp_nonzero_sd": 0.21447130001493692, "dgp_reversed": false, "cypher_query": "MATCH path = (n0:CellularComponent)-[:PARTICIPATES_GpCC]-(n1)-[:PARTICIPATES_GpBP]-(n2)-[:PARTICIPATES_GpBP]-(n3:Gene)\nUSING JOIN ON n1\nWHERE n0.identifier = 'GO:0005788' // endoplasmic reticulum lumen\nAND n3.identifier = 399979 // SNX19\nAND n1 <> n3\nWITH\n[\nsize((n0)-[:PARTICIPATES_GpCC]-()),\nsize(()-[:PARTICIPATES_GpCC]-(n1)),\nsize((n1)-[:PARTICIPATES_GpBP]-()),\nsize(()-[:PARTICIPATES_GpBP]-(n2)),\nsize((n2)-[:PARTICIPATES_GpBP]-()),\nsize(()-[:PARTICIPATES_GpBP]-(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": 8, "pathcount_table_random_id": 142194107, "pathcount_table_max_id": 169602979 }