api_results

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

22 rows where query_id = 83802

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45092 45092 83802 83802 PubChem (compound) 1 10872 10872 1
45099 45099 83802 83802 PubChem (compound) 1 188062 188062 2
113712 113712 83802 83802 PubChem (compound) 1 284744 284744 3
359978 359978 83802 83802 PubChem (substance) 2 10872 10872 1
359992 359992 83802 83802 PubChem (substance) 2 138375 138375 6
360000 360000 83802 83802 PubChem (substance) 2 136608 136608 3
360015 360015 83802 83802 PubChem (substance) 2 188062 188062 2
360025 360025 83802 83802 PubChem (substance) 2 246747 246747 11
360029 360029 83802 83802 PubChem (substance) 2 230904 230904 8
360038 360038 83802 83802 PubChem (substance) 2 240719 240719 10
360049 360049 83802 83802 PubChem (substance) 2 241752 241752 14
456097 456097 83802 83802 PubChem (substance) 2 284744 284744 17
719707 719707 83802 83802 PubChem (substance) 2 250733 250733 13
719720 719720 83802 83802 PubChem (substance) 2 200265 200265 4
719724 719724 83802 83802 PubChem (substance) 2 217308 217308 7
719736 719736 83802 83802 PubChem (substance) 2 260068 260068 5
719750 719750 83802 83802 PubChem (substance) 2 237274 237274 9
719772 719772 83802 83802 PubChem (substance) 2 288705 288705 12
719784 719784 83802 83802 PubChem (substance) 2 288896 288896 15
719787 719787 83802 83802 PubChem (substance) 2 189566 189566 16
970885 970885 83802 83802 CAS Common Chemistry 3 10872 10872 1
1173410 1173410 83802 83802 Computational Toxicology and Exposure Data 4 10872 10872 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)
);