consensus_index

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

27 rows where inchi_id = 186367

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
26532 26532 7739 7739 186367 3 0.27668111204776
44826 44826 13699 13699 186367 2 0.0411257333188546
81301 81301 29300 29300 186367 2 0.0411257333188546
81312 81312 29302 29302 186367 3 0.27668111204776
174137 174137 62205 62205 186367 3 0.0433674110149464
174151 174151 62207 62207 186367 3 0.27668111204776
228461 228461 78505 78505 186367 2 0.0735721372613247
275550 275550 93437 93437 186367 4 0.31413612565445
354033 354033 119806 119806 186367 2 0.0918172963073402
434764 434764 156178 156178 186367 1 0.140845070422535
452482 452482 162412 162412 186367 4 0.308491383545233
459183 459183 165069 165069 186367 2 0.0471245168232799
483418 483418 177963 177963 186367 1 0.105263157894737
542523 542523 214662 214662 186367 2 0.046232334802912
702815 702815 250294 250294 186367 2 0.0918172963073402
724900 724900 256146 256146 186367 3 0.0456238783460059
766678 766678 268443 268443 186367 2 0.175777121958412
766683 766683 268444 268444 186367 1 0.139211136890951
835923 835923 290033 290033 186367 2 0.0411257333188546
835932 835932 290034 290034 186367 1 0.0416470196750692
835943 835943 290035 290035 186367 2 0.0466689656342196
897813 897813 315550 315550 186367 1 0.0415804158137042
953193 953193 342085 342085 186367 1 0.139211136890951
1621160 1621160 489550 489550 186367 2 0.175777121958412
1651270 1651270 500125 500125 186367 2 0.0411257333188546
1738907 1738907 532648 532648 186367 2 0.0411257333188546
1754828 1754828 537750 537750 186367 1 0.105263157894737 
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)
);