home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 21469

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47593 47593 21469 21469 PubChem (compound) 1 21186 21186 1
333333 333333 21469 21469 PubChem (substance) 2 87483 87483 2
353597 353597 21469 21469 PubChem (substance) 2 57370 57370 5
363532 363532 21469 21469 PubChem (substance) 2 21186 21186 1
373184 373184 21469 21469 PubChem (substance) 2 52760 52760 9
455074 455074 21469 21469 PubChem (substance) 2 30588 30588 7
490904 490904 21469 21469 PubChem (substance) 2 79036 79036 6
520408 520408 21469 21469 PubChem (substance) 2 59830 59830 4
713355 713355 21469 21469 PubChem (substance) 2 167433 167433 15
721009 721009 21469 21469 PubChem (substance) 2 158475 158475 3
721010 721010 21469 21469 PubChem (substance) 2 140434 140434 8
721011 721011 21469 21469 PubChem (substance) 2 164382 164382 10
721012 721012 21469 21469 PubChem (substance) 2 164383 164383 11
721013 721013 21469 21469 PubChem (substance) 2 164384 164384 12
721014 721014 21469 21469 PubChem (substance) 2 165745 165745 13
721015 721015 21469 21469 PubChem (substance) 2 191740 191740 14
721016 721016 21469 21469 PubChem (substance) 2 167935 167935 16
972664 972664 21469 21469 CAS Common Chemistry 3 21186 21186 1
1175336 1175336 21469 21469 Computational Toxicology and Exposure Data 4 21186 21186 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 494.596ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website