consensus_index

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

24 rows where inventory_id = 209557

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
526818 526818 209557 209557 365 2 0.0898031068248107
526819 526819 209557 209557 422 10 0.270817039166926
526820 526820 209557 209557 124382 2 0.0635003858074436
526821 526821 209557 209557 179620 1 0.062217417479243
526822 526822 209557 209557 223504 2 0.0803223405803808
526823 526823 209557 209557 232060 1 0.0444410124851736
526824 526824 209557 209557 232061 1 0.0388858859245269
526825 526825 209557 209557 232062 1 0.0345652319329128
526826 526826 209557 209557 232063 1 0.0311087087396215
526827 526827 209557 209557 232064 1 0.0282806443087468
526828 526828 209557 209557 232065 1 0.0259239239496846
526829 526829 209557 209557 232066 1 0.023929775953555
526830 526830 209557 209557 232067 1 0.0222205062425868
526831 526831 209557 209557 232068 1 0.0207391391597477
526832 526832 209557 209557 232069 1 0.0194429429622634
526833 526833 209557 209557 232070 1 0.0182992404350715
526834 526834 209557 209557 232071 1 0.0172826159664564
526835 526835 209557 209557 232072 1 0.0163730045998008
526836 526836 209557 209557 232073 1 0.0155543543698107
526837 526837 209557 209557 232074 1 0.0148136708283912
526838 526838 209557 209557 232075 1 0.0141403221543734
526839 526839 209557 209557 232076 1 0.0135255255389659
526840 526840 209557 209557 232077 1 0.0129619619748423
526841 526841 209557 209557 232078 1 0.0124434834958486 
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)
);