api_results

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

10 rows where query_id = 92795

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
118714 118714 92795 92795 PubChem (compound) 1 38145 38145 1
363702 363702 92795 92795 PubChem (substance) 2 312 312 3
463122 463122 92795 92795 PubChem (substance) 2 38145 38145 1
463225 463225 92795 92795 PubChem (substance) 2 16940 16940 4
651083 651083 92795 92795 PubChem (substance) 2 22148 22148 2
766325 766325 92795 92795 PubChem (substance) 2 188347 188347 5
766327 766327 92795 92795 PubChem (substance) 2 157795 157795 6
766329 766329 92795 92795 PubChem (substance) 2 266840 266840 7
972753 972753 92795 92795 CAS Common Chemistry 3 38145 38145 1
1227193 1227193 92795 92795 Computational Toxicology and Exposure Data 4 38145 38145 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)
);