consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inventory_id = 247200
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 692886 | 692886 | 247200 247200 | 24514 | 10 | 0.22106015367495 |
| 692887 | 692887 | 247200 247200 | 137031 | 4 | 0.134273489630882 |
| 692888 | 692888 | 247200 247200 | 185660 | 4 | 0.0675359898328224 |
| 692889 | 692889 | 247200 247200 | 186522 | 1 | 0.0157968811330449 |
| 692890 | 692890 | 247200 247200 | 186662 | 4 | 0.0492780059120457 |
| 692891 | 692891 | 247200 247200 | 186862 | 4 | 0.072143127299183 |
| 692892 | 692892 | 247200 247200 | 192782 | 3 | 0.0394684514385261 |
| 692893 | 692893 | 247200 247200 | 194699 | 4 | 0.0360715636495915 |
| 692894 | 692894 | 247200 247200 | 195248 | 1 | 0.019181927090126 |
| 692895 | 692895 | 247200 247200 | 199461 | 1 | 0.0223789149384803 |
| 692896 | 692896 | 247200 247200 | 199799 | 1 | 0.0179031319507843 |
| 692897 | 692897 | 247200 247200 | 207534 | 1 | 0.0206574599432126 |
| 692898 | 692898 | 247200 247200 | 207783 | 4 | 0.0775228353834201 |
| 692899 | 692899 | 247200 247200 | 213356 | 1 | 0.0244133617510695 |
| 692900 | 692900 | 247200 247200 | 232869 | 1 | 0.0167841862038602 |
| 692901 | 692901 | 247200 247200 | 233324 | 2 | 0.0258409451278067 |
| 692902 | 692902 | 247200 247200 | 234181 | 1 | 0.0298385532513071 |
| 692903 | 692903 | 247200 247200 | 234182 | 3 | 0.0232548404747163 |
| 692904 | 692904 | 247200 247200 | 241015 | 1 | 0.0268546979261764 |
| 692905 | 692905 | 247200 247200 | 260195 | 4 | 0.0355945919842822 |
| 692906 | 692906 | 247200 247200 | 321845 | 3 | 0.0195952476874114 |
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)
);