contig_metadata
17 rows where bioproject = "PRJNA690592", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3222643 | 3222643 | PRJNA690592_S_NODE_45403_length_458_cov_2.348052_g44389_i0 | PRJNA690592 | 45403 | 458 | 2.348052 | 10.75407816 | Bacillati | 1783272 | Bacteria | Bacteria | 192 | 2.3999999999999996e-56 | NR | MBI3925067.1 | 2033014 | g44389 | i0 | 59.9 | 10.938864628821 | 152 | 60 | 99.6 | 1 | 3 | 458 | 157 | 307 | MBI3925067.1 putrescine aminotransferase [Armatimonadota bacterium] | diamond | 5010 | 192 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 13932931 | 13932931 | PRJNA690592_S_NODE_160551_length_269_cov_1.015306_g159537_i0 | PRJNA690592 | 160551 | 269 | 1.015306 | 2.73117314 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 126 | 1.66e-34 | NR | MEJ5169988.1 | 2682145 | g159537 | i0 | 64.4 | 2.00743494423792 | 90 | 31 | 99.3 | 1 | 269 | 3 | 80 | 169 | MEJ5169988.1 glutathione peroxidase [Fimbriimonadales bacterium] | diamond | 540 | 126 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 18523305 | 18523305 | PRJNA690592_S_NODE_188295_length_250_cov_1.457627_g187281_i0 | PRJNA690592 | 188295 | 250 | 1.457627 | 3.6440675 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 6.08e-39 | NR | MFH1452818.1 | 2033014 | g187281 | i0 | 75.9 | 3.96 | 83 | 20 | 99.6 | 0 | 249 | 1 | 159 | 241 | MFH1452818.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Armatimonadota bacterium] | diamond | 990 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 19797870 | 19797870 | PRJNA690592_S_NODE_13576_length_795_cov_7.547091_g12720_i0 | PRJNA690592 | 13576 | 795 | 7.547091 | 59.99937345 | Bacteria | 2 | Bacteria | Bacteria | 394 | 2.38e-136 | NR | MFH1452818.1 | 2033014 | g12720 | i0 | 73.5 | 3.71698113207547 | 245 | 65 | 92.5 | 0 | 59 | 793 | 3 | 247 | MFH1452818.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Armatimonadota bacterium] | diamond | 2955 | 395 | 0.99746835443038 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27493260 | 27493260 | PRJNA690592_S_NODE_118443_length_306_cov_1.283262_g117429_i0 | PRJNA690592 | 118443 | 306 | 1.283262 | 3.92678172 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 69.3 | 3.25e-11 | NR | HVK01870.1 | 2933160 | g117429 | i0 | 43.7 | 2.01960784313725 | 103 | 55 | 99 | 3 | 2 | 304 | 122 | 223 | HVK01870.1 FAD-dependent oxidoreductase [Armatimonadaceae bacterium] | diamond | 618 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 27524880 | 27524880 | PRJNA690592_S_NODE_43683_length_466_cov_1.732824_g42669_i0 | PRJNA690592 | 43683 | 466 | 1.732824 | 8.07495984 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 131 | 5.2300000000000005e-33 | NR | MBM3464694.1 | 2033014 | g42669 | i0 | 66 | 3.5793991416309 | 94 | 32 | 60.5 | 0 | 1 | 282 | 355 | 448 | MBM3464694.1 aspartate aminotransferase family protein [Armatimonadota bacterium] | diamond | 1668 | 131 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27746183 | 27746183 | PRJNA690592_S_NODE_90384_length_341_cov_1.694030_g89370_i0 | PRJNA690592 | 90384 | 341 | 1.69403 | 5.7766423 | Armatimonadetes bacterium Uphvl-Ar1 | 2004467 | Bacteria | Bacteria | 54.7 | 6.72e-6 | NR | ARU42094.1 | 2004467 | g89370 | i0 | 40.5 | 1.25806451612903 | 79 | 45 | 68.6 | 2 | 241 | 8 | 222 | 299 | ARU42094.1 hypothetical protein CCB80_13480 [Armatimonadetes bacterium Uphvl-Ar1] | diamond | 429 | 54.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar1 | ||||||
| 27809184 | 27809184 | PRJNA690592_S_NODE_157584_length_271_cov_1.166667_g156570_i0 | PRJNA690592 | 157584 | 271 | 1.166667 | 3.16166757 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 137 | 1.34e-36 | NR | MCC2668867.1 | 2033014 | g156570 | i0 | 73 | 3.9409594095941 | 89 | 24 | 98.5 | 0 | 3 | 269 | 265 | 353 | MCC2668867.1 succinyl-CoA synthetase (ADP-forming) beta subunit [Armatimonadota bacterium] | diamond | 1068 | 137 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27935338 | 27935338 | PRJNA690592_S_NODE_138545_length_287_cov_0.864486_g137531_i0 | PRJNA690592 | 138545 | 287 | 0.864486 | 2.48107482 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 44.3 | 0.0178 | NR | NCO34496.1 | 2033014 | g137531 | i0 | 35.8 | 0.700348432055749 | 67 | 42 | 69 | 1 | 2 | 199 | 506 | 572 | NCO34496.1 hypothetical protein [Armatimonadota bacterium] | diamond | 201 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28010060 | 28010060 | PRJNA690592_S_NODE_31745_length_538_cov_3.509677_g30739_i0 | PRJNA690592 | 31745 | 538 | 3.509677 | 18.88206226 | Bacteria | 2 | Bacteria | Bacteria | 141 | 7.2799999999999994e-40 | NR | WP_184192813.1 | 685828 | g30739 | i0 | 55.5 | 6.80297397769517 | 119 | 51 | 65.2 | 1 | 154 | 504 | 3 | 121 | WP_184192813.1 group I truncated hemoglobin [Armatimonas rosea] | diamond | 3660 | 142 | 0.992957746478873 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 29356269 | 29356269 | PRJNA690592_S_NODE_66269_length_389_cov_1.604430_g65255_i0 | PRJNA690592 | 66269 | 389 | 1.60443 | 6.2412327 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 48.9 | 0.00132 | NR | MCX6361298.1 | 2033014 | g65255 | i0 | 41.8 | 0.516709511568123 | 67 | 37 | 50.9 | 2 | 389 | 192 | 792 | 857 | MCX6361298.1 glycosyl hydrolase [Armatimonadota bacterium] | diamond | 201 | 48.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29387920 | 29387920 | PRJNA690592_S_NODE_53089_length_428_cov_2.752113_g52075_i0 | PRJNA690592 | 53089 | 428 | 2.752113 | 11.77904364 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 91.7 | 1.46e-19 | NR | MBS1716519.1 | 2033014 | g52075 | i0 | 45.8 | 0.841121495327103 | 120 | 56 | 80.6 | 6 | 413 | 69 | 100 | 215 | MBS1716519.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Armatimonadota bacterium] | diamond | 360 | 91.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31378172 | 31378172 | PRJNA690592_S_NODE_19456_length_676_cov_3.122720_g18506_i0 | PRJNA690592 | 19456 | 676 | 3.12272 | 21.1095872 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 169 | 4.03e-49 | NR | MCS7192197.1 | 2033014 | g18506 | i0 | 48.7 | 1.59319526627219 | 189 | 95 | 83.9 | 1 | 626 | 60 | 2 | 188 | MCS7192197.1 macro domain-containing protein [Armatimonadota bacterium] | diamond | 1077 | 169 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31536425 | 31536425 | PRJNA690592_S_NODE_194276_length_248_cov_1.320000_g193262_i0 | PRJNA690592 | 194276 | 248 | 1.32 | 3.2736 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47.8 | 6.72e-4 | NR | MBW3624006.1 | 2033014 | g193262 | i0 | 43.3 | 0.810483870967742 | 67 | 32 | 81 | 2 | 247 | 47 | 101 | 161 | MBW3624006.1 hypothetical protein [Armatimonadota bacterium] | diamond | 201 | 47.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32212069 | 32212069 | PRJNA690592_S_NODE_20758_length_656_cov_2.933105_g19794_i0 | PRJNA690592 | 20758 | 656 | 2.933105 | 19.2411688 | Bacteria | 2 | Bacteria | Bacteria | 90.1 | 9.06e-20 | NR | MBI2264858.1 | 2033014 | g19794 | i0 | 71.7 | 1.47256097560976 | 60 | 17 | 27.4 | 0 | 118 | 297 | 7 | 66 | MBI2264858.1 cold-shock protein [Armatimonadota bacterium] | diamond | 966 | 90.5 | 0.995580110497237 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32422082 | 32422082 | PRJNA690592_S_NODE_199479_length_246_cov_1.618497_g198465_i0 | PRJNA690592 | 199479 | 246 | 1.618497 | 3.98150262 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 111 | 2.16e-26 | NR | NUP98281.1 | 2033014 | g198465 | i0 | 87.7 | 0.792682926829268 | 65 | 8 | 79.3 | 0 | 51 | 245 | 1 | 65 | NUP98281.1 ABC transporter substrate-binding protein [Armatimonadota bacterium] | diamond | 195 | 111 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32800469 | 32800469 | PRJNA690592_S_NODE_26020_length_591_cov_1.486486_g25028_i0 | PRJNA690592 | 26020 | 591 | 1.486486 | 8.78513226 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 163 | 8.14e-45 | NR | MDR3691976.1 | 1936159 | g25028 | i0 | 47.5 | 1.82233502538071 | 183 | 78 | 92.9 | 3 | 3 | 551 | 124 | 288 | MDR3691976.1 cysteine desulfurase-like protein [Fimbriimonas sp.] | diamond | 1077 | 163 | 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);;