consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
31 rows where inchi_id = 87520
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 19717 | 19717 | 5779 5779 | 87520 | 8 | 0.628571428571429 |
| 19721 | 19721 | 5780 5780 | 87520 | 1 | 0.115384615384615 |
| 35974 | 35974 | 10719 10719 | 87520 | 1 | 0.137931034482759 |
| 81902 | 81902 | 29485 29485 | 87520 | 8 | 0.628571428571429 |
| 100745 | 100745 | 35608 35608 | 87520 | 1 | 0.115384615384615 |
| 129826 | 129826 | 46278 46278 | 87520 | 1 | 0.115384615384615 |
| 130106 | 130106 | 46321 46321 | 87520 | 12 | 0.638297872340426 |
| 218255 | 218255 | 75676 75676 | 87520 | 8 | 0.625 |
| 264178 | 264178 | 89492 89492 | 87520 | 1 | 0.148148148148148 |
| 427819 | 427819 | 154228 154228 | 87520 | 8 | 0.625 |
| 532726 | 532726 | 211304 211304 | 87520 | 12 | 0.636363636363636 |
| 667576 | 667576 | 239243 239243 | 87520 | 1 | 0.137931034482759 |
| 735661 | 735661 | 259492 259492 | 87520 | 8 | 0.628571428571429 |
| 735665 | 735665 | 259493 259493 | 87520 | 1 | 0.115384615384615 |
| 779117 | 779117 | 272455 272455 | 87520 | 1 | 0.168674698795181 |
| 779120 | 779120 | 272456 272456 | 87520 | 1 | 0.168674698795181 |
| 779123 | 779123 | 272457 272457 | 87520 | 1 | 0.168674698795181 |
| 779126 | 779126 | 272458 272458 | 87520 | 1 | 0.137931034482759 |
| 857616 | 857616 | 296651 296651 | 87520 | 8 | 0.628571428571429 |
| 857618 | 857618 | 296652 296652 | 87520 | 4 | 0.6 |
| 857620 | 857620 | 296653 296653 | 87520 | 7 | 0.620689655172414 |
| 857622 | 857622 | 296654 296654 | 87520 | 8 | 0.625 |
| 857627 | 857627 | 296656 296656 | 87520 | 1 | 0.115384615384615 |
| 943555 | 943555 | 337867 337867 | 87520 | 1 | 0.168674698795181 |
| 944421 | 944421 | 338227 338227 | 87520 | 4 | 0.6 |
| 1613423 | 1613423 | 487090 487090 | 87520 | 7 | 0.620689655172414 |
| 1613427 | 1613427 | 487091 487091 | 87520 | 1 | 0.115384615384615 |
| 1638021 | 1638021 | 495378 495378 | 87520 | 1 | 0.137931034482759 |
| 1718268 | 1718268 | 526242 526242 | 87520 | 8 | 0.628571428571429 |
| 1718272 | 1718272 | 526243 526243 | 87520 | 1 | 0.115384615384615 |
| 1732406 | 1732406 | 530569 530569 | 87520 | 1 | 0.168674698795181 |
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)
);