consensus_index

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

10 rows where inventory_id = 42631

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
122655 122655 42631 42631 33708 1 0.0327404153108245
122656 122656 42631 42631 49796 8 0.327404153108245
122657 122657 42631 42631 183577 2 0.163702076554122
122658 122658 42631 42631 202639 1 0.065480830621649
122659 122659 42631 42631 203897 1 0.0545673588513742
122660 122660 42631 42631 204190 1 0.0818510382770612
122661 122661 42631 42631 204498 1 0.109134717702748
122662 122662 42631 42631 243281 1 0.0409255191385306
122663 122663 42631 42631 245046 2 0.071445443545783
122664 122664 42631 42631 259649 1 0.0363782392342494 
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)
);