consensus_index

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

23 rows where inventory_id = 104397

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
309005 309005 104397 104397 9123 3 0.0966017282001999
309006 309006 104397 104397 115871 2 0.278647601975383
309007 309007 104397 104397 192824 19 0.0377735582217398
309008 309008 104397 104397 194717 2 0.0359732507303763
309009 309009 104397 104397 194720 2 0.0192744576607969
309010 309010 104397 104397 203139 14 0.0381857839045221
309011 309011 104397 104397 207121 5 0.0241589579535973
309012 309012 104397 104397 214912 2 0.0235500206379393
309013 309013 104397 104397 217489 4 0.017091022584007
309014 309014 104397 104397 232393 3 0.0283254179743689
309015 309015 104397 104397 240702 2 0.0239821671535842
309016 309016 104397 104397 246960 1 0.0253316001795802
309017 309017 104397 104397 259273 4 0.0985168044590815
309018 309018 104397 104397 263374 4 0.0669537638547727
309019 309019 104397 104397 265927 2 0.0106699681381143
309020 309020 104397 104397 277422 2 0.0257609799155724
309021 309021 104397 104397 289343 4 0.0181889164061666
309022 309022 104397 104397 291090 1 0.0163910354103166
309023 309023 104397 104397 308705 2 0.0148943408319719
309024 309024 104397 104397 323944 4 0.03330475858034
309025 309025 104397 104397 324009 1 0.0103202815546438
309026 309026 104397 104397 332596 1 0.0398068002821975
309027 309027 104397 104397 333006 4 0.0131659114584205 
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)
);