api_results

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

9 rows where query_id = 32432

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
67544 67544 32432 32432 PubChem (compound) 1 126179 126179 1
67546 67546 32432 32432 PubChem (compound) 1 193647 193647 2
369779 369779 32432 32432 PubChem (substance) 2 192711 192711 3
391966 391966 32432 32432 PubChem (substance) 2 126179 126179 2
391970 391970 32432 32432 PubChem (substance) 2 193647 193647 1
732755 732755 32432 32432 PubChem (substance) 2 193647 193647 4
732756 732756 32432 32432 PubChem (substance) 2 18363 18363 5
987974 987974 32432 32432 CAS Common Chemistry 3 18363 18363 1
1190850 1190850 32432 32432 Computational Toxicology and Exposure Data 4 126179 126179 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)
);