consensus_index

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

12 rows where inventory_id = 51648

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
144841 144841 51648 51648 215 1 0.116862913769095
144842 144842 51648 51648 755 2 0.165269117590692
144843 144843 51648 51648 756 4 0.23372582753819
144844 144844 51648 51648 2438 1 0.0467451655076381
144845 144845 51648 51648 2439 1 0.0389543045896984
144846 144846 51648 51648 75973 1 0.0779086091793968
144847 144847 51648 51648 76425 1 0.0333894039340272
144848 144848 51648 51648 136452 1 0.0779086091793968
144849 144849 51648 51648 139912 1 0.0292157284422738
144850 144850 51648 51648 142231 1 0.0259695363931322
144851 144851 51648 51648 182948 2 0.0826345587953459
144852 144852 51648 51648 253861 1 0.0584314568845476 
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)
);