contig_metadata
10 rows where bioproject = "PRJNA533114", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26602631 | 26602631 | PRJNA533114_P_NODE_59201_length_309_cov_1.843220_g58949_i0 | PRJNA533114 | 59201 | 309 | 1.84322 | 5.6955498 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 59.7 | 8.9e-8 | NR | MBS1718041.1 | 2033014 | g58949 | i0 | 44.7 | 0.825242718446602 | 85 | 37 | 81.6 | 3 | 29 | 280 | 15 | 90 | MBS1718041.1 hypothetical protein [Armatimonadota bacterium] | diamond | 255 | 59.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27203840 | 27203840 | PRJNA533114_P_NODE_118022_length_242_cov_0.911243_g117770_i0 | PRJNA533114 | 118022 | 242 | 0.911243 | 2.20520806 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 61.2 | 8e-9 | NR | MBC7808400.1 | 2033014 | g117770 | i0 | 41.3 | 1.66115702479339 | 75 | 38 | 93 | 1 | 241 | 17 | 195 | 263 | MBC7808400.1 phytanoyl-CoA dioxygenase family protein [Armatimonadota bacterium] | diamond | 402 | 61.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27709866 | 27709866 | PRJNA533114_P_NODE_103604_length_247_cov_1.327586_g103352_i0 | PRJNA533114 | 103604 | 247 | 1.327586 | 3.27913742 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.4 | 0.00451 | NR | MCC2670082.1 | 2033014 | g103352 | i0 | 44.9 | 0.838056680161943 | 69 | 33 | 81.4 | 3 | 38 | 238 | 895 | 960 | MCC2670082.1 hypothetical protein [Armatimonadota bacterium] | diamond | 207 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27741458 | 27741458 | PRJNA533114_P_NODE_96284_length_250_cov_0.870056_g96032_i0 | PRJNA533114 | 96284 | 250 | 0.870056 | 2.17514 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 107 | 3.25e-25 | NR | HEX5324540.1 | 2953755 | g96032 | i0 | 66.2 | 4.644 | 74 | 25 | 88.8 | 0 | 5 | 226 | 70 | 143 | HEX5324540.1 glutamate--tRNA ligase [Capsulimonadaceae bacterium] | diamond | 1161 | 107 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae bacterium | |||
| 28404047 | 28404047 | PRJNA533114_P_NODE_106566_length_246_cov_0.890173_g106314_i0 | PRJNA533114 | 106566 | 246 | 0.890173 | 2.18982558 | Armatimonas rosea | 685828 | Bacteria | Bacteria | 89 | 2.06e-18 | NR | WP_184192403.1 | 685828 | g106314 | i0 | 51.9 | 1.96341463414634 | 81 | 36 | 97.6 | 2 | 244 | 5 | 224 | 302 | WP_184192403.1 alpha-L-arabinofuranosidase C-terminal domain-containing protein [Armatimonas rosea] | diamond | 483 | 89 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 29162112 | 29162112 | PRJNA533114_P_NODE_43449_length_354_cov_1.096085_g43197_i0 | PRJNA533114 | 43449 | 354 | 1.096085 | 3.8801409 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 66.2 | 7.35e-10 | NR | MBM3474493.1 | 2033014 | g43197 | i0 | 51.4 | 0.627118644067797 | 74 | 34 | 62.7 | 2 | 2 | 223 | 35 | 106 | MBM3474493.1 hydroxylamine reductase [Armatimonadota bacterium] | diamond | 222 | 66.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29492643 | 29492643 | PRJNA533114_P_NODE_63130_length_300_cov_1.696035_g62878_i0 | PRJNA533114 | 63130 | 300 | 1.696035 | 5.088105 | Bacteria | 2 | Bacteria | Bacteria | 149 | 4.749999999999999e-40 | NR | MBX3119674.1 | 2682144 | g62878 | i0 | 78.9 | 16.22 | 95 | 18 | 95 | 1 | 289 | 5 | 78 | 170 | MBX3119674.1 MmgE/PrpD family protein [Fimbriimonadaceae bacterium] | diamond | 4866 | 149 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30534962 | 30534962 | PRJNA533114_P_NODE_101693_length_248_cov_0.880000_g101441_i0 | PRJNA533114 | 101693 | 248 | 0.88 | 2.1824 | PVC group | 1783257 | Bacteria | Bacteria | 49.7 | 9.1e-5 | NR | HOS44485.1 | 2033014 | g101441 | i0 | 83.3 | 1.34274193548387 | 24 | 4 | 29 | 0 | 82 | 11 | 173 | 196 | HOS44485.1 9-O-acetylesterase [Armatimonadota bacterium] | diamond | 333 | 50.1 | 0.992015968063872 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30787815 | 30787815 | PRJNA533114_P_NODE_15754_length_570_cov_1.313883_g15507_i0 | PRJNA533114 | 15754 | 570 | 1.313883 | 7.4891331 | FCB group | 1783270 | Bacteria | Bacteria | 139 | 1.55e-34 | NR | MBI1333722.1 | 2033014 | g15507 | i0 | 41.5 | 4.10526315789474 | 188 | 105 | 96.8 | 4 | 5 | 556 | 400 | 586 | MBI1333722.1 beta-galactosidase [Armatimonadota bacterium] | diamond | 2340 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31816050 | 31816050 | PRJNA533114_P_NODE_63557_length_299_cov_1.676991_g63305_i0 | PRJNA533114 | 63557 | 299 | 1.676991 | 5.01420309 | Chthonomonas sp. | 2282153 | Bacteria | Bacteria | 62.8 | 4.51e-9 | NR | MBL8049453.1 | 2282153 | g63305 | i0 | 37.2 | 0.782608695652174 | 78 | 47 | 78.3 | 1 | 239 | 6 | 208 | 283 | MBL8049453.1 FHA domain-containing protein [Chthonomonas sp.] | diamond | 234 | 62.8 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas 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);;