consensus_index

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

18 rows where inventory_id = 153026

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
421734 421734 153026 153026 9014 1 0.0885596373126029
421735 421735 153026 153026 45333 8 0.265678911937809
421736 421736 153026 153026 149542 1 0.0379541302768298
421737 421737 153026 153026 169903 1 0.0156281712904593
421738 421738 153026 153026 182692 2 0.132839455968904
421739 421739 153026 153026 208438 2 0.0766948956626504
421740 421740 153026 153026 230850 1 0.0221399093281507
421741 421741 153026 153026 232032 1 0.0664197279844522
421742 421742 153026 153026 232033 1 0.0531357823875618
421743 421743 153026 153026 232034 1 0.0442798186563015
421744 421744 153026 153026 232035 1 0.0332098639922261
421745 421745 153026 153026 232036 1 0.029519879104201
421746 421746 153026 153026 232037 1 0.0265678911937809
421747 421747 153026 153026 232038 1 0.0241526283579826
421748 421748 153026 153026 232039 1 0.0204368393798314
421749 421749 153026 153026 232040 1 0.0189770651384149
421750 421750 153026 153026 232041 1 0.0177119274625206
421751 421751 153026 153026 232042 1 0.0166049319961131 
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)
);