contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2198479 | 2198479 | PRJNA942359_P_NODE_8022_length_305_cov_12.556034_g7907_i0 | PRJNA942359 | 8022 | 305 | 12.556034 | 38.2959037 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 326 | 1.52e-84 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g7907 | i0 | 85.993 | 264.950819672131 | 307 | 39 | 100 | 4 | 1 | 305 | 3559014 | 3559318 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 80810 | 326 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 4751219 | 4751219 | PRJNA942359_P_NODE_11284_length_268_cov_1.051282_g11169_i0 | PRJNA942359 | 11284 | 268 | 1.051282 | 2.81743576 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 440 | 4.479999999999998e-119 | NTclustered | gi|2874253678|emb|OY969112.1| | 171953 | g11169 | i0 | 96.617 | 344.182835820896 | 266 | 7 | 99 | 2 | 3 | 267 | 4731767 | 4732031 | MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 | blastn | 92241 | 440 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 7301051 | 7301051 | PRJNA942359_P_NODE_16586_length_247_cov_1.724138_g16471_i0 | PRJNA942359 | 16586 | 247 | 1.724138 | 4.25862086 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 353 | 5.46e-93 | NTclustered | gi|112980881|gb|DQ829685.1| | 171953 | g16471 | i0 | 92.308 | 61.3724696356275 | 247 | 19 | 100 | 0 | 1 | 247 | 505 | 259 | Uncultured Acidobacteria bacterium clone DON13 23S ribosomal RNA gene, partial sequence | blastn | 15159 | 353 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 8575734 | 8575734 | PRJNA942359_P_NODE_10327_length_277_cov_2.441176_g10212_i0 | PRJNA942359 | 10327 | 277 | 2.441176 | 6.76205752 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 296 | 1.07e-75 | NTclustered | gi|2874254061|emb|OY970385.1| | 2026791 | g10212 | i0 | 86.022 | 258.252707581227 | 279 | 35 | 100 | 4 | 1 | 277 | 2774352 | 2774628 | MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 | blastn | 71536 | 296 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 16225864 | 16225864 | PRJNA942359_P_NODE_15553_length_249_cov_0.886364_g15438_i0 | PRJNA942359 | 15553 | 249 | 0.886364 | 2.20704636 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 416 | 6.939999999999999e-112 | NTclustered | gi|112980828|gb|DQ829632.1| | 171953 | g15438 | i0 | 96.787 | 100.072289156627 | 249 | 8 | 100 | 0 | 1 | 249 | 315 | 67 | Uncultured Acidobacteria bacterium clone DON17 16S ribosomal RNA gene, partial sequence | blastn | 24918 | 416 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 16561363 | 16561363 | PRJNA942359_P_NODE_3433_length_430_cov_2.834734_g3318_i0 | PRJNA942359 | 3433 | 430 | 2.834734 | 12.1893562 | Bacteria | 2 | Bacteria | Bacteria | 717 | 0 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g3318 | i0 | 96.744 | 139.325581395349 | 430 | 14 | 100 | 0 | 1 | 430 | 2365653 | 2366082 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 59910 | 717 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 18774762 | 18774762 | PRJNA942359_P_NODE_19115_length_243_cov_2.870588_g19000_i0 | PRJNA942359 | 19115 | 243 | 2.870588 | 6.97552884 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 322 | 1.51e-83 | NTclustered | gi|2874253796|emb|OY969780.1| | 194844 | g19000 | i0 | 90.535 | 106.423868312757 | 243 | 23 | 100 | 0 | 1 | 243 | 285778 | 286020 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 | blastn | 25861 | 322 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 23875371 | 23875371 | PRJNA942359_P_NODE_13279_length_253_cov_0.866667_g13164_i0 | PRJNA942359 | 13279 | 253 | 0.866667 | 2.19266751 | Acidobacteria bacterium Mor1 | 1660251 | Bacteria | Bacteria | 322 | 1.58e-83 | NTclustered | gi|1037405666|gb|CP011806.1| | 1660251 | g13164 | i0 | 89.683 | 94.8932806324111 | 252 | 26 | 99 | 0 | 1 | 252 | 97851 | 97600 | Acidobacteria bacterium Mor1 chromosome | blastn | 24008 | 322 | 1 | Bacteria | Acidobacteriota subdivision 22 | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium Mor1 | |||||
| 23875637 | 23875637 | PRJNA942359_P_NODE_7819_length_308_cov_4.600000_g7704_i0 | PRJNA942359 | 7819 | 308 | 4.6 | 14.168 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 363 | 1.17e-95 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g7704 | i0 | 89.547 | 272.886363636364 | 287 | 29 | 93 | 1 | 1 | 286 | 3298173 | 3298459 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 84049 | 363 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 25149182 | 25149182 | PRJNA942359_P_NODE_17460_length_246_cov_0.901734_g17345_i0 | PRJNA942359 | 17460 | 246 | 0.901734 | 2.21826564 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 287 | 5.599999999999999e-73 | NTclustered | gi|2874253744|emb|OY969603.1| | 171953 | g17345 | i0 | 88.066 | 5.7479674796748 | 243 | 27 | 98 | 2 | 2 | 243 | 6561329 | 6561570 | MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1 | blastn | 1414 | 287 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota 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);;