contig_metadata
23 rows where bioproject = "PRJNA1233465", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25541833 | 25541833 | PRJNA1233465d_S_NODE_127833_length_166_cov_1.273504_g126722_i0 | PRJNA1233465 | 127833 | 166 | 1.273504 | 2.11401664 | uncultured Armatimonadaceae bacterium | 1579981 | Bacteria | Bacteria | 302 | 1.2500000000000001e-77 | NTclustered | gi|1962354638|emb|LR605213.1| | 1579981 | g126722 | i0 | 99.401 | 100.518072289157 | 167 | 0 | 100 | 1 | 1 | 166 | 235 | 69 | uncultured Armatimonadaceae bacterium partial 16S rRNA gene | blastn | 16686 | 302 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | uncultured Armatimonadaceae bacterium | |||
| 25692264 | 25692264 | PRJNA1233465f_S_NODE_215474_length_172_cov_2.349593_g213194_i0 | PRJNA1233465 | 215474 | 172 | 2.349593 | 4.04129996 | uncultured Armatimonadaceae bacterium | 1579981 | Bacteria | Bacteria | 313 | 5.989999999999998e-81 | NTclustered | gi|1962354638|emb|LR605213.1| | 1579981 | g213194 | i0 | 99.422 | 100.843023255814 | 173 | 0 | 100 | 1 | 1 | 172 | 76 | 248 | uncultured Armatimonadaceae bacterium partial 16S rRNA gene | blastn | 17345 | 313 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | uncultured Armatimonadaceae bacterium | |||
| 26163708 | 26163708 | PRJNA1233465a_S_NODE_77845_length_252_cov_1.152709_g76571_i0 | PRJNA1233465 | 77845 | 252 | 1.152709 | 2.90482668 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 158 | 8.39e-48 | NR | HTQ09601.1 | 2682144 | g76571 | i0 | 79.8 | 4 | 84 | 17 | 100 | 0 | 252 | 1 | 30 | 113 | HTQ09601.1 peptide-methionine (R)-S-oxide reductase MsrB [Fimbriimonadaceae bacterium] | diamond | 1008 | 158 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32934064 | 32934064 | PRJNA1233465f_S_NODE_228505_length_168_cov_1.554622_g226225_i0 | PRJNA1233465 | 228505 | 168 | 1.554622 | 2.61176496 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 56.2 | 1.16e-7 | NR | HTQ09178.1 | 2682144 | g226225 | i0 | 75.8 | 2.25 | 33 | 8 | 58.9 | 0 | 164 | 66 | 77 | 109 | HTQ09178.1 response regulator transcription factor [Fimbriimonadaceae bacterium] | diamond | 378 | 56.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32950506 | 32950506 | PRJNA1233465e_S_NODE_153290_length_164_cov_1.243478_g151980_i0 | PRJNA1233465 | 153290 | 164 | 1.243478 | 2.03930392 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 55.1 | 4.97e-8 | NR | NLH99377.1 | 2282151 | g151980 | i0 | 51 | 0.932926829268293 | 51 | 24 | 91.5 | 1 | 162 | 13 | 32 | 82 | NLH99377.1 antibiotic biosynthesis monooxygenase [Chthonomonadales bacterium] | diamond | 153 | 55.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 32950673 | 32950673 | PRJNA1233465e_S_NODE_42370_length_276_cov_1.572687_g41060_i0 | PRJNA1233465 | 42370 | 276 | 1.572687 | 4.34061612 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 78.2 | 1.73e-14 | NR | MCS7235602.1 | 2033014 | g41060 | i0 | 45.7 | 2 | 92 | 49 | 98.9 | 1 | 2 | 274 | 258 | 349 | MCS7235602.1 amidase [Armatimonadota bacterium] | diamond | 552 | 78.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32984732 | 32984732 | PRJNA1233465e_S_NODE_22635_length_362_cov_2.223642_g21325_i0 | PRJNA1233465 | 22635 | 362 | 2.223642 | 8.04958404 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 92 | 1.75e-19 | NR | HSV73416.1 | 2282151 | g21325 | i0 | 69.6 | 0.464088397790055 | 56 | 17 | 46.4 | 0 | 15 | 182 | 257 | 312 | HSV73416.1 GDP-L-fucose synthase [Chthonomonadales bacterium] | diamond | 168 | 92 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 33009383 | 33009383 | PRJNA1233465f_S_NODE_154371_length_198_cov_1.583893_g152091_i0 | PRJNA1233465 | 154371 | 198 | 1.583893 | 3.13610814 | PVC group | 1783257 | Bacteria | Bacteria | 77.8 | 9.25e-15 | NR | MBU0606703.1 | 2033014 | g152091 | i0 | 60.3 | 8.45454545454546 | 58 | 23 | 87.9 | 0 | 198 | 25 | 371 | 428 | MBU0606703.1 hypothetical protein [Armatimonadota bacterium] | diamond | 1674 | 77.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33019378 | 33019378 | PRJNA1233465f_S_NODE_19140_length_474_cov_6.449412_g16939_i0 | PRJNA1233465 | 19140 | 474 | 6.449412 | 30.57021288 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 98.2 | 2e-23 | NR | HWD40172.1 | 1936159 | g16939 | i0 | 60.3 | 0.430379746835443 | 68 | 27 | 43 | 0 | 1 | 204 | 26 | 93 | HWD40172.1 Imm74 family immunity protein [Fimbriimonas sp.] | diamond | 204 | 98.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 33026316 | 33026316 | PRJNA1233465d_S_NODE_23236_length_338_cov_1.692042_g22125_i0 | PRJNA1233465 | 23236 | 338 | 1.692042 | 5.71910196 | Bacteria | 2 | Bacteria | Bacteria | 117 | 8.359999999999999e-31 | NR | MBV6503421.1 | 2682145 | g22125 | i0 | 56.5 | 1.63313609467456 | 92 | 40 | 81.7 | 0 | 2 | 277 | 74 | 165 | MBV6503421.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 552 | 117 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 33077663 | 33077663 | PRJNA1233465f_S_NODE_49117_length_323_cov_2.412409_g46837_i0 | PRJNA1233465 | 49117 | 323 | 2.412409 | 7.79208107 | PVC group | 1783257 | Bacteria | Bacteria | 135 | 2.09e-36 | NR | WP_044949074.1 | 454171 | g46837 | i0 | 65.7 | 5.48916408668731 | 99 | 34 | 92 | 0 | 321 | 25 | 33 | 131 | WP_044949074.1 SDR family oxidoreductase [Chthonomonas calidirosea] | diamond | 1773 | 136 | 0.992647058823529 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 33094245 | 33094245 | PRJNA1233465a_S_NODE_215070_length_168_cov_1.285714_g213796_i0 | PRJNA1233465 | 215070 | 168 | 1.285714 | 2.15999952 | Bacteria | 2 | Bacteria | Bacteria | 87 | 7.92e-19 | NR | WP_044949074.1 | 454171 | g213796 | i0 | 75.9 | 4.85714285714286 | 54 | 13 | 96.4 | 0 | 5 | 166 | 52 | 105 | WP_044949074.1 SDR family oxidoreductase [Chthonomonas calidirosea] | diamond | 816 | 87 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 33102363 | 33102363 | PRJNA1233465a_S_NODE_207174_length_171_cov_0.852459_g205900_i0 | PRJNA1233465 | 207174 | 171 | 0.852459 | 1.45770489 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 57.8 | 6.52e-8 | NR | MCC7229608.1 | 2682144 | g205900 | i0 | 73.5 | 2.2280701754386 | 34 | 9 | 59.6 | 0 | 104 | 3 | 259 | 292 | MCC7229608.1 aldo/keto reductase [Fimbriimonadaceae bacterium] | diamond | 381 | 57.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 33137610 | 33137610 | PRJNA1233465d_S_NODE_14591_length_411_cov_4.209945_g13481_i0 | PRJNA1233465 | 14591 | 411 | 4.209945 | 17.30287395 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 76.3 | 3.94e-15 | NR | HWD40172.1 | 1936159 | g13481 | i0 | 53.4 | 0.423357664233577 | 58 | 27 | 42.3 | 0 | 6 | 179 | 36 | 93 | HWD40172.1 Imm74 family immunity protein [Fimbriimonas sp.] | diamond | 174 | 76.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 33137730 | 33137730 | PRJNA1233465d_S_NODE_38711_length_271_cov_1.756757_g37600_i0 | PRJNA1233465 | 38711 | 271 | 1.756757 | 4.76081147 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 90.1 | 9.23e-19 | NR | MCS7235602.1 | 2033014 | g37600 | i0 | 48.9 | 0.996309963099631 | 90 | 46 | 99.6 | 0 | 271 | 2 | 295 | 384 | MCS7235602.1 amidase [Armatimonadota bacterium] | diamond | 270 | 90.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33137911 | 33137911 | PRJNA1233465d_S_NODE_76311_length_204_cov_1.025806_g75200_i0 | PRJNA1233465 | 76311 | 204 | 1.025806 | 2.09264424 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 77 | 1.63e-16 | NR | HWD40172.1 | 1936159 | g75200 | i0 | 81.4 | 0.632352941176471 | 43 | 8 | 63.2 | 0 | 131 | 3 | 1 | 43 | HWD40172.1 Imm74 family immunity protein [Fimbriimonas sp.] | diamond | 129 | 77 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 33138935 | 33138935 | PRJNA1233465f_S_NODE_229671_length_168_cov_1.084034_g227391_i0 | PRJNA1233465 | 229671 | 168 | 1.084034 | 1.82117712 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 92.8 | 1.07e-21 | NR | HCU35405.1 | 2033014 | g227391 | i0 | 67.9 | 3.78571428571429 | 53 | 17 | 94.6 | 0 | 8 | 166 | 138 | 190 | HCU35405.1 response regulator [Armatimonadota bacterium] | diamond | 636 | 92.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33139149 | 33139149 | PRJNA1233465f_S_NODE_49447_length_322_cov_2.820513_g47167_i0 | PRJNA1233465 | 49447 | 322 | 2.820513 | 9.08205186 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 63.9 | 1.19e-10 | NR | NLH99377.1 | 2282151 | g47167 | i0 | 46.4 | 1.29503105590062 | 69 | 36 | 63.4 | 1 | 1 | 204 | 14 | 82 | NLH99377.1 antibiotic biosynthesis monooxygenase [Chthonomonadales bacterium] | diamond | 417 | 63.9 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 33153273 | 33153273 | PRJNA1233465a_S_NODE_112624_length_218_cov_61025.603550_g111350_i0 | PRJNA1233465 | 112624 | 218 | 61025.60355 | 133035.815739 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 42.7 | 0.026 | NR | MCW5939630.1 | 2682144 | g111350 | i0 | 44.2 | 0.591743119266055 | 43 | 21 | 59.2 | 1 | 41 | 169 | 222 | 261 | MCW5939630.1 succinylglutamate desuccinylase/aspartoacylase family protein [Fimbriimonadaceae bacterium] | diamond | 129 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 33153307 | 33153307 | PRJNA1233465a_S_NODE_125160_length_210_cov_1.248447_g123886_i0 | PRJNA1233465 | 125160 | 210 | 1.248447 | 2.6217387 | Armatimonadetes bacterium RBG_16_67_12 | 1797288 | Bacteria | Bacteria | 42 | 0.0411 | NR | OFX29318.1 | 1797288 | g123886 | i0 | 37 | 0.771428571428571 | 54 | 29 | 70 | 2 | 203 | 57 | 96 | 149 | OFX29318.1 MAG: hypothetical protein A2Z07_09005 [Armatimonadetes bacterium RBG_16_67_12] | diamond | 162 | 42 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium RBG_16_67_12 | ||||||
| 33153788 | 33153788 | PRJNA1233465a_S_NODE_82224_length_247_cov_1.232323_g80950_i0 | PRJNA1233465 | 82224 | 247 | 1.232323 | 3.04383781 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 122 | 3.84e-32 | NR | MFO8082381.1 | 2033014 | g80950 | i0 | 83.6 | 0.88663967611336 | 73 | 12 | 88.7 | 0 | 232 | 14 | 201 | 273 | MFO8082381.1 GDP-mannose 4,6-dehydratase [Armatimonadota bacterium] | diamond | 219 | 122 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33155176 | 33155176 | PRJNA1233465e_S_NODE_21208_length_372_cov_1.408669_g19899_i0 | PRJNA1233465 | 21208 | 372 | 1.408669 | 5.24024868 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 100 | 1.28e-21 | NR | HZP81223.1 | 2739509 | g19899 | i0 | 44.1 | 3.90322580645161 | 118 | 65 | 95.2 | 1 | 371 | 18 | 319 | 435 | HZP81223.1 choice-of-anchor tandem repeat GloVer-containing protein [Chthonomonadaceae bacterium] | diamond | 1452 | 100 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 33155384 | 33155384 | PRJNA1233465e_S_NODE_6560_length_596_cov_2.738574_g5425_i0 | PRJNA1233465 | 6560 | 596 | 2.738574 | 16.32190104 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 97.1 | 1.92e-22 | NR | HWD40172.1 | 1936159 | g5425 | i0 | 59.7 | 0.337248322147651 | 67 | 27 | 33.7 | 0 | 594 | 394 | 27 | 93 | HWD40172.1 Imm74 family immunity protein [Fimbriimonas sp.] | diamond | 201 | 97.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. |
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);;