consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 142247
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 52843 | 52843 | 16439 16439 | 142247 | 3 | 0.214142840334157 |
| 53039 | 53039 | 16499 16499 | 142247 | 1 | 0.109628434066906 |
| 110552 | 110552 | 38731 38731 | 142247 | 3 | 0.214142840334157 |
| 189847 | 189847 | 67664 67664 | 142247 | 1 | 0.40847646066685 |
| 189851 | 189851 | 67665 67665 | 142247 | 3 | 0.203918491591105 |
| 317832 | 317832 | 107110 107110 | 142247 | 4 | 0.42052772921983 |
| 319342 | 319342 | 107612 107612 | 142247 | 3 | 0.214142840334157 |
| 319948 | 319948 | 107825 107825 | 142247 | 1 | 0.111499478327209 |
| 469795 | 469795 | 169963 169963 | 142247 | 3 | 0.214142840334157 |
| 575555 | 575555 | 225455 225455 | 142247 | 1 | 0.109628434066906 |
| 687523 | 687523 | 245187 245187 | 142247 | 4 | 0.213197004475489 |
| 687843 | 687843 | 245303 245303 | 142247 | 1 | 0.109628434066906 |
| 771880 | 771880 | 270072 270072 | 142247 | 2 | 0.203325680626162 |
| 771889 | 771889 | 270073 270073 | 142247 | 3 | 0.213849287169043 |
| 771899 | 771899 | 270074 270074 | 142247 | 2 | 0.175640375911224 |
| 946822 | 946822 | 339337 339337 | 142247 | 1 | 0.204316451155497 |
| 1665125 | 1665125 | 504820 504820 | 142247 | 1 | 0.204316451155497 |
| 1665466 | 1665466 | 504934 504934 | 142247 | 1 | 0.110830116344725 |
| 1747526 | 1747526 | 535250 535250 | 142247 | 3 | 0.214142840334157 |
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)
);