consensus_index

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

13 rows where inventory_id = 153747

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
426190 426190 153747 153747 78292 6 0.27353477794126
426191 426191 153747 153747 106269 1 0.13676738897063
426192 426192 153747 153747 137698 1 0.13676738897063
426193 426193 153747 153747 169084 1 0.0341918472426575
426194 426194 153747 153747 173372 1 0.0683836944853149
426195 426195 153747 153747 197331 1 0.0455891296568766
426196 426196 153747 153747 206945 1 0.0547069555882519
426197 426197 153747 153747 239235 1 0.0911782593137532
426198 426198 153747 153747 260140 1 0.0390763968487514
426199 426199 153747 153747 308102 1 0.0303927531045844
426200 426200 153747 153747 320921 1 0.027353477794126
426201 426201 153747 153747 324634 1 0.02486679799466
426202 426202 153747 153747 326415 1 0.0227945648284383 
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)
);