consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 119674
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 3007 | 3007 | 858 858 | 119674 | 11 | 0.378958601904959 |
| 9678 | 9678 | 2934 2934 | 119674 | 1 | 0.15180738426686 |
| 46560 | 46560 | 14183 14183 | 119674 | 5 | 0.391511567362797 |
| 144218 | 144218 | 51416 51416 | 119674 | 5 | 0.391511567362797 |
| 198090 | 198090 | 70443 70443 | 119674 | 1 | 0.120880913697146 |
| 199714 | 199714 | 71030 71030 | 119674 | 1 | 0.154639175257732 |
| 303046 | 303046 | 102567 102567 | 119674 | 1 | 0.154639175257732 |
| 526322 | 526322 | 209435 209435 | 119674 | 3 | 0.406779661016949 |
| 527182 | 527182 | 209642 209642 | 119674 | 1 | 0.154639175257732 |
| 527188 | 527188 | 209643 209643 | 119674 | 1 | 0.154639175257732 |
| 527194 | 527194 | 209644 209644 | 119674 | 1 | 0.154639175257732 |
| 538057 | 538057 | 213455 213455 | 119674 | 6 | 0.394520515650572 |
| 593588 | 593588 | 231319 231319 | 119674 | 1 | 0.154639175257732 |
| 729199 | 729199 | 257313 257313 | 119674 | 5 | 0.391511567362797 |
| 743662 | 743662 | 261771 261771 | 119674 | 1 | 0.171428571428571 |
| 743667 | 743667 | 261772 261772 | 119674 | 1 | 0.154639175257732 |
| 844895 | 844895 | 292653 292653 | 119674 | 5 | 0.391511567362797 |
| 844899 | 844899 | 292654 292654 | 119674 | 4 | 0.409090909090909 |
| 1741017 | 1741017 | 533151 533151 | 119674 | 3 | 0.406779661016949 |
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)
);