contig_metadata
17 rows where bioproject = "PRJNA1010780", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15457862 | 15457862 | PRJNA1010780_S_NODE_9353_length_811_cov_3.747423_g8450_i0 | PRJNA1010780 | 9353 | 811 | 3.747423 | 30.39160053 | Chthonomonas calidirosea | 454171 | Bacteria | Bacteria | 411 | 9.89e-142 | NR | WP_016483035.1 | 454171 | g8450 | i0 | 73.9 | 0.950678175092478 | 257 | 65 | 94.3 | 1 | 810 | 46 | 62 | 318 | WP_016483035.1 sugar phosphate isomerase/epimerase family protein [Chthonomonas calidirosea] | diamond | 771 | 411 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 19280653 | 19280653 | PRJNA1010780_S_NODE_28376_length_279_cov_3.881148_g27087_i0 | PRJNA1010780 | 28376 | 279 | 3.881148 | 10.82840292 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2076447151|gb|CP075366.1| | 2682144 | g27087 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 170 | 197 | 1399799 | 1399772 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26781573 | 26781573 | PRJNA1010780_S_NODE_50961_length_173_cov_1.340580_g49672_i0 | PRJNA1010780 | 50961 | 173 | 1.34058 | 2.3192034 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 66.6 | 2.96e-11 | NR | MBC8138190.1 | 2033014 | g49672 | i0 | 56.9 | 0.884393063583815 | 51 | 22 | 88.4 | 0 | 153 | 1 | 30 | 80 | MBC8138190.1 DUF4419 domain-containing protein [Armatimonadota bacterium] | diamond | 153 | 66.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26971109 | 26971109 | PRJNA1010780_S_NODE_10302_length_754_cov_6.186370_g9339_i0 | PRJNA1010780 | 10302 | 754 | 6.18637 | 46.6452298 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 49.7 | 0.00658 | NR | MBX3097899.1 | 2682144 | g9339 | i0 | 33.3 | 0.29840848806366 | 75 | 49 | 29.4 | 1 | 524 | 745 | 88 | 162 | MBX3097899.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 225 | 49.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27571713 | 27571713 | PRJNA1010780_S_NODE_28324_length_280_cov_2.114286_g27035_i0 | PRJNA1010780 | 28324 | 280 | 2.114286 | 5.9200008 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 87.8 | 8.43e-18 | NR | HEY3781194.1 | 2682144 | g27035 | i0 | 48.4 | 0.975 | 91 | 45 | 97.5 | 1 | 273 | 1 | 475 | 563 | HEY3781194.1 formylglycine-generating enzyme family protein [Fimbriimonadaceae bacterium] | diamond | 273 | 87.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27918969 | 27918969 | PRJNA1010780_S_NODE_29045_length_273_cov_2.323529_g27756_i0 | PRJNA1010780 | 29045 | 273 | 2.323529 | 6.34323417 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 60.1 | 2.76e-8 | NR | MDQ2799281.1 | 2033014 | g27756 | i0 | 44.3 | 0.868131868131868 | 79 | 38 | 85.7 | 3 | 36 | 269 | 85 | 158 | MDQ2799281.1 alpha/beta hydrolase [Armatimonadota bacterium] | diamond | 237 | 60.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28076853 | 28076853 | PRJNA1010780_S_NODE_47685_length_181_cov_1.746575_g46396_i0 | PRJNA1010780 | 47685 | 181 | 1.746575 | 3.16130075 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.4 | 0.0229 | NR | MFN3650225.1 | 2033014 | g46396 | i0 | 58.6 | 0.480662983425414 | 29 | 11 | 46.4 | 1 | 25 | 108 | 394 | 422 | MFN3650225.1 alpha-L-fucosidase [Armatimonadota bacterium] | diamond | 87 | 42.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28763906 | 28763906 | PRJNA1010780_S_NODE_47047_length_183_cov_1.256757_g45758_i0 | PRJNA1010780 | 47047 | 183 | 1.256757 | 2.29986531 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 45.4 | 0.00184 | NR | MBM3457507.1 | 2033014 | g45758 | i0 | 39.7 | 3 | 63 | 35 | 98.4 | 1 | 182 | 3 | 225 | 287 | MBM3457507.1 hypothetical protein [Armatimonadota bacterium] | diamond | 549 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28866192 | 28866192 | PRJNA1010780_S_NODE_15268_length_533_cov_5.305221_g14053_i0 | PRJNA1010780 | 15268 | 533 | 5.305221 | 28.27682793 | Fimbriimonadia bacterium | 2575566 | Bacteria | Bacteria | 90.1 | 2.49e-17 | NR | MCW5935503.1 | 2575566 | g14053 | i0 | 30.2 | 0.968105065666041 | 172 | 116 | 95.7 | 3 | 510 | 1 | 45 | 214 | MCW5935503.1 M60 family metallopeptidase [Fimbriimonadia bacterium] | diamond | 516 | 90.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadia bacterium | |||||
| 30501013 | 30501013 | PRJNA1010780_S_NODE_45293_length_188_cov_1.673203_g44004_i0 | PRJNA1010780 | 45293 | 188 | 1.673203 | 3.14562164 | PVC group | 1783257 | Bacteria | Bacteria | 61.2 | 5.32e-9 | NR | HEY3284826.1 | 2033014 | g44004 | i0 | 54.8 | 12.8936170212766 | 62 | 24 | 98.9 | 2 | 187 | 2 | 430 | 487 | HEY3284826.1 PAS domain S-box protein [Armatimonadota bacterium] | diamond | 2424 | 61.6 | 0.993506493506494 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31362002 | 31362002 | PRJNA1010780_S_NODE_51956_length_170_cov_2.207407_g50667_i0 | PRJNA1010780 | 51956 | 170 | 2.207407 | 3.7525919 | Fimbriimonadia bacterium | 2575566 | Bacteria | Bacteria | 53.9 | 1.58e-6 | NR | MEP0767396.1 | 2575566 | g50667 | i0 | 46.9 | 0.864705882352941 | 49 | 24 | 82.9 | 1 | 30 | 170 | 568 | 616 | MEP0767396.1 glycoside hydrolase family 127 protein [Fimbriimonadia bacterium] | diamond | 147 | 53.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadia bacterium | |||||
| 32026112 | 32026112 | PRJNA1010780_S_NODE_32378_length_247_cov_1.820755_g31089_i0 | PRJNA1010780 | 32378 | 247 | 1.820755 | 4.49726485 | Fimbriimonadia bacterium | 2575566 | Bacteria | Bacteria | 43.1 | 0.0283 | NR | MEP0765571.1 | 2575566 | g31089 | i0 | 39.4 | 0.801619433198381 | 66 | 37 | 76.5 | 2 | 24 | 212 | 249 | 314 | MEP0765571.1 UPF0182 family protein [Fimbriimonadia bacterium] | diamond | 198 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadia bacterium | |||||
| 32247975 | 32247975 | PRJNA1010780_S_NODE_61798_length_152_cov_1.965812_g60509_i0 | PRJNA1010780 | 61798 | 152 | 1.965812 | 2.98803424 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 47 | 3.39e-4 | NR | NLI01589.1 | 2282151 | g60509 | i0 | 48 | 0.986842105263158 | 50 | 26 | 98.7 | 0 | 1 | 150 | 181 | 230 | NLI01589.1 cell wall anchor protein [Chthonomonadales bacterium] | diamond | 150 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 32469263 | 32469263 | PRJNA1010780_S_NODE_29499_length_269_cov_2.495726_g28210_i0 | PRJNA1010780 | 29499 | 269 | 2.495726 | 6.71350294 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 54.7 | 2.44e-6 | NR | MDQ2799281.1 | 2033014 | g28210 | i0 | 36.9 | 0.936802973977695 | 84 | 40 | 92.6 | 3 | 269 | 21 | 6 | 77 | MDQ2799281.1 alpha/beta hydrolase [Armatimonadota bacterium] | diamond | 252 | 54.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32564205 | 32564205 | PRJNA1010780_S_NODE_26139_length_304_cov_1.215613_g24850_i0 | PRJNA1010780 | 26139 | 304 | 1.215613 | 3.69546352 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 158 | 9.42e-43 | NR | MBV9852567.1 | 2033014 | g24850 | i0 | 68.3 | 0.996710526315789 | 101 | 32 | 99.7 | 0 | 303 | 1 | 117 | 217 | MBV9852567.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Armatimonadota bacterium] | diamond | 303 | 158 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32682172 | 32682172 | PRJNA1010780_S_NODE_3320_length_1464_cov_6.892232_g2983_i0 | PRJNA1010780 | 3320 | 1464 | 6.892232 | 100.90227648 | Armatimonadota | 67819 | Bacteria | Bacteria | 288 | 2.35e-90 | NR | WP_221290249.1 | 685828 | g2983 | i0 | 51.3 | 3.95491803278689 | 273 | 114 | 52.9 | 2 | 1315 | 542 | 18 | 286 | WP_221290249.1 phytanoyl-CoA dioxygenase family protein [Armatimonas rosea] | diamond | 5790 | 288 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 32689849 | 32689849 | PRJNA1010780_S_NODE_43260_length_195_cov_1.106250_g41971_i0 | PRJNA1010780 | 43260 | 195 | 1.10625 | 2.1571875 | Capsulimonas sp. | 2494211 | Bacteria | Bacteria | 72.4 | 7.08e-13 | NR | WP_348222454.1 | 2494211 | g41971 | i0 | 42.9 | 1.07692307692308 | 70 | 34 | 98.5 | 1 | 4 | 195 | 214 | 283 | WP_348222454.1 IPT/TIG domain-containing protein [Capsulimonas sp.] | diamond | 210 | 72.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas 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);;