api_results

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

18 rows where query_id = 94704

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21549 21549 94704 94704 PubChem (compound) 1 51329 51329 1
309932 309932 94704 94704 PubChem (substance) 2 63043 63043 7
326344 326344 94704 94704 PubChem (substance) 2 51329 51329 1
346942 346942 94704 94704 PubChem (substance) 2 31914 31914 6
346963 346963 94704 94704 PubChem (substance) 2 31916 31916 2
380758 380758 94704 94704 PubChem (substance) 2 75665 75665 13
478940 478940 94704 94704 PubChem (substance) 2 32807 32807 9
522084 522084 94704 94704 PubChem (substance) 2 64419 64419 12
707230 707230 94704 94704 PubChem (substance) 2 51329 51329 3
714947 714947 94704 94704 PubChem (substance) 2 31916 31916 4
751057 751057 94704 94704 PubChem (substance) 2 169448 169448 14
766916 766916 94704 94704 PubChem (substance) 2 180052 180052 5
766920 766920 94704 94704 PubChem (substance) 2 32807 32807 8
766921 766921 94704 94704 PubChem (substance) 2 197097 197097 10
766922 766922 94704 94704 PubChem (substance) 2 188317 188317 11
954113 954113 94704 94704 CAS Common Chemistry 3 51329 51329 2
964305 964305 94704 94704 CAS Common Chemistry 3 31916 31916 1
1165895 1165895 94704 94704 Computational Toxicology and Exposure Data 4 125495 125495 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)
);