consensus_index

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

10 rows where inventory_id = 227770

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
582549 582549 227770 227770 860 1 0.222843017108624
582550 582550 227770 227770 9318 2 0.157573808537578
582551 582551 227770 227770 9322 1 0.0371405028514373
582552 582552 227770 227770 97376 5 0.222843017108624
582553 582553 227770 227770 139050 1 0.0318347167298034
582554 582554 227770 227770 149671 1 0.0557107542771559
582555 582555 227770 227770 230782 1 0.111421508554312
582556 582556 227770 227770 248492 1 0.0445686034217248
582557 582557 227770 227770 249880 1 0.0742810057028746
582558 582558 227770 227770 266315 1 0.027855377138578 
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)
);