consensus_index

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

20 rows where inventory_id = 248045

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
695672 695672 248045 248045 28878 12 0.234541122943591
695673 695673 248045 248045 56470 2 0.10200131651246
695674 695674 248045 248045 136652 3 0.0928489547630739
695675 695675 248045 248045 139413 2 0.0545219970556445
695676 695676 248045 248045 148891 2 0.0744912292654645
695677 695677 248045 248045 155895 1 0.0480838817306104
695678 695678 248045 248045 177100 2 0.0288503290383663
695679 695679 248045 248045 185985 1 0.0160279605768701
695680 695680 248045 248045 192130 2 0.0241258571444093
695681 695681 248045 248045 195198 1 0.0169707817872743
695682 695682 248045 248045 199939 1 0.0262275718530602
695683 695683 248045 248045 214904 2 0.0340004388374866
695684 695684 248045 248045 219176 1 0.0360629112979578
695685 695685 248045 248045 225386 1 0.0221925607987433
695686 695686 248045 248045 227385 1 0.0192335526922442
695687 695687 248045 248045 228983 1 0.0206073778845473
695688 695688 248045 248045 229268 1 0.0412147557690947
695689 695689 248045 248045 232026 1 0.0480838817306104
695690 695690 248045 248045 233141 1 0.0320559211537403
695691 695691 248045 248045 240067 2 0.0208209315456375 
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)
);