consensus_index

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

25 rows where inchi_id = 185614

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18119 18119 5298 5298 185614 2 0.167695206606939
49020 49020 15066 15066 185614 4 0.303715408416645
81036 81036 29220 29220 185614 1 0.166909524440323
123949 123949 42993 42993 185614 1 0.156335386820615
156843 156843 56414 56414 185614 2 0.167695206606939
215959 215959 74993 74993 185614 2 0.161096759925069
303546 303546 102672 102672 185614 1 0.156335386820615
303772 303772 102730 102730 185614 4 0.303715408416645
394119 394119 136074 136074 185614 1 0.146341463414634
395354 395354 136697 136697 185614 4 0.255467924064161
426364 426364 153791 153791 185614 1 0.16664462372702
535752 535752 212627 212627 185614 2 0.165105647971802
589564 589564 230150 230150 185614 4 0.303715408416645
676614 676614 241807 241807 185614 4 0.303715408416645
731186 731186 257877 257877 185614 3 0.266218971852111
732296 732296 258236 258236 185614 2 0.159026172615507
851070 851070 294436 294436 185614 1 0.16664462372702
851080 851080 294437 294437 185614 1 0.16664462372702
890591 890591 312052 312052 185614 2 0.314139685724475
956242 956242 343550 343550 185614 2 0.387096774193548
1611811 1611811 486564 486564 185614 1 0.167142004377529
1656550 1656550 501945 501945 185614 4 0.303715408416645
1717529 1717529 526010 526010 185614 2 0.167695206606939
1743249 1743249 533907 533907 185614 1 0.156335386820615
1761917 1761917 541034 541034 185614 3 0.266218971852111 
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)
);