consensus_index

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

25 rows where inventory_id = 153124

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
422600 422600 153124 153124 21885 1 0.0289201756902128
422601 422601 153124 153124 52192 6 0.145748552475028
422602 422602 153124 153124 97503 6 0.231361405521702
422603 422603 153124 153124 129063 1 0.0385602342536171
422604 422604 153124 153124 136946 1 0.0154240937014468
422605 422605 153124 153124 138456 2 0.0252435988974899
422606 422606 153124 153124 140285 4 0.028739459183676
422607 422607 153124 153124 151217 2 0.0243876334702146
422608 422608 153124 153124 173867 1 0.0257068228357447
422609 422609 153124 153124 177741 1 0.0231361405521702
422610 422610 153124 153124 179574 2 0.0178499199619684
422611 422611 153124 153124 179680 1 0.00964005856340427
422612 422612 153124 153124 183142 4 0.0717686827290625
422613 422613 153124 153124 190455 2 0.0462722811043405
422614 422614 153124 153124 199658 1 0.0192801171268085
422615 422615 153124 153124 207196 1 0.0210328550474275
422616 422616 153124 153124 215478 1 0.0330516293602432
422617 422617 153124 153124 232206 1 0.0177970311939771
422618 422618 153124 153124 239259 4 0.0621535024395136
422619 422619 153124 153124 258849 4 0.0235978763505141
422620 422620 153124 153124 278026 1 0.0144600878451064
422621 422621 153124 153124 288174 1 0.0136094944424531
422622 422622 153124 153124 290595 2 0.0291487972375614
422623 422623 153124 153124 310251 2 0.0187658879992706
422624 422624 153124 153124 327291 1 0.0100591915444218 
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)
);