consensus_index

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

28 rows where inchi_id = 84886

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19406 19406 5708 5708 84886 8 0.461538461538462
88564 88564 31658 31658 84886 8 0.461538461538462
169842 169842 60567 60567 84886 1 0.112607099143207
169847 169847 60568 60568 84886 16 0.390076177054981
217779 217779 75537 75537 84886 8 0.461538461538462
343106 343106 115829 115829 84886 1 0.25
427495 427495 154132 154132 84886 8 0.461538461538462
515047 515047 206545 206545 84886 8 0.461538461538462
515051 515051 206546 206546 84886 7 0.45993031358885
533512 533512 211636 211636 84886 8 0.461538461538462
734794 734794 259205 259205 84886 10 0.464088397790055
856048 856048 296131 296131 84886 8 0.461538461538462
856052 856052 296132 296132 84886 8 0.461538461538462
856056 856056 296133 296133 84886 5 0.455696202531646
856060 856060 296134 296134 84886 5 0.455696202531646
900402 900402 316781 316781 84886 4 0.452830188679245
1173512 1173512 393981 393981 84886 8 0.461538461538462
1173516 1173516 393982 393982 84886 8 0.461538461538462
1173520 1173520 393983 393983 84886 8 0.461538461538462
1429026 1429026 445615 445615 84886 8 0.461538461538462
1429030 1429030 445616 445616 84886 8 0.461538461538462
1429034 1429034 445617 445617 84886 8 0.461538461538462
1586400 1586400 478953 478953 84886 8 0.461538461538462
1586404 1586404 478954 478954 84886 8 0.461538461538462
1586408 1586408 478955 478955 84886 8 0.461538461538462
1606888 1606888 485477 485477 84886 8 0.461538461538462
1613002 1613002 486982 486982 84886 8 0.461538461538462
1718103 1718103 526189 526189 84886 4 0.452830188679245 
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)
);