consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
51 rows where inchi_id = 527
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 3908 | 3908 | 1131 1131 | 527 | 1 | 0.118705035971223 |
| 3918 | 3918 | 1133 1133 | 527 | 2 | 0.190955370918348 |
| 3922 | 3922 | 1134 1134 | 527 | 2 | 0.350459541707626 |
| 3927 | 3927 | 1135 1135 | 527 | 1 | 0.318181818181818 |
| 29119 | 29119 | 8435 8435 | 527 | 3 | 0.390026994219539 |
| 140908 | 140908 | 50211 50211 | 527 | 8 | 0.396600566572238 |
| 140914 | 140914 | 50212 50212 | 527 | 1 | 0.431576391758326 |
| 200888 | 200888 | 71357 71357 | 527 | 1 | 0.118421052631579 |
| 201090 | 201090 | 71413 71413 | 527 | 1 | 0.318181818181818 |
| 214691 | 214691 | 74639 74639 | 527 | 1 | 0.3125 |
| 238645 | 238645 | 81204 81204 | 527 | 2 | 0.350459541707626 |
| 300441 | 300441 | 101729 101729 | 527 | 2 | 0.190955370918348 |
| 338477 | 338477 | 114125 114125 | 527 | 1 | 0.166493818891805 |
| 420401 | 420401 | 151506 151506 | 527 | 3 | 0.690983005625053 |
| 438030 | 438030 | 157019 157019 | 527 | 3 | 0.450868224495074 |
| 461982 | 461982 | 165976 165976 | 527 | 1 | 0.153846153846154 |
| 461986 | 461986 | 165977 165977 | 527 | 6 | 0.341334572767198 |
| 513896 | 513896 | 206283 206283 | 527 | 1 | 0.3125 |
| 521466 | 521466 | 208099 208099 | 527 | 3 | 0.431939108028114 |
| 521469 | 521469 | 208100 208100 | 527 | 3 | 0.431939108028114 |
| 555237 | 555237 | 218886 218886 | 527 | 2 | 0.350459541707626 |
| 595794 | 595794 | 232004 232004 | 527 | 6 | 0.341334572767198 |
| 663068 | 663068 | 237737 237737 | 527 | 3 | 0.469186371455602 |
| 666334 | 666334 | 238547 238547 | 527 | 1 | 0.118421052631579 |
| 710262 | 710262 | 251982 251982 | 527 | 3 | 0.390026994219539 |
| 729746 | 729746 | 257476 257476 | 527 | 1 | 0.147239263803681 |
| 809458 | 809458 | 281809 281809 | 527 | 3 | 0.390026994219539 |
| 809462 | 809462 | 281810 281810 | 527 | 2 | 0.225794998231249 |
| 809467 | 809467 | 281811 281811 | 527 | 3 | 0.431939108028114 |
| 845930 | 845930 | 293005 293005 | 527 | 1 | 0.146341463414634 |
| 876683 | 876683 | 303738 303738 | 527 | 1 | 0.431576391758326 |
| 952530 | 952530 | 341759 341759 | 527 | 1 | 0.150943396226415 |
| 971125 | 971125 | 352061 352061 | 527 | 2 | 0.182647423110619 |
| 1062389 | 1062389 | 375080 375080 | 527 | 3 | 0.390026994219539 |
| 1062393 | 1062393 | 375081 375081 | 527 | 3 | 0.390026994219539 |
| 1062397 | 1062397 | 375082 375082 | 527 | 3 | 0.390026994219539 |
| 1181119 | 1181119 | 396071 396071 | 527 | 2 | 0.182647423110619 |
| 1286278 | 1286278 | 422815 422815 | 527 | 3 | 0.390026994219539 |
| 1286282 | 1286282 | 422816 422816 | 527 | 3 | 0.390026994219539 |
| 1286286 | 1286286 | 422817 422817 | 527 | 3 | 0.390026994219539 |
| 1435657 | 1435657 | 447461 447461 | 527 | 2 | 0.182647423110619 |
| 1500807 | 1500807 | 464262 464262 | 527 | 3 | 0.390026994219539 |
| 1500811 | 1500811 | 464263 464263 | 527 | 3 | 0.390026994219539 |
| 1500815 | 1500815 | 464264 464264 | 527 | 3 | 0.390026994219539 |
| 1589463 | 1589463 | 479803 479803 | 527 | 2 | 0.182647423110619 |
| 1600628 | 1600628 | 483530 483530 | 527 | 3 | 0.390026994219539 |
| 1625409 | 1625409 | 490840 490840 | 527 | 3 | 0.390026994219539 |
| 1654750 | 1654750 | 501384 501384 | 527 | 8 | 0.396600566572238 |
| 1725807 | 1725807 | 528430 528430 | 527 | 1 | 0.431576391758326 |
| 1742165 | 1742165 | 533622 533622 | 527 | 2 | 0.182647423110619 |
| 1742169 | 1742169 | 533623 533623 | 527 | 8 | 0.396600566572238 |
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)
);