consensus_index

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

22 rows where inventory_id = 264001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
750939 750939 264001 264001 5011 8 0.265939421082208
750940 750940 264001 264001 15620 1 0.0189956729344434
750941 750941 264001 264001 44609 2 0.0170952334574595
750942 750942 264001 264001 136814 3 0.116159741530349
750943 750943 264001 264001 137765 2 0.0566984750819231
750944 750944 264001 264001 154758 1 0.0295488245646898
750945 750945 264001 264001 174105 3 0.0481962178154241
750946 750946 264001 264001 177769 3 0.0747673315773904
750947 750947 264001 264001 189174 3 0.0339653144700962
750948 750948 264001 264001 192049 3 0.0334173910033832
750949 750949 264001 264001 196026 3 0.0454750013323702
750950 750950 264001 264001 196693 3 0.0507374404948653
750951 750951 264001 264001 207804 1 0.0204568785447853
750952 750952 264001 264001 213930 2 0.0410353435599641
750953 750953 264001 264001 214032 2 0.0210243572561595
750954 750954 264001 264001 217158 2 0.0167526088569526
750955 750955 264001 264001 224600 2 0.0242768366427651
750956 750956 264001 264001 233560 1 0.0132969710541104
750957 750957 264001 264001 235289 2 0.0169213201509208
750958 750958 264001 264001 265398 2 0.0167526088569526
750959 750959 264001 264001 266465 1 0.0177292947388139
750960 750960 264001 264001 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)
);