consensus_index

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

13 rows where inventory_id = 4774

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15627 15627 4774 4774 53075 6 0.278892087891762
15628 15628 4774 4774 123838 3 0.193372973466942
15629 15629 4774 4774 136294 2 0.139446043945881
15630 15630 4774 4774 173408 1 0.0278892087891762
15631 15631 4774 4774 186248 1 0.0557784175783525
15632 15632 4774 4774 192012 1 0.0697230219729406
15633 15633 4774 4774 195204 1 0.046482014648627
15634 15634 4774 4774 195512 1 0.0232410073243135
15635 15635 4774 4774 197730 1 0.0398417268416803
15636 15636 4774 4774 204661 1 0.0214532375301356
15637 15637 4774 4774 226433 1 0.0348615109864703
15638 15638 4774 4774 228419 1 0.0253538261719784
15639 15639 4774 4774 255480 1 0.0309880097657514 
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)
);