consensus_index

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

8 rows where inventory_id = 470717

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1544205 1544205 470717 470717 52405 1 0.0332759396753015
1544206 1544206 470717 470717 70728 3 0.136219213012796
1544207 1544207 470717 470717 121833 2 0.232931577727111
1544208 1544208 470717 470717 151624 1 0.116465788863555
1544209 1544209 470717 470717 160057 1 0.0388219296211851
1544210 1544210 470717 470717 223150 2 0.232931577727111
1544211 1544211 470717 470717 292777 1 0.0582328944317777
1544212 1544212 470717 470717 321587 2 0.134483109103512 
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)
);