api_results

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

11 rows where query_id = 163812

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
183048 183048 163812 163812 PubChem (compound) 1 25250 25250 1
183050 183050 163812 163812 PubChem (compound) 1 212040 212040 2
183051 183051 163812 163812 PubChem (compound) 1 258422 258422 3
183052 183052 163812 163812 PubChem (compound) 1 188532 188532 4
548722 548722 163812 163812 PubChem (substance) 2 25250 25250 1
548725 548725 163812 163812 PubChem (substance) 2 212040 212040 2
548727 548727 163812 163812 PubChem (substance) 2 258422 258422 3
548729 548729 163812 163812 PubChem (substance) 2 188532 188532 4
814134 814134 163812 163812 PubChem (substance) 2 172772 172772 5
1072520 1072520 163812 163812 CAS Common Chemistry 3 25250 25250 1
1273869 1273869 163812 163812 Computational Toxicology and Exposure Data 4 25250 25250 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)
);