consensus_index

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

27 rows where inchi_id = 40819

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2784 2784 782 782 40819 2 0.172131147540984
11898 11898 3614 3614 40819 5 0.377174279148888
38984 38984 11745 11745 40819 5 0.377174279148888
61651 61651 19803 19803 40819 1 0.169811320754717
90751 90751 32386 32386 40819 5 0.377174279148888
90755 90755 32387 32387 40819 1 0.169811320754717
163761 163761 58647 58647 40819 2 0.1954757495347
163766 163766 58648 58648 40819 3 0.383781450104316
205871 205871 72974 72974 40819 2 0.171428571428571
276966 276966 93893 93893 40819 5 0.328356859892476
420132 420132 151073 151073 40819 1 0.1875
452983 452983 162622 162622 40819 3 0.371906382794278
557604 557604 219583 219583 40819 2 0.171428571428571
560847 560847 220576 220576 40819 7 0.338519450428135
702850 702850 250308 250308 40819 7 0.335513752863138
707537 707537 251306 251306 40819 2 0.172131147540984
799080 799080 278764 278764 40819 4 0.399629456437526
799084 799084 278765 278765 40819 5 0.377174279148888
799097 799097 278766 278766 40819 3 0.138813817147502
799125 799125 278767 278767 40819 4 0.399629456437526
799129 799129 278768 278768 40819 7 0.251316463993165
805135 805135 280556 280556 40819 1 0.075814305438128
805163 805163 280557 280557 40819 1 0.168
805167 805167 280558 280558 40819 1 0.168
1644146 1644146 497627 497627 40819 5 0.409718378240293
1735417 1735417 531605 531605 40819 5 0.377174279148888
1755416 1755416 538012 538012 40819 1 0.169811320754717 
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)
);