consensus_index

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

25 rows where inventory_id = 226972

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
579811 579811 226972 226972 11091 8 0.250953391140427
579812 579812 226972 226972 137053 2 0.0836511303801423
579813 579813 226972 226972 148284 2 0.0501906782280854
579814 579814 226972 226972 173801 1 0.0278837101267141
579815 579815 226972 226972 183932 1 0.0209127825950356
579816 579816 226972 226972 186649 1 0.0193041070108021
579817 579817 226972 226972 188270 1 0.0250953391140427
579818 579818 226972 226972 195651 1 0.0418255651900712
579819 579819 226972 226972 200126 2 0.0149973336350261
579820 579820 226972 226972 216557 2 0.125476695570214
579821 579821 226972 226972 217171 2 0.0130818498273205
579822 579822 226972 226972 219140 1 0.0114069723245649
579823 579823 226972 226972 238966 2 0.0627383477851068
579824 579824 226972 226972 239190 2 0.0313691738925534
579825 579825 226972 226972 239240 2 0.0244905432720625
579826 579826 226972 226972 240732 2 0.0209127825950356
579827 579827 226972 226972 240920 1 0.0139418550633571
579828 579828 226972 226972 243217 2 0.0248480883639358
579829 579829 226972 226972 267621 2 0.0299946672700523
579830 579830 226972 226972 274014 2 0.0228139446491297
579831 579831 226972 226972 294528 2 0.0159677818999754
579832 579832 226972 226972 310244 1 0.0119501614828775
579833 579833 226972 226972 320533 2 0.0193614744686575
579834 579834 226972 226972 320762 1 0.0167302260760285
579835 579835 226972 226972 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)
);