api_results

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

15 rows where query_id = 302358

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
7051 7051 302358 302358 PubChem (compound) 1 17122 17122 1
305246 305246 302358 302358 PubChem (substance) 2 17122 17122 1
472863 472863 302358 302358 PubChem (substance) 2 74794 74794 8
805213 805213 302358 302358 PubChem (substance) 2 171620 171620 5
846100 846100 302358 302358 PubChem (substance) 2 187944 187944 2
846101 846101 302358 302358 PubChem (substance) 2 186757 186757 3
846102 846102 302358 302358 PubChem (substance) 2 125131 125131 4
846104 846104 302358 302358 PubChem (substance) 2 31930 31930 6
846105 846105 302358 302358 PubChem (substance) 2 272690 272690 7
943357 943357 302358 302358 CAS Common Chemistry 3 17122 17122 1
1112559 1112559 302358 302358 CAS Common Chemistry 3 22602 22602 2
1112560 1112560 302358 302358 CAS Common Chemistry 3 31930 31930 3
1140991 1140991 302358 302358 Computational Toxicology and Exposure Data 4 17122 17122 3
1323304 1323304 302358 302358 Computational Toxicology and Exposure Data 4 99115 99115 1
1323305 1323305 302358 302358 Computational Toxicology and Exposure Data 4 108049 108049 2 
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)
);