api_results

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

12 rows where query_id = 9845

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18654 18654 9845 9845 PubChem (compound) 1 137874 137874 1
322024 322024 9845 9845 PubChem (substance) 2 137874 137874 1
363178 363178 9845 9845 PubChem (substance) 2 99590 99590 5
468887 468887 9845 9845 PubChem (substance) 2 217538 217538 4
468889 468889 9845 9845 PubChem (substance) 2 31823 31823 3
560703 560703 9845 9845 PubChem (substance) 2 37162 37162 6
705177 705177 9845 9845 PubChem (substance) 2 137874 137874 2
705180 705180 9845 9845 PubChem (substance) 2 263117 263117 7
705181 705181 9845 9845 PubChem (substance) 2 309511 309511 8
705182 705182 9845 9845 PubChem (substance) 2 228814 228814 9
952107 952107 9845 9845 CAS Common Chemistry 3 31823 31823 1
1151309 1151309 9845 9845 Computational Toxicology and Exposure Data 4 97369 97369 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)
);