api_results

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

18 rows where query_id = 78179

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
23895 23895 78179 78179 PubChem (compound) 1 78294 78294 1
329934 329934 78179 78179 PubChem (substance) 2 78294 78294 1
329937 329937 78179 78179 PubChem (substance) 2 192483 192483 14
329945 329945 78179 78179 PubChem (substance) 2 142478 142478 2
329952 329952 78179 78179 PubChem (substance) 2 78295 78295 4
626832 626832 78179 78179 PubChem (substance) 2 19817 19817 13
709449 709449 78179 78179 PubChem (substance) 2 138817 138817 3
709452 709452 78179 78179 PubChem (substance) 2 235218 235218 7
709456 709456 78179 78179 PubChem (substance) 2 291886 291886 12
759562 759562 78179 78179 PubChem (substance) 2 186400 186400 5
759563 759563 78179 78179 PubChem (substance) 2 215573 215573 6
759564 759564 78179 78179 PubChem (substance) 2 270447 270447 8
759565 759565 78179 78179 PubChem (substance) 2 270453 270453 9
759566 759566 78179 78179 PubChem (substance) 2 270458 270458 10
759568 759568 78179 78179 PubChem (substance) 2 136705 136705 11
759570 759570 78179 78179 PubChem (substance) 2 313888 313888 15
759571 759571 78179 78179 PubChem (substance) 2 212791 212791 16
1155742 1155742 78179 78179 Computational Toxicology and Exposure Data 4 78294 78294 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)
);