consensus_index

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

23 rows where inchi_id = 63747

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17422 17422 5103 5103 63747 1 0.173228346456693
31318 31318 9184 9184 63747 8 0.519685039370079
82020 82020 29536 29536 63747 8 0.519685039370079
177842 177842 63389 63389 63747 3 0.487804878048781
177844 177844 63390 63390 63747 4 0.506024096385542
197031 197031 69957 69957 63747 1 0.105175754220869
214579 214579 74602 74602 63747 1 0.104712041884817
245765 245765 83628 83628 63747 7 0.500210743444938
425384 425384 153530 153530 63747 1 0.104712041884817
441163 441163 158147 158147 63747 8 0.519685039370079
522184 522184 208348 208348 63747 8 0.519685039370079
537693 537693 213331 213331 63747 1 0.104712041884817
545844 545844 215988 215988 63747 8 0.519685039370079
721517 721517 255012 255012 63747 8 0.519685039370079
729601 729601 257425 257425 63747 1 0.105175754220869
755703 755703 265528 265528 63747 3 0.415239576400731
845624 845624 292904 292904 63747 1 0.173228346456693
845628 845628 292905 292905 63747 1 0.104712041884817
945752 945752 338775 338775 63747 1 0.168674698795181
1610901 1610901 486267 486267 63747 1 0.173228346456693
1629613 1629613 492394 492394 63747 8 0.519685039370079
1698090 1698090 517829 517829 63747 1 0.3125
1727564 1727564 529042 529042 63747 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)
);