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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99451 99451 59789 59789 PubChem (compound) 1 152599 152599 1
99452 99452 59789 59789 PubChem (compound) 1 93556 93556 2
99453 99453 59789 59789 PubChem (compound) 1 136394 136394 3
99454 99454 59789 59789 PubChem (compound) 1 216887 216887 4
99455 99455 59789 59789 PubChem (compound) 1 188313 188313 5
99456 99456 59789 59789 PubChem (compound) 1 290506 290506 6
99457 99457 59789 59789 PubChem (compound) 1 326501 326501 7
436325 436325 59789 59789 PubChem (substance) 2 152599 152599 1
436327 436327 59789 59789 PubChem (substance) 2 93556 93556 3
436333 436333 59789 59789 PubChem (substance) 2 136394 136394 4
436334 436334 59789 59789 PubChem (substance) 2 216887 216887 5
436335 436335 59789 59789 PubChem (substance) 2 188313 188313 6
436336 436336 59789 59789 PubChem (substance) 2 290506 290506 10
436337 436337 59789 59789 PubChem (substance) 2 326501 326501 11
436340 436340 59789 59789 PubChem (substance) 2 44729 44729 2
436345 436345 59789 59789 PubChem (substance) 2 182465 182465 9
749702 749702 59789 59789 PubChem (substance) 2 147318 147318 7
749703 749703 59789 59789 PubChem (substance) 2 169489 169489 8
1011601 1011601 59789 59789 CAS Common Chemistry 3 44729 44729 1
1213687 1213687 59789 59789 Computational Toxicology and Exposure Data 4 93556 93556 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 454.185ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website