consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
40 rows where inchi_id = 19667
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 17545 | 17545 | 5148 5148 | 19667 | 1 | 0.0228944838499734 |
| 119549 | 119549 | 41621 41621 | 19667 | 1 | 0.0228944838499734 |
| 261517 | 261517 | 88585 88585 | 19667 | 8 | 0.625 |
| 537412 | 537412 | 213242 213242 | 19667 | 1 | 0.016552813009067 |
| 663691 | 663691 | 237868 237868 | 19667 | 1 | 0.0122884032168405 |
| 666407 | 666407 | 238566 238566 | 19667 | 1 | 0.016552813009067 |
| 729864 | 729864 | 257512 257512 | 19667 | 1 | 0.016552813009067 |
| 846131 | 846131 | 293062 293062 | 19667 | 1 | 0.0228944838499734 |
| 1165185 | 1165185 | 391266 391266 | 19667 | 1 | 0.0228944838499734 |
| 1165200 | 1165200 | 391267 391267 | 19667 | 1 | 0.0228944838499734 |
| 1165215 | 1165215 | 391268 391268 | 19667 | 1 | 0.0228944838499734 |
| 1165230 | 1165230 | 391269 391269 | 19667 | 1 | 0.0228944838499734 |
| 1165245 | 1165245 | 391270 391270 | 19667 | 1 | 0.0228944838499734 |
| 1165260 | 1165260 | 391271 391271 | 19667 | 1 | 0.0228944838499734 |
| 1165275 | 1165275 | 391272 391272 | 19667 | 1 | 0.0228944838499734 |
| 1165290 | 1165290 | 391273 391273 | 19667 | 1 | 0.0228944838499734 |
| 1165305 | 1165305 | 391274 391274 | 19667 | 1 | 0.0228944838499734 |
| 1165320 | 1165320 | 391275 391275 | 19667 | 1 | 0.0228944838499734 |
| 1419990 | 1419990 | 442587 442587 | 19667 | 1 | 0.0228944838499734 |
| 1420005 | 1420005 | 442588 442588 | 19667 | 1 | 0.0228944838499734 |
| 1420020 | 1420020 | 442589 442589 | 19667 | 1 | 0.0228944838499734 |
| 1420035 | 1420035 | 442590 442590 | 19667 | 1 | 0.0228944838499734 |
| 1420050 | 1420050 | 442591 442591 | 19667 | 1 | 0.0228944838499734 |
| 1420065 | 1420065 | 442592 442592 | 19667 | 1 | 0.0228944838499734 |
| 1420080 | 1420080 | 442593 442593 | 19667 | 1 | 0.0228944838499734 |
| 1420095 | 1420095 | 442594 442594 | 19667 | 1 | 0.0228944838499734 |
| 1420110 | 1420110 | 442595 442595 | 19667 | 1 | 0.0228944838499734 |
| 1420125 | 1420125 | 442596 442596 | 19667 | 1 | 0.0228944838499734 |
| 1420140 | 1420140 | 442597 442597 | 19667 | 1 | 0.0228944838499734 |
| 1420155 | 1420155 | 442598 442598 | 19667 | 1 | 0.0228944838499734 |
| 1580348 | 1580348 | 476785 476785 | 19667 | 1 | 0.0228944838499734 |
| 1580363 | 1580363 | 476786 476786 | 19667 | 1 | 0.0228944838499734 |
| 1580378 | 1580378 | 476787 476787 | 19667 | 1 | 0.0228944838499734 |
| 1580393 | 1580393 | 476788 476788 | 19667 | 1 | 0.0228944838499734 |
| 1580408 | 1580408 | 476789 476789 | 19667 | 1 | 0.0228944838499734 |
| 1580423 | 1580423 | 476790 476790 | 19667 | 1 | 0.0228944838499734 |
| 1580438 | 1580438 | 476791 476791 | 19667 | 1 | 0.0228944838499734 |
| 1580453 | 1580453 | 476792 476792 | 19667 | 1 | 0.0228944838499734 |
| 1605796 | 1605796 | 485098 485098 | 19667 | 1 | 0.0228944838499734 |
| 1611037 | 1611037 | 486317 486317 | 19667 | 1 | 0.0228944838499734 |
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)
);