consensus_index

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

11 rows where inventory_id = 198907

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
500799 500799 198907 198907 5804 1 0.140516774810944
500800 500800 198907 198907 8184 1 0.0936778498739627
500801 500801 198907 198907 115944 2 0.162254795525513
500802 500802 198907 198907 139097 1 0.0936778498739627
500803 500803 198907 198907 170571 2 0.12568202418252
500804 500804 198907 198907 181718 1 0.070258387405472
500805 500805 198907 198907 205785 1 0.040147649945984
500806 500806 198907 198907 216174 1 0.140516774810944
500807 500807 198907 198907 235042 1 0.0312259499579876
500808 500808 198907 198907 259310 1 0.0468389249369813
500809 500809 198907 198907 281886 1 0.035129193702736 
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)
);