contig_metadata
14 rows where bioproject = "PRJNA1000943", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15447831 | 15447831 | PRJNA1000943_P_NODE_15553_length_242_cov_0.923077_g15415_i0 | PRJNA1000943 | 15553 | 242 | 0.923077 | 2.23384634 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 235 | 2.02e-57 | NTclustered | gi|2076447151|gb|CP075366.1| | 2682144 | g15415 | i0 | 84.454 | 36.0743801652893 | 238 | 37 | 98 | 0 | 1 | 238 | 259507 | 259270 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome | blastn | 8730 | 235 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 17996797 | 17996797 | PRJNA1000943_P_NODE_12215_length_250_cov_0.881356_g12077_i0 | PRJNA1000943 | 12215 | 250 | 0.881356 | 2.20339 | Armatimonadota | 67819 | Bacteria | Bacteria | 132 | 1.16e-33 | NR | MBN8690012.1 | 2033014 | g12077 | i0 | 89.3 | 40.5 | 75 | 8 | 90 | 0 | 227 | 3 | 1 | 75 | MBN8690012.1 ATP-dependent Clp protease ATP-binding subunit [Armatimonadota bacterium] | diamond | 10125 | 132 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 19270632 | 19270632 | PRJNA1000943_P_NODE_10396_length_260_cov_1.251337_g10258_i0 | PRJNA1000943 | 10396 | 260 | 1.251337 | 3.2534762 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 303 | 5.92e-78 | NTclustered | gi|2076447151|gb|CP075366.1| | 2682144 | g10258 | i0 | 87.833 | 13.4538461538462 | 263 | 26 | 100 | 6 | 1 | 260 | 894367 | 894626 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome | blastn | 3498 | 303 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 19270699 | 19270699 | PRJNA1000943_P_NODE_1936_length_546_cov_1.484144_g1800_i0 | PRJNA1000943 | 1936 | 546 | 1.484144 | 8.10342624 | Armatimonadetes bacterium Uphvl-Ar2 | 2004468 | Bacteria | Bacteria | 710 | 0 | NTclustered | gi|1199101103|gb|CP021424.1| | 2004468 | g1800 | i0 | 90.128 | 686.910256410256 | 547 | 52 | 100 | 2 | 1 | 546 | 2201939 | 2201394 | Armatimonadetes bacterium Uphvl-Ar2 genome | blastn | 375053 | 710 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar2 | ||||||
| 26749039 | 26749039 | PRJNA1000943_P_NODE_14881_length_243_cov_0.917647_g14743_i0 | PRJNA1000943 | 14881 | 243 | 0.917647 | 2.22988221 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 131 | 1.39e-34 | NR | HVL38048.1 | 2682144 | g14743 | i0 | 73.8 | 1.97530864197531 | 80 | 21 | 98.8 | 0 | 242 | 3 | 141 | 220 | HVL38048.1 saccharopine dehydrogenase C-terminal domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 480 | 131 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26812868 | 26812868 | PRJNA1000943_P_NODE_7161_length_306_cov_1.339056_g7023_i0 | PRJNA1000943 | 7161 | 306 | 1.339056 | 4.09751136 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 90.9 | 8.55e-19 | NR | MCE2768028.1 | 2682144 | g7023 | i0 | 50 | 5.33333333333333 | 86 | 42 | 83.3 | 1 | 305 | 51 | 416 | 501 | MCE2768028.1 MmgE/PrpD family protein [Fimbriimonadaceae bacterium] | diamond | 1632 | 90.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26837251 | 26837251 | PRJNA1000943_P_NODE_14701_length_244_cov_0.912281_g14563_i0 | PRJNA1000943 | 14701 | 244 | 0.912281 | 2.22596564 | Bacillati | 1783272 | Bacteria | Bacteria | 147 | 4.38e-39 | NR | MBX7132201.1 | 2682144 | g14563 | i0 | 97.5 | 1.99180327868852 | 81 | 2 | 99.6 | 0 | 2 | 244 | 412 | 492 | MBX7132201.1 heavy metal translocating P-type ATPase [Fimbriimonadaceae bacterium] | diamond | 486 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26939264 | 26939264 | PRJNA1000943_P_NODE_11582_length_252_cov_0.871508_g11444_i0 | PRJNA1000943 | 11582 | 252 | 0.871508 | 2.19620016 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 127 | 6.879999999999999e-34 | NR | MBS1723656.1 | 2033014 | g11444 | i0 | 73.8 | 3 | 84 | 22 | 100 | 0 | 252 | 1 | 158 | 241 | MBS1723656.1 KH domain-containing protein [Armatimonadota bacterium] | diamond | 756 | 127 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27406497 | 27406497 | PRJNA1000943_P_NODE_7723_length_296_cov_1.605381_g7585_i0 | PRJNA1000943 | 7723 | 296 | 1.605381 | 4.75192776 | FCB group | 1783270 | Bacteria | Bacteria | 46.6 | 0.00259 | NR | MCC7439385.1 | 2033014 | g7585 | i0 | 32.6 | 2.7972972972973 | 92 | 48 | 93.2 | 2 | 13 | 288 | 32 | 109 | MCC7439385.1 DUF5602 domain-containing protein [Armatimonadota bacterium] | diamond | 828 | 46.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28606057 | 28606057 | PRJNA1000943_P_NODE_12007_length_251_cov_0.876404_g11869_i0 | PRJNA1000943 | 12007 | 251 | 0.876404 | 2.19977404 | Bacteria | 2 | Bacteria | Bacteria | 105 | 2.5699999999999997e-24 | NR | MCB0824992.1 | 2033014 | g11869 | i0 | 61 | 5.77290836653386 | 82 | 32 | 98 | 0 | 6 | 251 | 841 | 922 | MCB0824992.1 carboxypeptidase regulatory-like domain-containing protein [Armatimonadota bacterium] | diamond | 1449 | 105 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30697776 | 30697776 | PRJNA1000943_P_NODE_11754_length_251_cov_0.876404_g11616_i0 | PRJNA1000943 | 11754 | 251 | 0.876404 | 2.19977404 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.7 | 0.0353 | NR | MCL5283899.1 | 2033014 | g11616 | i0 | 40 | 0.537848605577689 | 45 | 27 | 53.8 | 0 | 159 | 25 | 179 | 223 | MCL5283899.1 zf-HC2 domain-containing protein [Armatimonadota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30761155 | 30761155 | PRJNA1000943_P_NODE_10794_length_255_cov_1.714286_g10656_i0 | PRJNA1000943 | 10794 | 255 | 1.714286 | 4.3714293 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 92 | 6.07e-20 | NR | MBS1719048.1 | 2033014 | g10656 | i0 | 57.1 | 0.905882352941176 | 77 | 33 | 90.6 | 0 | 250 | 20 | 137 | 213 | MBS1719048.1 TlpA family protein disulfide reductase [Armatimonadota bacterium] | diamond | 231 | 92 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31424763 | 31424763 | PRJNA1000943_P_NODE_15116_length_243_cov_0.917647_g14978_i0 | PRJNA1000943 | 15116 | 243 | 0.917647 | 2.22988221 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 102 | 2.65e-25 | NR | MCU0316902.1 | 2682144 | g14978 | i0 | 59.5 | 0.975308641975309 | 79 | 32 | 97.5 | 0 | 6 | 242 | 77 | 155 | MCU0316902.1 sigma-70 family RNA polymerase sigma factor [Fimbriimonadaceae bacterium] | diamond | 237 | 102 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32713765 | 32713765 | PRJNA1000943_P_NODE_12480_length_249_cov_0.886364_g12342_i0 | PRJNA1000943 | 12480 | 249 | 0.886364 | 2.20704636 | Bacteria | 2 | Bacteria | Bacteria | 81.3 | 2.16e-16 | NR | WP_309685325.1 | 1872638 | g12342 | i0 | 50.7 | 1.55421686746988 | 75 | 32 | 90.4 | 2 | 7 | 231 | 157 | 226 | WP_309685325.1 hypothetical protein [Armatimonas sp.] | diamond | 387 | 81.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas 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);;