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 = 359789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1005609 1005609 359789 359789 443 1 0.0418827283605903
1005610 1005610 359789 359789 6869 8 0.335061826884723
1005611 1005611 359789 359789 16988 1 0.0335061826884723
1005612 1005612 359789 359789 30757 1 0.0478659752692461
1005613 1005613 359789 359789 37525 1 0.0558436378141205
1005614 1005614 359789 359789 37635 1 0.0372290918760803
1005615 1005615 359789 359789 50017 1 0.0670123653769446
1005616 1005616 359789 359789 54039 1 0.167530913442361
1005617 1005617 359789 359789 58649 1 0.0837654567211807
1005618 1005618 359789 359789 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 1155.042ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website