consensus_index

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

12 rows where inventory_id = 220009

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
559138 559138 220009 220009 31915 2 0.0497768415451947
559139 559139 220009 220009 44265 8 0.314816388024221
559140 559140 220009 220009 137026 1 0.0349795986693579
559141 559141 220009 220009 137531 2 0.157408194012111
559142 559142 220009 220009 169517 2 0.0396631367314144
559143 559143 220009 220009 185691 1 0.0449737697177459
559144 559144 220009 220009 191999 2 0.0908796631855449
559145 559145 220009 220009 197718 2 0.0445217605601164
559146 559146 220009 220009 208868 2 0.0908796631855449
559147 559147 220009 220009 240640 2 0.0524693980040368
559148 559148 220009 220009 266983 1 0.0393520485030276
559149 559149 220009 220009 279901 1 0.0286196716385656 
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)
);