api_results

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

12 rows where query_id = 20295

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
44985 44985 20295 20295 PubChem (compound) 1 246880 246880 1
44987 44987 20295 20295 PubChem (compound) 1 246880 246880 2
44989 44989 20295 20295 PubChem (compound) 1 189960 189960 3
359777 359777 20295 20295 PubChem (substance) 2 246880 246880 1
359783 359783 20295 20295 PubChem (substance) 2 246880 246880 2
359785 359785 20295 20295 PubChem (substance) 2 189960 189960 4
719531 719531 20295 20295 PubChem (substance) 2 264435 264435 3
719538 719538 20295 20295 PubChem (substance) 2 264287 264287 5
719541 719541 20295 20295 PubChem (substance) 2 310200 310200 6
719542 719542 20295 20295 PubChem (substance) 2 328655 328655 7
719544 719544 20295 20295 PubChem (substance) 2 329488 329488 8
1173363 1173363 20295 20295 Computational Toxicology and Exposure Data 4 107104 107104 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)
);