home / zeropm-v0-0-4

api_results

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

42 rows where query_id = 354727

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
32197 32197 354727 354727 PubChem (compound) 1 4065 4065 1
295810 295810 354727 354727 PubChem (substance) 2 74053 74053 28
298725 298725 354727 354727 PubChem (substance) 2 3739 3739 27
303373 303373 354727 354727 PubChem (substance) 2 58549 58549 19
303407 303407 354727 354727 PubChem (substance) 2 55050 55050 17
303750 303750 354727 354727 PubChem (substance) 2 3505 3505 12
305570 305570 354727 354727 PubChem (substance) 2 2054 2054 14
305762 305762 354727 354727 PubChem (substance) 2 60355 60355 20
305904 305904 354727 354727 PubChem (substance) 2 3513 3513 2
306134 306134 354727 354727 PubChem (substance) 2 49259 49259 18
309345 309345 354727 354727 PubChem (substance) 2 3690 3690 9
310172 310172 354727 354727 PubChem (substance) 2 2666 2666 13
310204 310204 354727 354727 PubChem (substance) 2 3721 3721 3
340029 340029 354727 354727 PubChem (substance) 2 3734 3734 15
340159 340159 354727 354727 PubChem (substance) 2 4032 4032 6
340216 340216 354727 354727 PubChem (substance) 2 4040 4040 7
340245 340245 354727 354727 PubChem (substance) 2 4041 4041 4
341417 341417 354727 354727 PubChem (substance) 2 4055 4055 5
341486 341486 354727 354727 PubChem (substance) 2 4065 4065 1
425109 425109 354727 354727 PubChem (substance) 2 160 160 35
455317 455317 354727 354727 PubChem (substance) 2 3349 3349 34
514680 514680 354727 354727 PubChem (substance) 2 46505 46505 16
699924 699924 354727 354727 PubChem (substance) 2 270351 270351 25
758538 758538 354727 354727 PubChem (substance) 2 271544 271544 36
765784 765784 354727 354727 PubChem (substance) 2 169668 169668 8
765787 765787 354727 354727 PubChem (substance) 2 215521 215521 10
765790 765790 354727 354727 PubChem (substance) 2 217731 217731 11
765793 765793 354727 354727 PubChem (substance) 2 258405 258405 21
765794 765794 354727 354727 PubChem (substance) 2 225665 225665 22
765797 765797 354727 354727 PubChem (substance) 2 262702 262702 23
765802 765802 354727 354727 PubChem (substance) 2 270350 270350 24
765803 765803 354727 354727 PubChem (substance) 2 219476 219476 26
765806 765806 354727 354727 PubChem (substance) 2 153040 153040 29
765809 765809 354727 354727 PubChem (substance) 2 288593 288593 30
765814 765814 354727 354727 PubChem (substance) 2 297854 297854 31
765816 765816 354727 354727 PubChem (substance) 2 241334 241334 32
765823 765823 354727 354727 PubChem (substance) 2 209810 209810 33
765826 765826 354727 354727 PubChem (substance) 2 220250 220250 37
765830 765830 354727 354727 PubChem (substance) 2 331054 331054 38
765832 765832 354727 354727 PubChem (substance) 2 340350 340350 39
961662 961662 354727 354727 CAS Common Chemistry 3 4065 4065 1
1162720 1162720 354727 354727 Computational Toxicology and Exposure Data 4 4065 4065 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 453.276ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website