consensus_index

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

21 rows where inventory_id = 33

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
144 144 33 33 35273 1 0.0388215482320788
145 145 33 33 55055 8 0.271750837624552
146 146 33 33 55227 1 0.020903910586504
147 147 33 33 56712 1 0.0143026756644501
148 148 33 33 138229 1 0.0905836125415172
149 149 33 33 139685 1 0.0452918062707586
150 150 33 33 141955 1 0.0339688547030689
151 151 33 33 143682 1 0.0679377094061379
152 152 33 33 177342 1 0.0543501675249103
153 153 33 33 184050 1 0.0181167225083034
154 154 33 33 201556 1 0.024704621602232
155 155 33 33 208270 1 0.135875418812276
156 156 33 33 215211 1 0.0135875418812276
157 157 33 33 227167 1 0.0129405160773596
158 158 33 33 243841 1 0.0194107741160394
159 159 33 33 259457 1 0.0301945375138391
160 160 33 33 259458 1 0.0271750837624552
161 161 33 33 283633 1 0.0226459031353793
162 162 33 33 323916 1 0.0169844273515345
163 163 33 33 323921 1 0.0159853433896795
164 164 33 33 323922 1 0.0150972687569195 
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)
);