consensus_index

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

20 rows where inventory_id = 114012

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
338143 338143 114012 114012 28878 9 0.222251217027391
338144 338144 114012 114012 56470 2 0.103563848719419
338145 338145 114012 114012 136652 3 0.0942712842697924
338146 338146 114012 114012 139413 2 0.0553572056519647
338147 338147 114012 114012 148891 2 0.0756323414475711
338148 338148 114012 114012 155895 1 0.0488204664768526
338149 338149 114012 114012 177100 2 0.0292922798861116
338150 338150 114012 114012 185985 1 0.0162734888256175
338151 338151 114012 114012 192130 2 0.0244954350096522
338152 338152 114012 114012 195198 1 0.0172307528741833
338153 338153 114012 114012 199939 1 0.0266293453510105
338154 338154 114012 114012 214904 2 0.034521282906473
338155 338155 114012 114012 219176 1 0.0366153498576395
338156 338156 114012 114012 225386 1 0.0225325229893166
338157 338157 114012 114012 227385 1 0.019528186590741
338158 338158 114012 114012 228983 1 0.0209230570615083
338159 338159 114012 114012 229268 1 0.0418461141230165
338160 338160 114012 114012 232026 1 0.0488204664768526
338161 338161 114012 114012 233141 1 0.0325469776512351
338162 338162 114012 114012 240067 2 0.0211398820967805 
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)
);