consensus_index

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

15 rows where inventory_id = 489748

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1621917 1621917 489748 489748 30575 8 0.270162403645047
1621918 1621918 489748 489748 46499 2 0.110293339435698
1621919 1621919 489748 489748 63043 1 0.135081201822523
1621920 1621920 489748 489748 120237 1 0.0192973145460748
1621921 1621921 489748 489748 139934 1 0.0900541345483488
1621922 1621922 489748 489748 216509 1 0.0540324807290093
1621923 1621923 489748 489748 256376 1 0.0385946290921495
1621924 1621924 489748 489748 256829 1 0.0675406009112616
1621925 1621925 489748 489748 274146 1 0.0270162403645047
1621926 1621926 489748 489748 274224 1 0.0450270672741744
1621927 1621927 489748 489748 274347 1 0.0300180448494496
1621928 1621928 489748 489748 288980 1 0.0245602185131861
1621929 1621929 489748 489748 289755 1 0.0225135336370872
1621930 1621930 489748 489748 322818 1 0.0337703004556308
1621931 1621931 489748 489748 322830 1 0.0207817233573113 
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)
);