consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

28 rows where inchi_id = 56806

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15807 15807 4801 4801 56806 1 0.176626902320039
27385 27385 7945 7945 56806 3 0.211644215337436
30466 30466 8876 8876 56806 6 0.280890693804253
112270 112270 39266 39266 56806 1 0.176626902320039
126363 126363 45157 45157 56806 1 0.175985888987188
197471 197471 70111 70111 56806 3 0.211644215337436
211278 211278 74045 74045 56806 2 0.0729757477066514
231337 231337 79164 79164 56806 1 0.310344827586207
231340 231340 79165 79165 56806 4 0.159516740549572
242871 242871 82596 82596 56806 6 0.280890693804253
423333 423333 153200 153200 56806 2 0.0729757477066514
550707 550707 217659 217659 56806 1 0.125339696325654
699153 699153 249178 249178 56806 3 0.211644215337436
715829 715829 253275 253275 56806 1 0.176626902320039
818430 818430 284139 284139 56806 1 0.176626902320039
915018 915018 324037 324037 56806 3 0.32260288959772
915208 915208 324194 324194 56806 1 0.3
917157 917157 325083 325083 56806 2 0.275934428637107
1073859 1073859 377037 377037 56806 1 0.176626902320039
1300149 1300149 424994 424994 56806 1 0.176626902320039
1300154 1300154 424995 424995 56806 1 0.176626902320039
1509120 1509120 465670 465670 56806 1 0.176626902320039
1601751 1601751 483829 483829 56806 1 0.176626902320039
1609072 1609072 485909 485909 56806 1 0.176626902320039
1622411 1622411 489864 489864 56806 3 0.211644215337436
1627479 1627479 491579 491579 56806 5 0.207040686355256
1715583 1715583 525529 525529 56806 1 0.173561342098306
1724069 1724069 527949 527949 56806 2 0.275934428637107 
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)
);