consensus_index

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

13 rows where inventory_id = 490014

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1622792 1622792 490014 490014 37114 3 0.140523407139873
1622793 1622793 490014 490014 77512 2 0.0613294428696729
1622794 1622794 490014 490014 133163 3 0.281046814279746
1622795 1622795 490014 490014 150458 1 0.0312274238088606
1622796 1622796 490014 490014 184959 1 0.140523407139873
1622797 1622797 490014 490014 230295 1 0.0936822714265819
1622798 1622798 490014 490014 235151 1 0.0216189857138266
1622799 1622799 490014 490014 235219 1 0.0468411357132909
1622800 1622800 490014 490014 237600 1 0.0351308517849682
1622801 1622801 490014 490014 251506 1 0.0562093628559491
1622802 1622802 490014 490014 288683 1 0.0281046814279746
1622803 1622803 490014 490014 288692 1 0.0255497103890678
1622804 1622804 490014 490014 309498 1 0.0234205678566455 
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)
);