home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 170786

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
137302 137302 307756 307756 PubChem (compound) 1 170786 170786 1
137303 137303 117678 117678 PubChem (compound) 1 170786 170786 1
488554 488554 11614 11614 PubChem (substance) 2 170786 170786 7
488555 488555 141261 141261 PubChem (substance) 2 170786 170786 4
488556 488556 307756 307756 PubChem (substance) 2 170786 170786 2
488557 488557 25509 25509 PubChem (substance) 2 170786 170786 2
488558 488558 26610 26610 PubChem (substance) 2 170786 170786 2
488559 488559 136808 136808 PubChem (substance) 2 170786 170786 2
488560 488560 12470 12470 PubChem (substance) 2 170786 170786 3
488561 488561 100138 100138 PubChem (substance) 2 170786 170786 2
488562 488562 24247 24247 PubChem (substance) 2 170786 170786 2
488563 488563 26611 26611 PubChem (substance) 2 170786 170786 3
488564 488564 89485 89485 PubChem (substance) 2 170786 170786 2
488565 488565 117678 117678 PubChem (substance) 2 170786 170786 2
488566 488566 39152 39152 PubChem (substance) 2 170786 170786 4
488567 488567 435758 435758 PubChem (substance) 2 170786 170786 7
488568 488568 142005 142005 PubChem (substance) 2 170786 170786 4
488569 488569 407018 407018 PubChem (substance) 2 170786 170786 5
488570 488570 389766 389766 PubChem (substance) 2 170786 170786 2
488571 488571 412695 412695 PubChem (substance) 2 170786 170786 3
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 1123.788ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website