home / zeropm-v0-0-4

consensus_index

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

10 rows where inventory_id = 452789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1457951 1457951 452789 452789 443 1 0.0418827283605903
1457952 1457952 452789 452789 6869 8 0.335061826884723
1457953 1457953 452789 452789 16988 1 0.0335061826884723
1457954 1457954 452789 452789 30757 1 0.0478659752692461
1457955 1457955 452789 452789 37525 1 0.0558436378141205
1457956 1457956 452789 452789 37635 1 0.0372290918760803
1457957 1457957 452789 452789 50017 1 0.0670123653769446
1457958 1457958 452789 452789 54039 1 0.167530913442361
1457959 1457959 452789 452789 58649 1 0.0837654567211807
1457960 1457960 452789 452789 138782 1 0.111687275628241
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)
);
Powered by Datasette · Queries took 703.549ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website