home / zeropm-v0-0-4

api_results

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

27 rows where inchi_id = 45550

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
157007 157007 142580 142580 PubChem (compound) 1 45550 45550 1
157008 157008 327374 327374 PubChem (compound) 1 45550 45550 1
157009 157009 136902 136902 PubChem (compound) 1 45550 45550 1
157010 157010 136901 136901 PubChem (compound) 1 45550 45550 1
157011 157011 238032 238032 PubChem (compound) 1 45550 45550 1
514349 514349 67065 67065 PubChem (substance) 2 45550 45550 2
514350 514350 67066 67066 PubChem (substance) 2 45550 45550 1
514351 514351 153881 153881 PubChem (substance) 2 45550 45550 2
514352 514352 31996 31996 PubChem (substance) 2 45550 45550 4
514353 514353 337232 337232 PubChem (substance) 2 45550 45550 3
514354 514354 136902 136902 PubChem (substance) 2 45550 45550 1
514355 514355 136901 136901 PubChem (substance) 2 45550 45550 1
514356 514356 137009 137009 PubChem (substance) 2 45550 45550 2
514357 514357 354299 354299 PubChem (substance) 2 45550 45550 7
514358 514358 156434 156434 PubChem (substance) 2 45550 45550 7
514359 514359 142581 142581 PubChem (substance) 2 45550 45550 1
514360 514360 142580 142580 PubChem (substance) 2 45550 45550 1
514361 514361 194208 194208 PubChem (substance) 2 45550 45550 2
514362 514362 327374 327374 PubChem (substance) 2 45550 45550 1
514363 514363 302338 302338 PubChem (substance) 2 45550 45550 7
514364 514364 153882 153882 PubChem (substance) 2 45550 45550 2
514365 514365 238032 238032 PubChem (substance) 2 45550 45550 1
514366 514366 153883 153883 PubChem (substance) 2 45550 45550 2
1053011 1053011 142580 142580 CAS Common Chemistry 3 45550 45550 1
1053012 1053012 327374 327374 CAS Common Chemistry 3 45550 45550 1
1053013 1053013 136902 136902 CAS Common Chemistry 3 45550 45550 1
1053014 1053014 136901 136901 CAS Common Chemistry 3 45550 45550 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 759.884ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website