contig_metadata
6 rows where bioproject = "PRJNA853203" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2116873 | 2116873 | PRJNA853203_P_NODE_39462_length_246_cov_0.901734_g39313_i0 | PRJNA853203 | 39462 | 246 | 0.901734 | 2.21826564 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 281 | 2.6000000000000007e-71 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g39313 | i0 | 88.017 | 132.154471544715 | 242 | 23 | 97 | 6 | 3 | 241 | 1305011 | 1305249 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 32510 | 281 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 17419788 | 17419788 | PRJNA853203_P_NODE_49574_length_230_cov_2.592357_g49425_i0 | PRJNA853203 | 49574 | 230 | 2.592357 | 5.9624211 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 220 | 5.32e-53 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g49425 | i0 | 84.615 | 3.53913043478261 | 221 | 34 | 96 | 0 | 1 | 221 | 2261274 | 2261054 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 814 | 220 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 24186151 | 24186151 | PRJNA853203_P_NODE_15119_length_277_cov_1.220588_g14970_i0 | PRJNA853203 | 15119 | 277 | 1.220588 | 3.38102876 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 182 | 3.43e-54 | NR | MCL6533319.1 | 2033014 | g14970 | i0 | 100 | 0.985559566787004 | 91 | 0 | 98.6 | 0 | 3 | 275 | 219 | 309 | MCL6533319.1 sn-glycerol-3-phosphate ABC transporter ATP-binding protein UgpC [Armatimonadota bacterium] | diamond | 273 | 182 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27094832 | 27094832 | PRJNA853203_P_NODE_16362_length_274_cov_1.472637_g16213_i0 | PRJNA853203 | 16362 | 274 | 1.472637 | 4.03502538 | PVC group | 1783257 | Bacteria | Bacteria | 92 | 2.53e-20 | NR | MDQ2800601.1 | 2033014 | g16213 | i0 | 53.8 | 14.6386861313869 | 80 | 37 | 87.6 | 0 | 256 | 17 | 163 | 242 | MDQ2800601.1 DUF2071 domain-containing protein [Armatimonadota bacterium] | diamond | 4011 | 92 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28444784 | 28444784 | PRJNA853203_P_NODE_40886_length_245_cov_1.569767_g40737_i0 | PRJNA853203 | 40886 | 245 | 1.569767 | 3.84592915 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 71.6 | 2.52e-12 | NR | MBW3637775.1 | 2033014 | g40737 | i0 | 52.6 | 0.930612244897959 | 76 | 36 | 93.1 | 0 | 16 | 243 | 90 | 165 | MBW3637775.1 hypothetical protein [Armatimonadota bacterium] | diamond | 228 | 71.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29612524 | 29612524 | PRJNA853203_P_NODE_32830_length_250_cov_0.881356_g32681_i0 | PRJNA853203 | 32830 | 250 | 0.881356 | 2.20339 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 97.8 | 4.91e-23 | NR | MCE2767070.1 | 2682144 | g32681 | i0 | 69.2 | 0.78 | 65 | 20 | 78 | 0 | 199 | 5 | 1 | 65 | MCE2767070.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 195 | 97.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae 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);;