consensus_index

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

14 rows where inventory_id = 418533

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1271991 1271991 418533 418533 1235 2 0.151743199129967
1271992 1271992 418533 418533 9328 1 0.101162132753311
1271993 1271993 418533 418533 31902 8 0.303486398259933
1271994 1271994 418533 418533 48605 1 0.0606972796519867
1271995 1271995 418533 418533 72769 1 0.0758715995649833
1271996 1271996 418533 418533 84210 1 0.0275896725690849
1271997 1271997 418533 418533 171576 1 0.0303486398259933
1271998 1271998 418533 418533 179388 1 0.0505810663766556
1271999 1271999 418533 418533 183363 1 0.0379357997824917
1272000 1272000 418533 418533 183514 1 0.0337207109177704
1272001 1272001 418533 418533 221686 1 0.0433551997514191
1272002 1272002 418533 418533 252412 1 0.0252905331883278
1272003 1272003 418533 418533 253801 1 0.0233451075584564
1272004 1272004 418533 418533 314908 1 0.0216775998757095 
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)
);