api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

23 rows where query_id = 325877

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
8280 8280 325877 325877 PubChem (compound) 1 60356 60356 1
306929 306929 325877 325877 PubChem (substance) 2 60356 60356 1
309812 309812 325877 325877 PubChem (substance) 2 73275 73275 13
309963 309963 325877 325877 PubChem (substance) 2 63043 63043 10
318605 318605 325877 325877 PubChem (substance) 2 32227 32227 7
343254 343254 325877 325877 PubChem (substance) 2 7026 7026 6
345433 345433 325877 325877 PubChem (substance) 2 101859 101859 11
350326 350326 325877 325877 PubChem (substance) 2 49260 49260 4
465622 465622 325877 325877 PubChem (substance) 2 43760 43760 16
698269 698269 325877 325877 PubChem (substance) 2 136299 136299 2
699554 699554 325877 325877 PubChem (substance) 2 169804 169804 12
708266 708266 325877 325877 PubChem (substance) 2 136298 136298 3
708270 708270 325877 325877 PubChem (substance) 2 204210 204210 5
708276 708276 325877 325877 PubChem (substance) 2 219773 219773 8
708280 708280 325877 325877 PubChem (substance) 2 253730 253730 9
708282 708282 325877 325877 PubChem (substance) 2 169634 169634 14
708288 708288 325877 325877 PubChem (substance) 2 228749 228749 15
708293 708293 325877 325877 PubChem (substance) 2 219656 219656 17
708297 708297 325877 325877 PubChem (substance) 2 251093 251093 18
708302 708302 325877 325877 PubChem (substance) 2 323674 323674 19
708306 708306 325877 325877 PubChem (substance) 2 269764 269764 20
944291 944291 325877 325877 CAS Common Chemistry 3 60356 60356 1
1142059 1142059 325877 325877 Computational Toxicology and Exposure Data 4 60356 60356 1 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);