home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 16630

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
23700 23700 16630 16630 PubChem (compound) 1 77512 77512 3
36135 36135 16630 16630 PubChem (compound) 1 133163 133163 1
36142 36142 16630 16630 PubChem (compound) 1 37114 37114 2
329672 329672 16630 16630 PubChem (substance) 2 77512 77512 7
347349 347349 16630 16630 PubChem (substance) 2 133163 133163 1
347355 347355 16630 16630 PubChem (substance) 2 37114 37114 4
650977 650977 16630 16630 PubChem (substance) 2 184959 184959 2
653606 653606 16630 16630 PubChem (substance) 2 230295 230295 3
653610 653610 16630 16630 PubChem (substance) 2 237600 237600 8
653612 653612 16630 16630 PubChem (substance) 2 309498 309498 12
709356 709356 16630 16630 PubChem (substance) 2 235151 235151 13
715130 715130 16630 16630 PubChem (substance) 2 251506 251506 5
715133 715133 16630 16630 PubChem (substance) 2 235219 235219 6
715137 715137 16630 16630 PubChem (substance) 2 150458 150458 9
715140 715140 16630 16630 PubChem (substance) 2 288683 288683 10
715145 715145 16630 16630 PubChem (substance) 2 288692 288692 11
964536 964536 16630 16630 CAS Common Chemistry 3 37114 37114 1
1166148 1166148 16630 16630 Computational Toxicology and Exposure Data 4 133163 133163 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 468.444ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website