api_results

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

8 rows where query_id = 18876

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41944 41944 18876 18876 PubChem (compound) 1 143328 143328 1
41947 41947 18876 18876 PubChem (compound) 1 74274 74274 2
355397 355397 18876 18876 PubChem (substance) 2 143328 143328 1
355399 355399 18876 18876 PubChem (substance) 2 74274 74274 2
717784 717784 18876 18876 PubChem (substance) 2 332889 332889 3
717785 717785 18876 18876 PubChem (substance) 2 141309 141309 4
968847 968847 18876 18876 CAS Common Chemistry 3 74274 74274 1
1170997 1170997 18876 18876 Computational Toxicology and Exposure Data 4 100687 100687 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)
);