api_results

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

10 rows where query_id = 179756

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
198097 198097 179756 179756 PubChem (compound) 1 46758 46758 1
521776 521776 179756 179756 PubChem (substance) 2 62743 62743 7
530533 530533 179756 179756 PubChem (substance) 2 8060 8060 5
563329 563329 179756 179756 PubChem (substance) 2 39817 39817 2
568210 568210 179756 179756 PubChem (substance) 2 46758 46758 1
572552 572552 179756 179756 PubChem (substance) 2 75318 75318 3
822781 822781 179756 179756 PubChem (substance) 2 278172 278172 4
822783 822783 179756 179756 PubChem (substance) 2 179174 179174 6
1082597 1082597 179756 179756 CAS Common Chemistry 3 46758 46758 1
1284189 1284189 179756 179756 Computational Toxicology and Exposure Data 4 46758 46758 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)
);