home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 340112

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21554 21554 340112 340112 PubChem (compound) 1 51336 51336 1
326363 326363 340112 340112 PubChem (substance) 2 51336 51336 1
357101 357101 340112 340112 PubChem (substance) 2 136289 136289 2
707238 707238 340112 340112 PubChem (substance) 2 188358 188358 20
707242 707242 340112 340112 PubChem (substance) 2 254256 254256 18
707244 707244 340112 340112 PubChem (substance) 2 140453 140453 3
707249 707249 340112 340112 PubChem (substance) 2 195821 195821 17
707250 707250 340112 340112 PubChem (substance) 2 147613 147613 14
707253 707253 340112 340112 PubChem (substance) 2 197890 197890 9
912647 912647 340112 340112 PubChem (substance) 2 186283 186283 4
912648 912648 340112 340112 PubChem (substance) 2 181541 181541 5
912649 912649 340112 340112 PubChem (substance) 2 205688 205688 6
912650 912650 340112 340112 PubChem (substance) 2 169633 169633 7
912651 912651 340112 340112 PubChem (substance) 2 169717 169717 8
912652 912652 340112 340112 PubChem (substance) 2 197891 197891 10
912653 912653 340112 340112 PubChem (substance) 2 204403 204403 11
912654 912654 340112 340112 PubChem (substance) 2 173742 173742 12
912655 912655 340112 340112 PubChem (substance) 2 173744 173744 13
912656 912656 340112 340112 PubChem (substance) 2 206007 206007 15
912657 912657 340112 340112 PubChem (substance) 2 199633 199633 16
912658 912658 340112 340112 PubChem (substance) 2 297226 297226 19
912659 912659 340112 340112 PubChem (substance) 2 174795 174795 21
954119 954119 340112 340112 CAS Common Chemistry 3 51336 51336 1
1153628 1153628 340112 340112 Computational Toxicology and Exposure Data 4 51336 51336 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 499.75ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website