contig_metadata
20 rows where bioproject = "PRJEB66218", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132358 | 132358 | PRJEB66218_P_NODE_208621_length_209_cov_0.878378_g206191_i0 | PRJEB66218 | 208621 | 209 | 0.878378 | 1.83581002 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 176 | 1.04e-39 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g206191 | i0 | 81.991 | 222.66985645933 | 211 | 34 | 100 | 4 | 1 | 209 | 1304067 | 1304275 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 46538 | 176 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 133843 | 133843 | PRJEB66218_P_NODE_57921_length_435_cov_1.529412_g55501_i0 | PRJEB66218 | 57921 | 435 | 1.529412 | 6.6529422 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 96.7 | 3.3700000000000003e-22 | NR | MDH7482967.1 | 2033014 | g55501 | i0 | 67.6 | 1.87586206896552 | 68 | 22 | 46.9 | 0 | 232 | 435 | 1 | 68 | MDH7482967.1 GNAT family N-acetyltransferase [Armatimonadota bacterium] | diamond | 816 | 96.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 3544627 | 3544627 | PRJEB66218_P_NODE_121183_length_273_cov_1.575472_g118754_i0 | PRJEB66218 | 121183 | 273 | 1.575472 | 4.30103856 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 263 | 1.06e-65 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g118754 | i0 | 84.42 | 3.27106227106227 | 276 | 34 | 100 | 8 | 1 | 273 | 28285 | 28016 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 893 | 263 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 3545288 | 3545288 | PRJEB66218_P_NODE_245483_length_194_cov_6.293233_g243051_i0 | PRJEB66218 | 245483 | 194 | 6.293233 | 12.20887202 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 233 | 5.57e-57 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g243051 | i0 | 88.542 | 91.1288659793814 | 192 | 22 | 99 | 0 | 1 | 192 | 29580 | 29771 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 17679 | 233 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 8648341 | 8648341 | PRJEB66218_P_NODE_86567_length_336_cov_1.236364_g84140_i0 | PRJEB66218 | 86567 | 336 | 1.236364 | 4.15418304 | Chthonomonas | 1077265 | Bacteria | Bacteria | 132 | 3.96e-26 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g84140 | i0 | 80.838 | 93.9464285714286 | 167 | 32 | 50 | 0 | 165 | 331 | 1447 | 1281 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 31566 | 132 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 9057941 | 9057941 | PRJEB66218_P_NODE_115328_length_281_cov_2.190909_g112899_i0 | PRJEB66218 | 115328 | 281 | 2.190909 | 6.15645429 | Armatimonadetes bacterium Uphvl-Ar2 | 2004468 | Bacteria | Bacteria | 185 | 2.4499999999999994e-42 | NTclustered | gi|1199101103|gb|CP021424.1| | 2004468 | g112899 | i0 | 81.579 | 51.0711743772242 | 228 | 38 | 80 | 3 | 48 | 273 | 742400 | 742625 | Armatimonadetes bacterium Uphvl-Ar2 genome | blastn | 14351 | 185 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar2 | ||||||
| 15022105 | 15022105 | PRJEB66218_P_NODE_141352_length_249_cov_4.010638_g138923_i0 | PRJEB66218 | 141352 | 249 | 4.010638 | 9.98648862 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 394 | 3.25e-105 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g138923 | i0 | 95.181 | 842.775100401606 | 249 | 12 | 100 | 0 | 1 | 249 | 26830 | 27078 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 209851 | 394 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 15434751 | 15434751 | PRJEB66218_P_NODE_201993_length_210_cov_0.872483_g199563_i0 | PRJEB66218 | 201993 | 210 | 0.872483 | 1.8322143 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 82.4 | 2.35e-11 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g199563 | i0 | 90.323 | 0.638095238095238 | 62 | 6 | 30 | 0 | 119 | 180 | 4625113 | 4625174 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 134 | 82.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 15434919 | 15434919 | PRJEB66218_P_NODE_213373_length_208_cov_0.884354_g210943_i0 | PRJEB66218 | 213373 | 208 | 0.884354 | 1.83945632 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 147 | 8.13e-43 | NR | MFN3690895.1 | 2682145 | g210943 | i0 | 100 | 0.980769230769231 | 68 | 0 | 98.1 | 0 | 206 | 3 | 3 | 70 | MFN3690895.1 cysteine hydrolase family protein [Fimbriimonadales bacterium] | diamond | 204 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 16711527 | 16711527 | PRJEB66218_P_NODE_99874_length_307_cov_1.414634_g97446_i0 | PRJEB66218 | 99874 | 307 | 1.414634 | 4.34292638 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 173 | 5.32e-50 | NR | MBI3926320.1 | 2033014 | g97446 | i0 | 85.1 | 3.94788273615635 | 101 | 15 | 98.7 | 0 | 305 | 3 | 268 | 368 | MBI3926320.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Armatimonadota bacterium] | diamond | 1212 | 173 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 17983942 | 17983942 | PRJEB66218_P_NODE_208375_length_209_cov_0.878378_g205945_i0 | PRJEB66218 | 208375 | 209 | 0.878378 | 1.83581002 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 165 | 2.26e-36 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g205945 | i0 | 81.395 | 259.311004784689 | 215 | 29 | 100 | 9 | 1 | 209 | 1304912 | 1304703 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 54196 | 165 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 18845899 | 18845899 | PRJEB66218_P_NODE_146495_length_244_cov_2.737705_g144066_i0 | PRJEB66218 | 146495 | 244 | 2.737705 | 6.6800002 | Bacillati | 1783272 | Bacteria | Bacteria | 191 | 4.47e-44 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g144066 | i0 | 86.034 | 892.745901639344 | 179 | 24 | 73 | 1 | 67 | 244 | 1304127 | 1304305 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 217830 | 191 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 26717071 | 26717071 | PRJEB66218_P_NODE_222841_length_206_cov_0.896552_g220411_i0 | PRJEB66218 | 222841 | 206 | 0.896552 | 1.84689712 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 145 | 3.52e-40 | NR | MCL6531677.1 | 2033014 | g220411 | i0 | 100 | 0.990291262135922 | 68 | 0 | 99 | 0 | 205 | 2 | 225 | 292 | MCL6531677.1 lipid-A-disaccharide synthase [Armatimonadota bacterium] | diamond | 204 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26812562 | 26812562 | PRJEB66218_P_NODE_221_length_8282_cov_10.627418_g161_i0 | PRJEB66218 | 221 | 8282 | 10.627418 | 880.16275876 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 7.79e-33 | NR | NOG38506.1 | 2033014 | g161 | i0 | 42.7 | 0.0670127988408597 | 185 | 95 | 6.5 | 4 | 56 | 592 | 17 | 196 | NOG38506.1 hypothetical protein [Armatimonadota bacterium] | diamond | 555 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26970617 | 26970617 | PRJEB66218_P_NODE_198582_length_211_cov_0.866667_g196152_i0 | PRJEB66218 | 198582 | 211 | 0.866667 | 1.82866737 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 72.4 | 6.34e-13 | NR | WP_309718863.1 | 1872638 | g196152 | i0 | 52.2 | 2.94312796208531 | 69 | 31 | 98.1 | 2 | 1 | 207 | 162 | 228 | WP_309718863.1 RNA ligase (ATP) [Armatimonas sp.] | diamond | 621 | 72.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 30476525 | 30476525 | PRJEB66218_P_NODE_207233_length_209_cov_0.878378_g204803_i0 | PRJEB66218 | 207233 | 209 | 0.878378 | 1.83581002 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.1 | 8.81e-14 | NR | MCC7439593.1 | 2033014 | g204803 | i0 | 64.5 | 0.889952153110048 | 62 | 21 | 87.6 | 1 | 188 | 6 | 21 | 82 | MCC7439593.1 FAD-dependent monooxygenase [Armatimonadota bacterium] | diamond | 186 | 75.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30539488 | 30539488 | PRJEB66218_P_NODE_145133_length_246_cov_1.135135_g142704_i0 | PRJEB66218 | 145133 | 246 | 1.135135 | 2.7924321 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 43.1 | 0.0276 | NR | HET6645382.1 | 2682145 | g142704 | i0 | 35.6 | 0.719512195121951 | 59 | 31 | 63.4 | 1 | 209 | 54 | 14 | 72 | HET6645382.1 phospholipase D-like domain-containing protein [Fimbriimonadales bacterium] | diamond | 177 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 30792257 | 30792257 | PRJEB66218_P_NODE_153054_length_239_cov_1.674157_g150625_i0 | PRJEB66218 | 153054 | 239 | 1.674157 | 4.00123523 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 124 | 2.9699999999999997e-35 | NR | MFN3690896.1 | 2682145 | g150625 | i0 | 96.8 | 0.790794979079498 | 63 | 2 | 79.1 | 0 | 233 | 45 | 1 | 63 | MFN3690896.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 189 | 124 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31670324 | 31670324 | PRJEB66218_P_NODE_135297_length_256_cov_1.333333_g132868_i0 | PRJEB66218 | 135297 | 256 | 1.333333 | 3.41333248 | Bacteria | 2 | Bacteria | Bacteria | 53.9 | 4e-6 | NR | GDX39766.1 | 2033014 | g132868 | i0 | 43 | 3.515625 | 79 | 38 | 91.4 | 3 | 5 | 238 | 63 | 135 | GDX39766.1 nucleotide pyrophosphatase [Armatimonadota bacterium] | diamond | 900 | 53.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32682023 | 32682023 | PRJEB66218_P_NODE_80360_length_352_cov_2.006873_g77934_i0 | PRJEB66218 | 80360 | 352 | 2.006873 | 7.06419296 | PVC group | 1783257 | Bacteria | Bacteria | 45.8 | 0.0111 | NR | HEY3378350.1 | 2033014 | g77934 | i0 | 36.7 | 3.40909090909091 | 98 | 58 | 81.8 | 4 | 37 | 324 | 999 | 1094 | HEY3378350.1 fibronectin type III domain-containing protein [Armatimonadota bacterium] | diamond | 1200 | 46.2 | 0.991341991341991 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;