consensus_index

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

12 rows where inventory_id = 290147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
836299 836299 290147 290147 71457 4 0.315884836502248
836300 836300 290147 290147 112097 1 0.157942418251124
836301 836301 290147 290147 162055 1 0.078971209125562
836302 836302 290147 290147 187085 1 0.0631769673004496
836303 836303 290147 290147 189837 1 0.0287168033183862
836304 836304 290147 290147 208599 1 0.0451264052146068
836305 836305 290147 290147 248267 1 0.105294945500749
836306 836306 290147 290147 248510 1 0.039485604562781
836307 836307 290147 290147 253222 1 0.0350983151669164
836308 836308 290147 290147 254006 1 0.0526474727503746
836309 836309 290147 290147 297718 1 0.0315884836502248
836310 836310 290147 290147 333370 1 0.0263237363751873 
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)
);