home / zeropm-v0-0-4

api_results

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

295,480 rows where api_id = 1

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
1 1 1 1 PubChem (compound) 1 6210 6210 1
2 2 109036 109036 PubChem (compound) 1 6210 6210 1
3 3 2 2 PubChem (compound) 1 6210 6210 1
4 4 3 3 PubChem (compound) 1 6210 6210 1
5 5 329167 329167 PubChem (compound) 1 6210 6210 1
6 6 437017 437017 PubChem (compound) 1 6210 6210 1
7 7 34440 34440 PubChem (compound) 1 101901 101901 1
8 8 7 7 PubChem (compound) 1 101901 101901 1
9 9 5 5 PubChem (compound) 1 101901 101901 1
10 10 4 4 PubChem (compound) 1 101901 101901 1
11 11 34134 34134 PubChem (compound) 1 101901 101901 1
12 12 4 4 PubChem (compound) 1 84835 84835 2
13 13 12858 12858 PubChem (compound) 1 84835 84835 1
14 14 106786 106786 PubChem (compound) 1 84835 84835 1
15 15 12859 12859 PubChem (compound) 1 84835 84835 1
16 16 436151 436151 PubChem (compound) 1 84835 84835 1
17 17 4 4 PubChem (compound) 1 27484 27484 3
18 18 4 4 PubChem (compound) 1 256988 256988 4
19 19 60444 60444 PubChem (compound) 1 75314 75314 1
20 20 9 9 PubChem (compound) 1 75314 75314 1
21 21 227422 227422 PubChem (compound) 1 75314 75314 1
22 22 11 11 PubChem (compound) 1 103118 103118 1
23 23 442196 442196 PubChem (compound) 1 6859 6859 2
24 24 69317 69317 PubChem (compound) 1 6859 6859 1
25 25 1440 1440 PubChem (compound) 1 6859 6859 1
26 26 360995 360995 PubChem (compound) 1 6859 6859 1
27 27 2370 2370 PubChem (compound) 1 6859 6859 1
28 28 23543 23543 PubChem (compound) 1 6859 6859 1
29 29 13 13 PubChem (compound) 1 6859 6859 1
30 30 1442 1442 PubChem (compound) 1 6859 6859 1
31 31 360994 360994 PubChem (compound) 1 6859 6859 1
32 32 2371 2371 PubChem (compound) 1 6859 6859 1
33 33 69318 69318 PubChem (compound) 1 6859 6859 1
34 34 1441 1441 PubChem (compound) 1 6859 6859 1
35 35 2375 2375 PubChem (compound) 1 6859 6859 1
36 36 237308 237308 PubChem (compound) 1 6859 6859 1
37 37 1443 1443 PubChem (compound) 1 6859 6859 1
38 38 1444 1444 PubChem (compound) 1 6859 6859 1
39 39 437097 437097 PubChem (compound) 1 6859 6859 1
40 40 2372 2372 PubChem (compound) 1 6859 6859 1
41 41 2374 2374 PubChem (compound) 1 6859 6859 1
42 42 2373 2373 PubChem (compound) 1 6859 6859 1
43 43 325405 325405 PubChem (compound) 1 6859 6859 1
44 44 2376 2376 PubChem (compound) 1 6859 6859 1
45 45 329652 329652 PubChem (compound) 1 6859 6859 1
46 46 68474 68474 PubChem (compound) 1 29879 29879 1
47 47 14 14 PubChem (compound) 1 29879 29879 1
48 48 302476 302476 PubChem (compound) 1 29879 29879 1
49 49 104096 104096 PubChem (compound) 1 29879 29879 1
50 50 312750 312750 PubChem (compound) 1 29879 29879 1
51 51 16 16 PubChem (compound) 1 6790 6790 1
52 52 403657 403657 PubChem (compound) 1 3684 3684 1
53 53 18 18 PubChem (compound) 1 3684 3684 1
54 54 104312 104312 PubChem (compound) 1 3684 3684 1
55 55 323328 323328 PubChem (compound) 1 3684 3684 1
56 56 19 19 PubChem (compound) 1 3684 3684 1
57 57 21 21 PubChem (compound) 1 3684 3684 1
58 58 22 22 PubChem (compound) 1 3684 3684 1
59 59 301262 301262 PubChem (compound) 1 3684 3684 1
60 60 20 20 PubChem (compound) 1 3684 3684 1
61 61 108426 108426 PubChem (compound) 1 3684 3684 1
62 62 66262 66262 PubChem (compound) 1 3684 3684 1
63 63 348658 348658 PubChem (compound) 1 3684 3684 1
64 64 24 24 PubChem (compound) 1 3684 3684 1
65 65 323329 323329 PubChem (compound) 1 3684 3684 1
66 66 348659 348659 PubChem (compound) 1 3684 3684 1
67 67 13134 13134 PubChem (compound) 1 90489 90489 2
68 68 27 27 PubChem (compound) 1 90489 90489 1
69 69 327134 327134 PubChem (compound) 1 90489 90489 2
70 70 28 28 PubChem (compound) 1 90489 90489 1
71 71 230674 230674 PubChem (compound) 1 90489 90489 1
72 72 29 29 PubChem (compound) 1 90489 90489 2
73 73 374886 374886 PubChem (compound) 1 90489 90489 2
74 74 69221 69221 PubChem (compound) 1 90489 90489 1
75 75 27 27 PubChem (compound) 1 186436 186436 2
76 76 13134 13134 PubChem (compound) 1 186436 186436 1
77 77 28 28 PubChem (compound) 1 186436 186436 2
78 78 374886 374886 PubChem (compound) 1 186436 186436 1
79 79 327134 327134 PubChem (compound) 1 186436 186436 1
80 80 29 29 PubChem (compound) 1 186436 186436 1
81 81 230674 230674 PubChem (compound) 1 186436 186436 2
82 82 104446 104446 PubChem (compound) 1 186437 186437 1
83 83 374883 374883 PubChem (compound) 1 186437 186437 1
84 84 13134 13134 PubChem (compound) 1 186437 186437 3
85 85 27 27 PubChem (compound) 1 186437 186437 3
86 86 374884 374884 PubChem (compound) 1 186437 186437 1
87 87 301100 301100 PubChem (compound) 1 186437 186437 1
88 88 374885 374885 PubChem (compound) 1 186437 186437 1
89 89 374886 374886 PubChem (compound) 1 186437 186437 3
90 90 327134 327134 PubChem (compound) 1 186437 186437 3
91 91 30 30 PubChem (compound) 1 186437 186437 1
92 92 28 28 PubChem (compound) 1 186437 186437 3
93 93 230674 230674 PubChem (compound) 1 186437 186437 3
94 94 29 29 PubChem (compound) 1 186437 186437 3
95 95 107172 107172 PubChem (compound) 1 186437 186437 1
96 96 32 32 PubChem (compound) 1 16367 16367 1
97 97 33 33 PubChem (compound) 1 16367 16367 1
98 98 101619 101619 PubChem (compound) 1 16367 16367 1
99 99 34 34 PubChem (compound) 1 16367 16367 1
100 100 324359 324359 PubChem (compound) 1 16367 16367 1

Next page

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 351.767ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website