api_results

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

10 rows where query_id = 171867

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
190544 190544 171867 171867 PubChem (compound) 1 35158 35158 1
326104 326104 171867 171867 PubChem (substance) 2 46097 46097 3
353466 353466 171867 171867 PubChem (substance) 2 57065 57065 6
558602 558602 171867 171867 PubChem (substance) 2 132579 132579 7
558611 558611 171867 171867 PubChem (substance) 2 35158 35158 1
772865 772865 171867 171867 PubChem (substance) 2 171697 171697 2
818774 818774 171867 171867 PubChem (substance) 2 177865 177865 4
818779 818779 171867 171867 PubChem (substance) 2 173893 173893 5
1077404 1077404 171867 171867 CAS Common Chemistry 3 35158 35158 1
1278822 1278822 171867 171867 Computational Toxicology and Exposure Data 4 35158 35158 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)
);