api_results

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

8 rows where query_id = 44599

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
84335 84335 44599 44599 PubChem (compound) 1 125358 125358 1
414998 414998 44599 44599 PubChem (substance) 2 125358 125358 1
740416 740416 44599 44599 PubChem (substance) 2 318533 318533 2
740418 740418 44599 44599 PubChem (substance) 2 125358 125358 3
740420 740420 44599 44599 PubChem (substance) 2 251990 251990 4
740423 740423 44599 44599 PubChem (substance) 2 68586 68586 5
999862 999862 44599 44599 CAS Common Chemistry 3 68586 68586 1
1202867 1202867 44599 44599 Computational Toxicology and Exposure Data 4 125358 125358 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)
);