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 = 22957

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
51101 51101 22957 22957 PubChem (compound) 1 134715 134715 1
51108 51108 22957 22957 PubChem (compound) 1 78515 78515 2
51109 51109 22957 22957 PubChem (compound) 1 314068 314068 3
368138 368138 22957 22957 PubChem (substance) 2 134715 134715 1
368146 368146 22957 22957 PubChem (substance) 2 78515 78515 3
368147 368147 22957 22957 PubChem (substance) 2 314068 314068 4
470833 470833 22957 22957 PubChem (substance) 2 26866 26866 12
722302 722302 22957 22957 PubChem (substance) 2 222425 222425 2
722308 722308 22957 22957 PubChem (substance) 2 198880 198880 5
722310 722310 22957 22957 PubChem (substance) 2 236807 236807 6
722313 722313 22957 22957 PubChem (substance) 2 134715 134715 7
722315 722315 22957 22957 PubChem (substance) 2 317309 317309 8
722319 722319 22957 22957 PubChem (substance) 2 248442 248442 9
722324 722324 22957 22957 PubChem (substance) 2 35526 35526 10
722325 722325 22957 22957 PubChem (substance) 2 198951 198951 11
722327 722327 22957 22957 PubChem (substance) 2 216107 216107 13
975333 975333 22957 22957 CAS Common Chemistry 3 35526 35526 1
1178100 1178100 22957 22957 Computational Toxicology and Exposure Data 4 134715 134715 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 456.616ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website