home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 104713

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21458 21458 104713 104713 PubChem (compound) 1 48081 48081 1
326159 326159 104713 104713 PubChem (substance) 2 48081 48081 1
326162 326162 104713 104713 PubChem (substance) 2 179834 179834 3
707048 707048 104713 104713 PubChem (substance) 2 136284 136284 2
707049 707049 104713 104713 PubChem (substance) 2 207146 207146 4
707054 707054 104713 104713 PubChem (substance) 2 204326 204326 5
707055 707055 104713 104713 PubChem (substance) 2 208623 208623 10
707063 707063 104713 104713 PubChem (substance) 2 249668 249668 11
707065 707065 104713 104713 PubChem (substance) 2 291098 291098 12
707067 707067 104713 104713 PubChem (substance) 2 202583 202583 13
707069 707069 104713 104713 PubChem (substance) 2 186336 186336 14
707072 707072 104713 104713 PubChem (substance) 2 197263 197263 15
738426 738426 104713 104713 PubChem (substance) 2 161543 161543 8
771520 771520 104713 104713 PubChem (substance) 2 169583 169583 6
771521 771521 104713 104713 PubChem (substance) 2 232241 232241 7
771522 771522 104713 104713 PubChem (substance) 2 178421 178421 9
954035 954035 104713 104713 CAS Common Chemistry 3 48081 48081 1
1153518 1153518 104713 104713 Computational Toxicology and Exposure Data 4 48081 48081 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 1439.183ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website