consensus_index

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

20 rows where inventory_id = 1965

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6419 6419 1965 1965 649 4 0.202496822578549
6420 6420 1965 1965 95113 1 0.0168747352148791
6421 6421 1965 1965 130681 1 0.0155766786598884
6422 6422 1965 1965 137100 3 0.0637825023258854
6423 6423 1965 1965 137613 1 0.0202496822578549
6424 6424 1965 1965 139632 1 0.0337494704297582
6425 6425 1965 1965 140403 1 0.0184088020525954
6426 6426 1965 1965 140404 3 0.0569308115941871
6427 6427 1965 1965 140408 1 0.0224996469531721
6428 6428 1965 1965 149856 4 0.202496822578549
6429 6429 1965 1965 152808 3 0.0803609172953517
6430 6430 1965 1965 173359 2 0.0191341512079861
6431 6431 1965 1965 173406 1 0.0674989408595164
6432 6432 1965 1965 183336 1 0.0224996469531721
6433 6433 1965 1965 186330 3 0.0381113611560688
6434 6434 1965 1965 190821 2 0.0197616663926252
6435 6435 1965 1965 196337 3 0.0198852126786024
6436 6436 1965 1965 199923 1 0.0253121028223187
6437 6437 1965 1965 224163 1 0.0289281175112213
6438 6438 1965 1965 267569 1 0.0202496822578549 
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)
);