consensus_index

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

14 rows where inventory_id = 465100

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1506582 1506582 465100 465100 51218 1 0.0267902005105187
1506583 1506583 465100 465100 52206 7 0.267902005105187
1506584 1506584 465100 465100 75159 1 0.0446503341841978
1506585 1506585 465100 465100 83488 1 0.0334877506381483
1506586 1506586 465100 465100 107005 1 0.0297668894561319
1506587 1506587 465100 465100 136474 2 0.0691720002791975
1506588 1506588 465100 465100 137028 2 0.0378870649006701
1506589 1506589 465100 465100 168930 2 0.07733664738196
1506590 1506590 465100 465100 169031 2 0.133951002552593
1506591 1506591 465100 465100 169090 2 0.0315725540838918
1506592 1506592 465100 465100 177695 2 0.133951002552593
1506593 1506593 465100 465100 188233 1 0.0243547277368352
1506594 1506594 465100 465100 238191 2 0.0413381768492918
1506595 1506595 465100 465100 271865 1 0.0382717150150267 
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)
);