consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
89 rows where inchi_id = 220831
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 29207 | 29207 | 8459 8459 | 220831 | 1 | 0.151652241832216 |
| 31012 | 31012 | 9077 9077 | 220831 | 1 | 0.3125 |
| 82496 | 82496 | 29714 29714 | 220831 | 1 | 0.3125 |
| 111701 | 111701 | 39080 39080 | 220831 | 1 | 0.151652241832216 |
| 177631 | 177631 | 63319 63319 | 220831 | 1 | 0.3125 |
| 177668 | 177668 | 63324 63324 | 220831 | 1 | 0.151974581496348 |
| 238825 | 238825 | 81252 81252 | 220831 | 1 | 0.151652241832216 |
| 244367 | 244367 | 83165 83165 | 220831 | 1 | 0.310344827586207 |
| 438145 | 438145 | 157053 157053 | 220831 | 1 | 0.151652241832216 |
| 440659 | 440659 | 157984 157984 | 220831 | 1 | 0.3125 |
| 548613 | 548613 | 216857 216857 | 220831 | 1 | 0.3125 |
| 555008 | 555008 | 218819 218819 | 220831 | 1 | 0.151652241832216 |
| 663093 | 663093 | 237743 237743 | 220831 | 1 | 0.151652241832216 |
| 663914 | 663914 | 237948 237948 | 220831 | 1 | 0.310344827586207 |
| 710496 | 710496 | 252045 252045 | 220831 | 1 | 0.151652241832216 |
| 718344 | 718344 | 254045 254045 | 220831 | 1 | 0.318181818181818 |
| 809880 | 809880 | 281937 281937 | 220831 | 1 | 0.151652241832216 |
| 822277 | 822277 | 285508 285508 | 220831 | 1 | 0.3125 |
| 822279 | 822279 | 285509 285509 | 220831 | 1 | 0.329633792761892 |
| 879016 | 879016 | 305111 305111 | 220831 | 1 | 0.3 |
| 1062957 | 1062957 | 375216 375216 | 220831 | 1 | 0.151652241832216 |
| 1062971 | 1062971 | 375217 375217 | 220831 | 1 | 0.151652241832216 |
| 1062985 | 1062985 | 375218 375218 | 220831 | 1 | 0.151652241832216 |
| 1062999 | 1062999 | 375219 375219 | 220831 | 1 | 0.151652241832216 |
| 1075662 | 1075662 | 377587 377587 | 220831 | 1 | 0.3125 |
| 1075664 | 1075664 | 377588 377588 | 220831 | 1 | 0.3125 |
| 1075666 | 1075666 | 377589 377589 | 220831 | 1 | 0.3125 |
| 1075668 | 1075668 | 377590 377590 | 220831 | 1 | 0.3125 |
| 1075670 | 1075670 | 377591 377591 | 220831 | 1 | 0.3125 |
| 1075672 | 1075672 | 377592 377592 | 220831 | 1 | 0.3125 |
| 1075674 | 1075674 | 377593 377593 | 220831 | 1 | 0.3125 |
| 1075676 | 1075676 | 377594 377594 | 220831 | 1 | 0.3125 |
| 1075678 | 1075678 | 377595 377595 | 220831 | 1 | 0.3125 |
| 1075680 | 1075680 | 377596 377596 | 220831 | 1 | 0.3125 |
| 1075682 | 1075682 | 377597 377597 | 220831 | 1 | 0.3125 |
| 1075684 | 1075684 | 377598 377598 | 220831 | 1 | 0.3125 |
| 1075686 | 1075686 | 377599 377599 | 220831 | 1 | 0.3125 |
| 1075688 | 1075688 | 377600 377600 | 220831 | 1 | 0.3125 |
| 1075690 | 1075690 | 377601 377601 | 220831 | 1 | 0.3125 |
| 1075692 | 1075692 | 377602 377602 | 220831 | 1 | 0.3125 |
| 1075694 | 1075694 | 377603 377603 | 220831 | 1 | 0.3125 |
| 1075696 | 1075696 | 377604 377604 | 220831 | 1 | 0.3125 |
| 1075698 | 1075698 | 377605 377605 | 220831 | 1 | 0.3125 |
| 1075700 | 1075700 | 377606 377606 | 220831 | 1 | 0.3125 |
| 1286840 | 1286840 | 422927 422927 | 220831 | 1 | 0.151652241832216 |
| 1286854 | 1286854 | 422928 422928 | 220831 | 1 | 0.151652241832216 |
| 1286868 | 1286868 | 422929 422929 | 220831 | 1 | 0.151652241832216 |
| 1286882 | 1286882 | 422930 422930 | 220831 | 1 | 0.151652241832216 |
| 1302270 | 1302270 | 425632 425632 | 220831 | 1 | 0.3125 |
| 1302272 | 1302272 | 425633 425633 | 220831 | 1 | 0.3125 |
| 1302274 | 1302274 | 425634 425634 | 220831 | 1 | 0.3125 |
| 1302276 | 1302276 | 425635 425635 | 220831 | 1 | 0.3125 |
| 1302278 | 1302278 | 425636 425636 | 220831 | 1 | 0.3125 |
| 1302280 | 1302280 | 425637 425637 | 220831 | 1 | 0.3125 |
| 1302282 | 1302282 | 425638 425638 | 220831 | 1 | 0.3125 |
| 1302284 | 1302284 | 425639 425639 | 220831 | 1 | 0.3125 |
| 1302286 | 1302286 | 425640 425640 | 220831 | 1 | 0.3125 |
| 1302288 | 1302288 | 425641 425641 | 220831 | 1 | 0.3125 |
| 1302290 | 1302290 | 425642 425642 | 220831 | 1 | 0.3125 |
| 1302292 | 1302292 | 425643 425643 | 220831 | 1 | 0.3125 |
| 1302294 | 1302294 | 425644 425644 | 220831 | 1 | 0.3125 |
| 1302296 | 1302296 | 425645 425645 | 220831 | 1 | 0.3125 |
| 1302298 | 1302298 | 425646 425646 | 220831 | 1 | 0.3125 |
| 1302300 | 1302300 | 425647 425647 | 220831 | 1 | 0.3125 |
| 1302302 | 1302302 | 425648 425648 | 220831 | 1 | 0.3125 |
| 1302304 | 1302304 | 425649 425649 | 220831 | 1 | 0.3125 |
| 1302306 | 1302306 | 425650 425650 | 220831 | 1 | 0.3125 |
| 1302308 | 1302308 | 425651 425651 | 220831 | 1 | 0.3125 |
| 1302310 | 1302310 | 425652 425652 | 220831 | 1 | 0.3125 |
| 1302312 | 1302312 | 425653 425653 | 220831 | 1 | 0.3125 |
| 1302314 | 1302314 | 425654 425654 | 220831 | 1 | 0.3125 |
| 1501143 | 1501143 | 464341 464341 | 220831 | 1 | 0.151652241832216 |
| 1501157 | 1501157 | 464342 464342 | 220831 | 1 | 0.151652241832216 |
| 1501171 | 1501171 | 464343 464343 | 220831 | 1 | 0.151652241832216 |
| 1510531 | 1510531 | 466088 466088 | 220831 | 1 | 0.3125 |
| 1510533 | 1510533 | 466089 466089 | 220831 | 1 | 0.3125 |
| 1510535 | 1510535 | 466090 466090 | 220831 | 1 | 0.3125 |
| 1510537 | 1510537 | 466091 466091 | 220831 | 1 | 0.3125 |
| 1510539 | 1510539 | 466092 466092 | 220831 | 1 | 0.3125 |
| 1510541 | 1510541 | 466093 466093 | 220831 | 1 | 0.3125 |
| 1510543 | 1510543 | 466094 466094 | 220831 | 1 | 0.3125 |
| 1510545 | 1510545 | 466095 466095 | 220831 | 1 | 0.3125 |
| 1510547 | 1510547 | 466096 466096 | 220831 | 1 | 0.3125 |
| 1600707 | 1600707 | 483550 483550 | 220831 | 1 | 0.151652241832216 |
| 1602172 | 1602172 | 483964 483964 | 220831 | 1 | 0.3125 |
| 1625543 | 1625543 | 490881 490881 | 220831 | 1 | 0.151652241832216 |
| 1628375 | 1628375 | 491940 491940 | 220831 | 1 | 0.3125 |
| 1725877 | 1725877 | 528449 528449 | 220831 | 1 | 0.151652241832216 |
| 1727289 | 1727289 | 528946 528946 | 220831 | 1 | 0.3125 |
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)
);