home / zeropm-v0-0-4

api_results

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

27 rows where query_id = 112239

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
131337 131337 112239 112239 PubChem (compound) 1 42699 42699 1
436871 436871 112239 112239 PubChem (substance) 2 37047 37047 21
480571 480571 112239 112239 PubChem (substance) 2 42699 42699 1
551770 551770 112239 112239 PubChem (substance) 2 28512 28512 22
778727 778727 112239 112239 PubChem (substance) 2 157513 157513 2
778731 778731 112239 112239 PubChem (substance) 2 237159 237159 20
778734 778734 112239 112239 PubChem (substance) 2 197759 197759 4
778737 778737 112239 112239 PubChem (substance) 2 208882 208882 3
778738 778738 112239 112239 PubChem (substance) 2 201737 201737 5
778739 778739 112239 112239 PubChem (substance) 2 200818 200818 6
778740 778740 112239 112239 PubChem (substance) 2 206738 206738 7
778741 778741 112239 112239 PubChem (substance) 2 206739 206739 8
778742 778742 112239 112239 PubChem (substance) 2 206740 206740 9
778743 778743 112239 112239 PubChem (substance) 2 206741 206741 10
778744 778744 112239 112239 PubChem (substance) 2 178420 178420 11
778745 778745 112239 112239 PubChem (substance) 2 200671 200671 12
778746 778746 112239 112239 PubChem (substance) 2 194292 194292 13
778747 778747 112239 112239 PubChem (substance) 2 198033 198033 14
778748 778748 112239 112239 PubChem (substance) 2 206916 206916 15
778749 778749 112239 112239 PubChem (substance) 2 206917 206917 16
778750 778750 112239 112239 PubChem (substance) 2 206980 206980 17
778751 778751 112239 112239 PubChem (substance) 2 206981 206981 18
778752 778752 112239 112239 PubChem (substance) 2 206982 206982 19
778754 778754 112239 112239 PubChem (substance) 2 151299 151299 23
778755 778755 112239 112239 PubChem (substance) 2 237241 237241 24
1033534 1033534 112239 112239 CAS Common Chemistry 3 42699 42699 1
1236474 1236474 112239 112239 Computational Toxicology and Exposure Data 4 42699 42699 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 432.459ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website