home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 306244

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
258937 258937 306244 306244 PubChem (compound) 1 70662 70662 1
436276 436276 306244 306244 PubChem (substance) 2 82954 82954 2
436284 436284 306244 306244 PubChem (substance) 2 224754 224754 3
436291 436291 306244 306244 PubChem (substance) 2 192037 192037 5
643216 643216 306244 306244 PubChem (substance) 2 70662 70662 1
643225 643225 306244 306244 PubChem (substance) 2 189130 189130 4
749668 749668 306244 306244 PubChem (substance) 2 137161 137161 12
846770 846770 306244 306244 PubChem (substance) 2 219883 219883 6
846772 846772 306244 306244 PubChem (substance) 2 160007 160007 7
846773 846773 306244 306244 PubChem (substance) 2 243358 243358 8
846774 846774 306244 306244 PubChem (substance) 2 276444 276444 9
846775 846775 306244 306244 PubChem (substance) 2 70662 70662 10
846780 846780 306244 306244 PubChem (substance) 2 219883 219883 11
846783 846783 306244 306244 PubChem (substance) 2 294582 294582 13
846784 846784 306244 306244 PubChem (substance) 2 296213 296213 14
1113025 1113025 306244 306244 CAS Common Chemistry 3 70662 70662 1
1323847 1323847 306244 306244 Computational Toxicology and Exposure Data 4 70662 70662 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 1767.467ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website