api_results

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

10 rows where query_id = 104695

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124631 124631 104695 104695 PubChem (compound) 1 48071 48071 1
471528 471528 104695 104695 PubChem (substance) 2 48071 48071 1
771424 771424 104695 104695 PubChem (substance) 2 171126 171126 2
771427 771427 104695 104695 PubChem (substance) 2 195627 195627 3
771429 771429 104695 104695 PubChem (substance) 2 173871 173871 4
771431 771431 104695 104695 PubChem (substance) 2 277347 277347 5
771434 771434 104695 104695 PubChem (substance) 2 290474 290474 6
771436 771436 104695 104695 PubChem (substance) 2 326517 326517 7
1028472 1028472 104695 104695 CAS Common Chemistry 3 48071 48071 1
1231277 1231277 104695 104695 Computational Toxicology and Exposure Data 4 48071 48071 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)
);