home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 138692

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113483 113483 138692 138692 PubChem (compound) 1 51123 51123 1
298716 298716 138692 138692 PubChem (substance) 2 3739 3739 7
310170 310170 138692 138692 PubChem (substance) 2 2666 2666 5
310208 310208 138692 138692 PubChem (substance) 2 3721 3721 6
340024 340024 138692 138692 PubChem (substance) 2 3734 3734 13
340154 340154 138692 138692 PubChem (substance) 2 4032 4032 23
340217 340217 138692 138692 PubChem (substance) 2 4040 4040 2
341433 341433 138692 138692 PubChem (substance) 2 4055 4055 12
341501 341501 138692 138692 PubChem (substance) 2 4065 4065 10
360716 360716 138692 138692 PubChem (substance) 2 51792 51792 22
370683 370683 138692 138692 PubChem (substance) 2 129387 129387 4
371344 371344 138692 138692 PubChem (substance) 2 44389 44389 21
395505 395505 138692 138692 PubChem (substance) 2 25158 25158 20
425120 425120 138692 138692 PubChem (substance) 2 160 160 8
428935 428935 138692 138692 PubChem (substance) 2 2963 2963 17
455706 455706 138692 138692 PubChem (substance) 2 51123 51123 1
514690 514690 138692 138692 PubChem (substance) 2 46505 46505 9
524164 524164 138692 138692 PubChem (substance) 2 73177 73177 11
761783 761783 138692 138692 PubChem (substance) 2 221356 221356 3
761786 761786 138692 138692 PubChem (substance) 2 275381 275381 14
761787 761787 138692 138692 PubChem (substance) 2 275382 275382 15
761789 761789 138692 138692 PubChem (substance) 2 275383 275383 16
761791 761791 138692 138692 PubChem (substance) 2 221729 221729 18
761793 761793 138692 138692 PubChem (substance) 2 294639 294639 19
1021144 1021144 138692 138692 CAS Common Chemistry 3 51123 51123 1
1223593 1223593 138692 138692 Computational Toxicology and Exposure Data 4 51123 51123 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 412.115ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website