consensus_index

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

16 rows where inchi_id = 187516

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
71551 71551 24292 24292 187516 4 0.263736263736264
171972 171972 61378 61378 187516 1 0.258620689655172
189185 189185 67418 67418 187516 4 0.263736263736264
393302 393302 135680 135680 187516 4 0.263736263736264
487562 487562 181432 181432 187516 1 0.258620689655172
494317 494317 187200 187200 187516 2 0.260869565217391
508696 508696 203541 203541 187516 2 0.260869565217391
539519 539519 213852 213852 187516 4 0.263736263736264
709071 709071 251663 251663 187516 1 0.259842519685039
727803 727803 256940 256940 187516 4 0.263736263736264
841623 841623 291776 291776 187516 4 0.263736263736264
841626 841626 291777 291777 187516 2 0.260869565217391
897092 897092 315176 315176 187516 2 0.257142857142857
1682707 1682707 511494 511494 187516 1 0.259842519685039
1684608 1684608 512226 512226 187516 2 0.215614266373077
1708813 1708813 522634 522634 187516 4 0.263736263736264 
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)
);