consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
36 rows where inchi_id = 138182
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 26243 | 26243 | 7676 7676 | 138182 | 1 | 0.229007633587786 |
| 30750 | 30750 | 8980 8980 | 138182 | 1 | 0.307692307692308 |
| 86970 | 86970 | 31156 31156 | 138182 | 1 | 0.230769230769231 |
| 134564 | 134564 | 47726 47726 | 138182 | 2 | 0.232558139534884 |
| 146253 | 146253 | 52201 52201 | 138182 | 1 | 0.239130434782609 |
| 228134 | 228134 | 78425 78425 | 138182 | 2 | 0.232558139534884 |
| 243702 | 243702 | 82906 82906 | 138182 | 2 | 0.260869565217391 |
| 434519 | 434519 | 156116 156116 | 138182 | 2 | 0.232558139534884 |
| 440291 | 440291 | 157844 157844 | 138182 | 2 | 0.260869565217391 |
| 521997 | 521997 | 208286 208286 | 138182 | 2 | 0.260869565217391 |
| 549142 | 549142 | 217056 217056 | 138182 | 1 | 0.239130434782609 |
| 579714 | 579714 | 226950 226950 | 138182 | 2 | 0.233409610983982 |
| 684015 | 684015 | 244081 244081 | 138182 | 2 | 0.234086242299795 |
| 717662 | 717662 | 253835 253835 | 138182 | 2 | 0.254184923472501 |
| 821246 | 821246 | 285143 285143 | 138182 | 1 | 0.239130434782609 |
| 821248 | 821248 | 285144 285144 | 138182 | 1 | 0.304347826086957 |
| 821251 | 821251 | 285145 285145 | 138182 | 2 | 0.260869565217391 |
| 950608 | 950608 | 341003 341003 | 138182 | 1 | 0.3 |
| 952009 | 952009 | 341548 341548 | 138182 | 1 | 0.226415094339623 |
| 1030397 | 1030397 | 365698 365698 | 138182 | 2 | 0.231454005934718 |
| 1030401 | 1030401 | 365699 365699 | 138182 | 2 | 0.231454005934718 |
| 1030405 | 1030405 | 365700 365700 | 138182 | 2 | 0.231454005934718 |
| 1030409 | 1030409 | 365701 365701 | 138182 | 2 | 0.231454005934718 |
| 1248873 | 1248873 | 411898 411898 | 138182 | 2 | 0.231454005934718 |
| 1248877 | 1248877 | 411899 411899 | 138182 | 2 | 0.231454005934718 |
| 1248881 | 1248881 | 411900 411900 | 138182 | 2 | 0.231454005934718 |
| 1248885 | 1248885 | 411901 411901 | 138182 | 2 | 0.231454005934718 |
| 1477422 | 1477422 | 457272 457272 | 138182 | 2 | 0.231454005934718 |
| 1477426 | 1477426 | 457273 457273 | 138182 | 2 | 0.231454005934718 |
| 1477430 | 1477430 | 457274 457274 | 138182 | 2 | 0.231454005934718 |
| 1477434 | 1477434 | 457275 457275 | 138182 | 2 | 0.231454005934718 |
| 1594683 | 1594683 | 481310 481310 | 138182 | 2 | 0.231454005934718 |
| 1620919 | 1620919 | 489474 489474 | 138182 | 2 | 0.231454005934718 |
| 1628014 | 1628014 | 491793 491793 | 138182 | 3 | 0.2625 |
| 1723035 | 1723035 | 527681 527681 | 138182 | 1 | 0.230769230769231 |
| 1727113 | 1727113 | 528880 528880 | 138182 | 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)
);