consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
44 rows where inchi_id = 197884
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 15656 | 15656 | 4776 4776 | 197884 | 1 | 0.115727002967359 |
| 46006 | 46006 | 14022 14022 | 197884 | 2 | 0.0648392837120218 |
| 87762 | 87762 | 31400 31400 | 197884 | 2 | 0.0648392837120218 |
| 87776 | 87776 | 31402 31402 | 197884 | 1 | 0.113207547169811 |
| 143356 | 143356 | 51111 51111 | 197884 | 2 | 0.0604119608490553 |
| 193688 | 193688 | 68835 68835 | 197884 | 2 | 0.0648392837120218 |
| 297611 | 297611 | 100615 100615 | 197884 | 2 | 0.0652899962369127 |
| 423135 | 423135 | 153167 153167 | 197884 | 1 | 0.114982578397213 |
| 460461 | 460461 | 165506 165506 | 197884 | 1 | 0.0527039745167596 |
| 539362 | 539362 | 213807 213807 | 197884 | 1 | 0.0373564899879457 |
| 552250 | 552250 | 218141 218141 | 197884 | 1 | 0.116504854368932 |
| 665760 | 665760 | 238414 238414 | 197884 | 2 | 0.0652899962369127 |
| 714473 | 714473 | 252910 252910 | 197884 | 2 | 0.0747440077765006 |
| 728047 | 728047 | 256998 256998 | 197884 | 3 | 0.0577593661124072 |
| 816470 | 816470 | 283537 283537 | 197884 | 1 | 0.115727002967359 |
| 816474 | 816474 | 283538 283538 | 197884 | 1 | 0.113207547169811 |
| 816478 | 816478 | 283539 283539 | 197884 | 1 | 0.11428436064927 |
| 816482 | 816482 | 283540 283540 | 197884 | 1 | 0.113207547169811 |
| 816486 | 816486 | 283541 283541 | 197884 | 1 | 0.0844338623979691 |
| 816493 | 816493 | 283542 283542 | 197884 | 1 | 0.113207547169811 |
| 816497 | 816497 | 283543 283543 | 197884 | 1 | 0.113207547169811 |
| 841972 | 841972 | 291870 291870 | 197884 | 1 | 0.0527039745167596 |
| 841981 | 841981 | 291871 291871 | 197884 | 1 | 0.0527039745167596 |
| 841990 | 841990 | 291872 291872 | 197884 | 1 | 0.0527039745167596 |
| 841999 | 841999 | 291873 291873 | 197884 | 1 | 0.0527039745167596 |
| 842008 | 842008 | 291874 291874 | 197884 | 1 | 0.0527039745167596 |
| 842017 | 842017 | 291875 291875 | 197884 | 1 | 0.0527039745167596 |
| 842026 | 842026 | 291876 291876 | 197884 | 1 | 0.0527039745167596 |
| 927805 | 927805 | 330019 330019 | 197884 | 1 | 0.113207547169811 |
| 1152519 | 1152519 | 388476 388476 | 197884 | 1 | 0.0501571935971724 |
| 1152528 | 1152528 | 388477 388477 | 197884 | 1 | 0.0501571935971724 |
| 1152537 | 1152537 | 388478 388478 | 197884 | 1 | 0.0501571935971724 |
| 1403711 | 1403711 | 439056 439056 | 197884 | 1 | 0.0501571935971724 |
| 1403720 | 1403720 | 439057 439057 | 197884 | 1 | 0.0501571935971724 |
| 1403729 | 1403729 | 439058 439058 | 197884 | 1 | 0.0501571935971724 |
| 1403738 | 1403738 | 439059 439059 | 197884 | 1 | 0.0501571935971724 |
| 1570249 | 1570249 | 474551 474551 | 197884 | 1 | 0.0501571935971724 |
| 1570258 | 1570258 | 474552 474552 | 197884 | 1 | 0.0501571935971724 |
| 1570267 | 1570267 | 474553 474553 | 197884 | 1 | 0.0501571935971724 |
| 1605037 | 1605037 | 484873 484873 | 197884 | 1 | 0.0501571935971724 |
| 1608843 | 1608843 | 485872 485872 | 197884 | 1 | 0.114503816793893 |
| 1652826 | 1652826 | 500596 500596 | 197884 | 1 | 0.0501571935971724 |
| 1715451 | 1715451 | 525502 525502 | 197884 | 1 | 0.113924050632911 |
| 1740166 | 1740166 | 532937 532937 | 197884 | 2 | 0.0648392837120218 |
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)
);