home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 370307

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22604 22604 370307 370307 PubChem (compound) 1 73273 73273 1
328203 328203 370307 370307 PubChem (substance) 2 73273 73273 1
357805 357805 370307 370307 PubChem (substance) 2 3977 3977 21
432614 432614 370307 370307 PubChem (substance) 2 33486 33486 5
436169 436169 370307 370307 PubChem (substance) 2 70946 70946 2
452311 452311 370307 370307 PubChem (substance) 2 4325 4325 17
478265 478265 370307 370307 PubChem (substance) 2 14680 14680 4
708790 708790 370307 370307 PubChem (substance) 2 176863 176863 6
708795 708795 370307 370307 PubChem (substance) 2 184359 184359 8
708801 708801 370307 370307 PubChem (substance) 2 176863 176863 3
749591 749591 370307 370307 PubChem (substance) 2 169733 169733 20
751066 751066 370307 370307 PubChem (substance) 2 169448 169448 14
761676 761676 370307 370307 PubChem (substance) 2 169389 169389 7
761680 761680 370307 370307 PubChem (substance) 2 198595 198595 9
761682 761682 370307 370307 PubChem (substance) 2 169388 169388 10
761684 761684 370307 370307 PubChem (substance) 2 169396 169396 11
761685 761685 370307 370307 PubChem (substance) 2 184359 184359 12
761687 761687 370307 370307 PubChem (substance) 2 169658 169658 13
761690 761690 370307 370307 PubChem (substance) 2 197096 197096 15
761693 761693 370307 370307 PubChem (substance) 2 177941 177941 16
761695 761695 370307 370307 PubChem (substance) 2 241510 241510 18
761697 761697 370307 370307 PubChem (substance) 2 169698 169698 19
954825 954825 370307 370307 CAS Common Chemistry 3 73273 73273 2
1011540 1011540 370307 370307 CAS Common Chemistry 3 70946 70946 1
1154586 1154586 370307 370307 Computational Toxicology and Exposure Data 4 73273 73273 1
1213623 1213623 370307 370307 Computational Toxicology and Exposure Data 4 128290 128290 2
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 1188.293ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website