api_results

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

12 rows where query_id = 14476

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3110 3110 14476 14476 PubChem (compound) 1 2895 2895 1
299830 299830 14476 14476 PubChem (substance) 2 2895 2895 1
338056 338056 14476 14476 PubChem (substance) 2 2600 2600 7
346880 346880 14476 14476 PubChem (substance) 2 28018 28018 3
390781 390781 14476 14476 PubChem (substance) 2 16051 16051 5
627136 627136 14476 14476 PubChem (substance) 2 20954 20954 4
692304 692304 14476 14476 PubChem (substance) 2 145047 145047 2
694457 694457 14476 14476 PubChem (substance) 2 169875 169875 6
712185 712185 14476 14476 PubChem (substance) 2 136745 136745 8
712189 712189 14476 14476 PubChem (substance) 2 94627 94627 9
940352 940352 14476 14476 CAS Common Chemistry 3 2895 2895 1
1137491 1137491 14476 14476 Computational Toxicology and Exposure Data 4 2895 2895 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)
);