consensus_index

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

9 rows where inventory_id = 331123

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
930135 930135 331123 331123 63030 4 0.225706570178387
930136 930136 331123 331123 159398 1 0.0638394585325979
930137 930137 331123 331123 180040 2 0.31919729266299
930138 930138 331123 331123 181393 2 0.0797993231657474
930139 930139 331123 331123 181898 2 0.10639909755433
930140 930140 331123 331123 237772 1 0.0531995487771649
930141 930141 331123 331123 274618 1 0.0398996615828737
930142 930142 331123 331123 309487 2 0.0475831229752226
930143 930143 331123 331123 321366 1 0.0455996132375699 
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)
);