consensus_index

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

25 rows where inchi_id = 54285

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
87968 87968 31461 31461 54285 1 0.167330677290837
87974 87974 31462 31462 54285 1 0.167597765363128
152453 152453 54853 54853 54285 3 0.185058362945992
241218 241218 81990 81990 54285 5 0.314931797141049
276848 276848 93853 93853 54285 1 0.258620689655172
297567 297567 100603 100603 54285 1 0.184819529926627
335160 335160 112977 112977 54285 3 0.185058362945992
439218 439218 157416 157416 54285 5 0.314931797141049
452937 452937 162600 162600 54285 1 0.257142857142857
460450 460450 165504 165504 54285 1 0.184819529926627
539405 539405 213824 213824 54285 1 0.184819529926627
551285 551285 217845 217845 54285 5 0.314931797141049
560951 560951 220611 220611 54285 1 0.258620689655172
569071 569071 223195 223195 54285 3 0.185058362945992
714829 714829 253011 253011 54285 7 0.505896680688712
782945 782945 273728 273728 54285 3 0.185058362945992
836513 836513 290219 290219 54285 1 0.158612994662193
935729 935729 334060 334060 54285 1 0.253012048192771
1044388 1044388 369826 369826 54285 3 0.185058362945992
1265072 1265072 416598 416598 54285 3 0.185058362945992
1487570 1487570 460339 460339 54285 3 0.185058362945992
1597119 1597119 482289 482289 54285 3 0.185058362945992
1626575 1626575 491218 491218 54285 7 0.505896680688712
1671971 1671971 507335 507335 54285 3 0.185058362945992
1750670 1750670 536271 536271 54285 3 0.185058362945992 
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)
);