api_results

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

11 rows where query_id = 331677

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
262702 262702 331677 331677 PubChem (compound) 1 11592 11592 1
262703 262703 331677 331677 PubChem (compound) 1 242070 242070 2
262704 262704 331677 331677 PubChem (compound) 1 159448 159448 3
262705 262705 331677 331677 PubChem (compound) 1 125771 125771 4
529120 529120 331677 331677 PubChem (substance) 2 126639 126639 5
648650 648650 331677 331677 PubChem (substance) 2 11592 11592 1
648652 648652 331677 331677 PubChem (substance) 2 242070 242070 2
648656 648656 331677 331677 PubChem (substance) 2 159448 159448 3
648657 648657 331677 331677 PubChem (substance) 2 125771 125771 4
1114658 1114658 331677 331677 CAS Common Chemistry 3 11592 11592 1
1325992 1325992 331677 331677 Computational Toxicology and Exposure Data 4 125771 125771 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)
);