consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 287142
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 827434 | 827434 | 287142 287142 | 8150 | 1 | 0.0156802163452749 |
| 827435 | 827435 | 287142 287142 | 45278 | 1 | 0.0188162596143298 |
| 827436 | 827436 | 287142 287142 | 61372 | 1 | 0.0940812980716491 |
| 827437 | 827437 | 287142 287142 | 63391 | 4 | 0.188162596143298 |
| 827438 | 827438 | 287142 287142 | 127988 | 1 | 0.0209069551270331 |
| 827439 | 827439 | 287142 287142 | 160363 | 1 | 0.026880370877614 |
| 827440 | 827440 | 287142 287142 | 178931 | 1 | 0.0235203245179123 |
| 827441 | 827441 | 287142 287142 | 182665 | 1 | 0.0313604326905497 |
| 827442 | 827442 | 287142 287142 | 182666 | 1 | 0.0470406490358246 |
| 827443 | 827443 | 287142 287142 | 183864 | 1 | 0.0144740458571768 |
| 827444 | 827444 | 287142 287142 | 190318 | 1 | 0.188162596143298 |
| 827445 | 827445 | 287142 287142 | 192104 | 1 | 0.0940812980716491 |
| 827446 | 827446 | 287142 287142 | 205015 | 1 | 0.0117601622589561 |
| 827447 | 827447 | 287142 287142 | 206188 | 1 | 0.0110683880084293 |
| 827448 | 827448 | 287142 287142 | 218600 | 1 | 0.0125441730762199 |
| 827449 | 827449 | 287142 287142 | 233551 | 1 | 0.0627208653810994 |
| 827450 | 827450 | 287142 287142 | 251932 | 1 | 0.0627208653810994 |
| 827451 | 827451 | 287142 287142 | 253834 | 1 | 0.0376325192286597 |
| 827452 | 827452 | 287142 287142 | 262180 | 1 | 0.013440185438807 |
| 827453 | 827453 | 287142 287142 | 293174 | 1 | 0.0171056905584817 |
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)
);