consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
25 rows where inventory_id = 78047
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 226818 | 226818 | 78047 78047 | 8133 | 6 | 0.145340929881245 |
| 226819 | 226819 | 78047 78047 | 136435 | 3 | 0.0666014945922278 |
| 226820 | 226820 | 78047 78047 | 137779 | 1 | 0.0169164069085527 |
| 226821 | 226821 | 78047 78047 | 139655 | 1 | 0.0129360758712462 |
| 226822 | 226822 | 78047 78047 | 151115 | 2 | 0.0173856720886011 |
| 226823 | 226823 | 78047 78047 | 167949 | 2 | 0.0185860652555268 |
| 226824 | 226824 | 78047 78047 | 168944 | 4 | 0.130761224463558 |
| 226825 | 226825 | 78047 78047 | 169441 | 3 | 0.0473788820368252 |
| 226826 | 226826 | 78047 78047 | 169456 | 3 | 0.219913289811185 |
| 226827 | 226827 | 78047 78047 | 173771 | 1 | 0.0199921172555623 |
| 226828 | 226828 | 78047 78047 | 189218 | 3 | 0.0174866471873943 |
| 226829 | 226829 | 78047 78047 | 195847 | 2 | 0.0224448061539251 |
| 226830 | 226830 | 78047 78047 | 232929 | 1 | 0.0244348099790206 |
| 226831 | 226831 | 78047 78047 | 237231 | 2 | 0.0138532351152017 |
| 226832 | 226832 | 78047 78047 | 244140 | 1 | 0.0146608859874123 |
| 226833 | 226833 | 78047 78047 | 257446 | 3 | 0.0389487903158325 |
| 226834 | 226834 | 78047 78047 | 257697 | 1 | 0.0199921172555623 |
| 226835 | 226835 | 78047 78047 | 258888 | 2 | 0.0214613395569087 |
| 226836 | 226836 | 78047 78047 | 271958 | 1 | 0.0219913289811185 |
| 226837 | 226837 | 78047 78047 | 282132 | 3 | 0.0304149804875303 |
| 226838 | 226838 | 78047 78047 | 290002 | 3 | 0.0251070132115937 |
| 226839 | 226839 | 78047 78047 | 291005 | 1 | 0.0137445806131991 |
| 226840 | 226840 | 78047 78047 | 309501 | 3 | 0.0151807634922965 |
| 226841 | 226841 | 78047 78047 | 320945 | 1 | 0.0104720614195802 |
| 226842 | 226842 | 78047 78047 | 327222 | 1 | 0.00999605862778114 |
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)
);