api_results

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

11 rows where query_id = 71397

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107530 107530 71397 71397 PubChem (compound) 1 242204 242204 1
447705 447705 71397 71397 PubChem (substance) 2 242204 242204 1
708412 708412 71397 71397 PubChem (substance) 2 248688 248688 2
757320 757320 71397 71397 PubChem (substance) 2 248591 248591 3
757322 757322 71397 71397 PubChem (substance) 2 248858 248858 4
757324 757324 71397 71397 PubChem (substance) 2 248606 248606 5
757325 757325 71397 71397 PubChem (substance) 2 248685 248685 6
757327 757327 71397 71397 PubChem (substance) 2 248632 248632 7
757329 757329 71397 71397 PubChem (substance) 2 292829 292829 8
1017006 1017006 71397 71397 CAS Common Chemistry 3 55060 55060 1
1219267 1219267 71397 71397 Computational Toxicology and Exposure Data 4 55060 55060 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)
);