home / zeropm-v0-0-4

api_results

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

19 rows where inchi_id = 40422

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
135295 135295 134057 134057 PubChem (compound) 1 40422 40422 1
135296 135296 115823 115823 PubChem (compound) 1 40422 40422 1
135297 135297 232383 232383 PubChem (compound) 1 40422 40422 1
135298 135298 134056 134056 PubChem (compound) 1 40422 40422 1
485975 485975 134056 134056 PubChem (substance) 2 40422 40422 1
485976 485976 115824 115824 PubChem (substance) 2 40422 40422 1
485977 485977 57945 57945 PubChem (substance) 2 40422 40422 9
485978 485978 115823 115823 PubChem (substance) 2 40422 40422 1
485979 485979 134057 134057 PubChem (substance) 2 40422 40422 1
485980 485980 246680 246680 PubChem (substance) 2 40422 40422 2
485981 485981 232383 232383 PubChem (substance) 2 40422 40422 1
485982 485982 246679 246679 PubChem (substance) 2 40422 40422 3
485983 485983 246682 246682 PubChem (substance) 2 40422 40422 2
485984 485984 401356 401356 PubChem (substance) 2 40422 40422 2
485985 485985 246681 246681 PubChem (substance) 2 40422 40422 2
1036459 1036459 134056 134056 CAS Common Chemistry 3 40422 40422 1
1036460 1036460 232383 232383 CAS Common Chemistry 3 40422 40422 1
1036461 1036461 115823 115823 CAS Common Chemistry 3 40422 40422 1
1036462 1036462 134057 134057 CAS Common Chemistry 3 40422 40422 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)
);
Powered by Datasette · Queries took 1347.563ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website