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 = 57307

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
56771 56771 140569 140569 PubChem (compound) 1 57307 57307 1
56772 56772 25798 25798 PubChem (compound) 1 57307 57307 1
56773 56773 25799 25799 PubChem (compound) 1 57307 57307 1
56774 56774 239123 239123 PubChem (compound) 1 57307 57307 1
56775 56775 341125 341125 PubChem (compound) 1 57307 57307 1
56776 56776 365350 365350 PubChem (compound) 1 57307 57307 1
376039 376039 25799 25799 PubChem (substance) 2 57307 57307 1
376040 376040 25798 25798 PubChem (substance) 2 57307 57307 1
376041 376041 341125 341125 PubChem (substance) 2 57307 57307 1
376042 376042 140569 140569 PubChem (substance) 2 57307 57307 1
376043 376043 365350 365350 PubChem (substance) 2 57307 57307 1
376044 376044 239123 239123 PubChem (substance) 2 57307 57307 1
376045 376045 308287 308287 PubChem (substance) 2 57307 57307 1
979681 979681 25799 25799 CAS Common Chemistry 3 57307 57307 1
979682 979682 25798 25798 CAS Common Chemistry 3 57307 57307 1
979683 979683 140569 140569 CAS Common Chemistry 3 57307 57307 1
979684 979684 365350 365350 CAS Common Chemistry 3 57307 57307 1
979685 979685 239123 239123 CAS Common Chemistry 3 57307 57307 1
979686 979686 341125 341125 CAS Common Chemistry 3 57307 57307 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 939.576ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website