consensus_index

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

10 rows where inchi_id = 33975

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
37808 37808 11371 11371 33975 6 0.473684210526316
116171 116171 40516 40516 33975 2 0.171428571428571
138763 138763 49420 49420 33975 6 0.473684210526316
271979 271979 92261 92261 33975 6 0.341968911917098
329396 329396 111028 111028 33975 1 0.110960658864511
451307 451307 161957 161957 33975 6 0.473684210526316
883605 883605 307415 307415 33975 3 0.454545454545455
935455 935455 333903 333903 33975 1 0.112
951039 951039 341178 341178 33975 1 0.168
1642003 1642003 496882 496882 33975 6 0.473684210526316 
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)
);