consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
66 rows where inchi_id = 85142
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 29165 | 29165 | 8451 8451 | 85142 | 2 | 0.201744009531245 |
| 32147 | 32147 | 9446 9446 | 85142 | 8 | 0.461538461538462 |
| 91274 | 91274 | 32562 32562 | 85142 | 2 | 0.201744009531245 |
| 91279 | 91279 | 32564 32564 | 85142 | 8 | 0.461538461538462 |
| 152465 | 152465 | 54857 54857 | 85142 | 8 | 0.461538461538462 |
| 152482 | 152482 | 54861 54861 | 85142 | 2 | 0.201744009531245 |
| 249907 | 249907 | 84973 84973 | 85142 | 7 | 0.461538461538462 |
| 442834 | 442834 | 158730 158730 | 85142 | 7 | 0.461538461538462 |
| 442838 | 442838 | 158731 158731 | 85142 | 1 | 0.172413793103448 |
| 522450 | 522450 | 208444 208444 | 85142 | 8 | 0.356093869404554 |
| 533200 | 533200 | 211508 211508 | 85142 | 8 | 0.462908011869436 |
| 667113 | 667113 | 238940 238940 | 85142 | 7 | 0.461538461538462 |
| 710391 | 710391 | 252026 252026 | 85142 | 2 | 0.201744009531245 |
| 734889 | 734889 | 259235 259235 | 85142 | 8 | 0.462908011869436 |
| 809699 | 809699 | 281889 281889 | 85142 | 2 | 0.201744009531245 |
| 856265 | 856265 | 296203 296203 | 85142 | 8 | 0.462908011869436 |
| 856269 | 856269 | 296204 296204 | 85142 | 5 | 0.455696202531646 |
| 856273 | 856273 | 296205 296205 | 85142 | 8 | 0.410058718282766 |
| 856278 | 856278 | 296206 296206 | 85142 | 8 | 0.356093869404554 |
| 856284 | 856284 | 296207 296207 | 85142 | 5 | 0.455696202531646 |
| 856288 | 856288 | 296208 296208 | 85142 | 5 | 0.455696202531646 |
| 951310 | 951310 | 341289 341289 | 85142 | 4 | 0.452830188679245 |
| 1173610 | 1173610 | 394008 394008 | 85142 | 8 | 0.462908011869436 |
| 1173614 | 1173614 | 394009 394009 | 85142 | 8 | 0.462908011869436 |
| 1173618 | 1173618 | 394010 394010 | 85142 | 8 | 0.462908011869436 |
| 1173622 | 1173622 | 394011 394011 | 85142 | 8 | 0.462908011869436 |
| 1173626 | 1173626 | 394012 394012 | 85142 | 8 | 0.462908011869436 |
| 1173630 | 1173630 | 394013 394013 | 85142 | 8 | 0.462908011869436 |
| 1173634 | 1173634 | 394014 394014 | 85142 | 8 | 0.462908011869436 |
| 1173638 | 1173638 | 394015 394015 | 85142 | 8 | 0.462908011869436 |
| 1173642 | 1173642 | 394016 394016 | 85142 | 8 | 0.462908011869436 |
| 1173646 | 1173646 | 394017 394017 | 85142 | 8 | 0.462908011869436 |
| 1173650 | 1173650 | 394018 394018 | 85142 | 8 | 0.462908011869436 |
| 1173654 | 1173654 | 394019 394019 | 85142 | 8 | 0.462908011869436 |
| 1173658 | 1173658 | 394020 394020 | 85142 | 8 | 0.462908011869436 |
| 1173662 | 1173662 | 394021 394021 | 85142 | 8 | 0.462908011869436 |
| 1173666 | 1173666 | 394022 394022 | 85142 | 8 | 0.462908011869436 |
| 1173670 | 1173670 | 394023 394023 | 85142 | 8 | 0.462908011869436 |
| 1173674 | 1173674 | 394024 394024 | 85142 | 8 | 0.462908011869436 |
| 1173678 | 1173678 | 394025 394025 | 85142 | 8 | 0.462908011869436 |
| 1429171 | 1429171 | 445658 445658 | 85142 | 8 | 0.462908011869436 |
| 1429175 | 1429175 | 445659 445659 | 85142 | 8 | 0.462908011869436 |
| 1429179 | 1429179 | 445660 445660 | 85142 | 8 | 0.462908011869436 |
| 1429183 | 1429183 | 445661 445661 | 85142 | 8 | 0.462908011869436 |
| 1429187 | 1429187 | 445662 445662 | 85142 | 8 | 0.462908011869436 |
| 1429191 | 1429191 | 445663 445663 | 85142 | 8 | 0.462908011869436 |
| 1429195 | 1429195 | 445664 445664 | 85142 | 8 | 0.462908011869436 |
| 1429199 | 1429199 | 445665 445665 | 85142 | 8 | 0.462908011869436 |
| 1429203 | 1429203 | 445666 445666 | 85142 | 8 | 0.462908011869436 |
| 1429207 | 1429207 | 445667 445667 | 85142 | 8 | 0.462908011869436 |
| 1429211 | 1429211 | 445668 445668 | 85142 | 8 | 0.462908011869436 |
| 1429215 | 1429215 | 445669 445669 | 85142 | 8 | 0.462908011869436 |
| 1586478 | 1586478 | 478975 478975 | 85142 | 8 | 0.462908011869436 |
| 1586482 | 1586482 | 478976 478976 | 85142 | 8 | 0.462908011869436 |
| 1586486 | 1586486 | 478977 478977 | 85142 | 8 | 0.462908011869436 |
| 1586490 | 1586490 | 478978 478978 | 85142 | 8 | 0.462908011869436 |
| 1586494 | 1586494 | 478979 478979 | 85142 | 8 | 0.462908011869436 |
| 1586498 | 1586498 | 478980 478980 | 85142 | 8 | 0.462908011869436 |
| 1586502 | 1586502 | 478981 478981 | 85142 | 8 | 0.462908011869436 |
| 1586506 | 1586506 | 478982 478982 | 85142 | 8 | 0.462908011869436 |
| 1586510 | 1586510 | 478983 478983 | 85142 | 8 | 0.462908011869436 |
| 1606928 | 1606928 | 485489 485489 | 85142 | 8 | 0.462908011869436 |
| 1625480 | 1625480 | 490867 490867 | 85142 | 2 | 0.201744009531245 |
| 1631420 | 1631420 | 493045 493045 | 85142 | 8 | 0.462908011869436 |
| 1725840 | 1725840 | 528440 528440 | 85142 | 2 | 0.201744009531245 |
| 1728521 | 1728521 | 529338 529338 | 85142 | 8 | 0.461538461538462 |
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)
);