home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 325879

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
8282 8282 325879 325879 PubChem (compound) 1 60356 60356 1
306926 306926 325879 325879 PubChem (substance) 2 60356 60356 1
309811 309811 325879 325879 PubChem (substance) 2 73275 73275 13
309953 309953 325879 325879 PubChem (substance) 2 63043 63043 10
318599 318599 325879 325879 PubChem (substance) 2 32227 32227 7
343248 343248 325879 325879 PubChem (substance) 2 7026 7026 6
345432 345432 325879 325879 PubChem (substance) 2 101859 101859 11
350325 350325 325879 325879 PubChem (substance) 2 49260 49260 4
465623 465623 325879 325879 PubChem (substance) 2 43760 43760 16
698271 698271 325879 325879 PubChem (substance) 2 136299 136299 2
699555 699555 325879 325879 PubChem (substance) 2 169804 169804 12
708264 708264 325879 325879 PubChem (substance) 2 136298 136298 3
708269 708269 325879 325879 PubChem (substance) 2 204210 204210 5
708275 708275 325879 325879 PubChem (substance) 2 219773 219773 8
708279 708279 325879 325879 PubChem (substance) 2 253730 253730 9
708284 708284 325879 325879 PubChem (substance) 2 169634 169634 14
708290 708290 325879 325879 PubChem (substance) 2 228749 228749 15
708294 708294 325879 325879 PubChem (substance) 2 219656 219656 17
708298 708298 325879 325879 PubChem (substance) 2 251093 251093 18
708300 708300 325879 325879 PubChem (substance) 2 323674 323674 19
708305 708305 325879 325879 PubChem (substance) 2 269764 269764 20
944292 944292 325879 325879 CAS Common Chemistry 3 60356 60356 1
1142061 1142061 325879 325879 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)
);
Powered by Datasette · Queries took 409.663ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website