consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
103 rows where inchi_id = 3916
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 176 | 176 | 36 36 | 3916 | 1 | 0.15929203539823 |
| 29024 | 29024 | 8401 8401 | 3916 | 1 | 0.187951807228916 |
| 32566 | 32566 | 9594 9594 | 3916 | 8 | 0.625 |
| 40740 | 40740 | 12355 12355 | 3916 | 1 | 0.259842519685039 |
| 94621 | 94621 | 33594 33594 | 3916 | 1 | 0.187951807228916 |
| 171534 | 171534 | 61212 61212 | 3916 | 1 | 0.263157894736842 |
| 193642 | 193642 | 68831 68831 | 3916 | 1 | 0.15929203539823 |
| 241445 | 241445 | 82073 82073 | 3916 | 1 | 0.3125 |
| 252745 | 252745 | 85867 85867 | 3916 | 8 | 0.478260869565217 |
| 284266 | 284266 | 96388 96388 | 3916 | 1 | 0.259842519685039 |
| 439295 | 439295 | 157445 157445 | 3916 | 1 | 0.3125 |
| 443758 | 443758 | 159077 159077 | 3916 | 8 | 0.478260869565217 |
| 455716 | 455716 | 163751 163751 | 3916 | 1 | 0.259842519685039 |
| 710038 | 710038 | 251918 251918 | 3916 | 1 | 0.187951807228916 |
| 710572 | 710572 | 252075 252075 | 3916 | 1 | 0.259842519685039 |
| 809072 | 809072 | 281697 281697 | 3916 | 1 | 0.187951807228916 |
| 810028 | 810028 | 282001 282001 | 3916 | 1 | 0.253012048192771 |
| 810031 | 810031 | 282002 282002 | 3916 | 1 | 0.259842519685039 |
| 953292 | 953292 | 342140 342140 | 3916 | 1 | 0.253012048192771 |
| 953318 | 953318 | 342146 342146 | 3916 | 4 | 0.6 |
| 1061959 | 1061959 | 374970 374970 | 3916 | 1 | 0.187951807228916 |
| 1061964 | 1061964 | 374971 374971 | 3916 | 1 | 0.187951807228916 |
| 1061969 | 1061969 | 374972 374972 | 3916 | 1 | 0.187951807228916 |
| 1061974 | 1061974 | 374973 374973 | 3916 | 1 | 0.187951807228916 |
| 1061979 | 1061979 | 374974 374974 | 3916 | 1 | 0.187951807228916 |
| 1061984 | 1061984 | 374975 374975 | 3916 | 1 | 0.187951807228916 |
| 1061989 | 1061989 | 374976 374976 | 3916 | 1 | 0.187951807228916 |
| 1061994 | 1061994 | 374977 374977 | 3916 | 1 | 0.187951807228916 |
| 1061999 | 1061999 | 374978 374978 | 3916 | 1 | 0.187951807228916 |
| 1062004 | 1062004 | 374979 374979 | 3916 | 1 | 0.187951807228916 |
| 1062009 | 1062009 | 374980 374980 | 3916 | 1 | 0.187951807228916 |
| 1062014 | 1062014 | 374981 374981 | 3916 | 1 | 0.187951807228916 |
| 1062019 | 1062019 | 374982 374982 | 3916 | 1 | 0.187951807228916 |
| 1062024 | 1062024 | 374983 374983 | 3916 | 1 | 0.187951807228916 |
| 1062029 | 1062029 | 374984 374984 | 3916 | 1 | 0.187951807228916 |
| 1062034 | 1062034 | 374985 374985 | 3916 | 1 | 0.187951807228916 |
| 1062039 | 1062039 | 374986 374986 | 3916 | 1 | 0.187951807228916 |
| 1062044 | 1062044 | 374987 374987 | 3916 | 1 | 0.187951807228916 |
| 1062049 | 1062049 | 374988 374988 | 3916 | 1 | 0.187951807228916 |
| 1062054 | 1062054 | 374989 374989 | 3916 | 1 | 0.187951807228916 |
| 1062059 | 1062059 | 374990 374990 | 3916 | 1 | 0.187951807228916 |
| 1062064 | 1062064 | 374991 374991 | 3916 | 1 | 0.187951807228916 |
| 1062069 | 1062069 | 374992 374992 | 3916 | 1 | 0.187951807228916 |
| 1062074 | 1062074 | 374993 374993 | 3916 | 1 | 0.187951807228916 |
| 1062079 | 1062079 | 374994 374994 | 3916 | 1 | 0.187951807228916 |
| 1285855 | 1285855 | 422686 422686 | 3916 | 1 | 0.187951807228916 |
| 1285860 | 1285860 | 422687 422687 | 3916 | 1 | 0.187951807228916 |
| 1285865 | 1285865 | 422688 422688 | 3916 | 1 | 0.187951807228916 |
| 1285870 | 1285870 | 422689 422689 | 3916 | 1 | 0.187951807228916 |
| 1285875 | 1285875 | 422690 422690 | 3916 | 1 | 0.187951807228916 |
| 1285880 | 1285880 | 422691 422691 | 3916 | 1 | 0.187951807228916 |
| 1285885 | 1285885 | 422692 422692 | 3916 | 1 | 0.187951807228916 |
| 1285890 | 1285890 | 422693 422693 | 3916 | 1 | 0.187951807228916 |
| 1285895 | 1285895 | 422694 422694 | 3916 | 1 | 0.187951807228916 |
| 1285900 | 1285900 | 422695 422695 | 3916 | 1 | 0.187951807228916 |
| 1285905 | 1285905 | 422696 422696 | 3916 | 1 | 0.187951807228916 |
| 1285910 | 1285910 | 422697 422697 | 3916 | 1 | 0.187951807228916 |
| 1285915 | 1285915 | 422698 422698 | 3916 | 1 | 0.187951807228916 |
| 1285920 | 1285920 | 422699 422699 | 3916 | 1 | 0.187951807228916 |
| 1285925 | 1285925 | 422700 422700 | 3916 | 1 | 0.187951807228916 |
| 1285930 | 1285930 | 422701 422701 | 3916 | 1 | 0.187951807228916 |
| 1285935 | 1285935 | 422702 422702 | 3916 | 1 | 0.187951807228916 |
| 1285940 | 1285940 | 422703 422703 | 3916 | 1 | 0.187951807228916 |
| 1285945 | 1285945 | 422704 422704 | 3916 | 1 | 0.187951807228916 |
| 1285950 | 1285950 | 422705 422705 | 3916 | 1 | 0.187951807228916 |
| 1285955 | 1285955 | 422706 422706 | 3916 | 1 | 0.187951807228916 |
| 1285960 | 1285960 | 422707 422707 | 3916 | 1 | 0.187951807228916 |
| 1285965 | 1285965 | 422708 422708 | 3916 | 1 | 0.187951807228916 |
| 1285970 | 1285970 | 422709 422709 | 3916 | 1 | 0.187951807228916 |
| 1285975 | 1285975 | 422710 422710 | 3916 | 1 | 0.187951807228916 |
| 1285980 | 1285980 | 422711 422711 | 3916 | 1 | 0.187951807228916 |
| 1285985 | 1285985 | 422712 422712 | 3916 | 1 | 0.187951807228916 |
| 1285990 | 1285990 | 422713 422713 | 3916 | 1 | 0.187951807228916 |
| 1285995 | 1285995 | 422714 422714 | 3916 | 1 | 0.187951807228916 |
| 1286000 | 1286000 | 422715 422715 | 3916 | 1 | 0.187951807228916 |
| 1286005 | 1286005 | 422716 422716 | 3916 | 1 | 0.187951807228916 |
| 1286010 | 1286010 | 422717 422717 | 3916 | 1 | 0.187951807228916 |
| 1286015 | 1286015 | 422718 422718 | 3916 | 1 | 0.187951807228916 |
| 1286020 | 1286020 | 422719 422719 | 3916 | 1 | 0.187951807228916 |
| 1500528 | 1500528 | 464189 464189 | 3916 | 1 | 0.187951807228916 |
| 1500533 | 1500533 | 464190 464190 | 3916 | 1 | 0.187951807228916 |
| 1500538 | 1500538 | 464191 464191 | 3916 | 1 | 0.187951807228916 |
| 1500543 | 1500543 | 464192 464192 | 3916 | 1 | 0.187951807228916 |
| 1500548 | 1500548 | 464193 464193 | 3916 | 1 | 0.187951807228916 |
| 1500553 | 1500553 | 464194 464194 | 3916 | 1 | 0.187951807228916 |
| 1500558 | 1500558 | 464195 464195 | 3916 | 1 | 0.187951807228916 |
| 1500563 | 1500563 | 464196 464196 | 3916 | 1 | 0.187951807228916 |
| 1500568 | 1500568 | 464197 464197 | 3916 | 1 | 0.187951807228916 |
| 1500573 | 1500573 | 464198 464198 | 3916 | 1 | 0.187951807228916 |
| 1500578 | 1500578 | 464199 464199 | 3916 | 1 | 0.187951807228916 |
| 1500583 | 1500583 | 464200 464200 | 3916 | 1 | 0.187951807228916 |
| 1500588 | 1500588 | 464201 464201 | 3916 | 1 | 0.187951807228916 |
| 1500593 | 1500593 | 464202 464202 | 3916 | 1 | 0.187951807228916 |
| 1500598 | 1500598 | 464203 464203 | 3916 | 1 | 0.187951807228916 |
| 1500603 | 1500603 | 464204 464204 | 3916 | 1 | 0.187951807228916 |
| 1500608 | 1500608 | 464205 464205 | 3916 | 1 | 0.187951807228916 |
| 1500613 | 1500613 | 464206 464206 | 3916 | 1 | 0.187951807228916 |
| 1500618 | 1500618 | 464207 464207 | 3916 | 1 | 0.187951807228916 |
| 1600575 | 1600575 | 483512 483512 | 3916 | 1 | 0.187951807228916 |
| 1625291 | 1625291 | 490792 490792 | 3916 | 1 | 0.187951807228916 |
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)
);