api_results

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

15 rows where query_id = 104589

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124508 124508 104589 104589 PubChem (compound) 1 45341 45341 1
471325 471325 104589 104589 PubChem (substance) 2 45341 45341 1
651692 651692 104589 104589 PubChem (substance) 2 137001 137001 2
651697 651697 104589 104589 PubChem (substance) 2 173721 173721 9
771111 771111 104589 104589 PubChem (substance) 2 234751 234751 3
771112 771112 104589 104589 PubChem (substance) 2 259184 259184 4
771114 771114 104589 104589 PubChem (substance) 2 210806 210806 5
771117 771117 104589 104589 PubChem (substance) 2 189189 189189 6
771118 771118 104589 104589 PubChem (substance) 2 173916 173916 7
771120 771120 104589 104589 PubChem (substance) 2 251008 251008 8
771121 771121 104589 104589 PubChem (substance) 2 227400 227400 10
771122 771122 104589 104589 PubChem (substance) 2 258380 258380 11
771125 771125 104589 104589 PubChem (substance) 2 237276 237276 12
1028370 1028370 104589 104589 CAS Common Chemistry 3 45341 45341 1
1231164 1231164 104589 104589 Computational Toxicology and Exposure Data 4 45341 45341 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)
);