api_results

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

12 rows where query_id = 24819

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
54927 54927 24819 24819 PubChem (compound) 1 129649 129649 1
373376 373376 24819 24819 PubChem (substance) 2 129649 129649 1
724290 724290 24819 24819 PubChem (substance) 2 273145 273145 2
724292 724292 24819 24819 PubChem (substance) 2 232713 232713 3
724293 724293 24819 24819 PubChem (substance) 2 333364 333364 4
724294 724294 24819 24819 PubChem (substance) 2 129649 129649 5
724295 724295 24819 24819 PubChem (substance) 2 232719 232719 6
724296 724296 24819 24819 PubChem (substance) 2 232713 232713 7
724298 724298 24819 24819 PubChem (substance) 2 263700 263700 8
724300 724300 24819 24819 PubChem (substance) 2 60272 60272 9
978309 978309 24819 24819 CAS Common Chemistry 3 60272 60272 1
1181220 1181220 24819 24819 Computational Toxicology and Exposure Data 4 129649 129649 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)
);