consensus_index

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

15 rows where inventory_id = 79756

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
233227 233227 79756 79756 42191 8 0.269477076134896
233228 233228 79756 79756 137012 2 0.134738538067448
233229 233229 79756 79756 164771 1 0.0538954152269792
233230 233230 79756 79756 189116 2 0.0898256920449654
233231 233231 79756 79756 195393 1 0.0449128460224827
233232 233232 79756 79756 199938 1 0.038496725162128
233233 233233 79756 79756 204545 1 0.0269477076134896
233234 233234 79756 79756 228237 2 0.033684634516862
233235 233235 79756 79756 228826 1 0.067369269033724
233236 233236 79756 79756 232120 1 0.0538954152269792
233237 233237 79756 79756 255289 1 0.0299418973483218
233238 233238 79756 79756 257957 1 0.0449128460224827
233239 233239 79756 79756 264426 2 0.0509263805346967
233240 233240 79756 79756 290094 2 0.0245997788882699
233241 233241 79756 79756 309476 2 0.0270834651861056 
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)
);