consensus_index

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

9 rows where inventory_id = 158975

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
443482 443482 158975 158975 2805 2 0.227146549958736
443483 443483 158975 158975 29279 1 0.0803084328994754
443484 443484 158975 158975 73622 1 0.0356926368442113
443485 443485 158975 158975 91474 1 0.107077910532634
443486 443486 158975 158975 115465 3 0.321233731597902
443487 443487 158975 158975 136947 1 0.0458905330854145
443488 443488 158975 158975 248524 1 0.0642467463195804
443489 443489 158975 158975 261982 1 0.053538955266317
443490 443490 158975 158975 290889 1 0.0401542164497377 
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)
);