consensus_index

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

14 rows where inchi_id = 10101

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2002 2002 531 531 10101 1 0.0598415957758874
25991 25991 7608 7608 10101 8 0.519685039370079
187838 187838 66866 66866 10101 16 0.368421052631579
200794 200794 71339 71339 10101 1 0.0598415957758874
213507 213507 74338 74338 10101 1 0.0700583819849875
227646 227646 78284 78284 10101 8 0.364485981308411
424605 424605 153346 153346 10101 1 0.0700583819849875
503582 503582 201512 201512 10101 8 0.364485981308411
512927 512927 206068 206068 10101 1 0.0680383584631739
664822 664822 238211 238211 10101 1 0.0680383584631739
682598 682598 243800 243800 10101 12 0.366906474820144
763598 763598 267727 267727 10101 8 0.519685039370079
953016 953016 341987 341987 10101 4 0.506024096385542
1620576 1620576 489372 489372 10101 8 0.519685039370079 
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)
);