api_results

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

9 rows where query_id = 339751

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
264781 264781 339751 339751 PubChem (compound) 1 208269 208269 1
442596 442596 339751 339751 PubChem (substance) 2 46090 46090 8
652020 652020 339751 339751 PubChem (substance) 2 208269 208269 1
912465 912465 339751 339751 PubChem (substance) 2 224801 224801 2
912466 912466 339751 339751 PubChem (substance) 2 206169 206169 3
912467 912467 339751 339751 PubChem (substance) 2 174792 174792 4
912469 912469 339751 339751 PubChem (substance) 2 196275 196275 5
912470 912470 339751 339751 PubChem (substance) 2 288141 288141 6
912471 912471 339751 339751 PubChem (substance) 2 325232 325232 7 
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)
);