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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
181856 181856 162554 162554 PubChem (compound) 1 23878 23878 1
531610 531610 162554 162554 PubChem (substance) 2 231932 231932 9
531634 531634 162554 162554 PubChem (substance) 2 188284 188284 8
547117 547117 162554 162554 PubChem (substance) 2 259613 259613 13
547118 547118 162554 162554 PubChem (substance) 2 207113 207113 7
547120 547120 162554 162554 PubChem (substance) 2 239128 239128 12
547124 547124 162554 162554 PubChem (substance) 2 274708 274708 1
547125 547125 162554 162554 PubChem (substance) 2 277423 277423 14
547127 547127 162554 162554 PubChem (substance) 2 23878 23878 3
805378 805378 162554 162554 PubChem (substance) 2 235019 235019 5
805395 805395 162554 162554 PubChem (substance) 2 235018 235018 11
813439 813439 162554 162554 PubChem (substance) 2 207113 207113 10
813443 813443 162554 162554 PubChem (substance) 2 261871 261871 2
813444 813444 162554 162554 PubChem (substance) 2 207553 207553 4
813445 813445 162554 162554 PubChem (substance) 2 235019 235019 6
1071674 1071674 162554 162554 CAS Common Chemistry 3 23878 23878 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 1486.496ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website