api_results

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

9 rows where query_id = 346041

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
266344 266344 346041 346041 PubChem (compound) 1 96761 96761 1
654668 654668 346041 346041 PubChem (substance) 2 96761 96761 1
846551 846551 346041 346041 PubChem (substance) 2 176770 176770 6
914336 914336 346041 346041 PubChem (substance) 2 95290 95290 2
914337 914337 346041 346041 PubChem (substance) 2 90135 90135 3
914338 914338 346041 346041 PubChem (substance) 2 248066 248066 4
914339 914339 346041 346041 PubChem (substance) 2 243127 243127 5
1116099 1116099 346041 346041 CAS Common Chemistry 3 90135 90135 1
1328168 1328168 346041 346041 Computational Toxicology and Exposure Data 4 95290 95290 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)
);