api_results

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

8 rows where inchi_id = 88759

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
233344 233344 222295 222295 PubChem (compound) 1 88759 88759 1
233345 233345 222296 222296 PubChem (compound) 1 88759 88759 1
612639 612639 11679 11679 PubChem (substance) 2 88759 88759 13
612640 612640 358783 358783 PubChem (substance) 2 88759 88759 13
612641 612641 11048 11048 PubChem (substance) 2 88759 88759 13
612642 612642 222296 222296 PubChem (substance) 2 88759 88759 1
612643 612643 222295 222295 PubChem (substance) 2 88759 88759 1
1105370 1105370 222295 222295 CAS Common Chemistry 3 88759 88759 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)
);