contig_metadata
26 rows where bioproject = "PRJNA888821", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3413396 | 3413396 | PRJNA888821_P_NODE_18123_length_310_cov_4.308017_g18041_i0 | PRJNA888821 | 18123 | 310 | 4.308017 | 13.3548527 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 150 | 9.98e-32 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g18041 | i0 | 85.034 | 1.34516129032258 | 147 | 22 | 47 | 0 | 163 | 309 | 359110 | 359256 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 417 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 3793976 | 3793976 | PRJNA888821_P_NODE_50523_length_204_cov_8.137405_g50440_i0 | PRJNA888821 | 50523 | 204 | 8.137405 | 16.6003062 | Chthonomonas | 1077265 | Bacteria | Bacteria | 134 | 6.1800000000000006e-27 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g50440 | i0 | 80.11 | 195.700980392157 | 181 | 34 | 88 | 2 | 26 | 204 | 2808 | 2628 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 39923 | 134 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 12341696 | 12341696 | PRJNA888821_P_NODE_14610_length_310_cov_6.848101_g14528_i0 | PRJNA888821 | 14610 | 310 | 6.848101 | 21.2291131 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 184 | 3.4e-54 | NR | MCL6534162.1 | 2033014 | g14528 | i0 | 75 | 1.23870967741935 | 128 | 7 | 99.7 | 1 | 309 | 1 | 291 | 418 | MCL6534162.1 hypothetical protein [Armatimonadota bacterium] | diamond | 384 | 184 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 13616564 | 13616564 | PRJNA888821_P_NODE_36411_length_247_cov_5.632184_g36328_i0 | PRJNA888821 | 36411 | 247 | 5.632184 | 13.91149448 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 123 | 4.9099999999999996e-32 | NR | MBW3622697.1 | 2033014 | g36328 | i0 | 71.3 | 11.8785425101215 | 80 | 23 | 97.2 | 0 | 1 | 240 | 159 | 238 | MBW3622697.1 sigma-70 family RNA polymerase sigma factor [Armatimonadota bacterium] | diamond | 2934 | 123 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 13616710 | 13616710 | PRJNA888821_P_NODE_43951_length_225_cov_7.118421_g43868_i0 | PRJNA888821 | 43951 | 225 | 7.118421 | 16.01644725 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 222 | 1.44e-53 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g43868 | i0 | 84.444 | 288.164444444444 | 225 | 35 | 100 | 0 | 1 | 225 | 592646 | 592870 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 64837 | 222 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 13616798 | 13616798 | PRJNA888821_P_NODE_48811_length_209_cov_7.352941_g48728_i0 | PRJNA888821 | 48811 | 209 | 7.352941 | 15.36764669 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 91.7 | 7.78e-20 | NR | MBC8103048.1 | 2033014 | g48728 | i0 | 63.8 | 0.990430622009569 | 69 | 25 | 99 | 0 | 209 | 3 | 217 | 285 | MBC8103048.1 response regulator [Armatimonadota bacterium] | diamond | 207 | 91.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 17441007 | 17441007 | PRJNA888821_P_NODE_31214_length_264_cov_15.287958_g31131_i0 | PRJNA888821 | 31214 | 264 | 15.287958 | 40.36020912 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 106 | 1.83e-18 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g31131 | i0 | 81.818 | 1.18939393939394 | 132 | 19 | 50 | 5 | 1 | 131 | 2072157 | 2072030 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 314 | 106 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17441102 | 17441102 | PRJNA888821_P_NODE_36294_length_247_cov_11.770115_g36211_i0 | PRJNA888821 | 36294 | 247 | 11.770115 | 29.07218405 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 226 | 1.2399999999999997e-54 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g36211 | i0 | 83.471 | 0.979757085020243 | 242 | 40 | 98 | 0 | 3 | 244 | 2529226 | 2529467 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 242 | 226 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17819292 | 17819292 | PRJNA888821_P_NODE_22634_length_307_cov_10.025641_g22552_i0 | PRJNA888821 | 22634 | 307 | 10.025641 | 30.77871787 | PVC group | 1783257 | Bacteria | Bacteria | 71.3 | 7.91e-8 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g22552 | i0 | 97.561 | 2.14983713355049 | 41 | 1 | 14 | 0 | 165 | 205 | 2209799 | 2209839 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 660 | 71.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 17819464 | 17819464 | PRJNA888821_P_NODE_38854_length_242_cov_0.911243_g38771_i0 | PRJNA888821 | 38854 | 242 | 0.911243 | 2.20520806 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 375 | 1.14e-99 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g38771 | i0 | 94.65 | 261.669421487603 | 243 | 11 | 100 | 2 | 1 | 242 | 29027 | 28786 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 63324 | 375 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26802220 | 26802220 | PRJNA888821_P_NODE_35021_length_250_cov_6.627119_g34938_i0 | PRJNA888821 | 35021 | 250 | 6.627119 | 16.5677975 | Armatimonadetes bacterium DC | 1661583 | Bacteria | Bacteria | 140 | 3.77e-38 | NR | CUU36901.1 | 1661583 | g34938 | i0 | 97.1 | 0.816 | 68 | 2 | 81.6 | 0 | 206 | 3 | 4 | 71 | CUU36901.1 Putative transposase, YhgA-like [Armatimonadetes bacterium DC] | diamond | 204 | 140 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium DC | ||||||
| 28034777 | 28034777 | PRJNA888821_P_NODE_9785_length_310_cov_11.392405_g9703_i0 | PRJNA888821 | 9785 | 310 | 11.392405 | 35.316455499999996 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 104 | 1.3e-23 | NR | MCL6533188.1 | 2033014 | g9703 | i0 | 100 | 1.45161290322581 | 50 | 0 | 48.4 | 0 | 150 | 1 | 295 | 344 | MCL6533188.1 hypothetical protein [Armatimonadota bacterium] | diamond | 450 | 104 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28666228 | 28666228 | PRJNA888821_P_NODE_16747_length_310_cov_5.333333_g16665_i0 | PRJNA888821 | 16747 | 310 | 5.333333 | 16.5333323 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 185 | 2.4399999999999998e-54 | NR | MCL6532822.1 | 2033014 | g16665 | i0 | 74.6 | 1.25806451612903 | 130 | 5 | 98.7 | 1 | 309 | 4 | 324 | 453 | MCL6532822.1 FAD-binding oxidoreductase [Armatimonadota bacterium] | diamond | 390 | 185 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28823682 | 28823682 | PRJNA888821_P_NODE_10808_length_310_cov_10.172996_g10726_i0 | PRJNA888821 | 10808 | 310 | 10.172996 | 31.5362876 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 192 | 2.1599999999999995e-54 | NR | MCL6531898.1 | 2033014 | g10726 | i0 | 96.1 | 0.996774193548387 | 103 | 2 | 99.7 | 1 | 310 | 2 | 718 | 818 | MCL6531898.1 SEC-C domain-containing protein [Armatimonadota bacterium] | diamond | 309 | 192 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29045124 | 29045124 | PRJNA888821_P_NODE_26848_length_284_cov_3.606635_g26766_i0 | PRJNA888821 | 26848 | 284 | 3.606635 | 10.2428434 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 196 | 2.4199999999999997e-57 | NR | MCL6532757.1 | 2033014 | g26766 | i0 | 100 | 0.992957746478873 | 94 | 0 | 99.3 | 0 | 284 | 3 | 144 | 237 | MCL6532757.1 hypothetical protein [Armatimonadota bacterium] | diamond | 282 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29203017 | 29203017 | PRJNA888821_P_NODE_28589_length_276_cov_4.492611_g28507_i0 | PRJNA888821 | 28589 | 276 | 4.492611 | 12.39960636 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 150 | 5.52e-42 | NR | MBC8064280.1 | 2682144 | g28507 | i0 | 73.9 | 3 | 92 | 24 | 100 | 0 | 1 | 276 | 89 | 180 | MBC8064280.1 type IV pilus twitching motility protein PilT [Fimbriimonadaceae bacterium] | diamond | 828 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29329108 | 29329108 | PRJNA888821_P_NODE_46229_length_217_cov_6.604167_g46146_i0 | PRJNA888821 | 46229 | 217 | 6.604167 | 14.33104239 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 161 | 3.7899999999999997e-47 | NR | MCL6531758.1 | 2033014 | g46146 | i0 | 100 | 0.995391705069124 | 72 | 0 | 99.5 | 0 | 1 | 216 | 134 | 205 | MCL6531758.1 glycosyltransferase family 2 protein [Armatimonadota bacterium] | diamond | 216 | 161 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29739341 | 29739341 | PRJNA888821_P_NODE_40230_length_238_cov_4.818182_g40147_i0 | PRJNA888821 | 40230 | 238 | 4.818182 | 11.46727316 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 75.9 | 4.64e-14 | NR | HLJ57032.1 | 2739509 | g40147 | i0 | 54.4 | 0.995798319327731 | 79 | 32 | 99.6 | 2 | 1 | 237 | 192 | 266 | HLJ57032.1 NAD-dependent epimerase/dehydratase family protein [Chthonomonadaceae bacterium] | diamond | 237 | 75.9 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 29739342 | 29739342 | PRJNA888821_P_NODE_50350_length_204_cov_16.320611_g50267_i0 | PRJNA888821 | 50350 | 204 | 16.320611 | 33.29404644 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 83.2 | 1.3e-16 | NR | MCL6533827.1 | 2033014 | g50267 | i0 | 100 | 0.647058823529412 | 44 | 0 | 64.7 | 0 | 1 | 132 | 1284 | 1327 | MCL6533827.1 DNA-directed RNA polymerase subunit beta [Armatimonadota bacterium] | diamond | 132 | 83.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30560769 | 30560769 | PRJNA888821_P_NODE_34893_length_251_cov_0.865169_g34810_i0 | PRJNA888821 | 34893 | 251 | 0.865169 | 2.17157419 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 81.3 | 2.48e-18 | NR | MEQ1935684.1 | 2682144 | g34810 | i0 | 87.2 | 0.561752988047809 | 47 | 6 | 56.2 | 0 | 2 | 142 | 10 | 56 | MEQ1935684.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 141 | 81.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30655711 | 30655711 | PRJNA888821_P_NODE_14933_length_310_cov_6.594937_g14851_i0 | PRJNA888821 | 14933 | 310 | 6.594937 | 20.4443047 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 95.9 | 8.419999999999999e-23 | NR | MCS7235757.1 | 2033014 | g14851 | i0 | 93.8 | 0.464516129032258 | 48 | 3 | 46.5 | 0 | 161 | 304 | 92 | 139 | MCS7235757.1 thermonuclease family protein [Armatimonadota bacterium] | diamond | 144 | 95.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32395149 | 32395149 | PRJNA888821_P_NODE_20379_length_309_cov_14.283898_g20297_i0 | PRJNA888821 | 20379 | 309 | 14.283898 | 44.13724482 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 101 | 1.4000000000000002e-22 | NR | MCL6532822.1 | 2033014 | g20297 | i0 | 100 | 0.475728155339806 | 49 | 0 | 47.6 | 0 | 149 | 3 | 84 | 132 | MCL6532822.1 FAD-binding oxidoreductase [Armatimonadota bacterium] | diamond | 147 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32426705 | 32426705 | PRJNA888821_P_NODE_38939_length_242_cov_0.911243_g38856_i0 | PRJNA888821 | 38939 | 242 | 0.911243 | 2.20520806 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 120 | 3.5199999999999995e-31 | NR | MCW3098136.1 | 2739509 | g38856 | i0 | 69.6 | 1.94628099173554 | 79 | 24 | 97.9 | 0 | 241 | 5 | 200 | 278 | MCW3098136.1 Phytoene/squalene synthetase [Chthonomonadaceae bacterium] | diamond | 471 | 120 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 32490142 | 32490142 | PRJNA888821_P_NODE_47199_length_214_cov_6.503546_g47116_i0 | PRJNA888821 | 47199 | 214 | 6.503546 | 13.91758844 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 2.29e-37 | NR | MCL6532823.1 | 2033014 | g47116 | i0 | 100 | 0.981308411214953 | 70 | 0 | 98.1 | 0 | 3 | 212 | 193 | 262 | MCL6532823.1 prolyl oligopeptidase family serine peptidase [Armatimonadota bacterium] | diamond | 210 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32623982 | 32623982 | PRJNA888821_P_NODE_10020_length_310_cov_11.097046_g9938_i0 | PRJNA888821 | 10020 | 310 | 11.097046 | 34.4008426 | Bacteria | 2 | Bacteria | Bacteria | 58.2 | 4.55e-8 | NR | MFM7321936.1 | 2033014 | g9938 | i0 | 65.8 | 0.725806451612903 | 38 | 13 | 36.8 | 0 | 163 | 276 | 102 | 139 | MFM7321936.1 acetyl-CoA carboxylase biotin carboxyl carrier protein [Armatimonadota bacterium] | diamond | 225 | 58.5 | 0.994871794871795 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32836577 | 32836577 | PRJNA888821_P_NODE_40240_length_238_cov_4.472727_g40157_i0 | PRJNA888821 | 40240 | 238 | 4.472727 | 10.64509026 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 97.4 | 1.08e-21 | NR | MCL6532985.1 | 2033014 | g40157 | i0 | 100 | 0.567226890756303 | 45 | 0 | 56.7 | 0 | 2 | 136 | 36 | 80 | MCL6532985.1 PEP-CTERM sorting domain-containing protein [Armatimonadota bacterium] | diamond | 135 | 97.4 | 1 | 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);;