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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
237777 237777 343846 343846 PubChem (compound) 1 74746 74746 1
440361 440361 343846 343846 PubChem (substance) 2 63052 63052 15
476716 476716 343846 343846 PubChem (substance) 2 7045 7045 5
517527 517527 343846 343846 PubChem (substance) 2 52913 52913 11
617979 617979 343846 343846 PubChem (substance) 2 74746 74746 1
653785 653785 343846 343846 PubChem (substance) 2 173293 173293 2
751555 751555 343846 343846 PubChem (substance) 2 232154 232154 6
840357 840357 343846 343846 PubChem (substance) 2 181387 181387 4
840359 840359 343846 343846 PubChem (substance) 2 219632 219632 13
840361 840361 343846 343846 PubChem (substance) 2 189161 189161 3
840363 840363 343846 343846 PubChem (substance) 2 237568 237568 7
840365 840365 343846 343846 PubChem (substance) 2 199792 199792 9
840367 840367 343846 343846 PubChem (substance) 2 320400 320400 10
840369 840369 343846 343846 PubChem (substance) 2 294529 294529 14
840372 840372 343846 343846 PubChem (substance) 2 210490 210490 16
913581 913581 343846 343846 PubChem (substance) 2 284053 284053 8
913582 913582 343846 343846 PubChem (substance) 2 179985 179985 12
913583 913583 343846 343846 PubChem (substance) 2 291627 291627 17
1107901 1107901 343846 343846 CAS Common Chemistry 3 74746 74746 1
1310211 1310211 343846 343846 Computational Toxicology and Exposure Data 4 74746 74746 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 420.724ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website