home / zeropm-v0-0-4

api_results

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

29 rows where query_id = 123292

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
133137 133137 123292 123292 PubChem (compound) 1 47316 47316 5
133141 133141 123292 123292 PubChem (compound) 1 137097 137097 2
143233 143233 123292 123292 PubChem (compound) 1 11858 11858 1
143235 143235 123292 123292 PubChem (compound) 1 169284 169284 3
143239 143239 123292 123292 PubChem (compound) 1 196023 196023 6
143241 143241 123292 123292 PubChem (compound) 1 196020 196020 4
143242 143242 123292 123292 PubChem (compound) 1 192358 192358 7
143243 143243 123292 123292 PubChem (compound) 1 298060 298060 8
143244 143244 123292 123292 PubChem (compound) 1 266547 266547 9
344881 344881 123292 123292 PubChem (substance) 2 108509 108509 9
483042 483042 123292 123292 PubChem (substance) 2 47316 47316 6
483047 483047 123292 123292 PubChem (substance) 2 137097 137097 2
496468 496468 123292 123292 PubChem (substance) 2 11858 11858 1
496472 496472 123292 123292 PubChem (substance) 2 169284 169284 3
496473 496473 123292 123292 PubChem (substance) 2 208046 208046 14
496478 496478 123292 123292 PubChem (substance) 2 196023 196023 5
496480 496480 123292 123292 PubChem (substance) 2 196020 196020 4
496482 496482 123292 123292 PubChem (substance) 2 192358 192358 7
496483 496483 123292 123292 PubChem (substance) 2 298060 298060 8
496484 496484 123292 123292 PubChem (substance) 2 266547 266547 12
761901 761901 123292 123292 PubChem (substance) 2 181335 181335 10
787643 787643 123292 123292 PubChem (substance) 2 217187 217187 11
787647 787647 123292 123292 PubChem (substance) 2 144687 144687 13
787649 787649 123292 123292 PubChem (substance) 2 309732 309732 15
787651 787651 123292 123292 PubChem (substance) 2 310008 310008 16
787655 787655 123292 123292 PubChem (substance) 2 288013 288013 17
787656 787656 123292 123292 PubChem (substance) 2 184244 184244 18
1042458 1042458 123292 123292 CAS Common Chemistry 3 11858 11858 1
1245397 1245397 123292 123292 Computational Toxicology and Exposure Data 4 11858 11858 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 511.735ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website