consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 20622
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 6644 | 6644 | 2038 2038 | 20622 | 1 | 0.0939759036144578 |
| 23281 | 23281 | 6831 6831 | 20622 | 1 | 0.115727002967359 |
| 54628 | 54628 | 17053 17053 | 20622 | 8 | 0.9 |
| 81907 | 81907 | 29487 29487 | 20622 | 1 | 0.115727002967359 |
| 140779 | 140779 | 50165 50165 | 20622 | 4 | 0.833333333333333 |
| 157119 | 157119 | 56499 56499 | 20622 | 1 | 0.116704805491991 |
| 222618 | 222618 | 76940 76940 | 20622 | 1 | 0.0939759036144578 |
| 326653 | 326653 | 110087 110087 | 20622 | 8 | 0.625 |
| 431113 | 431113 | 155168 155168 | 20622 | 1 | 0.0939759036144578 |
| 506394 | 506394 | 202520 202520 | 20622 | 8 | 0.625 |
| 518205 | 518205 | 207299 207299 | 20622 | 1 | 0.115384615384615 |
| 592133 | 592133 | 230908 230908 | 20622 | 1 | 0.115727002967359 |
| 673890 | 673890 | 240951 240951 | 20622 | 1 | 0.115727002967359 |
| 747248 | 747248 | 262812 262812 | 20622 | 1 | 0.115727002967359 |
| 747252 | 747252 | 262813 262813 | 20622 | 1 | 0.114503816793893 |
| 940041 | 940041 | 336180 336180 | 20622 | 1 | 0.113207547169811 |
| 1617817 | 1617817 | 488499 488499 | 20622 | 1 | 0.114982578397213 |
| 1720580 | 1720580 | 526962 526962 | 20622 | 1 | 0.115727002967359 |
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)
);