consensus_index

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

12 rows where inventory_id = 537448

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1754076 1754076 537448 537448 37783 4 0.175270535534532
1754077 1754077 537448 537448 129218 1 0.247869968437331
1754078 1754078 537448 537448 192689 3 0.0945800943904858
1754079 1754079 537448 537448 193636 3 0.171863437188959
1754080 1754080 537448 537448 196765 2 0.0468430209976147
1754081 1754081 537448 537448 197573 3 0.0575255238843333
1754082 1754082 537448 537448 228315 2 0.0264230274169407
1754083 1754083 537448 537448 233993 3 0.0413116614062218
1754084 1754084 537448 537448 234314 1 0.0247869968437331
1754085 1754085 537448 537448 249637 3 0.0443143682060809
1754086 1754086 537448 537448 287900 1 0.0275411076041479
1754087 1754087 537448 537448 320196 2 0.0331230177986772 
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)
);