consensus_index

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

29 rows where inventory_id = 1515

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4969 4969 1515 1515 45286 22 0.252519832624041
4970 4970 1515 1515 136966 6 0.0768364105891975
4971 4971 1515 1515 186242 6 0.0743413237734794
4972 4972 1515 1515 186857 6 0.0363385241785641
4973 4973 1515 1515 189109 6 0.0300644247255007
4974 4974 1515 1515 191719 2 0.0143886528466635
4975 4975 1515 1515 192424 1 0.0168346555082694
4976 4976 1515 1515 194994 6 0.0460424165979109
4977 4977 1515 1515 195140 1 0.0105216596926684
4978 4978 1515 1515 197990 2 0.0109895151363796
4979 4979 1515 1515 203715 6 0.028306775685307
4980 4980 1515 1515 208869 6 0.0240781481474577
4981 4981 1515 1515 208870 1 0.0505039665248082
4982 4982 1515 1515 230927 1 0.0126259916312021
4983 4983 1515 1515 237667 6 0.0549191143138882
4984 4984 1515 1515 254800 6 0.0305842590820998
4985 4985 1515 1515 256410 6 0.0233846361528992
4986 4986 1515 1515 258902 6 0.0258404326218023
4987 4987 1515 1515 259521 6 0.0204364119075261
4988 4988 1515 1515 259787 6 0.0237993036998289
4989 4989 1515 1515 270296 6 0.0202323747009796
4990 4990 1515 1515 270900 2 0.0129882187019188
4991 4991 1515 1515 274355 2 0.0175091000884147
4992 4992 1515 1515 275028 1 0.0140288795902245
4993 4993 1515 1515 276349 6 0.0168104764998207
4994 4994 1515 1515 288143 1 0.0140288795902245
4995 4995 1515 1515 288201 1 0.0132905175065285
4996 4996 1515 1515 291669 2 0.0153112638598855
4997 4997 1515 1515 310173 2 0.0105308049874785 
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)
);