home / zeropm-v0-0-4

consensus_index

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

17 rows where inchi_id = 201557

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4787 4787 1456 1456 201557 2 0.260869565217391
117107 117107 40870 40870 201557 1 0.3125
154673 154673 55624 55624 201557 1 0.317073170731707
204838 204838 72589 72589 201557 2 0.260869565217391
238053 238053 81007 81007 201557 1 0.310344827586207
437768 437768 156932 156932 201557 1 0.310344827586207
521361 521361 208067 208067 201557 2 0.260869565217391
521364 521364 208068 208068 201557 2 0.260869565217391
521367 521367 208069 208069 201557 2 0.260869565217391
555948 555948 219100 219100 201557 1 0.239130434782609
662980 662980 237712 237712 201557 1 0.205152004447151
709621 709621 251787 251787 201557 2 0.263736263736264
808357 808357 281442 281442 201557 1 0.304347826086957
808359 808359 281443 281443 201557 1 0.3125
902555 902555 317976 317976 201557 1 0.3
1625062 1625062 490705 490705 201557 1 0.3125
1725638 1725638 528362 528362 201557 1 0.3
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 1944.664ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website