consensus_index

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

11 rows where inchi_id = 33027

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16219 16219 4852 4852 33027 1 0.0793201133144476
92356 92356 32930 32930 33027 1 0.0793201133144476
172331 172331 61553 61553 33027 1 0.0592676215339025
212216 212216 74174 74174 33027 1 0.0591341077085533
344057 344057 116201 116201 33027 7 0.444444444444444
423808 423808 153258 153258 33027 1 0.0662983425414365
512293 512293 206015 206015 33027 1 0.0591341077085533
547046 547046 216367 216367 33027 1 0.0591719765617495
941398 941398 336851 336851 33027 1 0.0784313725490196
1609556 1609556 485976 485976 33027 1 0.0793201133144476
1675994 1675994 508815 508815 33027 8 0.334661354581673 
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)
);