home / zeropm-v0-0-4

consensus_index

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

15 rows where inchi_id = 31443

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20670 20670 6083 6083 31443 1 0.3125
24670 24670 7239 7239 31443 1 0.259842519685039
139868 139868 49818 49818 31443 1 0.3125
167099 167099 59771 59771 31443 4 0.6
167102 167102 59772 59772 31443 2 0.233766233766234
224650 224650 77487 77487 31443 2 0.259842519685039
269963 269963 91532 91532 31443 7 0.422535211267606
270584 270584 91763 91763 31443 1 0.310344827586207
676752 676752 241848 241848 31443 1 0.263157894736842
790975 790975 276154 276154 31443 1 0.3
790977 790977 276155 276155 31443 1 0.3125
881185 881185 306168 306168 31443 4 0.417633410672854
894806 894806 314103 314103 31443 1 0.253012048192771
1618809 1618809 488801 488801 31443 1 0.259842519685039
1641211 1641211 496593 496593 31443 1 0.3125
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 1293.78ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website