contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA385073" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1680545 | 1680545 | PRJNA385073_P_NODE_24042_length_298_cov_12.080000_g23880_i0 | PRJNA385073 | 24042 | 298 | 12.08 | 35.9984 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 407 | 5.1299999999999995e-109 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g23880 | i0 | 91.275 | 169.197986577181 | 298 | 26 | 100 | 0 | 1 | 298 | 3559019 | 3559316 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 50421 | 407 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 4232945 | 4232945 | PRJNA385073_P_NODE_29444_length_280_cov_3.700483_g29282_i0 | PRJNA385073 | 29444 | 280 | 3.700483 | 10.3613524 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 231 | 3.09e-56 | NTclustered | gi|112980862|gb|DQ829666.1| | 171953 | g29282 | i0 | 83.658 | 142.428571428571 | 257 | 31 | 90 | 10 | 27 | 279 | 348 | 597 | Uncultured Acidobacteria bacterium clone DON18 23S ribosomal RNA gene, partial sequence | blastn | 39880 | 231 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4232950 | 4232950 | PRJNA385073_P_NODE_29584_length_280_cov_1.623188_g29422_i0 | PRJNA385073 | 29584 | 280 | 1.623188 | 4.5449264 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g29422 | i0 | 100 | 0.321428571428571 | 30 | 0 | 22 | 0 | 103 | 132 | 3769386 | 3769357 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 90 | 56.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 5510073 | 5510073 | PRJNA385073_P_NODE_54385_length_243_cov_3.211765_g54223_i0 | PRJNA385073 | 54385 | 243 | 3.211765 | 7.80458895 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 272 | 1.5399999999999998e-68 | NTclustered | gi|2874253678|emb|OY969112.1| | 171953 | g54223 | i0 | 88.496 | 2.49794238683128 | 226 | 24 | 93 | 2 | 19 | 243 | 1196009 | 1196233 | MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 | blastn | 607 | 272 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6783632 | 6783632 | PRJNA385073_P_NODE_33926_length_268_cov_2.030769_g33764_i0 | PRJNA385073 | 33926 | 268 | 2.030769 | 5.44246092 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 132 | 3.06e-26 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g33764 | i0 | 88.288 | 59.4328358208955 | 111 | 12 | 41 | 1 | 158 | 267 | 2368111 | 2368001 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 15928 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 10610154 | 10610154 | PRJNA385073_P_NODE_56749_length_242_cov_0.911243_g56587_i0 | PRJNA385073 | 56749 | 242 | 0.911243 | 2.20520806 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 292 | 1.18e-74 | NTclustered | gi|112980852|gb|DQ829656.1| | 171953 | g56587 | i0 | 88.43 | 94.9173553719008 | 242 | 28 | 100 | 0 | 1 | 242 | 1680 | 1439 | Uncultured Acidobacteria bacterium clone DON25 23S ribosomal RNA gene, partial sequence | blastn | 22970 | 292 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13160326 | 13160326 | PRJNA385073_P_NODE_64051_length_212_cov_4.093525_g63889_i0 | PRJNA385073 | 64051 | 212 | 4.093525 | 8.678273 | Granulicella sp. 5B5 | 1617967 | Bacteria | Bacteria | 135 | 1.8e-27 | NTclustered | gi|1886125103|gb|CP046444.1| | 1617967 | g63889 | i0 | 79.793 | 1.82075471698113 | 193 | 33 | 90 | 6 | 17 | 206 | 2474640 | 2474829 | Granulicella sp. 5B5 chromosome, complete genome | blastn | 386 | 135 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella sp. 5B5 | ||
| 22082538 | 22082538 | PRJNA385073_P_NODE_42678_length_250_cov_2.276836_g42516_i0 | PRJNA385073 | 42678 | 250 | 2.276836 | 5.69209 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 167 | 7.75e-37 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g42516 | i0 | 79.283 | 1.004 | 251 | 42 | 98 | 10 | 1 | 246 | 4497155 | 4497400 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 251 | 167 | 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);;