api_results

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

8 rows where inchi_id = 16764

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
66969 66969 32108 32108 PubChem (compound) 1 16764 16764 3
391189 391189 32108 32108 PubChem (substance) 2 16764 16764 3
391190 391190 156888 156888 PubChem (substance) 2 16764 16764 3
391191 391191 32109 32109 PubChem (substance) 2 16764 16764 1
987488 987488 32108 32108 CAS Common Chemistry 3 16764 16764 1
987489 987489 156888 156888 CAS Common Chemistry 3 16764 16764 1
987490 987490 32109 32109 CAS Common Chemistry 3 16764 16764 1
987491 987491 415956 415956 CAS Common Chemistry 3 16764 16764 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)
);