consensus_index

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

9 rows where inventory_id = 238107

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
664520 664520 238107 238107 22182 1 0.0942263186942505
664521 664521 238107 238107 180555 1 0.0706697390206879
664522 664522 238107 238107 191343 1 0.0565357912165503
664523 664523 238107 238107 219502 1 0.0403827080118217
664524 664524 238107 238107 224052 1 0.0314087728980835
664525 664525 238107 238107 225923 1 0.282678956082752
664526 664526 238107 238107 226722 3 0.224362436127516
664527 664527 238107 238107 231924 1 0.0471131593471253
664528 664528 238107 238107 247311 1 0.0353348695103439 
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)
);