api_results

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

9 rows where query_id = 96308

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
362688 362688 96308 96308 PubChem (substance) 2 99485 99485 4
720741 720741 96308 96308 PubChem (substance) 2 180059 180059 5
767394 767394 96308 96308 PubChem (substance) 2 108967 108967 1
767395 767395 96308 96308 PubChem (substance) 2 148700 148700 2
767396 767396 96308 96308 PubChem (substance) 2 13367 13367 3
767397 767397 96308 96308 PubChem (substance) 2 188605 188605 6
767398 767398 96308 96308 PubChem (substance) 2 241317 241317 7
1025811 1025811 96308 96308 CAS Common Chemistry 3 13367 13367 1
1228433 1228433 96308 96308 Computational Toxicology and Exposure Data 4 108967 108967 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)
);