home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 21486

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47637 47637 21486 21486 PubChem (compound) 1 112748 112748 1
47640 47640 21486 21486 PubChem (compound) 1 210051 210051 2
47645 47645 21486 21486 PubChem (compound) 1 112748 112748 3
47647 47647 21486 21486 PubChem (compound) 1 112748 112748 4
47650 47650 21486 21486 PubChem (compound) 1 21886 21886 5
47653 47653 21486 21486 PubChem (compound) 1 112748 112748 6
47654 47654 21486 21486 PubChem (compound) 1 112748 112748 7
47657 47657 21486 21486 PubChem (compound) 1 291462 291462 8
363593 363593 21486 21486 PubChem (substance) 2 112748 112748 1
363602 363602 21486 21486 PubChem (substance) 2 210051 210051 4
363609 363609 21486 21486 PubChem (substance) 2 112748 112748 3
363614 363614 21486 21486 PubChem (substance) 2 112748 112748 5
363622 363622 21486 21486 PubChem (substance) 2 21886 21886 7
363624 363624 21486 21486 PubChem (substance) 2 112748 112748 6
363626 363626 21486 21486 PubChem (substance) 2 112748 112748 8
363628 363628 21486 21486 PubChem (substance) 2 291462 291462 12
432738 432738 21486 21486 PubChem (substance) 2 147223 147223 10
707273 707273 21486 21486 PubChem (substance) 2 14536 14536 13
721029 721029 21486 21486 PubChem (substance) 2 14536 14536 2
721036 721036 21486 21486 PubChem (substance) 2 332993 332993 9
721037 721037 21486 21486 PubChem (substance) 2 296480 296480 11
972698 972698 21486 21486 CAS Common Chemistry 3 21886 21886 1
1175372 1175372 21486 21486 Computational Toxicology and Exposure Data 4 112748 112748 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)
);
Powered by Datasette · Queries took 497.524ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website