home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 74367

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
109078 109078 74367 74367 PubChem (compound) 1 33948 33948 1
109079 109079 74367 74367 PubChem (compound) 1 183273 183273 2
109080 109080 74367 74367 PubChem (compound) 1 231415 231415 3
109081 109081 74367 74367 PubChem (compound) 1 190471 190471 4
109082 109082 74367 74367 PubChem (compound) 1 199478 199478 5
109083 109083 74367 74367 PubChem (compound) 1 189828 189828 6
109084 109084 74367 74367 PubChem (compound) 1 241983 241983 7
109085 109085 74367 74367 PubChem (compound) 1 291857 291857 8
109086 109086 74367 74367 PubChem (compound) 1 309459 309459 9
449735 449735 74367 74367 PubChem (substance) 2 33948 33948 1
449736 449736 74367 74367 PubChem (substance) 2 183273 183273 2
449737 449737 74367 74367 PubChem (substance) 2 231415 231415 3
449738 449738 74367 74367 PubChem (substance) 2 190471 190471 4
449739 449739 74367 74367 PubChem (substance) 2 199478 199478 5
449740 449740 74367 74367 PubChem (substance) 2 189828 189828 11
449741 449741 74367 74367 PubChem (substance) 2 241983 241983 9
449742 449742 74367 74367 PubChem (substance) 2 291857 291857 8
449743 449743 74367 74367 PubChem (substance) 2 309459 309459 10
758362 758362 74367 74367 PubChem (substance) 2 243160 243160 6
758363 758363 74367 74367 PubChem (substance) 2 279550 279550 7
1018107 1018107 74367 74367 CAS Common Chemistry 3 33948 33948 1
1220440 1220440 74367 74367 Computational Toxicology and Exposure Data 4 33948 33948 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 437.492ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website