api_results

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

9 rows where query_id = 412996

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
58804 58804 412996 412996 PubChem (compound) 1 103014 103014 1
378906 378906 412996 412996 PubChem (substance) 2 103014 103014 1
681049 681049 412996 412996 PubChem (substance) 2 25284 25284 2
726441 726441 412996 412996 PubChem (substance) 2 46792 46792 4
726446 726446 412996 412996 PubChem (substance) 2 248109 248109 5
726449 726449 412996 412996 PubChem (substance) 2 170643 170643 3
726457 726457 412996 412996 PubChem (substance) 2 103014 103014 6
981357 981357 412996 412996 CAS Common Chemistry 3 70177 70177 1
1184221 1184221 412996 412996 Computational Toxicology and Exposure Data 4 103014 103014 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)
);