api_results

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

11 rows where query_id = 152293

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
171554 171554 152293 152293 PubChem (compound) 1 10856 10856 1
533853 533853 152293 152293 PubChem (substance) 2 10856 10856 1
806672 806672 152293 152293 PubChem (substance) 2 183475 183475 2
806673 806673 152293 152293 PubChem (substance) 2 326778 326778 3
806676 806676 152293 152293 PubChem (substance) 2 258779 258779 4
806678 806678 152293 152293 PubChem (substance) 2 238460 238460 5
806679 806679 152293 152293 PubChem (substance) 2 250896 250896 6
806680 806680 152293 152293 PubChem (substance) 2 227639 227639 7
1064194 1064194 152293 152293 CAS Common Chemistry 3 10856 10856 1
1266075 1266075 152293 152293 Computational Toxicology and Exposure Data 4 108943 108943 2
1266076 1266076 152293 152293 Computational Toxicology and Exposure Data 4 105488 105488 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)
);