consensus_index

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

8 rows where inventory_id = 51661

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
144903 144903 51661 51661 452 5 0.317384590953797
144904 144904 51661 51661 10711 2 0.100365820165487
144905 144905 51661 51661 13291 2 0.158692295476899
144906 144906 51661 51661 76292 1 0.158692295476899
144907 144907 51661 51661 142927 1 0.0453406558505424
144908 144908 51661 51661 147777 1 0.0528974318256328
144909 144909 51661 51661 147783 1 0.105794863651266
144910 144910 51661 51661 308904 1 0.0396730738692246 
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)
);