consensus_index

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

22 rows where inventory_id = 37123

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
105541 105541 37123 37123 5011 8 0.265939421082208
105542 105542 37123 37123 15620 1 0.0189956729344434
105543 105543 37123 37123 44609 2 0.0170952334574595
105544 105544 37123 37123 136814 3 0.116159741530349
105545 105545 37123 37123 137765 2 0.0566984750819231
105546 105546 37123 37123 154758 1 0.0295488245646898
105547 105547 37123 37123 174105 3 0.0481962178154241
105548 105548 37123 37123 177769 3 0.0747673315773904
105549 105549 37123 37123 189174 3 0.0339653144700962
105550 105550 37123 37123 192049 3 0.0334173910033832
105551 105551 37123 37123 196026 3 0.0454750013323702
105552 105552 37123 37123 196693 3 0.0507374404948653
105553 105553 37123 37123 207804 1 0.0204568785447853
105554 105554 37123 37123 213930 2 0.0410353435599641
105555 105555 37123 37123 214032 2 0.0210243572561595
105556 105556 37123 37123 217158 2 0.0167526088569526
105557 105557 37123 37123 224600 2 0.0242768366427651
105558 105558 37123 37123 233560 1 0.0132969710541104
105559 105559 37123 37123 235289 2 0.0169213201509208
105560 105560 37123 37123 265398 2 0.0167526088569526
105561 105561 37123 37123 266465 1 0.0177292947388139
105562 105562 37123 37123 310242 1 0.015643495357777 
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)
);