consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 78922
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 230323 | 230323 | 78922 78922 | 30579 | 7 | 0.219301953884499 |
| 230324 | 230324 | 78922 78922 | 179989 | 1 | 0.0548254884711249 |
| 230325 | 230325 | 78922 78922 | 245409 | 1 | 0.0548254884711249 |
| 230326 | 230326 | 78922 78922 | 254871 | 1 | 0.10965097694225 |
| 230327 | 230327 | 78922 78922 | 257141 | 1 | 0.0731006512948332 |
| 230328 | 230328 | 78922 78922 | 289727 | 1 | 0.10965097694225 |
| 230329 | 230329 | 78922 78922 | 292856 | 1 | 0.0731006512948332 |
| 230330 | 230330 | 78922 78922 | 292857 | 1 | 0.0438603907768999 |
| 230331 | 230331 | 78922 78922 | 292858 | 1 | 0.0365503256474166 |
| 230332 | 230332 | 78922 78922 | 292859 | 1 | 0.0313288505549285 |
| 230333 | 230333 | 78922 78922 | 292860 | 1 | 0.0274127442355624 |
| 230334 | 230334 | 78922 78922 | 292861 | 1 | 0.0243668837649444 |
| 230335 | 230335 | 78922 78922 | 292862 | 1 | 0.0219301953884499 |
| 230336 | 230336 | 78922 78922 | 292863 | 1 | 0.0199365412622272 |
| 230337 | 230337 | 78922 78922 | 292864 | 1 | 0.0182751628237083 |
| 230338 | 230338 | 78922 78922 | 292865 | 1 | 0.0168693810680384 |
| 230339 | 230339 | 78922 78922 | 292866 | 1 | 0.0156644252774642 |
| 230340 | 230340 | 78922 78922 | 292867 | 1 | 0.0146201302589666 |
| 230341 | 230341 | 78922 78922 | 292868 | 1 | 0.0137063721177812 |
| 230342 | 230342 | 78922 78922 | 322784 | 1 | 0.0129001149343823 |
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)
);