home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 339668

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
36501 36501 339668 339668 PubChem (compound) 1 136255 136255 2
131134 131134 339668 339668 PubChem (compound) 1 40664 40664 1
347808 347808 339668 339668 PubChem (substance) 2 43676 43676 12
347841 347841 339668 339668 PubChem (substance) 2 136255 136255 4
350372 350372 339668 339668 PubChem (substance) 2 49388 49388 2
480324 480324 339668 339668 PubChem (substance) 2 40664 40664 1
618438 618438 339668 339668 PubChem (substance) 2 49387 49387 13
716289 716289 339668 339668 PubChem (substance) 2 138111 138111 3
716294 716294 339668 339668 PubChem (substance) 2 150509 150509 11
912442 912442 339668 339668 PubChem (substance) 2 202200 202200 5
912443 912443 339668 339668 PubChem (substance) 2 195971 195971 6
912444 912444 339668 339668 PubChem (substance) 2 202138 202138 7
912445 912445 339668 339668 PubChem (substance) 2 169826 169826 8
912446 912446 339668 339668 PubChem (substance) 2 169983 169983 9
912447 912447 339668 339668 PubChem (substance) 2 202679 202679 10
966045 966045 339668 339668 CAS Common Chemistry 3 49388 49388 1
1167902 1167902 339668 339668 Computational Toxicology and Exposure Data 4 49388 49388 2
1327000 1327000 339668 339668 Computational Toxicology and Exposure Data 4 106105 106105 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)
);
Powered by Datasette · Queries took 1162.102ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website