consensus_index

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

9 rows where inventory_id = 209874

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
528185 528185 209874 209874 12829 2 0.12843404218829
528186 528186 209874 209874 16245 2 0.0681124366249041
528187 528187 209874 209874 16246 10 0.26925957496389
528188 528188 209874 209874 45298 1 0.0428113473960966
528189 528189 209874 209874 45550 2 0.0728152576082127
528190 528190 209874 209874 45971 2 0.192651063282435
528191 528191 209874 209874 150005 1 0.0770604253129739
528192 528192 209874 209874 155725 1 0.0770604253129739
528193 528193 209874 209874 172978 1 0.0550431609378385 
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)
);