consensus_index

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

9 rows where inventory_id = 528147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1724781 1724781 528147 528147 43099 1 0.0592922387441408
1724782 1724782 528147 528147 44438 5 0.23798172164866
1724783 1724783 528147 528147 162379 1 0.074115298430176
1724784 1724784 528147 528147 186398 3 0.235301405389997
1724785 1724785 528147 528147 190469 1 0.037057649215088
1724786 1724786 528147 528147 192417 2 0.148230596860352
1724787 1724787 528147 528147 208504 1 0.0988203979069013
1724788 1724788 528147 528147 260747 1 0.0494101989534507
1724789 1724789 528147 528147 308186 1 0.0423515991029577 
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)
);