consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 47700
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 5473 | 5473 | 1643 1643 | 47700 | 1 | 0.0478631030108425 |
| 192840 | 192840 | 68539 68539 | 47700 | 10 | 0.916666666666667 |
| 205241 | 205241 | 72766 72766 | 47700 | 1 | 0.0478631030108425 |
| 221610 | 221610 | 76668 76668 | 47700 | 1 | 0.0476976712317453 |
| 282510 | 282510 | 95811 95811 | 47700 | 7 | 0.888888888888889 |
| 430309 | 430309 | 154950 154950 | 47700 | 1 | 0.0476976712317453 |
| 455034 | 455034 | 163494 163494 | 47700 | 7 | 0.888888888888889 |
| 517246 | 517246 | 207077 207077 | 47700 | 1 | 0.0476976712317453 |
| 517255 | 517255 | 207078 207078 | 47700 | 1 | 0.0476976712317453 |
| 593167 | 593167 | 231194 231194 | 47700 | 1 | 0.0428604359768653 |
| 597782 | 597782 | 235494 235494 | 47700 | 1 | 0.0478631030108425 |
| 597791 | 597791 | 235495 235495 | 47700 | 1 | 0.0476976712317453 |
| 672696 | 672696 | 240648 240648 | 47700 | 1 | 0.0428604359768653 |
| 743545 | 743545 | 261747 261747 | 47700 | 1 | 0.065359477124183 |
| 744808 | 744808 | 262094 262094 | 47700 | 1 | 0.0476976712317453 |
| 775927 | 775927 | 271402 271402 | 47700 | 1 | 0.065359477124183 |
| 831578 | 831578 | 288618 288618 | 47700 | 1 | 0.065359477124183 |
| 831584 | 831584 | 288619 288619 | 47700 | 1 | 0.065359477124183 |
| 898171 | 898171 | 315732 315732 | 47700 | 4 | 0.833333333333333 |
| 1646474 | 1646474 | 498521 498521 | 47700 | 8 | 0.9 |
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)
);