consensus_index

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

25 rows where inventory_id = 159625

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
445640 445640 159625 159625 11091 8 0.250953391140427
445641 445641 159625 159625 137053 2 0.0836511303801423
445642 445642 159625 159625 148284 2 0.0501906782280854
445643 445643 159625 159625 173801 1 0.0278837101267141
445644 445644 159625 159625 183932 1 0.0209127825950356
445645 445645 159625 159625 186649 1 0.0193041070108021
445646 445646 159625 159625 188270 1 0.0250953391140427
445647 445647 159625 159625 195651 1 0.0418255651900712
445648 445648 159625 159625 200126 2 0.0149973336350261
445649 445649 159625 159625 216557 2 0.125476695570214
445650 445650 159625 159625 217171 2 0.0130818498273205
445651 445651 159625 159625 219140 1 0.0114069723245649
445652 445652 159625 159625 238966 2 0.0627383477851068
445653 445653 159625 159625 239190 2 0.0313691738925534
445654 445654 159625 159625 239240 2 0.0244905432720625
445655 445655 159625 159625 240732 2 0.0209127825950356
445656 445656 159625 159625 240920 1 0.0139418550633571
445657 445657 159625 159625 243217 2 0.0248480883639358
445658 445658 159625 159625 267621 2 0.0299946672700523
445659 445659 159625 159625 274014 2 0.0228139446491297
445660 445660 159625 159625 294528 2 0.0159677818999754
445661 445661 159625 159625 310244 1 0.0119501614828775
445662 445662 159625 159625 320533 2 0.0193614744686575
445663 445663 159625 159625 320762 1 0.0167302260760285
445664 445664 159625 159625 329602 1 0.014761964184731 
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)
);