api_results

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

11 rows where query_id = 359431

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21442 21442 359431 359431 PubChem (compound) 1 46104 46104 1
326134 326134 359431 359431 PubChem (substance) 2 46104 46104 1
426415 426415 359431 359431 PubChem (substance) 2 34224 34224 2
478077 478077 359431 359431 PubChem (substance) 2 13326 13326 3
771169 771169 359431 359431 PubChem (substance) 2 232056 232056 4
771172 771172 359431 359431 PubChem (substance) 2 232109 232109 5
771174 771174 359431 359431 PubChem (substance) 2 181424 181424 6
771177 771177 359431 359431 PubChem (substance) 2 169937 169937 7
771179 771179 359431 359431 PubChem (substance) 2 192099 192099 8
954019 954019 359431 359431 CAS Common Chemistry 3 46104 46104 1
1153499 1153499 359431 359431 Computational Toxicology and Exposure Data 4 46104 46104 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)
);