api_results

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

8 rows where query_id = 399658

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
282056 282056 399658 399658 PubChem (compound) 1 102841 102841 1
351193 351193 399658 399658 PubChem (substance) 2 50914 50914 6
436150 436150 399658 399658 PubChem (substance) 2 50319 50319 2
643919 643919 399658 399658 PubChem (substance) 2 46639 46639 4
652051 652051 399658 399658 PubChem (substance) 2 209303 209303 5
674981 674981 399658 399658 PubChem (substance) 2 102841 102841 1
932005 932005 399658 399658 PubChem (substance) 2 229538 229538 3
1338357 1338357 399658 399658 Computational Toxicology and Exposure Data 4 102841 102841 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)
);