consensus_index

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

10 rows where inventory_id = 78651

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
229301 229301 78651 78651 4808 2 0.038235156982941
229302 229302 78651 78651 12675 2 0.0825973793231198
229303 229303 78651 78651 12885 4 0.16090031381126
229304 229304 78651 78651 106044 1 0.0476876191865609
229305 229305 78651 78651 106113 6 0.286125715119365
229306 229306 78651 78651 114845 1 0.143062857559683
229307 229307 78651 78651 139258 1 0.0408751021599093
229308 229308 78651 78651 223421 2 0.0825973793231198
229309 229309 78651 78651 230454 1 0.0476876191865609
229310 229310 78651 78651 324664 1 0.057225143023873 
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)
);