consensus_index

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

24 rows where inchi_id = 53791

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42136 42136 12825 12825 53791 6 0.384615384615385
42499 42499 12923 12923 53791 1 0.0545182372632438
83702 83702 30130 30130 53791 6 0.384615384615385
191298 191298 68060 68060 53791 1 0.0266532081984536
193181 193181 68705 68705 53791 6 0.384615384615385
286588 286588 97088 97088 53791 5 0.382978723404255
456424 456424 164013 164013 53791 5 0.382978723404255
524543 524543 209048 209048 53791 1 0.0563315035509415
524550 524550 209049 209049 53791 1 0.0371753555057718
551745 551745 217992 217992 53791 5 0.382978723404255
715975 715975 253310 253310 53791 1 0.0516826926369425
816173 816173 283472 283472 53791 6 0.384615384615385
818611 818611 284185 284185 53791 1 0.0560225407860943
818617 818617 284186 284186 53791 1 0.0545182372632438
818623 818623 284187 284187 53791 1 0.0560225407860943
904295 904295 318871 318871 53791 3 0.375
925458 925458 328966 328966 53791 1 0.0560225407860943
1072267 1072267 376644 376644 53791 6 0.384615384615385
1298657 1298657 424624 424624 53791 6 0.384615384615385
1508019 1508019 465388 465388 53791 6 0.384615384615385
1601437 1601437 483738 483738 53791 6 0.384615384615385
1648009 1648009 499022 499022 53791 6 0.384615384615385
1737075 1737075 532139 532139 53791 6 0.384615384615385
1737367 1737367 532210 532210 53791 1 0.0545182372632438 
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)
);