consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 201797
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 21167 | 21167 | 6246 6246 | 201797 | 1 | 0.259842519685039 |
| 135309 | 135309 | 47957 47957 | 201797 | 1 | 0.209016393442623 |
| 139415 | 139415 | 49674 49674 | 201797 | 1 | 0.0532410973073765 |
| 202002 | 202002 | 71642 71642 | 201797 | 1 | 0.0532373336818472 |
| 214643 | 214643 | 74622 74622 | 201797 | 1 | 0.0529756402516064 |
| 219689 | 219689 | 76096 76096 | 201797 | 1 | 0.206896551724138 |
| 428897 | 428897 | 154546 154546 | 201797 | 1 | 0.206896551724138 |
| 513842 | 513842 | 206265 206265 | 201797 | 1 | 0.0529756402516064 |
| 537648 | 537648 | 213316 213316 | 201797 | 1 | 0.0529756402516064 |
| 666317 | 666317 | 238540 238540 | 201797 | 1 | 0.0531333305712542 |
| 668821 | 668821 | 239625 239625 | 201797 | 1 | 0.259842519685039 |
| 729698 | 729698 | 257459 257459 | 201797 | 1 | 0.0531333305712542 |
| 737263 | 737263 | 259974 259974 | 201797 | 1 | 0.149439601494396 |
| 737269 | 737269 | 259975 259975 | 201797 | 1 | 0.259842519685039 |
| 845854 | 845854 | 292972 292972 | 201797 | 1 | 0.0529756402516064 |
| 954864 | 954864 | 342843 342843 | 201797 | 1 | 0.253012048192771 |
| 1614505 | 1614505 | 487456 487456 | 201797 | 1 | 0.259842519685039 |
| 1718958 | 1718958 | 526459 526459 | 201797 | 1 | 0.259842519685039 |
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)
);