contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax_phylum = "Chloroflexota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2765238 | 2765238 | PRJNA1111077_P_NODE_18383_length_292_cov_7.082192_g18162_i0 | PRJNA1111077 | 18383 | 292 | 7.082192 | 20.68000064 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 427 | 3.8499999999999997e-115 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g18162 | i0 | 93.151 | 3.03082191780822 | 292 | 18 | 99 | 2 | 2 | 292 | 1617684 | 1617974 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 885 | 427 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 2765685 | 2765685 | PRJNA1111077_P_NODE_37763_length_230_cov_3.471338_g37542_i0 | PRJNA1111077 | 37763 | 230 | 3.471338 | 7.9840774 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 82.4 | 2.62e-11 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g37542 | i0 | 85.714 | 10.5521739130435 | 77 | 11 | 33 | 0 | 151 | 227 | 2013936 | 2014012 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 2427 | 82.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 4041314 | 4041314 | PRJNA1111077_P_NODE_15604_length_310_cov_2.894515_g15383_i0 | PRJNA1111077 | 15604 | 310 | 2.894515 | 8.9729965 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 250 | 9.57e-62 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g15383 | i0 | 96.689 | 5.13225806451613 | 151 | 4 | 97 | 1 | 1 | 150 | 565109 | 565259 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 1591 | 250 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 7867372 | 7867372 | PRJNA1111077_P_NODE_21227_length_283_cov_1.271429_g21006_i0 | PRJNA1111077 | 21227 | 283 | 1.271429 | 3.59814407 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 100 | 9.2e-17 | NTclustered | gi|2874253741|emb|OY969584.1| | 1672391 | g21006 | i0 | 89.024 | 8.48056537102473 | 82 | 7 | 28 | 2 | 22 | 101 | 1624060 | 1624141 | MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1 | blastn | 2400 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 7867601 | 7867601 | PRJNA1111077_P_NODE_30967_length_250_cov_0.870056_g30746_i0 | PRJNA1111077 | 30967 | 250 | 0.870056 | 2.17514 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 252 | 2.08e-62 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g30746 | i0 | 84.861 | 15.096 | 251 | 36 | 100 | 2 | 1 | 250 | 1651138 | 1650889 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 3774 | 252 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 16791653 | 16791653 | PRJNA1111077_P_NODE_17334_length_298_cov_4.653333_g17113_i0 | PRJNA1111077 | 17334 | 298 | 4.653333 | 13.86693234 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 512 | 1.06e-140 | NTclustered | gi|2874253835|emb|OY969885.1| | 1672391 | g17113 | i0 | 97.651 | 432.734899328859 | 298 | 7 | 100 | 0 | 1 | 298 | 2092097 | 2091800 | MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 | blastn | 128955 | 512 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18066299 | 18066299 | PRJNA1111077_P_NODE_21695_length_281_cov_1.971154_g21474_i0 | PRJNA1111077 | 21695 | 281 | 1.971154 | 5.53894274 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 121 | 7.000000000000001e-23 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g21474 | i0 | 83.333 | 0.850533807829182 | 138 | 16 | 48 | 5 | 2 | 136 | 3148708 | 3148841 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 239 | 121 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 20615804 | 20615804 | PRJNA1111077_P_NODE_22497_length_278_cov_9.385366_g22276_i0 | PRJNA1111077 | 22497 | 278 | 9.385366 | 26.09131748 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 217 | 8.569999999999999e-52 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g22276 | i0 | 92.715 | 107.291366906475 | 151 | 9 | 100 | 2 | 1 | 150 | 566218 | 566367 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 29827 | 217 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;