home / zeropm-v0-0-4

api_results

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

59 rows where query_id = 145199

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
165230 165230 145199 145199 PubChem (compound) 1 75302 75302 1
165232 165232 145199 145199 PubChem (compound) 1 228298 228298 2
165235 165235 145199 145199 PubChem (compound) 1 259629 259629 3
165236 165236 145199 145199 PubChem (compound) 1 183996 183996 4
165239 165239 145199 145199 PubChem (compound) 1 185652 185652 5
165242 165242 145199 145199 PubChem (compound) 1 253767 253767 6
165244 165244 145199 145199 PubChem (compound) 1 190029 190029 7
165248 165248 145199 145199 PubChem (compound) 1 194710 194710 8
165250 165250 145199 145199 PubChem (compound) 1 200366 200366 9
165251 165251 145199 145199 PubChem (compound) 1 224103 224103 10
165252 165252 145199 145199 PubChem (compound) 1 251116 251116 11
165253 165253 145199 145199 PubChem (compound) 1 262813 262813 12
165254 165254 145199 145199 PubChem (compound) 1 282872 282872 13
165256 165256 145199 145199 PubChem (compound) 1 326634 326634 14
165259 165259 145199 145199 PubChem (compound) 1 169201 169201 15
165261 165261 145199 145199 PubChem (compound) 1 177665 177665 16
165262 165262 145199 145199 PubChem (compound) 1 215648 215648 17
165264 165264 145199 145199 PubChem (compound) 1 256269 256269 18
165266 165266 145199 145199 PubChem (compound) 1 265816 265816 19
165268 165268 145199 145199 PubChem (compound) 1 273974 273974 20
165272 165272 145199 145199 PubChem (compound) 1 277635 277635 21
165274 165274 145199 145199 PubChem (compound) 1 315639 315639 22
165276 165276 145199 145199 PubChem (compound) 1 320781 320781 23
165277 165277 145199 145199 PubChem (compound) 1 321411 321411 24
525162 525162 145199 145199 PubChem (substance) 2 75302 75302 1
525165 525165 145199 145199 PubChem (substance) 2 228298 228298 2
525168 525168 145199 145199 PubChem (substance) 2 259629 259629 3
525170 525170 145199 145199 PubChem (substance) 2 183996 183996 4
525176 525176 145199 145199 PubChem (substance) 2 185652 185652 5
525178 525178 145199 145199 PubChem (substance) 2 253767 253767 6
525182 525182 145199 145199 PubChem (substance) 2 190029 190029 8
525187 525187 145199 145199 PubChem (substance) 2 194710 194710 7
525190 525190 145199 145199 PubChem (substance) 2 200366 200366 13
525194 525194 145199 145199 PubChem (substance) 2 224103 224103 20
525195 525195 145199 145199 PubChem (substance) 2 251116 251116 12
525199 525199 145199 145199 PubChem (substance) 2 262813 262813 9
525203 525203 145199 145199 PubChem (substance) 2 282872 282872 19
525207 525207 145199 145199 PubChem (substance) 2 326634 326634 18
525211 525211 145199 145199 PubChem (substance) 2 169201 169201 32
525212 525212 145199 145199 PubChem (substance) 2 177665 177665 25
525214 525214 145199 145199 PubChem (substance) 2 215648 215648 22
525216 525216 145199 145199 PubChem (substance) 2 256269 256269 27
525218 525218 145199 145199 PubChem (substance) 2 265816 265816 28
525221 525221 145199 145199 PubChem (substance) 2 273974 273974 26
525224 525224 145199 145199 PubChem (substance) 2 277635 277635 21
525228 525228 145199 145199 PubChem (substance) 2 315639 315639 33
525229 525229 145199 145199 PubChem (substance) 2 320781 320781 30
525231 525231 145199 145199 PubChem (substance) 2 321411 321411 31
690850 690850 145199 145199 PubChem (substance) 2 254018 254018 15
801902 801902 145199 145199 PubChem (substance) 2 315689 315689 10
801906 801906 145199 145199 PubChem (substance) 2 243370 243370 11
801911 801911 145199 145199 PubChem (substance) 2 241515 241515 14
801914 801914 145199 145199 PubChem (substance) 2 259346 259346 16
801920 801920 145199 145199 PubChem (substance) 2 261923 261923 17
801922 801922 145199 145199 PubChem (substance) 2 287943 287943 23
801924 801924 145199 145199 PubChem (substance) 2 285367 285367 24
801928 801928 145199 145199 PubChem (substance) 2 320457 320457 29
1059112 1059112 145199 145199 CAS Common Chemistry 3 75302 75302 1
1261681 1261681 145199 145199 Computational Toxicology and Exposure Data 4 75302 75302 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 536.227ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website