home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 5093

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
643 643 5093 5093 PubChem (compound) 1 136630 136630 3
647 647 5093 5093 PubChem (compound) 1 157922 157922 4
9477 9477 5093 5093 PubChem (compound) 1 208688 208688 1
9480 9480 5093 5093 PubChem (compound) 1 137995 137995 2
9481 9481 5093 5093 PubChem (compound) 1 282402 282402 5
9482 9482 5093 5093 PubChem (compound) 1 208690 208690 6
9483 9483 5093 5093 PubChem (compound) 1 255646 255646 7
296453 296453 5093 5093 PubChem (substance) 2 208689 208689 7
296465 296465 5093 5093 PubChem (substance) 2 136630 136630 5
296474 296474 5093 5093 PubChem (substance) 2 157922 157922 4
308756 308756 5093 5093 PubChem (substance) 2 208688 208688 1
308761 308761 5093 5093 PubChem (substance) 2 137995 137995 2
308768 308768 5093 5093 PubChem (substance) 2 282402 282402 6
308769 308769 5093 5093 PubChem (substance) 2 208690 208690 9
308771 308771 5093 5093 PubChem (substance) 2 255646 255646 8
479859 479859 5093 5093 PubChem (substance) 2 37918 37918 3
699048 699048 5093 5093 PubChem (substance) 2 183206 183206 10
945188 945188 5093 5093 CAS Common Chemistry 3 43831 43831 2
945191 945191 5093 5093 CAS Common Chemistry 3 37918 37918 1
1143127 1143127 5093 5093 Computational Toxicology and Exposure Data 4 43831 43831 2
1143128 1143128 5093 5093 Computational Toxicology and Exposure Data 4 125518 125518 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 440.966ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website