contig_metadata
23 rows where bioproject = "PRJNA1126661", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11761086 | 11761086 | PRJNA1126661_P_NODE_43590_length_300_cov_4.621145_g43061_i0 | PRJNA1126661 | 43590 | 300 | 4.621145 | 13.863435 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 90.9 | 2.91e-19 | NR | HCE01152.1 | 2033014 | g43061 | i0 | 100 | 0.92 | 46 | 0 | 46 | 0 | 300 | 163 | 257 | 302 | HCE01152.1 ferredoxin--NADP(+) reductase [Armatimonadota bacterium] | diamond | 276 | 90.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 15058720 | 15058720 | PRJNA1126661_P_NODE_47932_length_298_cov_3.622222_g47403_i0 | PRJNA1126661 | 47932 | 298 | 3.622222 | 10.79422156 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 150 | 6.16e-40 | NR | MCA1948360.1 | 2033014 | g47403 | i0 | 50.8 | 1.96308724832215 | 195 | 0 | 99.7 | 1 | 298 | 2 | 210 | 404 | MCA1948360.1 methylmalonyl-CoA mutase subunit beta [Armatimonadota bacterium] | diamond | 585 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 20683603 | 20683603 | PRJNA1126661_P_NODE_17597_length_326_cov_4.395257_g17068_i0 | PRJNA1126661 | 17597 | 326 | 4.395257 | 14.32853782 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 182 | 1.0299999999999999e-52 | NR | MCA1996072.1 | 2033014 | g17068 | i0 | 82 | 1.12269938650307 | 122 | 8 | 99.4 | 1 | 3 | 326 | 289 | 410 | MCA1996072.1 efflux RND transporter periplasmic adaptor subunit [Armatimonadota bacterium] | diamond | 366 | 182 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 21959543 | 21959543 | PRJNA1126661_P_NODE_72978_length_246_cov_0.901734_g72448_i0 | PRJNA1126661 | 72978 | 246 | 0.901734 | 2.21826564 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2107879857|gb|CP070816.1| | 2033014 | g72448 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 169 | 196 | 342805 | 342832 | MAG: Armatimonadetes bacterium isolate bin117 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26595270 | 26595270 | PRJNA1126661_P_NODE_7921_length_326_cov_10.351779_g7392_i0 | PRJNA1126661 | 7921 | 326 | 10.351779 | 33.74679954 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 83.2 | 4.27e-16 | NR | MBW3635025.1 | 2033014 | g7392 | i0 | 40.7 | 1.0398773006135 | 113 | 57 | 94.8 | 1 | 325 | 17 | 277 | 389 | MBW3635025.1 sn-glycerol-3-phosphate ABC transporter ATP-binding protein UgpC [Armatimonadota bacterium] | diamond | 339 | 83.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26817312 | 26817312 | PRJNA1126661_P_NODE_12021_length_326_cov_6.134387_g11492_i0 | PRJNA1126661 | 12021 | 326 | 6.134387 | 19.99810162 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 102 | 6.259999999999999e-23 | NR | MES2464322.1 | 2033014 | g11492 | i0 | 98 | 0.920245398773006 | 50 | 1 | 46 | 0 | 150 | 1 | 140 | 189 | MES2464322.1 type II secretion system F family protein [Armatimonadota bacterium] | diamond | 300 | 102 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27418228 | 27418228 | PRJNA1126661_P_NODE_52643_length_293_cov_2.790909_g52114_i0 | PRJNA1126661 | 52643 | 293 | 2.790909 | 8.17736337 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 150 | 6.05e-44 | NR | HCD99474.1 | 2033014 | g52114 | i0 | 88.2 | 2.25255972696246 | 110 | 0 | 99.3 | 1 | 2 | 292 | 53 | 162 | HCD99474.1 sulfite exporter TauE/SafE family protein [Armatimonadota bacterium] | diamond | 660 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27449699 | 27449699 | PRJNA1126661_P_NODE_29063_length_326_cov_2.731225_g28534_i0 | PRJNA1126661 | 29063 | 326 | 2.731225 | 8.9037935 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 86.7 | 1.15e-17 | NR | MES2459489.1 | 2033014 | g28534 | i0 | 81.6 | 0.450920245398773 | 49 | 9 | 45.1 | 0 | 324 | 178 | 192 | 240 | MES2459489.1 Mu-like prophage major head subunit gpT family protein [Armatimonadota bacterium] | diamond | 147 | 86.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28259372 | 28259372 | PRJNA1126661_P_NODE_37666_length_301_cov_4.377193_g37137_i0 | PRJNA1126661 | 37666 | 301 | 4.377193 | 13.17535093 | Bacteria | 2 | Bacteria | Bacteria | 105 | 5.0099999999999994e-24 | NR | MCA1947397.1 | 2033014 | g37137 | i0 | 100 | 0.996677740863787 | 50 | 0 | 49.8 | 0 | 300 | 151 | 510 | 559 | MCA1947397.1 extracellular solute-binding protein [Armatimonadota bacterium] | diamond | 300 | 105 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28301993 | 28301993 | PRJNA1126661_P_NODE_13346_length_326_cov_5.608696_g12817_i0 | PRJNA1126661 | 13346 | 326 | 5.608696 | 18.28434896 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 103 | 3.1599999999999996e-23 | NR | MCA1995839.1 | 2033014 | g12817 | i0 | 98 | 0.460122699386503 | 50 | 1 | 46 | 0 | 177 | 326 | 170 | 219 | MCA1995839.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium] | diamond | 150 | 103 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28460084 | 28460084 | PRJNA1126661_P_NODE_29986_length_326_cov_2.545455_g29457_i0 | PRJNA1126661 | 29986 | 326 | 2.545455 | 8.2981833 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 99.4 | 1.16e-21 | NR | MCA1947273.1 | 2033014 | g29457 | i0 | 100 | 0.460122699386503 | 50 | 0 | 46 | 0 | 1 | 150 | 439 | 488 | MCA1947273.1 esterase family protein [Armatimonadota bacterium] | diamond | 150 | 99.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28523163 | 28523163 | PRJNA1126661_P_NODE_42747_length_300_cov_6.365639_g42218_i0 | PRJNA1126661 | 42747 | 300 | 6.365639 | 19.096917 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 102 | 5.77e-23 | NR | MCA1996741.1 | 2033014 | g42218 | i0 | 91.1 | 0.56 | 56 | 5 | 56 | 0 | 132 | 299 | 296 | 351 | MCA1996741.1 DEAD/DEAH box helicase [Armatimonadota bacterium] | diamond | 168 | 102 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28870281 | 28870281 | PRJNA1126661_P_NODE_16908_length_326_cov_4.553360_g16379_i0 | PRJNA1126661 | 16908 | 326 | 4.55336 | 14.8439536 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 101 | 2.04e-22 | NR | MCA1997509.1 | 2033014 | g16379 | i0 | 49.3 | 1.25153374233129 | 136 | 11 | 71.8 | 1 | 91 | 324 | 301 | 436 | MCA1997509.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium] | diamond | 408 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29880961 | 29880961 | PRJNA1126661_P_NODE_48671_length_297_cov_6.272321_g48142_i0 | PRJNA1126661 | 48671 | 297 | 6.272321 | 18.62879337 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 115 | 2.4e-28 | NR | MCA1996260.1 | 2033014 | g48142 | i0 | 100 | 1.18181818181818 | 59 | 0 | 59.6 | 0 | 295 | 119 | 338 | 396 | MCA1996260.1 NAD/NADP octopine/nopaline dehydrogenase family protein [Armatimonadota bacterium] | diamond | 351 | 115 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30260156 | 30260156 | PRJNA1126661_P_NODE_75712_length_238_cov_8.436364_g75182_i0 | PRJNA1126661 | 75712 | 238 | 8.436364 | 20.07854632 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 62.8 | 3.66e-10 | NR | MBV9850372.1 | 2033014 | g75182 | i0 | 49.2 | 0.794117647058823 | 63 | 32 | 79.4 | 0 | 49 | 237 | 27 | 89 | MBV9850372.1 hypothetical protein [Armatimonadota bacterium] | diamond | 189 | 62.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30670541 | 30670541 | PRJNA1126661_P_NODE_16553_length_326_cov_4.632411_g16024_i0 | PRJNA1126661 | 16553 | 326 | 4.632411 | 15.10165986 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 106 | 3.64e-24 | NR | HCE00276.1 | 2033014 | g16024 | i0 | 100 | 0.920245398773006 | 50 | 0 | 46 | 0 | 151 | 2 | 577 | 626 | HCE00276.1 hypothetical protein [Armatimonadota bacterium] | diamond | 300 | 106 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30702193 | 30702193 | PRJNA1126661_P_NODE_62014_length_273_cov_3.225000_g61484_i0 | PRJNA1126661 | 62014 | 273 | 3.225 | 8.80425 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 44.3 | 0.0068 | NR | MCA1948888.1 | 2033014 | g61484 | i0 | 100 | 0.505494505494505 | 23 | 0 | 25.3 | 0 | 273 | 205 | 100 | 122 | MCA1948888.1 chemotaxis protein CheW [Armatimonadota bacterium] | diamond | 138 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30796926 | 30796926 | PRJNA1126661_P_NODE_22954_length_326_cov_3.462451_g22425_i0 | PRJNA1126661 | 22954 | 326 | 3.462451 | 11.28759026 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 185 | 1.0199999999999998e-55 | NR | MCA1948522.1 | 2033014 | g22425 | i0 | 81.3 | 1.1319018404908 | 123 | 8 | 99.4 | 1 | 325 | 2 | 112 | 234 | MCA1948522.1 HD-GYP domain-containing protein [Armatimonadota bacterium] | diamond | 369 | 185 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30828553 | 30828553 | PRJNA1126661_P_NODE_20194_length_326_cov_3.893281_g19665_i0 | PRJNA1126661 | 20194 | 326 | 3.893281 | 12.69209606 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 187 | 3.4899999999999995e-54 | NR | HCE01553.1 | 2033014 | g19665 | i0 | 91.7 | 1.98773006134969 | 108 | 1 | 99.4 | 1 | 326 | 3 | 403 | 502 | HCE01553.1 hypothetical protein [Armatimonadota bacterium] | diamond | 648 | 187 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31050079 | 31050079 | PRJNA1126661_P_NODE_46215_length_299_cov_3.654867_g45686_i0 | PRJNA1126661 | 46215 | 299 | 3.654867 | 10.92805233 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 108 | 3.0200000000000003e-27 | NR | MCA1997851.1 | 2033014 | g45686 | i0 | 66.7 | 1.36454849498328 | 87 | 26 | 87.3 | 2 | 37 | 297 | 24 | 107 | MCA1997851.1 cytochrome c nitrite reductase small subunit [Armatimonadota bacterium] | diamond | 408 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31966753 | 31966753 | PRJNA1126661_P_NODE_17398_length_326_cov_4.434783_g16869_i0 | PRJNA1126661 | 17398 | 326 | 4.434783 | 14.45739258 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 54.3 | 3.19e-6 | NR | MCA1997832.1 | 2033014 | g16869 | i0 | 100 | 0.239263803680982 | 26 | 0 | 23.9 | 0 | 178 | 255 | 159 | 184 | MCA1997832.1 hypothetical protein [Armatimonadota bacterium] | diamond | 78 | 54.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32630828 | 32630828 | PRJNA1126661_P_NODE_47440_length_298_cov_4.684444_g46911_i0 | PRJNA1126661 | 47440 | 298 | 4.684444 | 13.95964312 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 152 | 3.9e-42 | NR | MCA1947992.1 | 2033014 | g46911 | i0 | 61.3 | 1.61073825503356 | 160 | 1 | 99.7 | 1 | 297 | 1 | 107 | 266 | MCA1947992.1 ABC transporter permease subunit [Armatimonadota bacterium] | diamond | 480 | 152 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32693906 | 32693906 | PRJNA1126661_P_NODE_38120_length_301_cov_4.157895_g37591_i0 | PRJNA1126661 | 38120 | 301 | 4.157895 | 12.51526395 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 107 | 6.47e-26 | NR | HCE01459.1 | 2033014 | g37591 | i0 | 100 | 0.498338870431894 | 50 | 0 | 49.8 | 0 | 301 | 152 | 10 | 59 | HCE01459.1 hypothetical protein [Armatimonadota bacterium] | diamond | 150 | 107 | 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);;