home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 11478

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22023 22023 11478 11478 PubChem (compound) 1 57316 57316 1
305212 305212 11478 11478 PubChem (substance) 2 55037 55037 7
327231 327231 11478 11478 PubChem (substance) 2 57316 57316 1
472237 472237 11478 11478 PubChem (substance) 2 6759 6759 4
472244 472244 11478 11478 PubChem (substance) 2 6759 6759 6
472250 472250 11478 11478 PubChem (substance) 2 249874 249874 3
655742 655742 11478 11478 PubChem (substance) 2 266466 266466 8
708113 708113 11478 11478 PubChem (substance) 2 57316 57316 2
708118 708118 11478 11478 PubChem (substance) 2 332526 332526 5
708119 708119 11478 11478 PubChem (substance) 2 263689 263689 9
708120 708120 11478 11478 PubChem (substance) 2 287465 287465 10
708121 708121 11478 11478 PubChem (substance) 2 168850 168850 11
708127 708127 11478 11478 PubChem (substance) 2 292579 292579 12
708128 708128 11478 11478 PubChem (substance) 2 199767 199767 13
954445 954445 11478 11478 CAS Common Chemistry 3 57316 57316 1
1154074 1154074 11478 11478 Computational Toxicology and Exposure Data 4 57316 57316 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 449.439ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website