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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
457038 457038 122621 122621 PubChem (substance) 2 12920 12920 20
493397 493397 122621 122621 PubChem (substance) 2 235264 235264 15
493402 493402 122621 122621 PubChem (substance) 2 186087 186087 1
617479 617479 122621 122621 PubChem (substance) 2 28476 28476 19
786827 786827 122621 122621 PubChem (substance) 2 141289 141289 2
786831 786831 122621 122621 PubChem (substance) 2 285527 285527 3
786832 786832 122621 122621 PubChem (substance) 2 261751 261751 4
786834 786834 122621 122621 PubChem (substance) 2 239057 239057 5
786837 786837 122621 122621 PubChem (substance) 2 270178 270178 6
786839 786839 122621 122621 PubChem (substance) 2 276462 276462 7
786841 786841 122621 122621 PubChem (substance) 2 243377 243377 8
786843 786843 122621 122621 PubChem (substance) 2 307819 307819 9
786845 786845 122621 122621 PubChem (substance) 2 322035 322035 10
786847 786847 122621 122621 PubChem (substance) 2 153744 153744 11
786848 786848 122621 122621 PubChem (substance) 2 246721 246721 12
786850 786850 122621 122621 PubChem (substance) 2 270210 270210 13
786852 786852 122621 122621 PubChem (substance) 2 207302 207302 14
786854 786854 122621 122621 PubChem (substance) 2 255540 255540 16
786856 786856 122621 122621 PubChem (substance) 2 277419 277419 17
786858 786858 122621 122621 PubChem (substance) 2 333637 333637 18
786860 786860 122621 122621 PubChem (substance) 2 333038 333038 21
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 462.256ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website