home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 117303

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94296 94296 117303 117303 PubChem (compound) 1 52201 52201 3
106922 106922 117303 117303 PubChem (compound) 1 101762 101762 1
106929 106929 117303 117303 PubChem (compound) 1 101762 101762 2
136902 136902 117303 117303 PubChem (compound) 1 101762 101762 4
136905 136905 117303 117303 PubChem (compound) 1 58727 58727 6
136908 136908 117303 117303 PubChem (compound) 1 225217 225217 7
136909 136909 117303 117303 PubChem (compound) 1 137346 137346 5
428886 428886 117303 117303 PubChem (substance) 2 52201 52201 3
446912 446912 117303 117303 PubChem (substance) 2 101762 101762 1
446922 446922 117303 117303 PubChem (substance) 2 101762 101762 2
488015 488015 117303 117303 PubChem (substance) 2 101762 101762 4
488017 488017 117303 117303 PubChem (substance) 2 58727 58727 6
488022 488022 117303 117303 PubChem (substance) 2 225217 225217 7
488024 488024 117303 117303 PubChem (substance) 2 137346 137346 5
1016604 1016604 117303 117303 CAS Common Chemistry 3 58727 58727 1
1218815 1218815 117303 117303 Computational Toxicology and Exposure Data 4 101762 101762 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 422.785ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website