consensus_index

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

21 rows where inventory_id = 228852

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
586037 586037 228852 228852 7153 5 0.153459821182342
586038 586038 228852 228852 23302 3 0.057597616032412
586039 586039 228852 228852 63043 1 0.0252249861825862
586040 586040 228852 228852 102597 6 0.252249861825862
586041 586041 228852 228852 137095 2 0.0550454326599601
586042 586042 228852 228852 217156 1 0.0168166574550574
586043 586043 228852 228852 229073 2 0.0728182628141036
586044 586044 228852 228852 230016 1 0.0315312327282327
586045 586045 228852 228852 230820 1 0.0140138812125479
586046 586046 228852 228852 231005 3 0.0585420070965643
586047 586047 228852 228852 239432 2 0.0343268582867179
586048 586048 228852 228852 261021 1 0.0315312327282327
586049 586049 228852 228852 261868 2 0.0340133644298736
586050 586050 228852 228852 278069 1 0.0280277624250957
586051 586051 228852 228852 288038 2 0.0240510806393329
586052 586052 228852 228852 291195 1 0.0210208218188218
586053 586053 228852 228852 292828 2 0.0201961523358818
586054 586054 228852 228852 309190 2 0.0186980037706277
586055 586055 228852 228852 328726 1 0.0148382271662272
586056 586056 228852 228852 333642 2 0.0168541528359543
586057 586057 228852 228852 334344 1 0.0132763085171506 
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)
);