consensus_index

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

12 rows where inventory_id = 490001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1622751 1622751 490001 490001 35702 1 0.0418011651101048
1622752 1622752 490001 490001 36775 8 0.229991024499793
1622753 1622753 490001 490001 98828 1 0.250806990660629
1622754 1622754 490001 490001 135599 2 0.056082148034932
1622755 1622755 490001 490001 137918 2 0.102391525173588
1622756 1622756 490001 490001 157515 2 0.102391525173588
1622757 1622757 490001 490001 196744 1 0.0278674434067365
1622758 1622758 490001 490001 207013 1 0.0250806990660629
1622759 1622759 490001 490001 219149 1 0.0627017476651571
1622760 1622760 490001 490001 242180 1 0.0313508738325786
1622761 1622761 490001 490001 258935 1 0.0358295700943755
1622762 1622762 490001 490001 320878 1 0.0228006355146026 
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)
);