home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 2303

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
4398 4398 2303 2303 PubChem (compound) 1 63056 63056 1
301687 301687 2303 2303 PubChem (substance) 2 63056 63056 1
431729 431729 2303 2303 PubChem (substance) 2 33625 33625 17
446209 446209 2303 2303 PubChem (substance) 2 23718 23718 3
455812 455812 2303 2303 PubChem (substance) 2 46225 46225 6
651384 651384 2303 2303 PubChem (substance) 2 136269 136269 9
658122 658122 2303 2303 PubChem (substance) 2 185872 185872 12
695770 695770 2303 2303 PubChem (substance) 2 136811 136811 5
695779 695779 2303 2303 PubChem (substance) 2 137660 137660 4
695787 695787 2303 2303 PubChem (substance) 2 186844 186844 8
695802 695802 2303 2303 PubChem (substance) 2 284000 284000 13
695823 695823 2303 2303 PubChem (substance) 2 227367 227367 10
695827 695827 2303 2303 PubChem (substance) 2 270864 270864 11
695839 695839 2303 2303 PubChem (substance) 2 203058 203058 2
695848 695848 2303 2303 PubChem (substance) 2 271988 271988 16
695857 695857 2303 2303 PubChem (substance) 2 192459 192459 7
695944 695944 2303 2303 PubChem (substance) 2 310732 310732 14
695949 695949 2303 2303 PubChem (substance) 2 232876 232876 15
941370 941370 2303 2303 CAS Common Chemistry 3 63056 63056 1
1138642 1138642 2303 2303 Computational Toxicology and Exposure Data 4 63056 63056 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 612.778ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website