consensus_index

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

10 rows where inventory_id = 490227

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1623399 1623399 490227 490227 146 1 0.0604800351082877
1623400 1623400 490227 490227 34921 1 0.0432000250773484
1623401 1623401 490227 490227 40664 1 0.0302400175541439
1623402 1623402 490227 490227 43676 8 0.25428722358489
1623403 1623403 490227 490227 47712 1 0.0504000292569064
1623404 1623404 490227 490227 62774 2 0.030392361176017
1623405 1623405 490227 490227 129129 1 0.302400175541439
1623406 1623406 490227 490227 136255 2 0.100800058513813
1623407 1623407 490227 490227 231208 2 0.0756000438853596
1623408 1623408 490227 490227 263573 1 0.0378000219426798 
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)
);