consensus_index

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

14 rows where inventory_id = 56767

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
157772 157772 56767 56767 7812 7 0.315068864399338
157773 157773 56767 56767 7814 1 0.0630137728798676
157774 157774 56767 56767 16385 1 0.105022954799779
157775 157775 56767 56767 56289 1 0.0350076515999264
157776 157776 56767 56767 136466 1 0.0525114773998897
157777 157777 56767 56767 137781 2 0.0421028479936521
157778 157778 56767 56767 137782 1 0.0286426240363034
157779 157779 56767 56767 195790 2 0.157534432199669
157780 157780 56767 56767 248990 1 0.0315068864399338
157781 157781 56767 56767 273967 1 0.045009837771334
157782 157782 56767 56767 276015 1 0.0393836080499172
157783 157783 56767 56767 289582 1 0.0262557386999448
157784 157784 56767 56767 309841 1 0.0242360664922568
157785 157785 56767 56767 323193 1 0.0210045909599559 
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)
);