consensus_index

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

13 rows where inventory_id = 299236

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
867033 867033 299236 299236 57550 4 0.309200978620495
867034 867034 299236 299236 136920 2 0.154600489310248
867035 867035 299236 299236 186799 1 0.0309200978620495
867036 867036 299236 299236 186854 2 0.0564521169310393
867037 867037 299236 299236 193915 1 0.0343556642911662
867038 867038 299236 299236 205794 2 0.103066992873498
867039 867039 299236 299236 210706 2 0.0441715683743565
867040 867040 299236 299236 210707 2 0.0564521169310393
867041 867041 299236 299236 240061 2 0.0285856405856369
867042 867042 299236 299236 253770 2 0.0773002446551238
867043 867043 299236 299236 263052 2 0.0386501223275619
867044 867044 299236 299236 267039 1 0.0281091798745905
867045 867045 299236 299236 276095 1 0.0257667482183746 
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)
);