api_results

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

11 rows where query_id = 30710

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
64408 64408 30710 30710 PubChem (compound) 1 125186 125186 1
387482 387482 30710 30710 PubChem (substance) 2 125186 125186 1
526095 526095 30710 30710 PubChem (substance) 2 231 231 7
674121 674121 30710 30710 PubChem (substance) 2 123556 123556 4
730934 730934 30710 30710 PubChem (substance) 2 125186 125186 2
730936 730936 30710 30710 PubChem (substance) 2 10334 10334 3
730939 730939 30710 30710 PubChem (substance) 2 258513 258513 5
730940 730940 30710 30710 PubChem (substance) 2 280397 280397 6
730941 730941 30710 30710 PubChem (substance) 2 241663 241663 8
985601 985601 30710 30710 CAS Common Chemistry 3 10334 10334 1
1188543 1188543 30710 30710 Computational Toxicology and Exposure Data 4 125186 125186 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)
);