consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
34 rows where inchi_id = 3197
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 22961 | 22961 | 6735 6735 | 3197 | 8 | 0.396600566572238 |
| 30864 | 30864 | 9027 9027 | 3197 | 1 | 0.0709939148073022 |
| 118681 | 118681 | 41383 41383 | 3197 | 1 | 0.0709939148073022 |
| 120361 | 120361 | 41894 41894 | 3197 | 8 | 0.396600566572238 |
| 153538 | 153538 | 55195 55195 | 3197 | 15 | 0.384762195655566 |
| 222193 | 222193 | 76819 76819 | 3197 | 8 | 0.327742576511524 |
| 244000 | 244000 | 83026 83026 | 3197 | 2 | 0.0602336168184636 |
| 430767 | 430767 | 155071 155071 | 3197 | 4 | 0.392156862745098 |
| 440437 | 440437 | 157904 157904 | 3197 | 2 | 0.0602336168184636 |
| 486006 | 486006 | 180075 180075 | 3197 | 1 | 0.059272563987427 |
| 517851 | 517851 | 207217 207217 | 3197 | 8 | 0.327742576511524 |
| 517858 | 517858 | 207218 207218 | 3197 | 8 | 0.327742576511524 |
| 591866 | 591866 | 230861 230861 | 3197 | 1 | 0.110513316364542 |
| 592530 | 592530 | 231029 231029 | 3197 | 7 | 0.395738203957382 |
| 673378 | 673378 | 240820 240820 | 3197 | 12 | 0.329090789803479 |
| 746262 | 746262 | 262505 262505 | 3197 | 8 | 0.396600566572238 |
| 898308 | 898308 | 315801 315801 | 3197 | 4 | 0.392156862745098 |
| 898400 | 898400 | 315841 315841 | 3197 | 1 | 0.0704225352112676 |
| 989624 | 989624 | 355435 355435 | 3197 | 8 | 0.396600566572238 |
| 989630 | 989630 | 355436 355436 | 3197 | 8 | 0.396600566572238 |
| 989636 | 989636 | 355437 355437 | 3197 | 8 | 0.396600566572238 |
| 1199516 | 1199516 | 399537 399537 | 3197 | 8 | 0.396600566572238 |
| 1199522 | 1199522 | 399538 399538 | 3197 | 8 | 0.396600566572238 |
| 1199528 | 1199528 | 399539 399539 | 3197 | 8 | 0.396600566572238 |
| 1199534 | 1199534 | 399540 399540 | 3197 | 8 | 0.396600566572238 |
| 1199540 | 1199540 | 399541 399541 | 3197 | 8 | 0.396600566572238 |
| 1199546 | 1199546 | 399542 399542 | 3197 | 8 | 0.396600566572238 |
| 1446989 | 1446989 | 449740 449740 | 3197 | 8 | 0.396600566572238 |
| 1446995 | 1446995 | 449741 449741 | 3197 | 8 | 0.396600566572238 |
| 1447001 | 1447001 | 449742 449742 | 3197 | 8 | 0.396600566572238 |
| 1590921 | 1590921 | 480218 480218 | 3197 | 8 | 0.396600566572238 |
| 1617460 | 1617460 | 488386 488386 | 3197 | 8 | 0.396600566572238 |
| 1628188 | 1628188 | 491869 491869 | 3197 | 1 | 0.0709939148073022 |
| 1727174 | 1727174 | 528906 528906 | 3197 | 1 | 0.0709939148073022 |
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)
);