consensus_index

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

19 rows where inventory_id = 501172

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1654236 1654236 501172 501172 139026 2 0.0569132642536669
1654237 1654237 501172 501172 170075 1 0.0301828163199224
1654238 1654238 501172 501172 170076 2 0.0328588884373149
1654239 1654239 501172 501172 181710 2 0.0697042285088328
1654240 1654240 501172 501172 181711 1 0.0482925061118758
1654241 1654241 501172 501172 195833 1 0.0219511391417617
1654242 1654242 501172 501172 199497 2 0.0162425275076797
1654243 1654243 501172 501172 229165 2 0.170739792761001
1654244 1654244 501172 501172 231498 2 0.170739792761001
1654245 1654245 501172 501172 231998 1 0.0603656326398447
1654246 1654246 501172 501172 240978 2 0.028860292460685
1654247 1654247 501172 501172 243721 2 0.0187978325095046
1654248 1654248 501172 501172 246033 1 0.0185740408122599
1654249 1654249 501172 501172 270490 1 0.0268291700621532
1654250 1654250 501172 501172 284740 1 0.0201218775466149
1654251 1654251 501172 501172 308111 2 0.0204073085059773
1654252 1654252 501172 501172 320288 2 0.0408146170119547
1654253 1654253 501172 501172 333098 1 0.0301828163199224
1654254 1654254 501172 501172 334341 2 0.0174260571272082 
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)
);