consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
44 rows where inventory_id = 249100
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 698880 | 698880 | 249100 249100 | 33625 | 10 | 0.204392898488766 |
| 698881 | 698881 | 249100 249100 | 136744 | 2 | 0.0834430513909927 |
| 698882 | 698882 | 249100 249100 | 148642 | 2 | 0.0263870097310018 |
| 698883 | 698883 | 249100 249100 | 160388 | 1 | 0.015722530652982 |
| 698884 | 698884 | 249100 249100 | 185881 | 1 | 0.00851637077036526 |
| 698885 | 698885 | 249100 249100 | 185882 | 1 | 0.00817571593955065 |
| 698886 | 698886 | 249100 249100 | 185883 | 1 | 0.00786126532649101 |
| 698887 | 698887 | 249100 249100 | 185884 | 2 | 0.0834430513909927 |
| 698888 | 698888 | 249100 249100 | 185885 | 1 | 0.00757010735143579 |
| 698889 | 698889 | 249100 249100 | 185886 | 1 | 0.00729974637459879 |
| 698890 | 698890 | 249100 249100 | 186838 | 3 | 0.0752989876131022 |
| 698891 | 698891 | 249100 249100 | 187778 | 2 | 0.0111505467718595 |
| 698892 | 698892 | 249100 249100 | 191748 | 1 | 0.0136261932325844 |
| 698893 | 698893 | 249100 249100 | 192682 | 1 | 0.00973299516613172 |
| 698894 | 698894 | 249100 249100 | 193071 | 1 | 0.00929058629494392 |
| 698895 | 698895 | 249100 249100 | 193583 | 1 | 0.0291989854983952 |
| 698896 | 698896 | 249100 249100 | 199452 | 1 | 0.0120231116758098 |
| 698897 | 698897 | 249100 249100 | 199618 | 1 | 0.0113551610271537 |
| 698898 | 698898 | 249100 249100 | 199784 | 1 | 0.00601155583790489 |
| 698899 | 698899 | 249100 249100 | 199952 | 1 | 0.00704803098237125 |
| 698900 | 698900 | 249100 249100 | 200211 | 1 | 0.00619372419662928 |
| 698901 | 698901 | 249100 249100 | 200445 | 1 | 0.00583979709967903 |
| 698902 | 698902 | 249100 249100 | 200483 | 2 | 0.0457036415139095 |
| 698903 | 698903 | 249100 249100 | 200908 | 2 | 0.0323173548394044 |
| 698904 | 698904 | 249100 249100 | 201183 | 1 | 0.010757520973093 |
| 698905 | 698905 | 249100 249100 | 201184 | 1 | 0.0102196449244383 |
| 698906 | 698906 | 249100 249100 | 202991 | 2 | 0.0240879340912967 |
| 698907 | 698907 | 249100 249100 | 203133 | 1 | 0.00681309661629221 |
| 698908 | 698908 | 249100 249100 | 204204 | 1 | 0.00888664776038114 |
| 698909 | 698909 | 249100 249100 | 204337 | 2 | 0.0165241864626536 |
| 698910 | 698910 | 249100 249100 | 205019 | 1 | 0.00638727807777394 |
| 698911 | 698911 | 249100 249100 | 206287 | 1 | 0.00659331930608923 |
| 698912 | 698912 | 249100 249100 | 223370 | 1 | 0.0145994927491976 |
| 698913 | 698913 | 249100 249100 | 243428 | 1 | 0.00537876048654648 |
| 698914 | 698914 | 249100 249100 | 247265 | 2 | 0.0157692544726392 |
| 698915 | 698915 | 249100 249100 | 254897 | 2 | 0.0121071904041749 |
| 698916 | 698916 | 249100 249100 | 258838 | 2 | 0.022301093543719 |
| 698917 | 698917 | 249100 249100 | 261709 | 1 | 0.0127745561555479 |
| 698918 | 698918 | 249100 249100 | 275453 | 4 | 0.0439444809477669 |
| 698919 | 698919 | 249100 249100 | 276386 | 2 | 0.0185811725898878 |
| 698920 | 698920 | 249100 249100 | 297594 | 2 | 0.0114259103784774 |
| 698921 | 698921 | 249100 249100 | 309925 | 2 | 0.00802931136376557 |
| 698922 | 698922 | 249100 249100 | 323929 | 2 | 0.00751363238105381 |
| 698923 | 698923 | 249100 249100 | 334598 | 2 | 0.00697785850163287 |
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)
);