api_results

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

12 rows where query_id = 173542

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
192216 192216 173542 173542 PubChem (compound) 1 37298 37298 1
560830 560830 173542 173542 PubChem (substance) 2 37298 37298 1
659383 659383 173542 173542 PubChem (substance) 2 37293 37293 3
668469 668469 173542 173542 PubChem (substance) 2 188522 188522 8
746528 746528 173542 173542 PubChem (substance) 2 136896 136896 9
819786 819786 173542 173542 PubChem (substance) 2 195245 195245 2
819787 819787 173542 173542 PubChem (substance) 2 189000 189000 4
819789 819789 173542 173542 PubChem (substance) 2 190416 190416 5
819790 819790 173542 173542 PubChem (substance) 2 206021 206021 6
819791 819791 173542 173542 PubChem (substance) 2 215473 215473 7
1078490 1078490 173542 173542 CAS Common Chemistry 3 37298 37298 1
1279931 1279931 173542 173542 Computational Toxicology and Exposure Data 4 37298 37298 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)
);