home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 170

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
165881 165881 327532 327532 PubChem (compound) 1 170 170 1
165882 165882 146289 146289 PubChem (compound) 1 170 170 1
165883 165883 240658 240658 PubChem (compound) 1 170 170 1
165884 165884 146290 146290 PubChem (compound) 1 170 170 1
526052 526052 240658 240658 PubChem (substance) 2 170 170 1
526053 526053 327532 327532 PubChem (substance) 2 170 170 1
526054 526054 10349 10349 PubChem (substance) 2 170 170 5
526055 526055 146290 146290 PubChem (substance) 2 170 170 1
526056 526056 146289 146289 PubChem (substance) 2 170 170 1
526057 526057 429598 429598 PubChem (substance) 2 170 170 4
1059526 1059526 146289 146289 CAS Common Chemistry 3 170 170 1
1059527 1059527 327532 327532 CAS Common Chemistry 3 170 170 1
1059528 1059528 240658 240658 CAS Common Chemistry 3 170 170 1
1059529 1059529 146290 146290 CAS Common Chemistry 3 170 170 1
1262082 1262082 146289 146289 Computational Toxicology and Exposure Data 4 170 170 1
1262083 1262083 240658 240658 Computational Toxicology and Exposure Data 4 170 170 1
1262084 1262084 146290 146290 Computational Toxicology and Exposure Data 4 170 170 1
1262085 1262085 327532 327532 Computational Toxicology and Exposure Data 4 170 170 2
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 497.403ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website