home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 120654

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140558 140558 120654 120654 PubChem (compound) 1 248910 248910 1
140559 140559 120654 120654 PubChem (compound) 1 248966 248966 2
140560 140560 120654 120654 PubChem (compound) 1 248716 248716 3
140561 140561 120654 120654 PubChem (compound) 1 328595 328595 4
140562 140562 120654 120654 PubChem (compound) 1 308192 308192 5
140563 140563 120654 120654 PubChem (compound) 1 326685 326685 6
429807 429807 120654 120654 PubChem (substance) 2 248640 248640 7
492842 492842 120654 120654 PubChem (substance) 2 248910 248910 1
492844 492844 120654 120654 PubChem (substance) 2 248966 248966 2
492845 492845 120654 120654 PubChem (substance) 2 248716 248716 4
492846 492846 120654 120654 PubChem (substance) 2 328595 328595 6
492848 492848 120654 120654 PubChem (substance) 2 308192 308192 13
492850 492850 120654 120654 PubChem (substance) 2 326685 326685 14
652366 652366 120654 120654 PubChem (substance) 2 248567 248567 8
785387 785387 120654 120654 PubChem (substance) 2 248727 248727 3
785388 785388 120654 120654 PubChem (substance) 2 248748 248748 5
785391 785391 120654 120654 PubChem (substance) 2 248890 248890 11
785393 785393 120654 120654 PubChem (substance) 2 288102 288102 12
785395 785395 120654 120654 PubChem (substance) 2 248689 248689 9
785396 785396 120654 120654 PubChem (substance) 2 248573 248573 10
785397 785397 120654 120654 PubChem (substance) 2 331101 331101 15
1040574 1040574 120654 120654 CAS Common Chemistry 3 91531 91531 1
1243560 1243560 120654 120654 Computational Toxicology and Exposure Data 4 133553 133553 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 442.876ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website