{"query":{"source_id":6602,"target_id":17054,"source_metanode":"Disease","target_metanode":"Compound","source_identifier":"DOID:1612","target_identifier":"DB00331","metapath":"DaGuCrC","metapath_id":[["Disease","Gene","associates","both"],["Gene","Compound","upregulates","both"],["Compound","Compound","resembles","both"]],"metapath_unadjusted_p_value":1.0,"metapath_adjusted_p_value":1.0,"metapath_score":-0.0,"limit":100},"path_count_info":{"id":null,"adjusted_p_value":1.0,"path_count":0,"dwpc":0.0,"p_value":1.0,"source":17054,"target":6602,"reversed":true,"metapath_abbreviation":"DaGuCrC","metapath_name":"Disease–associates–Gene–upregulates–Compound–resembles–Compound","metapath_length":3,"metapath_path_count_density":0.21871,"metapath_path_count_mean":1.088,"metapath_path_count_max":144,"metapath_dwpc_raw_mean":0.000159954,"metapath_n_similar":121,"metapath_p_threshold":1.0,"metapath_source":"Disease","metapath_target":"Compound","metapath_id":"CrCuGaD","metapath_reversed":true,"metapath_metaedges":[["Disease","Gene","associates","both"],["Gene","Compound","upregulates","both"],["Compound","Compound","resembles","both"]],"dgp_id":23633958,"dgp_source_degree":540,"dgp_target_degree":0,"dgp_n_dwpcs":54200,"dgp_n_nonzero_dwpcs":0,"dgp_nonzero_mean":null,"dgp_nonzero_sd":null,"dgp_reversed":true,"cypher_query":"MATCH path = (n0:Disease)-[:ASSOCIATES_DaG]-(n1)-[:UPREGULATES_CuG]-(n2)-[:RESEMBLES_CrC]-(n3:Compound)\nUSING JOIN ON n1\nWHERE n0.identifier = 'DOID:1612' // breast cancer\nAND n3.identifier = 'DB00331' // Metformin\nAND n2 <> n3\nWITH\n[\nsize((n0)-[:ASSOCIATES_DaG]-()),\nsize(()-[:ASSOCIATES_DaG]-(n1)),\nsize((n1)-[:UPREGULATES_CuG]-()),\nsize(()-[:UPREGULATES_CuG]-(n2)),\nsize((n2)-[:RESEMBLES_CrC]-()),\nsize(()-[:RESEMBLES_CrC]-(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"},"paths":[],"nodes":{},"relationships":{}}