consensus_index

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

24 rows where inventory_id = 218297

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
552905 552905 218297 218297 7608 1 0.0264105842079526
552906 552906 218297 218297 52227 8 0.237695257871574
552907 552907 218297 218297 56848 2 0.0259346788459175
552908 552908 218297 218297 137477 2 0.0686167105586253
552909 552909 218297 218297 137623 2 0.118847628935787
552910 552910 218297 218297 171056 1 0.0339564654102248
552911 552911 218297 218297 186393 1 0.0297119072339467
552912 552912 218297 218297 189155 1 0.0396158763119289
552913 552913 218297 218297 192156 1 0.0182842506055057
552914 552914 218297 218297 195256 1 0.0237695257871574
552915 552915 218297 218297 207085 1 0.0113188218034083
552916 552916 218297 218297 219156 1 0.0475390515743147
552917 552917 218297 218297 233183 2 0.0686167105586253
552918 552918 218297 218297 234864 1 0.0132052921039763
552919 552919 218297 218297 237356 1 0.0297119072339467
552920 552920 218297 218297 261510 1 0.0216086598065067
552921 552921 218297 218297 262053 1 0.0198079381559645
552922 552922 218297 218297 288147 1 0.0475390515743147
552923 552923 218297 218297 294563 2 0.0231966819496389
552924 552924 218297 218297 308304 1 0.0264105842079526
552925 552925 218297 218297 320214 1 0.0148559536169733
552926 552926 218297 218297 327063 1 0.0139820739924455
552927 552927 218297 218297 330539 2 0.016025411016518
552928 552928 218297 218297 333120 2 0.0172442264349601 
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)
);