consensus_index

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

11 rows where inventory_id = 528137

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1724735 1724735 528137 528137 44226 4 0.316852083456083
1724736 1724736 528137 528137 138015 1 0.0528086805760139
1724737 1724737 528137 528137 147385 1 0.0452645833508691
1724738 1724738 528137 528137 166742 2 0.105617361152028
1724739 1724739 528137 528137 188910 2 0.0792130208640208
1724740 1724740 528137 528137 190981 2 0.0448096513689765
1724741 1724741 528137 528137 191884 2 0.0431181071336198
1724742 1724742 528137 528137 216644 2 0.158426041728042
1724743 1724743 528137 528137 217178 2 0.042341140663506
1724744 1724744 528137 528137 218194 1 0.0633704166912167
1724745 1724745 528137 528137 334231 2 0.0337765455858023 
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)
);