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 = 435733

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
4394 4394 435733 435733 PubChem (compound) 1 63056 63056 1
301683 301683 435733 435733 PubChem (substance) 2 63056 63056 1
431733 431733 435733 435733 PubChem (substance) 2 33625 33625 17
446214 446214 435733 435733 PubChem (substance) 2 23718 23718 3
455809 455809 435733 435733 PubChem (substance) 2 46225 46225 6
651385 651385 435733 435733 PubChem (substance) 2 136269 136269 9
658119 658119 435733 435733 PubChem (substance) 2 185872 185872 12
695772 695772 435733 435733 PubChem (substance) 2 136811 136811 5
695780 695780 435733 435733 PubChem (substance) 2 137660 137660 4
695796 695796 435733 435733 PubChem (substance) 2 186844 186844 8
695803 695803 435733 435733 PubChem (substance) 2 284000 284000 13
695820 695820 435733 435733 PubChem (substance) 2 227367 227367 10
695825 695825 435733 435733 PubChem (substance) 2 270864 270864 11
695837 695837 435733 435733 PubChem (substance) 2 203058 203058 2
695847 695847 435733 435733 PubChem (substance) 2 271988 271988 16
695853 695853 435733 435733 PubChem (substance) 2 192459 192459 7
695946 695946 435733 435733 PubChem (substance) 2 310732 310732 14
695948 695948 435733 435733 PubChem (substance) 2 232876 232876 15
941367 941367 435733 435733 CAS Common Chemistry 3 63056 63056 1
1138641 1138641 435733 435733 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 497.067ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website