consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
55 rows where inchi_id = 43245
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14441 | 14441 | 4460 4460 | 43245 | 1 | 0.0661000944287063 |
| 20666 | 20666 | 6082 6082 | 43245 | 1 | 0.0661000944287063 |
| 81799 | 81799 | 29450 29450 | 43245 | 1 | 0.0661000944287063 |
| 84166 | 84166 | 30289 30289 | 43245 | 8 | 0.519685039370079 |
| 180830 | 180830 | 64567 64567 | 43245 | 8 | 0.519685039370079 |
| 180873 | 180873 | 64590 64590 | 43245 | 1 | 0.0657894736842105 |
| 262927 | 262927 | 89077 89077 | 43245 | 1 | 0.0538998097653773 |
| 279372 | 279372 | 94737 94737 | 43245 | 1 | 0.187951807228916 |
| 279393 | 279393 | 94742 94742 | 43245 | 8 | 0.502113490128201 |
| 572239 | 572239 | 224249 224249 | 43245 | 1 | 0.0664322000781555 |
| 691278 | 691278 | 246588 246588 | 43245 | 1 | 0.0661000944287063 |
| 704067 | 704067 | 250692 250692 | 43245 | 8 | 0.519685039370079 |
| 777528 | 777528 | 271947 271947 | 43245 | 1 | 0.0661000944287063 |
| 777536 | 777536 | 271948 271948 | 43245 | 1 | 0.0538998097653773 |
| 801204 | 801204 | 279488 279488 | 43245 | 8 | 0.519685039370079 |
| 801207 | 801207 | 279489 279489 | 43245 | 8 | 0.502113490128201 |
| 947720 | 947720 | 339749 339749 | 43245 | 1 | 0.065359477124183 |
| 947739 | 947739 | 339756 339756 | 43245 | 4 | 0.506024096385542 |
| 1040239 | 1040239 | 368554 368554 | 43245 | 1 | 0.0661000944287063 |
| 1040245 | 1040245 | 368555 368555 | 43245 | 1 | 0.0661000944287063 |
| 1055970 | 1055970 | 373309 373309 | 43245 | 8 | 0.519685039370079 |
| 1055973 | 1055973 | 373310 373310 | 43245 | 8 | 0.519685039370079 |
| 1260155 | 1260155 | 415146 415146 | 43245 | 1 | 0.0661000944287063 |
| 1260161 | 1260161 | 415147 415147 | 43245 | 1 | 0.0661000944287063 |
| 1260167 | 1260167 | 415148 415148 | 43245 | 1 | 0.0661000944287063 |
| 1260173 | 1260173 | 415149 415149 | 43245 | 1 | 0.0661000944287063 |
| 1260179 | 1260179 | 415150 415150 | 43245 | 1 | 0.0661000944287063 |
| 1260185 | 1260185 | 415151 415151 | 43245 | 1 | 0.0661000944287063 |
| 1260191 | 1260191 | 415152 415152 | 43245 | 1 | 0.0661000944287063 |
| 1260197 | 1260197 | 415153 415153 | 43245 | 1 | 0.0661000944287063 |
| 1260203 | 1260203 | 415154 415154 | 43245 | 1 | 0.0661000944287063 |
| 1260209 | 1260209 | 415155 415155 | 43245 | 1 | 0.0661000944287063 |
| 1260215 | 1260215 | 415156 415156 | 43245 | 1 | 0.0661000944287063 |
| 1260221 | 1260221 | 415157 415157 | 43245 | 1 | 0.0661000944287063 |
| 1260227 | 1260227 | 415158 415158 | 43245 | 1 | 0.0661000944287063 |
| 1260233 | 1260233 | 415159 415159 | 43245 | 1 | 0.0661000944287063 |
| 1260239 | 1260239 | 415160 415160 | 43245 | 1 | 0.0661000944287063 |
| 1260245 | 1260245 | 415161 415161 | 43245 | 1 | 0.0661000944287063 |
| 1279226 | 1279226 | 420837 420837 | 43245 | 8 | 0.519685039370079 |
| 1279229 | 1279229 | 420838 420838 | 43245 | 8 | 0.519685039370079 |
| 1279232 | 1279232 | 420839 420839 | 43245 | 8 | 0.519685039370079 |
| 1279235 | 1279235 | 420840 420840 | 43245 | 8 | 0.519685039370079 |
| 1279238 | 1279238 | 420841 420841 | 43245 | 8 | 0.519685039370079 |
| 1279241 | 1279241 | 420842 420842 | 43245 | 8 | 0.519685039370079 |
| 1279244 | 1279244 | 420843 420843 | 43245 | 8 | 0.519685039370079 |
| 1279247 | 1279247 | 420844 420844 | 43245 | 8 | 0.519685039370079 |
| 1484647 | 1484647 | 459423 459423 | 43245 | 1 | 0.0661000944287063 |
| 1484653 | 1484653 | 459424 459424 | 43245 | 1 | 0.0661000944287063 |
| 1496291 | 1496291 | 463005 463005 | 43245 | 8 | 0.519685039370079 |
| 1496294 | 1496294 | 463006 463006 | 43245 | 8 | 0.519685039370079 |
| 1596394 | 1596394 | 481945 481945 | 43245 | 1 | 0.0661000944287063 |
| 1599708 | 1599708 | 483237 483237 | 43245 | 8 | 0.519685039370079 |
| 1637496 | 1637496 | 495175 495175 | 43245 | 1 | 0.0661000944287063 |
| 1645189 | 1645189 | 498040 498040 | 43245 | 8 | 0.519685039370079 |
| 1732135 | 1732135 | 530474 530474 | 43245 | 1 | 0.0661000944287063 |
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)
);