api_results

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

15 rows where query_id = 104670

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124601 124601 104670 104670 PubChem (compound) 1 47093 47093 1
372456 372456 104670 104670 PubChem (substance) 2 49175 49175 11
471476 471476 104670 104670 PubChem (substance) 2 47093 47093 1
677249 677249 104670 104670 PubChem (substance) 2 171111 171111 2
771331 771331 104670 104670 PubChem (substance) 2 260057 260057 7
771333 771333 104670 104670 PubChem (substance) 2 253182 253182 8
771335 771335 104670 104670 PubChem (substance) 2 309418 309418 9
771337 771337 104670 104670 PubChem (substance) 2 264425 264425 10
771339 771339 104670 104670 PubChem (substance) 2 207702 207702 3
771340 771340 104670 104670 PubChem (substance) 2 57992 57992 4
771341 771341 104670 104670 PubChem (substance) 2 155136 155136 5
771342 771342 104670 104670 PubChem (substance) 2 183546 183546 6
1028438 1028438 104670 104670 CAS Common Chemistry 3 47093 47093 1
1028439 1028439 104670 104670 CAS Common Chemistry 3 57992 57992 2
1231243 1231243 104670 104670 Computational Toxicology and Exposure Data 4 47093 47093 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)
);