consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
56 rows where inchi_id = 4187
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 18275 | 18275 | 5351 5351 | 4187 | 1 | 0.239130434782609 |
| 32685 | 32685 | 9636 9636 | 4187 | 8 | 0.625 |
| 84483 | 84483 | 30405 30405 | 4187 | 1 | 0.239130434782609 |
| 178259 | 178259 | 63523 63523 | 4187 | 1 | 0.139523352627271 |
| 223321 | 223321 | 77148 77148 | 4187 | 1 | 0.194004451249207 |
| 253038 | 253038 | 85973 85973 | 4187 | 7 | 0.620689655172414 |
| 431741 | 431741 | 155343 155343 | 4187 | 1 | 0.310344827586207 |
| 503499 | 503499 | 201494 201494 | 4187 | 1 | 0.310344827586207 |
| 518784 | 518784 | 207429 207429 | 4187 | 1 | 0.310344827586207 |
| 590875 | 590875 | 230558 230558 | 4187 | 1 | 0.194805194805195 |
| 598650 | 598650 | 235711 235711 | 4187 | 1 | 0.194004451249207 |
| 674940 | 674940 | 241237 241237 | 4187 | 8 | 0.625 |
| 675123 | 675123 | 241421 241421 | 4187 | 1 | 0.239130434782609 |
| 749226 | 749226 | 263425 263425 | 4187 | 8 | 0.625 |
| 749228 | 749228 | 263426 263426 | 4187 | 5 | 0.608695652173913 |
| 749617 | 749617 | 263572 263572 | 4187 | 1 | 0.239130434782609 |
| 749620 | 749620 | 263573 263573 | 4187 | 1 | 0.310344827586207 |
| 877858 | 877858 | 304487 304487 | 4187 | 1 | 0.3 |
| 912887 | 912887 | 322594 322594 | 4187 | 4 | 0.6 |
| 997087 | 997087 | 357266 357266 | 4187 | 1 | 0.239130434782609 |
| 997090 | 997090 | 357267 357267 | 4187 | 1 | 0.239130434782609 |
| 997093 | 997093 | 357268 357268 | 4187 | 1 | 0.239130434782609 |
| 997096 | 997096 | 357269 357269 | 4187 | 1 | 0.239130434782609 |
| 997099 | 997099 | 357270 357270 | 4187 | 1 | 0.239130434782609 |
| 997102 | 997102 | 357271 357271 | 4187 | 1 | 0.239130434782609 |
| 997105 | 997105 | 357272 357272 | 4187 | 1 | 0.239130434782609 |
| 997108 | 997108 | 357273 357273 | 4187 | 1 | 0.239130434782609 |
| 997111 | 997111 | 357274 357274 | 4187 | 1 | 0.239130434782609 |
| 1208071 | 1208071 | 401629 401629 | 4187 | 1 | 0.239130434782609 |
| 1208074 | 1208074 | 401630 401630 | 4187 | 1 | 0.239130434782609 |
| 1208077 | 1208077 | 401631 401631 | 4187 | 1 | 0.239130434782609 |
| 1208080 | 1208080 | 401632 401632 | 4187 | 1 | 0.239130434782609 |
| 1208083 | 1208083 | 401633 401633 | 4187 | 1 | 0.239130434782609 |
| 1208086 | 1208086 | 401634 401634 | 4187 | 1 | 0.239130434782609 |
| 1208089 | 1208089 | 401635 401635 | 4187 | 1 | 0.239130434782609 |
| 1208092 | 1208092 | 401636 401636 | 4187 | 1 | 0.239130434782609 |
| 1208095 | 1208095 | 401637 401637 | 4187 | 1 | 0.239130434782609 |
| 1208098 | 1208098 | 401638 401638 | 4187 | 1 | 0.239130434782609 |
| 1208101 | 1208101 | 401639 401639 | 4187 | 1 | 0.239130434782609 |
| 1208104 | 1208104 | 401640 401640 | 4187 | 1 | 0.239130434782609 |
| 1208107 | 1208107 | 401641 401641 | 4187 | 1 | 0.239130434782609 |
| 1208110 | 1208110 | 401642 401642 | 4187 | 1 | 0.239130434782609 |
| 1208113 | 1208113 | 401643 401643 | 4187 | 1 | 0.239130434782609 |
| 1452502 | 1452502 | 451046 451046 | 4187 | 1 | 0.239130434782609 |
| 1452505 | 1452505 | 451047 451047 | 4187 | 1 | 0.239130434782609 |
| 1452508 | 1452508 | 451048 451048 | 4187 | 1 | 0.239130434782609 |
| 1452511 | 1452511 | 451049 451049 | 4187 | 1 | 0.239130434782609 |
| 1452514 | 1452514 | 451050 451050 | 4187 | 1 | 0.239130434782609 |
| 1452517 | 1452517 | 451051 451051 | 4187 | 1 | 0.239130434782609 |
| 1452520 | 1452520 | 451052 451052 | 4187 | 1 | 0.239130434782609 |
| 1452523 | 1452523 | 451053 451053 | 4187 | 1 | 0.239130434782609 |
| 1452526 | 1452526 | 451054 451054 | 4187 | 1 | 0.239130434782609 |
| 1591759 | 1591759 | 480456 480456 | 4187 | 1 | 0.239130434782609 |
| 1615202 | 1615202 | 487686 487686 | 4187 | 1 | 0.239130434782609 |
| 1632791 | 1632791 | 493541 493541 | 4187 | 8 | 0.625 |
| 1721007 | 1721007 | 527108 527108 | 4187 | 1 | 0.239130434782609 |
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)
);