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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1258701 1258701 414647 414647 1303 1 0.0786236895159959
1258702 1258702 414647 414647 3314 1 0.0786236895159959
1258703 1258703 414647 414647 18534 5 0.178756843079347
1258704 1258704 414647 414647 43742 1 0.0471742137095976
1258705 1258705 414647 414647 73578 1 0.0336958669354268
1258706 1258706 414647 414647 76366 1 0.117935534273994
1258707 1258707 414647 414647 144143 1 0.039311844757998
1258708 1258708 414647 414647 144194 1 0.0589677671369969
1258709 1258709 414647 414647 190546 4 0.235871068547988
1258710 1258710 414647 414647 228445 1 0.117935534273994
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 850.081ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website