contig_metadata
27 rows where bioproject = "PRJNA399711", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25836167 | 25836167 | PRJNA399711_S_NODE_54091_length_193_cov_6.121795_g53949_i0 | PRJNA399711 | 54091 | 193 | 6.121795 | 11.81506435 | Fimbriimonas ginsengisoli Gsoil 348 | 661478 | Bacteria | Bacteria | 91.6 | 3.53e-14 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g53949 | i0 | 86.047 | 2.49740932642487 | 86 | 11 | 44 | 1 | 61 | 145 | 2888728 | 2888813 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 482 | 91.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26106308 | 26106308 | PRJNA399711_S_NODE_104941_length_152_cov_3.513043_g104799_i0 | PRJNA399711 | 104941 | 152 | 3.513043 | 5.33982536 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 114 | 3.97e-28 | NR | MBC8102058.1 | 2033014 | g104799 | i0 | 98 | 0.986842105263158 | 50 | 1 | 98.7 | 0 | 1 | 150 | 225 | 274 | MBC8102058.1 cysteine--tRNA ligase [Armatimonadota bacterium] | diamond | 150 | 114 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32951772 | 32951772 | PRJNA399711_S_NODE_108786_length_150_cov_4.345133_g108644_i0 | PRJNA399711 | 108786 | 150 | 4.345133 | 6.5176995 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 96.7 | 1.04e-21 | NR | MBC8104835.1 | 2033014 | g108644 | i0 | 85.7 | 1.94 | 49 | 7 | 98 | 0 | 2 | 148 | 505 | 553 | MBC8104835.1 hypothetical protein [Armatimonadota bacterium] | diamond | 291 | 96.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32952068 | 32952068 | PRJNA399711_S_NODE_49266_length_200_cov_3.306748_g49124_i0 | PRJNA399711 | 49266 | 200 | 3.306748 | 6.613496 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 59.3 | 1.55e-8 | NR | MCD6351159.1 | 2033014 | g49124 | i0 | 57.8 | 0.675 | 45 | 19 | 67.5 | 0 | 189 | 55 | 11 | 55 | MCD6351159.1 hypothetical protein [Armatimonadota bacterium] | diamond | 135 | 59.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32952092 | 32952092 | PRJNA399711_S_NODE_52074_length_196_cov_3.352201_g51932_i0 | PRJNA399711 | 52074 | 196 | 3.352201 | 6.57031396 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 80.5 | 4.07e-16 | NR | MBC7807659.1 | 2033014 | g51932 | i0 | 66.7 | 1.85204081632653 | 60 | 19 | 90.3 | 1 | 191 | 15 | 106 | 165 | MBC7807659.1 cytidine deaminase [Armatimonadota bacterium] | diamond | 363 | 80.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32958374 | 32958374 | PRJNA399711_S_NODE_101162_length_154_cov_3.905983_g101020_i0 | PRJNA399711 | 101162 | 154 | 3.905983 | 6.01521382 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.00192 | NR | MBW3637136.1 | 2033014 | g101020 | i0 | 44.9 | 1.71428571428571 | 49 | 27 | 95.5 | 0 | 4 | 150 | 22 | 70 | MBW3637136.1 UPF0182 family protein [Armatimonadota bacterium] | diamond | 264 | 43.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32969185 | 32969185 | PRJNA399711_S_NODE_39634_length_216_cov_11.905028_g39492_i0 | PRJNA399711 | 39634 | 216 | 11.905028 | 25.71486048 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 85.1 | 2.95e-17 | NR | MES2465338.1 | 2033014 | g39492 | i0 | 63.4 | 0.986111111111111 | 71 | 26 | 98.6 | 0 | 215 | 3 | 157 | 227 | MES2465338.1 sigma-70 family RNA polymerase sigma factor [Armatimonadota bacterium] | diamond | 213 | 85.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32969390 | 32969390 | PRJNA399711_S_NODE_72602_length_174_cov_1.948905_g72460_i0 | PRJNA399711 | 72602 | 174 | 1.948905 | 3.3910947 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.1 | 1.72e-10 | NR | MBC8139937.1 | 2033014 | g72460 | i0 | 51.9 | 1.87931034482759 | 54 | 22 | 93.1 | 1 | 164 | 3 | 143 | 192 | MBC8139937.1 cellulase family glycosylhydrolase [Armatimonadota bacterium] | diamond | 327 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32969472 | 32969472 | PRJNA399711_S_NODE_87050_length_163_cov_1.761905_g86908_i0 | PRJNA399711 | 87050 | 163 | 1.761905 | 2.87190515 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 61.2 | 3.78e-9 | NR | MES2463209.1 | 2033014 | g86908 | i0 | 84.8 | 0.607361963190184 | 33 | 5 | 60.7 | 0 | 1 | 99 | 10 | 42 | MES2463209.1 TonB-dependent receptor [Armatimonadota bacterium] | diamond | 99 | 61.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32969483 | 32969483 | PRJNA399711_S_NODE_88458_length_162_cov_1.864000_g88316_i0 | PRJNA399711 | 88458 | 162 | 1.864 | 3.01968 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 87.4 | 1.45e-18 | NR | MES1227149.1 | 2033014 | g88316 | i0 | 83 | 0.981481481481482 | 53 | 9 | 98.1 | 0 | 161 | 3 | 40 | 92 | MES1227149.1 IS3 family transposase [Armatimonadota bacterium] | diamond | 159 | 87.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32986207 | 32986207 | PRJNA399711_S_NODE_42811_length_210_cov_12.184971_g42669_i0 | PRJNA399711 | 42811 | 210 | 12.184971000000001 | 25.5884391 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 114 | 3.3600000000000003e-29 | NR | MES2464747.1 | 2033014 | g42669 | i0 | 74.3 | 2 | 70 | 18 | 100 | 0 | 210 | 1 | 160 | 229 | MES2464747.1 protein phosphatase 2C domain-containing protein [Armatimonadota bacterium] | diamond | 420 | 114 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32986244 | 32986244 | PRJNA399711_S_NODE_48467_length_201_cov_4.682927_g48325_i0 | PRJNA399711 | 48467 | 201 | 4.682927 | 9.41268327 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 87 | 5.25e-18 | NR | MES2462485.1 | 2033014 | g48325 | i0 | 77.2 | 0.850746268656716 | 57 | 13 | 85.1 | 0 | 200 | 30 | 810 | 866 | MES2462485.1 DNA gyrase subunit A [Armatimonadota bacterium] | diamond | 171 | 87 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33003099 | 33003099 | PRJNA399711_S_NODE_34275_length_228_cov_0.989529_g34133_i0 | PRJNA399711 | 34275 | 228 | 0.989529 | 2.25612612 | Capsulimonas sp. | 2494211 | Bacteria | Bacteria | 53.1 | 4.21e-6 | NR | MCW3058866.1 | 2494211 | g34133 | i0 | 36.5 | 0.973684210526316 | 74 | 46 | 97.4 | 1 | 5 | 226 | 28 | 100 | MCW3058866.1 hypothetical protein [Capsulimonas sp.] | diamond | 222 | 53.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas sp. | ||
| 33019950 | 33019950 | PRJNA399711_S_NODE_109388_length_150_cov_2.522124_g109246_i0 | PRJNA399711 | 109388 | 150 | 2.522124 | 3.783186 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.1 | 1.64e-6 | NR | MBC7807358.1 | 2033014 | g109246 | i0 | 59.1 | 0.88 | 44 | 18 | 88 | 0 | 147 | 16 | 190 | 233 | MBC7807358.1 hypothetical protein [Armatimonadota bacterium] | diamond | 132 | 53.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33020460 | 33020460 | PRJNA399711_S_NODE_89012_length_161_cov_7.008065_g88870_i0 | PRJNA399711 | 89012 | 161 | 7.008065 | 11.28298465 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 97.1 | 1.41e-24 | NR | MES2460440.1 | 2033014 | g88870 | i0 | 97.9 | 0.894409937888199 | 48 | 1 | 89.4 | 0 | 159 | 16 | 55 | 102 | MES2460440.1 50S ribosomal protein L21 [Armatimonadota bacterium] | diamond | 144 | 97.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33026660 | 33026660 | PRJNA399711_S_NODE_102196_length_154_cov_1.273504_g102054_i0 | PRJNA399711 | 102196 | 154 | 1.273504 | 1.96119616 | Bacillati | 1783272 | Bacteria | Bacteria | 83.6 | 1.89e-17 | NR | MBV9851412.1 | 2033014 | g102054 | i0 | 77.1 | 1.87012987012987 | 48 | 11 | 93.5 | 0 | 11 | 154 | 160 | 207 | MBV9851412.1 Gfo/Idh/MocA family oxidoreductase [Armatimonadota bacterium] | diamond | 288 | 84.3 | 0.991696322657177 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33071011 | 33071011 | PRJNA399711_S_NODE_10525_length_340_cov_4.864686_g10383_i0 | PRJNA399711 | 10525 | 340 | 4.864686 | 16.5399324 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 74.7 | 7.1e-13 | NR | MCC7437351.1 | 2033014 | g10383 | i0 | 38.7 | 0.979411764705882 | 111 | 67 | 97.1 | 1 | 335 | 6 | 875 | 985 | MCC7437351.1 DNA polymerase III subunit alpha [Armatimonadota bacterium] | diamond | 333 | 74.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33071406 | 33071406 | PRJNA399711_S_NODE_61037_length_185_cov_3.810811_g60895_i0 | PRJNA399711 | 61037 | 185 | 3.810811 | 7.05000035 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.1 | 2.67e-6 | NR | MBC8104362.1 | 2033014 | g60895 | i0 | 57.6 | 0.956756756756757 | 59 | 15 | 82.7 | 2 | 1 | 153 | 4 | 60 | MBC8104362.1 hypothetical protein [Armatimonadota bacterium] | diamond | 177 | 53.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33071599 | 33071599 | PRJNA399711_S_NODE_94405_length_158_cov_3.223140_g94263_i0 | PRJNA399711 | 94405 | 158 | 3.22314 | 5.0925612 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 103 | 3.0799999999999994e-24 | NR | MBC8103165.1 | 2033014 | g94263 | i0 | 90.4 | 0.987341772151899 | 52 | 5 | 98.7 | 0 | 157 | 2 | 354 | 405 | MBC8103165.1 hypothetical protein [Armatimonadota bacterium] | diamond | 156 | 103 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33105410 | 33105410 | PRJNA399711_S_NODE_25774_length_252_cov_3.437209_g25632_i0 | PRJNA399711 | 25774 | 252 | 3.437209 | 8.66176668 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 137 | 1.22e-35 | NR | MBC7809042.1 | 2033014 | g25632 | i0 | 78.6 | 1 | 84 | 18 | 100 | 0 | 252 | 1 | 208 | 291 | MBC7809042.1 polyribonucleotide nucleotidyltransferase [Armatimonadota bacterium] | diamond | 252 | 137 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33105519 | 33105519 | PRJNA399711_S_NODE_41494_length_213_cov_2.636364_g41352_i0 | PRJNA399711 | 41494 | 213 | 2.636364 | 5.61545532 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 99 | 8.13e-23 | NR | MES2459244.1 | 2033014 | g41352 | i0 | 71.2 | 0.929577464788732 | 66 | 19 | 93 | 0 | 14 | 211 | 214 | 279 | MES2459244.1 relaxase/mobilization nuclease domain-containing protein [Armatimonadota bacterium] | diamond | 198 | 99 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33105767 | 33105767 | PRJNA399711_S_NODE_82742_length_166_cov_2.232558_g82600_i0 | PRJNA399711 | 82742 | 166 | 2.232558 | 3.70604628 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 113 | 1.11e-27 | NR | MES2459559.1 | 2033014 | g82600 | i0 | 100 | 1.98795180722892 | 55 | 0 | 99.4 | 0 | 2 | 166 | 303 | 357 | MES2459559.1 DUF87 domain-containing protein [Armatimonadota bacterium] | diamond | 330 | 113 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33156570 | 33156570 | PRJNA399711_S_NODE_43552_length_209_cov_5.476744_g43410_i0 | PRJNA399711 | 43552 | 209 | 5.476744 | 11.44639496 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 74.7 | 1.27e-13 | NR | HTQ09779.1 | 2682144 | g43410 | i0 | 47.8 | 0.990430622009569 | 69 | 36 | 99 | 0 | 2 | 208 | 521 | 589 | HTQ09779.1 Qat anti-phage system ATPase QatA [Fimbriimonadaceae bacterium] | diamond | 207 | 74.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 33156709 | 33156709 | PRJNA399711_S_NODE_65584_length_180_cov_5.363636_g65442_i0 | PRJNA399711 | 65584 | 180 | 5.363636 | 9.6545448 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.1 | 2.15e-10 | NR | MDQ3812393.1 | 2033014 | g65442 | i0 | 46.6 | 1.95 | 58 | 31 | 96.7 | 0 | 7 | 180 | 307 | 364 | MDQ3812393.1 DUF2339 domain-containing protein [Armatimonadota bacterium] | diamond | 351 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33156834 | 33156834 | PRJNA399711_S_NODE_83904_length_165_cov_2.687500_g83762_i0 | PRJNA399711 | 83904 | 165 | 2.6875 | 4.434375 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 102 | 8.21e-25 | NR | MES2461330.1 | 2033014 | g83762 | i0 | 97.8 | 0.836363636363636 | 46 | 1 | 83.6 | 0 | 28 | 165 | 1 | 46 | MES2461330.1 methyltransferase domain-containing protein [Armatimonadota bacterium] | diamond | 138 | 102 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33173836 | 33173836 | PRJNA399711_S_NODE_42216_length_211_cov_12.919540_g42074_i0 | PRJNA399711 | 42216 | 211 | 12.91954 | 27.2602294 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 64.7 | 4.48e-10 | NR | MES2464979.1 | 2033014 | g42074 | i0 | 42.9 | 0.995260663507109 | 70 | 40 | 99.5 | 0 | 210 | 1 | 624 | 693 | MES2464979.1 DNA polymerase III subunit gamma/tau [Armatimonadota bacterium] | diamond | 210 | 64.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 33173933 | 33173933 | PRJNA399711_S_NODE_58536_length_188_cov_2.589404_g58394_i0 | PRJNA399711 | 58536 | 188 | 2.589404 | 4.86807952 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 43.5 | 0.00974 | NR | HEY3330736.1 | 2953755 | g58394 | i0 | 51.3 | 0.622340425531915 | 39 | 19 | 62.2 | 0 | 68 | 184 | 516 | 554 | HEY3330736.1 TonB-dependent receptor [Capsulimonadaceae bacterium] | diamond | 117 | 43.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae 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);;