consensus_index

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

9 rows where inventory_id = 47675

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
134333 134333 47675 47675 336 1 0.044089197337477
134334 134334 47675 47675 2895 2 0.0836533702770353
134335 134335 47675 47675 14457 5 0.184864360465804
134336 134336 47675 47675 106642 9 0.264535184024862
134337 134337 47675 47675 145047 1 0.0529070368049724
134338 134338 47675 47675 159141 1 0.0661337960062156
134339 134339 47675 47675 223657 1 0.0881783946749541
134340 134340 47675 47675 248309 1 0.132267592012431
134341 134341 47675 47675 248496 3 0.0727896610352539 
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)
);