consensus_index

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

28 rows where inchi_id = 45582

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28365 28365 8222 8222 45582 8 0.375903614457831
29958 29958 8688 8688 45582 1 0.3125
90475 90475 32298 32298 45582 8 0.375903614457831
125752 125752 44938 44938 45582 1 0.0911007933895107
130663 130663 46480 46480 45582 12 0.295059122514055
158062 158062 56889 56889 45582 1 0.321428571428571
236141 236141 80506 80506 45582 8 0.461538461538462
241103 241103 81945 81945 45582 2 0.260869565217391
437172 437172 156764 156764 45582 8 0.461538461538462
439117 439117 157377 157377 45582 2 0.260869565217391
521202 521202 208019 208019 45582 8 0.375903614457831
521207 521207 208020 208020 45582 8 0.34434879615049
551424 551424 217896 217896 45582 1 0.310344827586207
558162 558162 219766 219766 45582 12 0.295059122514055
559503 559503 220114 220114 45582 1 0.0911007933895107
662804 662804 237646 237646 45582 11 0.294851982592019
704383 704383 250774 250774 45582 1 0.0911007933895107
706863 706863 251151 251151 45582 12 0.295059122514055
714681 714681 252964 252964 45582 2 0.263736263736264
804021 804021 280273 280273 45582 8 0.375903614457831
804026 804026 280274 280274 45582 8 0.461538461538462
816781 816781 283638 283638 45582 1 0.310344827586207
816783 816783 283639 283639 45582 1 0.3125
893193 893193 313370 313370 45582 1 0.262020410288673
962376 962376 346436 346436 45582 2 0.630993034743972
1624221 1624221 490467 490467 45582 8 0.375903614457831
1626487 1626487 491183 491183 45582 1 0.3125
1725071 1725071 528226 528226 45582 7 0.45993031358885 
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)
);