consensus_index

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

21 rows where inventory_id = 77185

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
223643 223643 77185 77185 4477 4 0.212912003720356
223644 223644 77185 77185 48386 1 0.0266140004650445
223645 223645 77185 77185 136293 4 0.0785419550014953
223646 223646 77185 77185 149682 1 0.0212912003720356
223647 223647 77185 77185 185603 4 0.212912003720356
223648 223648 77185 77185 186247 4 0.0388722357337543
223649 223649 77185 77185 186830 4 0.0961938565771504
223650 223650 77185 77185 190288 4 0.0388722357337543
223651 223651 77185 77185 190437 4 0.0285638004086809
223652 223652 77185 77185 201760 1 0.0236568893022618
223653 223653 77185 77185 215491 1 0.0141941335813571
223654 223654 77185 77185 233191 2 0.0284515632661826
223655 223655 77185 77185 241512 1 0.0118284446511309
223656 223656 77185 77185 242696 1 0.0125242355129621
223657 223657 77185 77185 254091 1 0.0152080002657397
223658 223658 77185 77185 256452 4 0.0532280009300891
223659 223659 77185 77185 256453 4 0.0232437921013449
223660 223660 77185 77185 310541 1 0.0177426669766964
223661 223661 77185 77185 310542 1 0.0163778464400274
223662 223662 77185 77185 310543 1 0.0133070002325223
223663 223663 77185 77185 323049 1 0.0112058949326503 
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)
);