consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inventory_id = 242616
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 678502 | 678502 | 242616 242616 | 1639 | 9 | 0.213072690153744 |
| 678503 | 678503 | 242616 242616 | 7040 | 3 | 0.213072690153744 |
| 678504 | 678504 | 242616 242616 | 16464 | 5 | 0.0210763307571189 |
| 678505 | 678505 | 242616 242616 | 43799 | 5 | 0.0599530355611099 |
| 678506 | 678506 | 242616 242616 | 102223 | 1 | 0.0142048460102496 |
| 678507 | 678507 | 242616 242616 | 137983 | 4 | 0.0198365874801243 |
| 678508 | 678508 | 242616 242616 | 140143 | 5 | 0.0559641345047917 |
| 678509 | 678509 | 242616 242616 | 140401 | 5 | 0.098238006655731 |
| 678510 | 678510 | 242616 242616 | 159132 | 5 | 0.0407258892308409 |
| 678511 | 678511 | 242616 242616 | 169008 | 2 | 0.0214146111003522 |
| 678512 | 678512 | 242616 242616 | 169009 | 5 | 0.0401677893688541 |
| 678513 | 678513 | 242616 242616 | 170702 | 4 | 0.031798391874408 |
| 678514 | 678514 | 242616 242616 | 171264 | 1 | 0.026634086269218 |
| 678515 | 678515 | 242616 242616 | 177302 | 1 | 0.023674743350416 |
| 678516 | 678516 | 242616 242616 | 177303 | 1 | 0.0213072690153744 |
| 678517 | 678517 | 242616 242616 | 195795 | 4 | 0.0200047511065667 |
| 678518 | 678518 | 242616 242616 | 208656 | 2 | 0.0164389149380787 |
| 678519 | 678519 | 242616 242616 | 218754 | 2 | 0.035512115025624 |
| 678520 | 678520 | 242616 242616 | 290984 | 1 | 0.023674743350416 |
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)
);