api_results

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

19 rows where query_id = 389558

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
277712 277712 389558 389558 PubChem (compound) 1 7141 7141 1
669376 669376 389558 389558 PubChem (substance) 2 7140 7140 3
669379 669379 389558 389558 PubChem (substance) 2 7141 7141 1
708722 708722 389558 389558 PubChem (substance) 2 314109 314109 5
926811 926811 389558 389558 PubChem (substance) 2 314983 314983 2
926812 926812 389558 389558 PubChem (substance) 2 238088 238088 4
926813 926813 389558 389558 PubChem (substance) 2 238088 238088 6
926814 926814 389558 389558 PubChem (substance) 2 7141 7141 7
926815 926815 389558 389558 PubChem (substance) 2 246713 246713 8
926816 926816 389558 389558 PubChem (substance) 2 263236 263236 9
926817 926817 389558 389558 PubChem (substance) 2 263236 263236 10
926818 926818 389558 389558 PubChem (substance) 2 314983 314983 11
926819 926819 389558 389558 PubChem (substance) 2 317485 317485 12
926820 926820 389558 389558 PubChem (substance) 2 315731 315731 13
926821 926821 389558 389558 PubChem (substance) 2 294545 294545 14
926822 926822 389558 389558 PubChem (substance) 2 316847 316847 15
926823 926823 389558 389558 PubChem (substance) 2 315563 315563 16
1122095 1122095 389558 389558 CAS Common Chemistry 3 7141 7141 1
1335726 1335726 389558 389558 Computational Toxicology and Exposure Data 4 7141 7141 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)
);