home / zeropm-v0-0-4

api_results

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

15 rows where inchi_id = 17507

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
120522 120522 96590 96590 PubChem (compound) 1 17507 17507 1
120523 120523 96591 96591 PubChem (compound) 1 17507 17507 1
465647 465647 16486 16486 PubChem (substance) 2 17507 17507 2
465648 465648 96613 96613 PubChem (substance) 2 17507 17507 3
465649 465649 96590 96590 PubChem (substance) 2 17507 17507 1
465650 465650 96591 96591 PubChem (substance) 2 17507 17507 1
465651 465651 358625 358625 PubChem (substance) 2 17507 17507 3
964221 964221 16486 16486 CAS Common Chemistry 3 17507 17507 1
964222 964222 404651 404651 CAS Common Chemistry 3 17507 17507 1
964223 964223 96613 96613 CAS Common Chemistry 3 17507 17507 1
964224 964224 358625 358625 CAS Common Chemistry 3 17507 17507 1
964225 964225 312497 312497 CAS Common Chemistry 3 17507 17507 1
964226 964226 16487 16487 CAS Common Chemistry 3 17507 17507 1
1025908 1025908 96590 96590 CAS Common Chemistry 3 17507 17507 1
1025909 1025909 96591 96591 CAS Common Chemistry 3 17507 17507 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 1013.788ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website