api_results

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

13 rows where inchi_id = 62690

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
80735 80735 307501 307501 PubChem (compound) 1 62690 62690 1
80736 80736 41678 41678 PubChem (compound) 1 62690 62690 1
80737 80737 41679 41679 PubChem (compound) 1 62690 62690 1
80738 80738 191386 191386 PubChem (compound) 1 62690 62690 1
410052 410052 41679 41679 PubChem (substance) 2 62690 62690 1
410053 410053 41678 41678 PubChem (substance) 2 62690 62690 1
410054 410054 191387 191387 PubChem (substance) 2 62690 62690 2
410055 410055 307501 307501 PubChem (substance) 2 62690 62690 1
410056 410056 191386 191386 PubChem (substance) 2 62690 62690 1
997226 997226 41679 41679 CAS Common Chemistry 3 62690 62690 1
997227 997227 41678 41678 CAS Common Chemistry 3 62690 62690 1
997228 997228 191386 191386 CAS Common Chemistry 3 62690 62690 1
997229 997229 307501 307501 CAS Common Chemistry 3 62690 62690 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)
);