home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 335014

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
181203 181203 335014 335014 PubChem (compound) 1 23531 23531 1
433371 433371 335014 335014 PubChem (substance) 2 16848 16848 4
546282 546282 335014 335014 PubChem (substance) 2 22989 22989 2
546289 546289 335014 335014 PubChem (substance) 2 140424 140424 11
546297 546297 335014 335014 PubChem (substance) 2 23531 23531 1
788577 788577 335014 335014 PubChem (substance) 2 224554 224554 3
813070 813070 335014 335014 PubChem (substance) 2 22989 22989 10
813072 813072 335014 335014 PubChem (substance) 2 320411 320411 7
910357 910357 335014 335014 PubChem (substance) 2 291021 291021 5
910359 910359 335014 335014 PubChem (substance) 2 259366 259366 6
910361 910361 335014 335014 PubChem (substance) 2 320459 320459 9
910363 910363 335014 335014 PubChem (substance) 2 309073 309073 13
910364 910364 335014 335014 PubChem (substance) 2 309847 309847 14
910367 910367 335014 335014 PubChem (substance) 2 241460 241460 8
910368 910368 335014 335014 PubChem (substance) 2 292311 292311 12
1114983 1114983 335014 335014 CAS Common Chemistry 3 23531 23531 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 434.402ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website