consensus_index

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

10 rows where inventory_id = 404402

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1218432 1218432 404402 404402 7026 8 0.295462539570876
1218433 1218433 404402 404402 60356 1 0.0984875131902919
1218434 1218434 404402 404402 133491 1 0.0590925079141752
1218435 1218435 404402 404402 136298 1 0.147731269785438
1218436 1218436 404402 404402 169479 1 0.0422089342244108
1218437 1218437 404402 404402 200989 1 0.147731269785438
1218438 1218438 404402 404402 219773 1 0.0328291710634306
1218439 1218439 404402 404402 220560 1 0.049243756595146
1218440 1218440 404402 404402 258465 1 0.073865634892719
1218441 1218441 404402 404402 326828 1 0.0369328174463595 
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)
);