api_results

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

10 rows where inchi_id = 43179

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
155645 155645 135533 135533 PubChem (compound) 1 43179 43179 1
155646 155646 135534 135534 PubChem (compound) 1 43179 43179 1
155647 155647 237566 237566 PubChem (compound) 1 43179 43179 1
512600 512600 23856 23856 PubChem (substance) 2 43179 43179 9
512601 512601 135533 135533 PubChem (substance) 2 43179 43179 1
512602 512602 135534 135534 PubChem (substance) 2 43179 43179 1
512603 512603 237566 237566 PubChem (substance) 2 43179 43179 1
1051995 1051995 135534 135534 CAS Common Chemistry 3 43179 43179 1
1051996 1051996 135533 135533 CAS Common Chemistry 3 43179 43179 1
1051997 1051997 237566 237566 CAS Common Chemistry 3 43179 43179 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)
);