api_results

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

13 rows where query_id = 29521

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
384660 384660 29521 29521 PubChem (substance) 2 181718 181718 4
386137 386137 29521 29521 PubChem (substance) 2 115944 115944 10
458822 458822 29521 29521 PubChem (substance) 2 170571 170571 3
655051 655051 29521 29521 PubChem (substance) 2 216006 216006 1
729641 729641 29521 29521 PubChem (substance) 2 235042 235042 7
729660 729660 29521 29521 PubChem (substance) 2 224732 224732 2
729763 729763 29521 29521 PubChem (substance) 2 225449 225449 5
729764 729764 29521 29521 PubChem (substance) 2 264570 264570 6
729766 729766 29521 29521 PubChem (substance) 2 294711 294711 8
729768 729768 29521 29521 PubChem (substance) 2 294896 294896 9
729769 729769 29521 29521 PubChem (substance) 2 330603 330603 11
984367 984367 29521 29521 CAS Common Chemistry 3 6054 6054 1
1187321 1187321 29521 29521 Computational Toxicology and Exposure Data 4 112088 112088 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)
);