consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
40 rows where inchi_id = 102167
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 19110 | 19110 | 5612 5612 | 102167 | 2 | 0.0531935127372318 |
| 106977 | 106977 | 37666 37666 | 102167 | 2 | 0.0511712898724084 |
| 155191 | 155191 | 55824 55824 | 102167 | 2 | 0.0939831261618227 |
| 155214 | 155214 | 55830 55830 | 102167 | 2 | 0.0511712898724084 |
| 217046 | 217046 | 75328 75328 | 102167 | 2 | 0.0429797080867757 |
| 235355 | 235355 | 80279 80279 | 102167 | 1 | 0.0220109256025786 |
| 235370 | 235370 | 80281 80281 | 102167 | 3 | 0.131478337142334 |
| 257855 | 257855 | 87297 87297 | 102167 | 1 | 0.0592472268066885 |
| 427055 | 427055 | 154004 154004 | 102167 | 2 | 0.0511712898724084 |
| 436848 | 436848 | 156677 156677 | 102167 | 2 | 0.120686242387031 |
| 445932 | 445932 | 159702 159702 | 102167 | 1 | 0.0592472268066885 |
| 490262 | 490262 | 183966 183966 | 102167 | 3 | 0.690983005625053 |
| 534255 | 534255 | 212007 212007 | 102167 | 2 | 0.0536759079334868 |
| 733745 | 733745 | 258758 258758 | 102167 | 2 | 0.0529727705844186 |
| 853633 | 853633 | 295333 295333 | 102167 | 2 | 0.0483874700219891 |
| 853647 | 853647 | 295334 295334 | 102167 | 2 | 0.047997835474906 |
| 853661 | 853661 | 295335 295335 | 102167 | 2 | 0.0536759079334868 |
| 853674 | 853674 | 295336 295336 | 102167 | 2 | 0.0532037304705446 |
| 853687 | 853687 | 295337 295337 | 102167 | 2 | 0.0531935127372318 |
| 853701 | 853701 | 295338 295338 | 102167 | 2 | 0.0429797080867757 |
| 853716 | 853716 | 295339 295339 | 102167 | 2 | 0.05369739100291 |
| 853729 | 853729 | 295340 295340 | 102167 | 2 | 0.05369739100291 |
| 853742 | 853742 | 295341 295341 | 102167 | 2 | 0.05369739100291 |
| 853755 | 853755 | 295342 295342 | 102167 | 2 | 0.0536759079334868 |
| 853768 | 853768 | 295343 295343 | 102167 | 2 | 0.0545522567628314 |
| 959618 | 959618 | 345319 345319 | 102167 | 2 | 0.0536759079334868 |
| 1172327 | 1172327 | 393668 393668 | 102167 | 2 | 0.0531935127372318 |
| 1172340 | 1172340 | 393669 393669 | 102167 | 2 | 0.0531935127372318 |
| 1172353 | 1172353 | 393670 393670 | 102167 | 2 | 0.0531935127372318 |
| 1427827 | 1427827 | 445297 445297 | 102167 | 2 | 0.0531935127372318 |
| 1427840 | 1427840 | 445298 445298 | 102167 | 2 | 0.0531935127372318 |
| 1427853 | 1427853 | 445299 445299 | 102167 | 2 | 0.0531935127372318 |
| 1427866 | 1427866 | 445300 445300 | 102167 | 2 | 0.0531935127372318 |
| 1585619 | 1585619 | 478745 478745 | 102167 | 2 | 0.0531935127372318 |
| 1585632 | 1585632 | 478746 478746 | 102167 | 2 | 0.0531935127372318 |
| 1585645 | 1585645 | 478747 478747 | 102167 | 2 | 0.0531935127372318 |
| 1606632 | 1606632 | 485395 485395 | 102167 | 2 | 0.0531935127372318 |
| 1612522 | 1612522 | 486812 486812 | 102167 | 2 | 0.0531935127372318 |
| 1717895 | 1717895 | 526123 526123 | 102167 | 2 | 0.0536759079334868 |
| 1724887 | 1724887 | 528171 528171 | 102167 | 2 | 0.1062082659774 |
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)
);