api_results

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

11 rows where query_id = 104615

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21440 21440 104615 104615 PubChem (compound) 1 46104 46104 1
326126 326126 104615 104615 PubChem (substance) 2 46104 46104 1
426409 426409 104615 104615 PubChem (substance) 2 34224 34224 2
478078 478078 104615 104615 PubChem (substance) 2 13326 13326 3
771168 771168 104615 104615 PubChem (substance) 2 232056 232056 4
771171 771171 104615 104615 PubChem (substance) 2 232109 232109 5
771173 771173 104615 104615 PubChem (substance) 2 181424 181424 6
771178 771178 104615 104615 PubChem (substance) 2 169937 169937 7
771180 771180 104615 104615 PubChem (substance) 2 192099 192099 8
954021 954021 104615 104615 CAS Common Chemistry 3 46104 46104 1
1153497 1153497 104615 104615 Computational Toxicology and Exposure Data 4 46104 46104 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)
);