api_results

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

9 rows where query_id = 153735

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
535806 535806 153735 153735 PubChem (substance) 2 12640 12640 1
807790 807790 153735 153735 PubChem (substance) 2 142195 142195 2
807792 807792 153735 153735 PubChem (substance) 2 154891 154891 3
807793 807793 153735 153735 PubChem (substance) 2 196494 196494 4
807794 807794 153735 153735 PubChem (substance) 2 238115 238115 5
807795 807795 153735 153735 PubChem (substance) 2 240466 240466 6
807796 807796 153735 153735 PubChem (substance) 2 182788 182788 7
1065231 1065231 153735 153735 CAS Common Chemistry 3 12640 12640 1
1267060 1267060 153735 153735 Computational Toxicology and Exposure Data 4 12640 12640 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)
);