consensus_index

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

13 rows where inventory_id = 240179

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
670841 670841 240179 240179 1680 1 0.191298896770397
670842 670842 240179 240179 114182 1 0.191298896770397
670843 670843 240179 240179 141992 3 0.105275839988276
670844 670844 240179 240179 216084 3 0.0436803426723451
670845 670845 240179 240179 314227 2 0.0478247241925993
670846 670846 240179 240179 314228 1 0.0173908087973088
670847 670847 240179 240179 314394 1 0.0382597793540794
670848 670848 240179 240179 314403 3 0.151834034986842
670849 670849 240179 240179 315064 3 0.0835574895721124
670850 670850 240179 240179 315617 2 0.0493931627559733
670851 670851 240179 240179 332931 2 0.0276116173865168
670852 670852 240179 240179 340218 2 0.0241013955683566
670853 670853 240179 240179 343676 2 0.0213878668599662 
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)
);