api_results

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

14 rows where query_id = 24304

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
53795 53795 24304 24304 PubChem (compound) 1 46206 46206 1
53799 53799 24304 24304 PubChem (compound) 1 46206 46206 2
53803 53803 24304 24304 PubChem (compound) 1 184036 184036 3
53806 53806 24304 24304 PubChem (compound) 1 27659 27659 4
371828 371828 24304 24304 PubChem (substance) 2 46206 46206 1
371832 371832 24304 24304 PubChem (substance) 2 46206 46206 2
371838 371838 24304 24304 PubChem (substance) 2 184036 184036 3
371840 371840 24304 24304 PubChem (substance) 2 27659 27659 4
656556 656556 24304 24304 PubChem (substance) 2 109286 109286 8
723703 723703 24304 24304 PubChem (substance) 2 214700 214700 5
723704 723704 24304 24304 PubChem (substance) 2 156887 156887 6
723705 723705 24304 24304 PubChem (substance) 2 281846 281846 7
977488 977488 24304 24304 CAS Common Chemistry 3 46206 46206 1
1180338 1180338 24304 24304 Computational Toxicology and Exposure Data 4 46206 46206 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)
);