consensus_index

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

12 rows where inventory_id = 338135

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
944190 944190 338135 338135 73748 4 0.315884836502248
944191 944191 338135 338135 136280 1 0.157942418251124
944192 944192 338135 338135 149657 1 0.078971209125562
944193 944193 338135 338135 161297 1 0.0451264052146068
944194 944194 338135 338135 186822 1 0.105294945500749
944195 944195 338135 338135 192594 1 0.0526474727503746
944196 944196 338135 338135 227324 1 0.0263237363751873
944197 944197 338135 338135 233188 1 0.0631769673004496
944198 944198 338135 338135 247267 1 0.0350983151669164
944199 944199 338135 338135 247268 1 0.039485604562781
944200 944200 338135 338135 251234 1 0.0287168033183862
944201 944201 338135 338135 321400 1 0.0315884836502248 
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)
);