home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 104114

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
220 220 104114 104114 PubChem (compound) 1 74053 74053 1
295804 295804 104114 104114 PubChem (substance) 2 74053 74053 1
411899 411899 104114 104114 PubChem (substance) 2 65005 65005 16
422686 422686 104114 104114 PubChem (substance) 2 88275 88275 20
498040 498040 104114 104114 PubChem (substance) 2 15740 15740 6
517231 517231 104114 104114 PubChem (substance) 2 52262 52262 13
587557 587557 104114 104114 PubChem (substance) 2 66167 66167 17
589280 589280 104114 104114 PubChem (substance) 2 67204 67204 18
600672 600672 104114 104114 PubChem (substance) 2 80608 80608 19
692105 692105 104114 104114 PubChem (substance) 2 203379 203379 2
692108 692108 104114 104114 PubChem (substance) 2 208110 208110 3
692111 692111 104114 104114 PubChem (substance) 2 208033 208033 4
692114 692114 104114 104114 PubChem (substance) 2 149161 149161 5
692117 692117 104114 104114 PubChem (substance) 2 244357 244357 7
692119 692119 104114 104114 PubChem (substance) 2 187958 187958 8
692122 692122 104114 104114 PubChem (substance) 2 215453 215453 9
692125 692125 104114 104114 PubChem (substance) 2 210249 210249 10
692129 692129 104114 104114 PubChem (substance) 2 272877 272877 11
692131 692131 104114 104114 PubChem (substance) 2 187800 187800 12
692134 692134 104114 104114 PubChem (substance) 2 192227 192227 14
692137 692137 104114 104114 PubChem (substance) 2 211245 211245 15
938307 938307 104114 104114 CAS Common Chemistry 3 74053 74053 1
1134943 1134943 104114 104114 Computational Toxicology and Exposure Data 4 74053 74053 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 511.927ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website