api_results

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

11 rows where query_id = 123741

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
143751 143751 123741 123741 PubChem (compound) 1 13672 13672 1
143752 143752 123741 123741 PubChem (compound) 1 186702 186702 2
143753 143753 123741 123741 PubChem (compound) 1 181649 181649 3
143754 143754 123741 123741 PubChem (compound) 1 179628 179628 4
143755 143755 123741 123741 PubChem (compound) 1 289454 289454 5
497166 497166 123741 123741 PubChem (substance) 2 13672 13672 1
497169 497169 123741 123741 PubChem (substance) 2 186702 186702 2
497170 497170 123741 123741 PubChem (substance) 2 181649 181649 3
497171 497171 123741 123741 PubChem (substance) 2 179628 179628 4
497173 497173 123741 123741 PubChem (substance) 2 289454 289454 5
1042863 1042863 123741 123741 CAS Common Chemistry 3 13672 13672 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)
);