consensus_index

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

25 rows where inchi_id = 195790

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13019 13019 4006 4006 195790 2 0.157329175368943
13064 13064 4010 4010 195790 2 0.0379546915223827
13102 13102 4013 4013 195790 2 0.183525594386367
25674 25674 7527 7527 195790 2 0.157329175368943
42705 42705 12969 12969 195790 2 0.0379546915223827
45670 45670 13931 13931 195790 2 0.183525594386367
105600 105600 37129 37129 195790 2 0.183525594386367
105609 105609 37130 37130 195790 2 0.157534432199669
157745 157745 56753 56753 195790 3 0.198176057803152
157779 157779 56767 56767 195790 2 0.157534432199669
296769 296769 100389 100389 195790 2 0.0670143462275784
679943 679943 242971 242971 195790 2 0.157329175368943
688120 688120 245408 245408 195790 1 0.103800193390652
716479 716479 253446 253446 195790 3 0.0329818240802164
757997 757997 266162 266162 195790 2 0.157329175368943
758011 758011 266163 266163 195790 1 0.15721139470662
819371 819371 284423 284423 195790 2 0.0379546915223827
819388 819388 284424 284424 195790 1 0.0199540595780381
819405 819405 284425 284425 195790 1 0.0199455554156219
928536 928536 330275 330275 195790 1 0.0199455554156219
944703 944703 338332 338332 195790 1 0.157081421078776
962366 962366 346434 346434 195790 1 0.0518625389025089
1620035 1620035 489205 489205 195790 3 0.228616802786461
1722486 1722486 527528 527528 195790 2 0.157329175368943
1737524 1737524 532239 532239 195790 2 0.0379546915223827 
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)
);