consensus_index

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

10 rows where inventory_id = 120138

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
354851 354851 120138 120138 41423 5 0.264363315321724
354852 354852 120138 120138 49857 1 0.0303756140399711
354853 354853 120138 120138 136760 4 0.0878670581947467
354854 354854 120138 120138 139709 5 0.132181657660862
354855 354855 120138 120138 168778 4 0.170513616123575
354856 354856 120138 120138 170652 2 0.0701494757711099
354857 354857 120138 120138 186714 4 0.0653453505257817
354858 354858 120138 120138 240424 4 0.039422308627044
354859 354859 120138 120138 249883 2 0.0627435985640705
354860 354860 120138 120138 263650 2 0.0627435985640705 
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)
);