api_results

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

9 rows where query_id = 14115

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
29263 29263 14115 14115 PubChem (compound) 1 1539 1539 1
337234 337234 14115 14115 PubChem (substance) 2 1539 1539 1
552722 552722 14115 14115 PubChem (substance) 2 139501 139501 6
666892 666892 14115 14115 PubChem (substance) 2 15476 15476 5
711821 711821 14115 14115 PubChem (substance) 2 208154 208154 2
711823 711823 14115 14115 PubChem (substance) 2 223685 223685 3
711824 711824 14115 14115 PubChem (substance) 2 204878 204878 4
959670 959670 14115 14115 CAS Common Chemistry 3 1539 1539 1
1160237 1160237 14115 14115 Computational Toxicology and Exposure Data 4 1539 1539 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)
);