home / zeropm-v0-0-4

consensus_index

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

34 rows where inventory_id = 45827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
128227 128227 45827 45827 83989 6 0.222076473450912
128228 128228 45827 45827 84313 1 0.0148050982300608
128229 128229 45827 45827 100951 6 0.0731335309150312
128230 128230 45827 45827 136684 4 0.111038236725456
128231 128231 45827 45827 141260 4 0.0387388401243337
128232 128232 45827 45827 186829 4 0.0260373987055394
128233 128233 45827 45827 188045 4 0.0547849930944357
128234 128234 45827 45827 188194 2 0.024675163716768
128235 128235 45827 45827 195558 1 0.0148050982300608
128236 128236 45827 45827 200466 2 0.0175566867710698
128237 128237 45827 45827 200555 1 0.0158626052464937
128238 128238 45827 45827 203927 1 0.013879779590682
128239 128239 45827 45827 205611 1 0.0130633219677007
128240 128240 45827 45827 223379 4 0.0137436169838384
128241 128241 45827 45827 232278 4 0.0368433464130371
128242 128242 45827 45827 243236 4 0.0533607885218644
128243 128243 45827 45827 258938 1 0.0158626052464937
128244 128244 45827 45827 259509 2 0.0169826123773757
128245 128245 45827 45827 261630 2 0.0157031780319134
128246 128246 45827 45827 273982 4 0.0277595591813639
128247 128247 45827 45827 279293 2 0.0120793677168564
128248 128248 45827 45827 283981 4 0.0114223812670811
128249 128249 45827 45827 288798 2 0.0117535333575762
128250 128250 45827 45827 291764 2 0.0193292759706212
128251 128251 45827 45827 295080 2 0.0111597626848787
128252 128252 45827 45827 296667 2 0.0101363578333551
128253 128253 45827 45827 308109 2 0.0125125917608095
128254 128254 45827 45827 308127 2 0.0118367158063655
128255 128255 45827 45827 309918 4 0.0113488157703473
128256 128256 45827 45827 320806 2 0.0106846593106305
128257 128257 45827 45827 323067 4 0.0186095368489799
128258 128258 45827 45827 325947 4 0.0162539188731451
128259 128259 45827 45827 343654 2 0.0096282362063022
128260 128260 45827 45827 343788 4 0.0102424648887152
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 2077.785ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website