api_results

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

7 rows where inchi_id = 78430

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
717977 717977 19056 19056 PubChem (substance) 2 78430 78430 5
717978 717978 119274 119274 PubChem (substance) 2 78430 78430 2
969169 969169 19056 19056 CAS Common Chemistry 3 78430 78430 1
969170 969170 405646 405646 CAS Common Chemistry 3 78430 78430 1
969171 969171 19057 19057 CAS Common Chemistry 3 78430 78430 1
969172 969172 438495 438495 CAS Common Chemistry 3 78430 78430 1
969173 969173 304815 304815 CAS Common Chemistry 3 78430 78430 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)
);