consensus_index

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

8 rows where inventory_id = 9097

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31067 31067 9097 9097 59117 3 0.247243342555929
31068 31068 9097 9097 119330 2 0.311507091732584
31069 31069 9097 9097 138192 5 0.18950980685696
31070 31070 9097 9097 138193 1 0.0623014183465168
31071 31071 9097 9097 138396 1 0.038938386466573
31072 31072 9097 9097 253875 1 0.0519178486220973
31073 31073 9097 9097 262111 1 0.0346118990813982
31074 31074 9097 9097 264277 1 0.0445010131046549 
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)
);