api_results

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

9 rows where query_id = 155685

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
174943 174943 155685 155685 PubChem (compound) 1 15193 15193 1
533239 533239 155685 155685 PubChem (substance) 2 121808 121808 6
538380 538380 155685 155685 PubChem (substance) 2 15193 15193 1
809244 809244 155685 155685 PubChem (substance) 2 168978 168978 2
809248 809248 155685 155685 PubChem (substance) 2 136344 136344 3
809249 809249 155685 155685 PubChem (substance) 2 201796 201796 4
809250 809250 155685 155685 PubChem (substance) 2 233164 233164 5
1066663 1066663 155685 155685 CAS Common Chemistry 3 15193 15193 1
1268297 1268297 155685 155685 Computational Toxicology and Exposure Data 4 15193 15193 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)
);