home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 335012

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
97403 97403 335012 335012 PubChem (compound) 1 16848 16848 4
181192 181192 335012 335012 PubChem (compound) 1 22989 22989 3
181194 181194 335012 335012 PubChem (compound) 1 140424 140424 2
181202 181202 335012 335012 PubChem (compound) 1 23531 23531 1
263551 263551 335012 335012 PubChem (compound) 1 231593 231593 5
263552 263552 335012 335012 PubChem (compound) 1 23531 23531 6
433370 433370 335012 335012 PubChem (substance) 2 16848 16848 5
546283 546283 335012 335012 PubChem (substance) 2 22989 22989 4
546286 546286 335012 335012 PubChem (substance) 2 140424 140424 2
546300 546300 335012 335012 PubChem (substance) 2 23531 23531 1
649884 649884 335012 335012 PubChem (substance) 2 231593 231593 6
649886 649886 335012 335012 PubChem (substance) 2 23531 23531 13
788575 788575 335012 335012 PubChem (substance) 2 224554 224554 3
910356 910356 335012 335012 PubChem (substance) 2 291021 291021 7
910358 910358 335012 335012 PubChem (substance) 2 259366 259366 8
910360 910360 335012 335012 PubChem (substance) 2 320459 320459 9
910362 910362 335012 335012 PubChem (substance) 2 309073 309073 10
910365 910365 335012 335012 PubChem (substance) 2 309847 309847 11
910366 910366 335012 335012 PubChem (substance) 2 326368 326368 12
1114984 1114984 335012 335012 CAS Common Chemistry 3 23531 23531 1
1326463 1326463 335012 335012 Computational Toxicology and Exposure Data 4 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 839.168ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website