home / zeropm-v0-0-4

api_results

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

70 rows where query_id = 150315

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102685 102685 150315 150315 PubChem (compound) 1 119329 119329 1
102694 102694 150315 150315 PubChem (compound) 1 314709 314709 2
102698 102698 150315 150315 PubChem (compound) 1 315696 315696 5
102700 102700 150315 150315 PubChem (compound) 1 314600 314600 8
102705 102705 150315 150315 PubChem (compound) 1 315581 315581 3
102710 102710 150315 150315 PubChem (compound) 1 314302 314302 7
102712 102712 150315 150315 PubChem (compound) 1 315701 315701 11
102718 102718 150315 150315 PubChem (compound) 1 315688 315688 9
102721 102721 150315 150315 PubChem (compound) 1 316303 316303 6
102724 102724 150315 150315 PubChem (compound) 1 316921 316921 13
102727 102727 150315 150315 PubChem (compound) 1 317329 317329 15
102730 102730 150315 150315 PubChem (compound) 1 317547 317547 16
102734 102734 150315 150315 PubChem (compound) 1 318147 318147 17
102738 102738 150315 150315 PubChem (compound) 1 318244 318244 18
102741 102741 150315 150315 PubChem (compound) 1 318325 318325 19
102746 102746 150315 150315 PubChem (compound) 1 318385 318385 20
102750 102750 150315 150315 PubChem (compound) 1 329621 329621 21
112576 112576 150315 150315 PubChem (compound) 1 8701 8701 4
112579 112579 150315 150315 PubChem (compound) 1 317326 317326 14
169584 169584 150315 150315 PubChem (compound) 1 314216 314216 10
169586 169586 150315 150315 PubChem (compound) 1 315716 315716 12
307502 307502 150315 150315 PubChem (substance) 2 78315 78315 23
441034 441034 150315 150315 PubChem (substance) 2 119329 119329 1
441049 441049 150315 150315 PubChem (substance) 2 314709 314709 2
441056 441056 150315 150315 PubChem (substance) 2 315696 315696 5
441067 441067 150315 150315 PubChem (substance) 2 314600 314600 9
441072 441072 150315 150315 PubChem (substance) 2 315581 315581 3
441082 441082 150315 150315 PubChem (substance) 2 314302 314302 7
441085 441085 150315 150315 PubChem (substance) 2 315701 315701 13
441098 441098 150315 150315 PubChem (substance) 2 315686 315686 20
441102 441102 150315 150315 PubChem (substance) 2 315688 315688 8
441106 441106 150315 150315 PubChem (substance) 2 316303 316303 6
441111 441111 150315 150315 PubChem (substance) 2 316921 316921 44
441113 441113 150315 150315 PubChem (substance) 2 317329 317329 37
441117 441117 150315 150315 PubChem (substance) 2 317547 317547 30
441121 441121 150315 150315 PubChem (substance) 2 318147 318147 47
441125 441125 150315 150315 PubChem (substance) 2 318244 318244 41
441130 441130 150315 150315 PubChem (substance) 2 318325 318325 43
441132 441132 150315 150315 PubChem (substance) 2 318385 318385 42
441136 441136 150315 150315 PubChem (substance) 2 329621 329621 45
454532 454532 150315 150315 PubChem (substance) 2 8701 8701 4
454542 454542 150315 150315 PubChem (substance) 2 317326 317326 36
531182 531182 150315 150315 PubChem (substance) 2 314216 314216 10
531189 531189 150315 150315 PubChem (substance) 2 315716 315716 15
752860 752860 150315 150315 PubChem (substance) 2 315702 315702 24
752864 752864 150315 150315 PubChem (substance) 2 317023 317023 27
752886 752886 150315 150315 PubChem (substance) 2 315090 315090 31
752895 752895 150315 150315 PubChem (substance) 2 315098 315098 12
752907 752907 150315 150315 PubChem (substance) 2 317895 317895 32
752919 752919 150315 150315 PubChem (substance) 2 317838 317838 33
752928 752928 150315 150315 PubChem (substance) 2 317948 317948 34
752933 752933 150315 150315 PubChem (substance) 2 318014 318014 35
752938 752938 150315 150315 PubChem (substance) 2 318058 318058 39
752944 752944 150315 150315 PubChem (substance) 2 317881 317881 40
761108 761108 150315 150315 PubChem (substance) 2 315060 315060 11
761116 761116 150315 150315 PubChem (substance) 2 119329 119329 14
805160 805160 150315 150315 PubChem (substance) 2 207698 207698 16
805162 805162 150315 150315 PubChem (substance) 2 207700 207700 17
805165 805165 150315 150315 PubChem (substance) 2 315561 315561 18
805167 805167 150315 150315 PubChem (substance) 2 315677 315677 19
805168 805168 150315 150315 PubChem (substance) 2 315640 315640 21
805170 805170 150315 150315 PubChem (substance) 2 315641 315641 22
805173 805173 150315 150315 PubChem (substance) 2 246889 246889 25
805175 805175 150315 150315 PubChem (substance) 2 207688 207688 26
805176 805176 150315 150315 PubChem (substance) 2 261263 261263 28
805178 805178 150315 150315 PubChem (substance) 2 320680 320680 29
805181 805181 150315 150315 PubChem (substance) 2 274096 274096 38
805182 805182 150315 150315 PubChem (substance) 2 261264 261264 46
1013767 1013767 150315 150315 CAS Common Chemistry 3 8701 8701 1
1215923 1215923 150315 150315 Computational Toxicology and Exposure Data 4 119329 119329 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 1413.024ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website