api_results

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

12 rows where inchi_id = 9542

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
128978 128978 109867 109867 PubChem (compound) 1 9542 9542 1
128979 128979 406759 406759 PubChem (compound) 1 9542 9542 1
128980 128980 109868 109868 PubChem (compound) 1 9542 9542 1
477426 477426 109867 109867 PubChem (substance) 2 9542 9542 1
477427 477427 69740 69740 PubChem (substance) 2 9542 9542 2
477428 477428 109868 109868 PubChem (substance) 2 9542 9542 1
477429 477429 406759 406759 PubChem (substance) 2 9542 9542 1
1031644 1031644 109867 109867 CAS Common Chemistry 3 9542 9542 1
1031645 1031645 406759 406759 CAS Common Chemistry 3 9542 9542 1
1031646 1031646 109868 109868 CAS Common Chemistry 3 9542 9542 1
1234548 1234548 109867 109867 Computational Toxicology and Exposure Data 4 9542 9542 1
1234549 1234549 406759 406759 Computational Toxicology and Exposure Data 4 9542 9542 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)
);