home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 9879

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18713 18713 9879 9879 PubChem (compound) 1 7812 7812 2
18756 18756 9879 9879 PubChem (compound) 1 56289 56289 1
18757 18757 9879 9879 PubChem (compound) 1 216127 216127 3
18762 18762 9879 9879 PubChem (compound) 1 217035 217035 4
322105 322105 9879 9879 PubChem (substance) 2 7812 7812 5
322173 322173 9879 9879 PubChem (substance) 2 56289 56289 1
322179 322179 9879 9879 PubChem (substance) 2 216127 216127 4
322186 322186 9879 9879 PubChem (substance) 2 217035 217035 7
484715 484715 9879 9879 PubChem (substance) 2 177859 177859 12
677341 677341 9879 9879 PubChem (substance) 2 195790 195790 15
705291 705291 9879 9879 PubChem (substance) 2 225334 225334 2
705296 705296 9879 9879 PubChem (substance) 2 177699 177699 3
705298 705298 9879 9879 PubChem (substance) 2 253189 253189 6
705300 705300 9879 9879 PubChem (substance) 2 173830 173830 8
705302 705302 9879 9879 PubChem (substance) 2 332650 332650 9
705304 705304 9879 9879 PubChem (substance) 2 237761 237761 10
705306 705306 9879 9879 PubChem (substance) 2 259480 259480 11
705309 705309 9879 9879 PubChem (substance) 2 225334 225334 13
705312 705312 9879 9879 PubChem (substance) 2 178304 178304 14
705315 705315 9879 9879 PubChem (substance) 2 320474 320474 16
705316 705316 9879 9879 PubChem (substance) 2 290050 290050 17
705317 705317 9879 9879 PubChem (substance) 2 178304 178304 18
705318 705318 9879 9879 PubChem (substance) 2 329549 329549 19
952156 952156 9879 9879 CAS Common Chemistry 3 56289 56289 1
1151371 1151371 9879 9879 Computational Toxicology and Exposure Data 4 56289 56289 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 418.965ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website