api_results

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

10 rows where inchi_id = 27659

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
53805 53805 24305 24305 PubChem (compound) 1 27659 27659 3
53806 53806 24304 24304 PubChem (compound) 1 27659 27659 4
53807 53807 362347 362347 PubChem (compound) 1 27659 27659 1
371840 371840 24304 24304 PubChem (substance) 2 27659 27659 4
371841 371841 137055 137055 PubChem (substance) 2 27659 27659 3
371842 371842 59693 59693 PubChem (substance) 2 27659 27659 20
371843 371843 24305 24305 PubChem (substance) 2 27659 27659 3
371844 371844 362347 362347 PubChem (substance) 2 27659 27659 1
371845 371845 411759 411759 PubChem (substance) 2 27659 27659 2
1116932 1116932 362346 362346 CAS Common Chemistry 3 27659 27659 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)
);