home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 59827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99561 99561 59827 59827 PubChem (compound) 1 114184 114184 1
99562 99562 59827 59827 PubChem (compound) 1 277344 277344 2
99563 99563 59827 59827 PubChem (compound) 1 37649 37649 3
99564 99564 59827 59827 PubChem (compound) 1 292410 292410 4
99565 99565 59827 59827 PubChem (compound) 1 292426 292426 5
99566 99566 59827 59827 PubChem (compound) 1 114184 114184 6
436556 436556 59827 59827 PubChem (substance) 2 114184 114184 1
436562 436562 59827 59827 PubChem (substance) 2 277344 277344 3
436564 436564 59827 59827 PubChem (substance) 2 37649 37649 6
436566 436566 59827 59827 PubChem (substance) 2 292410 292410 7
436567 436567 59827 59827 PubChem (substance) 2 292426 292426 11
436568 436568 59827 59827 PubChem (substance) 2 114184 114184 13
436570 436570 59827 59827 PubChem (substance) 2 145363 145363 5
436575 436575 59827 59827 PubChem (substance) 2 212669 212669 2
459344 459344 59827 59827 PubChem (substance) 2 49292 49292 14
749769 749769 59827 59827 PubChem (substance) 2 165101 165101 4
749770 749770 59827 59827 PubChem (substance) 2 216908 216908 8
749771 749771 59827 59827 PubChem (substance) 2 235012 235012 9
749772 749772 59827 59827 PubChem (substance) 2 258900 258900 10
749773 749773 59827 59827 PubChem (substance) 2 226605 226605 12
1011640 1011640 59827 59827 CAS Common Chemistry 3 37649 37649 1
1213731 1213731 59827 59827 Computational Toxicology and Exposure Data 4 114184 114184 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 451.142ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website