consensus_index

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

21 rows where inchi_id = 46716

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2693 2693 741 741 46716 8 0.461538461538462
151017 151017 54126 54126 46716 1 0.0599795722222174
201773 201773 71583 71583 46716 5 0.455696202531646
420045 420045 150930 150930 46716 4 0.833333333333333
430208 430208 154928 154928 46716 1 0.12448132780083
485192 485192 179439 179439 46716 7 0.45993031358885
491364 491364 184847 184847 46716 1 0.114982578397213
517012 517012 207030 207030 46716 1 0.0597747001681718
517022 517022 207031 207031 46716 1 0.0597747001681718
517032 517032 207032 207032 46716 1 0.0597747001681718
529557 529557 210234 210234 46716 8 0.461538461538462
529561 529561 210235 210235 46716 8 0.461538461538462
529918 529918 210333 210333 46716 1 0.113207547169811
545784 545784 215967 215967 46716 1 0.115727002967359
557325 557325 219490 219490 46716 7 0.461538461538462
593375 593375 231262 231262 46716 1 0.0597747001681718
597662 597662 235465 235465 46716 2 0.0826846595685097
599901 599901 236289 236289 46716 1 2.70444062932811e-05
828942 828942 287561 287561 46716 1 0.0535357100835392
936872 936872 334572 334572 46716 1 0.113207547169811
1755531 1755531 538046 538046 46716 7 0.45993031358885 
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)
);