api_results

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

11 rows where query_id = 437691

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
294473 294473 437691 437691 PubChem (compound) 1 44438 44438 1
512526 512526 437691 437691 PubChem (substance) 2 43099 43099 5
690450 690450 437691 437691 PubChem (substance) 2 44438 44438 1
690453 690453 437691 437691 PubChem (substance) 2 186398 186398 2
795549 795549 437691 437691 PubChem (substance) 2 260747 260747 6
929542 929542 437691 437691 PubChem (substance) 2 162379 162379 4
937504 937504 437691 437691 PubChem (substance) 2 208504 208504 3
937505 937505 437691 437691 PubChem (substance) 2 308186 308186 7
937506 937506 437691 437691 PubChem (substance) 2 190469 190469 8
1134233 1134233 437691 437691 CAS Common Chemistry 3 44438 44438 1
1349034 1349034 437691 437691 Computational Toxicology and Exposure Data 4 44438 44438 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)
);