consensus_index

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

25 rows where inventory_id = 100389

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
296757 296757 100389 100389 7812 7 0.259545446896389
296758 296758 100389 100389 7814 1 0.0259545446896389
296759 296759 100389 100389 16385 1 0.086515148965463
296760 296760 100389 100389 55071 2 0.0203918161696144
296761 296761 100389 100389 56289 1 0.129772723448194
296762 296762 100389 100389 136466 1 0.0216287872413657
296763 296763 100389 100389 137781 1 0.0162215904310243
296764 296764 100389 100389 137782 1 0.0370779209851984
296765 296765 100389 100389 173830 2 0.0131257774344975
296766 296766 100389 100389 177699 1 0.0288383829884877
296767 296767 100389 100389 177859 1 0.0144191914942438
296768 296768 100389 100389 178304 1 0.0324431808620486
296769 296769 100389 100389 195790 2 0.0670143462275784
296770 296770 100389 100389 208659 2 0.0153741454196558
296771 296771 100389 100389 216127 1 0.0129772723448194
296772 296772 100389 100389 217035 1 0.0123593069950661
296773 296773 100389 100389 225334 2 0.0147889743728934
296774 296774 100389 100389 228810 1 0.0089498429964272
296775 296775 100389 100389 237761 1 0.0235950406269444
296776 296776 100389 100389 243179 1 0.0108143936206829
296777 296777 100389 100389 258455 1 0.0103818178758556
296778 296778 100389 100389 259480 1 0.00998251718832265
296779 296779 100389 100389 273967 1 0.0199650343766453
296780 296780 100389 100389 276015 2 0.0917631727632648
296781 296781 100389 100389 289582 1 0.0092694802462996 
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)
);