consensus_index

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

22 rows where inventory_id = 43149

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
124376 124376 43149 43149 8571 1 0.0700430895490224
124377 124377 43149 43149 32364 5 0.142385885660114
124378 124378 43149 43149 52389 1 0.0150092334747905
124379 124379 43149 43149 144849 4 0.148583830786111
124380 124380 43149 43149 165946 1 0.0350215447745112
124381 124381 43149 43149 197568 1 0.0116738482581704
124382 124382 43149 43149 198250 2 0.0264737994293344
124383 124383 43149 43149 198251 2 0.0234931664378579
124384 124384 43149 43149 198252 2 0.0211187861083065
124385 124385 43149 43149 198253 2 0.019182090071677
124386 124386 43149 43149 198479 1 0.0140086179098045
124387 124387 43149 43149 198480 1 0.0131330792904417
124388 124388 43149 43149 198481 1 0.0123605452145334
124389 124389 43149 43149 202232 1 0.105064634323534
124390 124390 43149 43149 204450 1 0.0420258537294135
124391 124391 43149 43149 205534 1 0.0161637898959283
124392 124392 43149 43149 206106 1 0.0525323171617668
124393 124393 43149 43149 206194 1 0.0350215447745112
124394 124394 43149 43149 206584 1 0.0262661585808834
124395 124395 43149 43149 218159 2 0.0700430895490224
124396 124396 43149 43149 231793 2 0.0525323171617668
124397 124397 43149 43149 259420 1 0.0420258537294135 
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)
);