consensus_index

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

11 rows where inventory_id = 331796

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
931661 931661 331796 331796 23535 5 0.307051035215475
931662 931662 331796 331796 49658 1 0.0423647420869162
931663 931663 331796 331796 106798 1 0.0325882631437817
931664 931664 331796 331796 136297 1 0.141215806956387
931665 931665 331796 331796 138474 2 0.122296476240151
931666 931666 331796 331796 157920 1 0.0529559276086453
931667 931667 331796 331796 233159 1 0.0353039517390969
931668 931668 331796 331796 233929 1 0.060521060124166
931669 931669 331796 331796 269708 1 0.0385134018971966
931670 931670 331796 331796 284681 2 0.0377415119448293
931671 931671 331796 331796 288515 1 0.105911855217291 
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)
);