contig_metadata
7 rows where analysis = "blastn", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Wolfeibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1887422 | 1887422 | PRJNA641707_P_NODE_119802_length_245_cov_8.122449_g117139_i0 | PRJNA641707 | 119802 | 245 | 8.122449 | 19.90000005 | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | 1619007 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g117139 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 5 | 32 | 822396 | 822369 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | ||||||
| 4429116 | 4429116 | PRJNA630162_P_NODE_115704_length_176_cov_4.283465_g114181_i0 | PRJNA630162 | 115704 | 176 | 4.283465 | 7.5388984 | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | 1619007 | Bacteria | Bacteria | 169 | 1.4099999999999998e-37 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g114181 | i0 | 85.89 | 56.3977272727273 | 163 | 17 | 92 | 6 | 1 | 162 | 820764 | 820921 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 9926 | 169 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | ||||||
| 5229002 | 5229002 | PRJEB64798_P_NODE_106845_length_211_cov_3.061728_g105079_i0 | PRJEB64798 | 106845 | 211 | 3.061728 | 6.46024608 | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | 1619007 | Bacteria | Bacteria | 241 | 3.69e-59 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g105079 | i0 | 87.56 | 0.990521327014218 | 209 | 24 | 99 | 2 | 1 | 208 | 820087 | 820294 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 209 | 241 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | ||||||
| 7388987 | 7388987 | PRJNA1054617_S_NODE_2846_length_304_cov_3.130268_g2758_i0 | PRJNA1054617 | 2846 | 304 | 3.130268 | 9.51601472 | Bacteria | 2 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g2758 | i0 | 97.059 | 15.6743421052632 | 34 | 0 | 11 | 1 | 269 | 301 | 822101 | 822068 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 4765 | 56.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | ||||||
| 10181454 | 10181454 | PRJNA928559_P_NODE_167588_length_270_cov_1.964467_g166019_i0 | PRJNA928559 | 167588 | 270 | 1.964467 | 5.3040609 | Bacteria | 2 | Bacteria | Bacteria | 252 | 2.27e-62 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g166019 | i0 | 86.784 | 43.2888888888889 | 227 | 28 | 84 | 2 | 29 | 254 | 820102 | 820327 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 11688 | 252 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | ||||||
| 24656923 | 24656923 | PRJNA436017_P_NODE_1220_length_850_cov_7.489545_g1040_i0 | PRJNA436017 | 1220 | 850 | 7.489545 | 63.6611325 | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | 1619007 | Bacteria | Bacteria | 678 | 0 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g1040 | i0 | 82.28 | 283.841176470588 | 807 | 122 | 94 | 15 | 50 | 850 | 819699 | 820490 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 241265 | 678 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | ||||||
| 24696246 | 24696246 | PRJNA493827_P_NODE_135640_length_293_cov_1.568182_g133442_i0 | PRJNA493827 | 135640 | 293 | 1.568182 | 4.59477326 | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 | 1619007 | Bacteria | Bacteria | 231 | 3.25e-56 | NTclustered | gi|837348553|gb|CP011209.1| | 1619007 | g133442 | i0 | 83.27 | 103.529010238908 | 263 | 32 | 87 | 11 | 34 | 289 | 822371 | 822628 | MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome | blastn | 30334 | 231 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 |
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);;