consensus_index

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

22 rows where inventory_id = 7179

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
24492 24492 7179 7179 5011 8 0.265939421082208
24493 24493 7179 7179 15620 1 0.0189956729344434
24494 24494 7179 7179 44609 2 0.0170952334574595
24495 24495 7179 7179 136814 3 0.116159741530349
24496 24496 7179 7179 137765 2 0.0566984750819231
24497 24497 7179 7179 154758 1 0.0295488245646898
24498 24498 7179 7179 174105 3 0.0481962178154241
24499 24499 7179 7179 177769 3 0.0747673315773904
24500 24500 7179 7179 189174 3 0.0339653144700962
24501 24501 7179 7179 192049 3 0.0334173910033832
24502 24502 7179 7179 196026 3 0.0454750013323702
24503 24503 7179 7179 196693 3 0.0507374404948653
24504 24504 7179 7179 207804 1 0.0204568785447853
24505 24505 7179 7179 213930 2 0.0410353435599641
24506 24506 7179 7179 214032 2 0.0210243572561595
24507 24507 7179 7179 217158 2 0.0167526088569526
24508 24508 7179 7179 224600 2 0.0242768366427651
24509 24509 7179 7179 233560 1 0.0132969710541104
24510 24510 7179 7179 235289 2 0.0169213201509208
24511 24511 7179 7179 265398 2 0.0167526088569526
24512 24512 7179 7179 266465 1 0.0177292947388139
24513 24513 7179 7179 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)
);