consensus_index

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

16 rows where inventory_id = 53274

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
147988 147988 53274 53274 27859 1 0.0194657298890591
147989 147989 53274 53274 35681 9 0.20024255783087
147990 147990 53274 53274 48098 5 0.203350825438687
147991 147991 53274 53274 84939 3 0.0361407657964717
147992 147992 53274 53274 114589 1 0.116794379334355
147993 147993 53274 53274 119911 1 0.0179683660514392
147994 147994 53274 53274 136277 2 0.0467177517337419
147995 147995 53274 53274 139024 3 0.0778629195562364
147996 147996 53274 53274 147391 1 0.0333698226669585
147997 147997 53274 53274 153429 4 0.0627518641193452
147998 147998 53274 53274 169028 2 0.0233588758668709
147999 147999 53274 53274 190420 1 0.0333698226669585
148000 148000 53274 53274 231816 1 0.0389314597781182
148001 148001 53274 53274 240518 3 0.0367879242581901
148002 148002 53274 53274 260209 1 0.0259543065187455
148003 148003 53274 53274 309990 2 0.0212353416971554 
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)
);