consensus_index

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

20 rows where inventory_id = 217649

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
550603 550603 217649 217649 54173 1 0.0446816125264485
550604 550604 217649 217649 55065 10 0.223408062632243
550605 550605 217649 217649 74190 1 0.0159577187594459
550606 550606 217649 217649 137347 3 0.111704031316121
550607 550607 217649 217649 195523 1 0.0279260078290303
550608 550608 217649 217649 197906 1 0.0446816125264485
550609 550609 217649 217649 197907 1 0.0372346771053738
550610 550610 217649 217649 197908 1 0.0319154375188918
550611 550611 217649 217649 200222 2 0.064492352549929
550612 550612 217649 217649 208871 1 0.0186173385526869
550613 550613 217649 217649 218239 1 0.0558520156580607
550614 550614 217649 217649 232219 1 0.0744693542107475
550615 550615 217649 217649 233313 2 0.0234195284458801
550616 550616 217649 217649 237031 1 0.0744693542107475
550617 550617 217649 217649 237853 1 0.0248231180702492
550618 550618 217649 217649 238236 2 0.0288418568661046
550619 550619 217649 217649 240048 1 0.0203098238756584
550620 550620 217649 217649 240977 1 0.0248231180702492
550621 550621 217649 217649 281190 1 0.0279260078290303
550622 550622 217649 217649 334592 2 0.0182411919290913 
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)
);