api_results

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

11 rows where query_id = 192195

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
209613 209613 192195 192195 PubChem (compound) 1 196072 196072 1
209615 209615 192195 192195 PubChem (compound) 1 139964 139964 2
209616 209616 192195 192195 PubChem (compound) 1 63615 63615 3
209617 209617 192195 192195 PubChem (compound) 1 200475 200475 4
209620 209620 192195 192195 PubChem (compound) 1 326582 326582 5
583046 583046 192195 192195 PubChem (substance) 2 196072 196072 1
583049 583049 192195 192195 PubChem (substance) 2 139964 139964 2
583051 583051 192195 192195 PubChem (substance) 2 63615 63615 3
583052 583052 192195 192195 PubChem (substance) 2 200475 200475 5
583054 583054 192195 192195 PubChem (substance) 2 326582 326582 4
1090440 1090440 192195 192195 CAS Common Chemistry 3 63615 63615 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)
);