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 = 5622

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
10480 10480 5622 5622 PubChem (compound) 1 84326 84326 1
310459 310459 5622 5622 PubChem (substance) 2 84326 84326 1
310531 310531 5622 5622 PubChem (substance) 2 26874 26874 2
336878 336878 5622 5622 PubChem (substance) 2 115681 115681 3
369346 369346 5622 5622 PubChem (substance) 2 186351 186351 10
473105 473105 5622 5622 PubChem (substance) 2 77172 77172 7
490784 490784 5622 5622 PubChem (substance) 2 39479 39479 6
524818 524818 5622 5622 PubChem (substance) 2 186232 186232 11
620423 620423 5622 5622 PubChem (substance) 2 23679 23679 8
665064 665064 5622 5622 PubChem (substance) 2 92864 92864 5
700028 700028 5622 5622 PubChem (substance) 2 186985 186985 4
700029 700029 5622 5622 PubChem (substance) 2 191714 191714 9
700030 700030 5622 5622 PubChem (substance) 2 198333 198333 12
700032 700032 5622 5622 PubChem (substance) 2 188567 188567 13
700033 700033 5622 5622 PubChem (substance) 2 189656 189656 14
700034 700034 5622 5622 PubChem (substance) 2 190340 190340 15
945915 945915 5622 5622 CAS Common Chemistry 3 84326 84326 1
1143936 1143936 5622 5622 Computational Toxicology and Exposure Data 4 84326 84326 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 811.946ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website