api_results

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

14 rows where query_id = 337383

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
190071 190071 337383 337383 PubChem (compound) 1 34540 34540 1
427023 427023 337383 337383 PubChem (substance) 2 42041 42041 3
427030 427030 337383 337383 PubChem (substance) 2 36012 36012 5
548431 548431 337383 337383 PubChem (substance) 2 24903 24903 2
556951 556951 337383 337383 PubChem (substance) 2 42045 42045 11
557992 557992 337383 337383 PubChem (substance) 2 34540 34540 1
818442 818442 337383 337383 PubChem (substance) 2 34540 34540 6
818445 818445 337383 337383 PubChem (substance) 2 196698 196698 8
818453 818453 337383 337383 PubChem (substance) 2 34540 34540 4
818456 818456 337383 337383 PubChem (substance) 2 240740 240740 7
910883 910883 337383 337383 PubChem (substance) 2 213797 213797 9
910884 910884 337383 337383 PubChem (substance) 2 210947 210947 10
1077086 1077086 337383 337383 CAS Common Chemistry 3 34540 34540 1
1278504 1278504 337383 337383 Computational Toxicology and Exposure Data 4 34540 34540 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)
);