consensus_index

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

10 rows where inventory_id = 242742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
678989 678989 242742 242742 7535 1 0.188173887129062
678990 678990 242742 242742 135238 1 0.188173887129062
678991 678991 242742 242742 278137 1 0.0235217358911327
678992 678992 242742 242742 315492 2 0.133059031631191
678993 678993 242742 242742 315685 1 0.0470434717822654
678994 678994 242742 242742 317145 1 0.0376347774258123
678995 678995 242742 242742 317421 1 0.188173887129062
678996 678996 242742 242742 317911 2 0.054321122194211
678997 678997 242742 242742 321437 1 0.0268819838755802
678998 678998 242742 242742 332636 1 0.0627246290430205 
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)
);