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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
37874 37874 17265 17265 PubChem (compound) 1 48434 48434 1
309859 309859 17265 17265 PubChem (substance) 2 63043 63043 13
349874 349874 17265 17265 PubChem (substance) 2 48434 48434 1
349881 349881 17265 17265 PubChem (substance) 2 138104 138104 2
644872 644872 17265 17265 PubChem (substance) 2 19218 19218 8
716126 716126 17265 17265 PubChem (substance) 2 200127 200127 3
716129 716129 17265 17265 PubChem (substance) 2 199635 199635 4
716133 716133 17265 17265 PubChem (substance) 2 207042 207042 5
716135 716135 17265 17265 PubChem (substance) 2 169213 169213 6
716138 716138 17265 17265 PubChem (substance) 2 238171 238171 7
716141 716141 17265 17265 PubChem (substance) 2 227561 227561 9
716142 716142 17265 17265 PubChem (substance) 2 184480 184480 10
716143 716143 17265 17265 PubChem (substance) 2 254347 254347 11
716144 716144 17265 17265 PubChem (substance) 2 233317 233317 12
716150 716150 17265 17265 PubChem (substance) 2 197064 197064 14
716151 716151 17265 17265 PubChem (substance) 2 197065 197065 15
716156 716156 17265 17265 PubChem (substance) 2 255321 255321 16
965754 965754 17265 17265 CAS Common Chemistry 3 48434 48434 1
1167554 1167554 17265 17265 Computational Toxicology and Exposure Data 4 48434 48434 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 928.091ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website