api_results

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

13 rows where inchi_id = 58092

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
136621 136621 117056 117056 PubChem (compound) 1 58092 58092 1
136622 136622 117055 117055 PubChem (compound) 1 58092 58092 1
136623 136623 407888 407888 PubChem (compound) 1 58092 58092 1
487663 487663 117055 117055 PubChem (substance) 2 58092 58092 1
487664 487664 126 126 PubChem (substance) 2 58092 58092 26
487665 487665 407888 407888 PubChem (substance) 2 58092 58092 1
487666 487666 117056 117056 PubChem (substance) 2 58092 58092 1
1037545 1037545 407888 407888 CAS Common Chemistry 3 58092 58092 1
1037546 1037546 117055 117055 CAS Common Chemistry 3 58092 58092 1
1037547 1037547 117056 117056 CAS Common Chemistry 3 58092 58092 1
1240542 1240542 117055 117055 Computational Toxicology and Exposure Data 4 58092 58092 1
1240543 1240543 117056 117056 Computational Toxicology and Exposure Data 4 58092 58092 1
1240544 1240544 407888 407888 Computational Toxicology and Exposure Data 4 58092 58092 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)
);