RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA407886", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 26 ✖

tax_phylum 1

  • Acidobacteriota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA407886 · 26 ✖

tax_clade 0

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
4244402 4244402 PRJNA407886_P_NODE_38144_length_356_cov_4.879859_g36450_i0 PRJNA407886 38144 356 4.879859 17.37229804 Acidobacteriota bacterium 1978231 Bacteria Bacteria 152 2.22e-45   NR MDQ7008654.1 1978231 g36450 i0 77.9 1.87078651685393 104 23 87.6 0 36 347 1 104 MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] diamond 666 152 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
6794921 6794921 PRJNA407886_P_NODE_31166_length_407_cov_1.838323_g29472_i0 PRJNA407886 31166 407 1.838323 7.48197461 Pseudomonadati 3379134 Bacteria Bacteria 167 1.8299999999999998e-46   NR MCU1243657.1 1953112 g29472 i0 75.5 10.5036855036855 102 25 75.2 0 405 100 104 205 MCU1243657.1 betaine-aldehyde dehydrogenase [Candidatus Acidiferrum typicum] diamond 4275 167 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum typicum
8070319 8070319 PRJNA407886_P_NODE_24387_length_488_cov_4.113253_g22696_i0 PRJNA407886 24387 488 4.113253 20.07267464 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 52.8 0.048   NTclustered gi|2893358444|emb|OZ220736.1| 2910147 g22696 i0 96.875 0.0655737704918033 32 0 7 1 267 298 4678644 4678614 MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1 blastn 32 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
9345958 9345958 PRJNA407886_P_NODE_62508_length_268_cov_1.158974_g60814_i0 PRJNA407886 62508 268 1.158974 3.10605032 Acidobacteriota bacterium 1978231 Bacteria Bacteria 159 5.439999999999999e-43   NR MCC6745278.1 1978231 g60814 i0 97.7 0.985074626865672 88 2 98.5 0 266 3 296 383 MCC6745278.1 efflux RND transporter permease subunit [Acidobacteriota bacterium] diamond 264 159 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
13171400 13171400 PRJNA407886_P_NODE_54491_length_290_cov_1.064516_g52797_i0 PRJNA407886 54491 290 1.064516 3.0870964 Acidobacteriota bacterium 1978231 Bacteria Bacteria 64.7 6.27e-10   NR MEK7723144.1 1978231 g52797 i0 35.9 2.8448275862069 92 59 95.2 0 9 284 78 169 MEK7723144.1 CAP domain-containing protein [Acidobacteriota bacterium] diamond 825 64.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
18268827 18268827 PRJNA407886_P_NODE_33535_length_388_cov_0.965079_g31841_i0 PRJNA407886 33535 388 0.965079 3.74450652 Geothrix sp. 21YS21S-2 3068893 Bacteria Bacteria 52.8 0.037   NTclustered gi|2566094019|gb|CP132910.1| 3068893 g31841 i0 100 0.0721649484536082 28 0 7 0 83 110 3145768 3145741 Geothrix sp. 21YS21S-2 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp. 21YS21S-2
18269552 18269552 PRJNA407886_P_NODE_67775_length_255_cov_1.692308_g66081_i0 PRJNA407886 67775 255 1.692308 4.3153854 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 62.1 3.85e-5   NTclustered gi|2874253744|emb|OY969603.1| 171953 g66081 i0 93.023 0.168627450980392 43 1 16 2 104 145 554410 554451 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1 blastn 43 62.1 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20818673 20818673 PRJNA407886_P_NODE_23777_length_498_cov_2.875294_g22086_i0 PRJNA407886 23777 498 2.875294 14.31896412 Acidobacteriota bacterium 1978231 Bacteria Bacteria 132 1.05e-36   NR MDQ7008653.1 1978231 g22086 i0 78.9 0.542168674698795 90 19 54.2 0 381 112 22 111 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 270 132 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26902511 26902511 PRJNA407886_P_NODE_47541_length_313_cov_1.925000_g45847_i0 PRJNA407886 47541 313 1.925 6.02525 Pseudomonadati 3379134 Bacteria Bacteria 86.7 3.25e-17   NR HMV46425.1 2052146 g45847 i0 52.8 7.79233226837061 106 38 93.9 3 308 15 359 460 HMV46425.1 DUF4394 domain-containing protein [Blastocatellia bacterium] diamond 2439 86.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
27043891 27043891 PRJNA407886_P_NODE_46862_length_316_cov_1.259259_g45168_i0 PRJNA407886 46862 316 1.259259 3.97925844 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 51.2 9.01e-5   NR MBY0503409.1 2212468 g45168 i0 42.4 1.31962025316456 66 36 60.8 2 264 73 312 377 MBY0503409.1 hypothetical protein [Bryobacteraceae bacterium] diamond 417 51.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27075516 27075516 PRJNA407886_P_NODE_76242_length_245_cov_2.197674_g74548_i0 PRJNA407886 76242 245 2.197674 5.3843013 Terracidiphilus sp. 1964191 Bacteria Bacteria 55.1 4e-7   NR HUA92617.1 1964191 g74548 i0 39.4 2.65714285714286 71 42 86.9 1 5 217 80 149 HUA92617.1 GyrI-like domain-containing protein [Terracidiphilus sp.] diamond 651 55.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
27170094 27170094 PRJNA407886_P_NODE_59882_length_274_cov_3.169154_g58188_i0 PRJNA407886 59882 274 3.169154 8.68348196 Acidobacteriota bacterium 1978231 Bacteria Bacteria 49.3 2.27e-4   NR MDT5123475.1 1978231 g58188 i0 38.3 2.37591240875912 81 45 84.3 2 2 232 93 172 MDT5123475.1 hypothetical protein [Acidobacteriota bacterium] diamond 651 49.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27233595 27233595 PRJNA407886_P_NODE_80663_length_242_cov_0.911243_g78969_i0 PRJNA407886 80663 242 0.911243 2.20520806 Acidobacteriota bacterium 1978231 Bacteria Bacteria 73.2 7.12e-13   NR MBS1768271.1 1978231 g78969 i0 43 1.99586776859504 79 44 96.7 1 8 241 1210 1288 MBS1768271.1 hypothetical protein [Acidobacteriota bacterium] diamond 483 73.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27328504 27328504 PRJNA407886_P_NODE_66263_length_258_cov_3.416216_g64569_i0 PRJNA407886 66263 258 3.416216 8.81383728 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 48.9 2.77e-4   NR MDR3737355.1 2052142 g64569 i0 39.5 1 86 46 96.5 3 251 3 172 254 MDR3737355.1 C1 family peptidase [Acidobacteriaceae bacterium] diamond 258 48.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
27454937 27454937 PRJNA407886_P_NODE_35623_length_373_cov_1.186667_g33929_i0 PRJNA407886 35623 373 1.186667 4.42626791 Terriglobales bacterium 2282142 Bacteria Bacteria 44.7 0.034   NR HEY6936921.1 2282142 g33929 i0 33.3 0.579088471849866 72 36 48.3 2 189 10 723 794 HEY6936921.1 hypothetical protein [Terriglobales bacterium] diamond 216 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
27770697 27770697 PRJNA407886_P_NODE_77044_length_245_cov_0.895349_g75350_i0 PRJNA407886 77044 245 0.895349 2.19360505 Acidobacteriota bacterium 1978231 Bacteria Bacteria 43.9 0.0153   NR MEP6945755.1 1978231 g75350 i0 66.7 0.330612244897959 27 9 33.1 0 125 45 1166 1192 MEP6945755.1 CHAT domain-containing protein [Acidobacteriota bacterium] diamond 81 43.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27959871 27959871 PRJNA407886_P_NODE_59825_length_275_cov_1.113861_g58131_i0 PRJNA407886 59825 275 1.113861 3.06311775 Acidobacteriota bacterium 1978231 Bacteria Bacteria 127 8.24e-36   NR MDQ7008653.1 1978231 g58131 i0 81.2 0.927272727272727 85 16 92.7 0 255 1 22 106 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 255 127 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29128388 29128388 PRJNA407886_P_NODE_42369_length_335_cov_1.019084_g40675_i0 PRJNA407886 42369 335 1.019084 3.4139314 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 65.1 1.59e-9   NR MEO6324750.1 2651171 g40675 i0 37.2 1.08358208955224 121 56 90.4 2 334 32 61 181 MEO6324750.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 363 65.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29285878 29285878 PRJNA407886_P_NODE_65449_length_260_cov_2.326203_g63755_i0 PRJNA407886 65449 260 2.326203 6.0481278 Terriglobales bacterium 2282142 Bacteria Bacteria 42.4 0.0339   NR HZU41573.1 2282142 g63755 i0 33.8 0.853846153846154 74 47 83.1 1 247 32 30 103 HZU41573.1 hypothetical protein [Terriglobales bacterium] diamond 222 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
29776188 29776188 PRJNA407886_P_NODE_74691_length_247_cov_0.885057_g72997_i0 PRJNA407886 74691 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 101 1.85e-25   NR HTC90217.1 2212468 g72997 i0 61 1.93117408906883 77 30 93.5 0 231 1 1 77 HTC90217.1 hypothetical protein [Bryobacteraceae bacterium] diamond 477 101 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
29980752 29980752 PRJNA407886_P_NODE_49871_length_304_cov_2.662338_g48177_i0 PRJNA407886 49871 304 2.662338 8.09350752 Terriglobia bacterium 2081523 Bacteria Bacteria 120 1.14e-29   NR MDT8066797.1 2081523 g48177 i0 58.1 9.07894736842105 93 38 91.8 1 299 21 347 438 MDT8066797.1 homogentisate 1,2-dioxygenase [Terriglobia bacterium] diamond 2760 120 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
30265397 30265397 PRJNA407886_P_NODE_68292_length_254_cov_1.337017_g66598_i0 PRJNA407886 68292 254 1.337017 3.39602318 Acidobacteriota bacterium 1978231 Bacteria Bacteria 78.6 6.03e-15   NR MDT5158201.1 1978231 g66598 i0 42.9 2.97637795275591 84 48 99.2 0 2 253 136 219 MDT5158201.1 NADPH:quinone reductase [Acidobacteriota bacterium] diamond 756 78.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30707365 30707365 PRJNA407886_P_NODE_71154_length_250_cov_0.870056_g69460_i0 PRJNA407886 71154 250 0.870056 2.17514 Acidobacteriota bacterium 1978231 Bacteria Bacteria 91.7 2.52e-19   NR PIE02207.1 1978231 g69460 i0 60 0.9 75 30 90 0 246 22 628 702 PIE02207.1 MAG: hypothetical protein CSA81_08195 [Acidobacteriota bacterium] diamond 225 91.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31482918 31482918 PRJNA407886_P_NODE_77996_length_244_cov_0.900585_g76302_i0 PRJNA407886 77996 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 72 1.57e-12   NR HEX4951506.1 2052146 g76302 i0 46.3 4.0327868852459 82 42 99.6 2 243 1 271 351 HEX4951506.1 phosphodiester glycosidase family protein [Blastocatellia bacterium] diamond 984 72.4 0.994475138121547 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
31719017 31719017 PRJNA407886_P_NODE_32557_length_395_cov_3.869565_g30863_i0 PRJNA407886 32557 395 3.869565 15.28478175 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 90.5 1.22e-18   NR MDR3737318.1 2052142 g30863 i0 44.3 0.926582278481013 122 61 88.9 3 2 352 188 307 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 366 90.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
32478589 32478589 PRJNA407886_P_NODE_61539_length_270_cov_1.563452_g59845_i0 PRJNA407886 61539 270 1.563452 4.2213204 Acidobacteriota bacterium 1978231 Bacteria Bacteria 62.8 4.37e-9   NR MEM7582641.1 1978231 g59845 i0 63.6 3.43333333333333 44 16 48.9 0 3 134 409 452 MEM7582641.1 aspartate aminotransferase family protein [Acidobacteriota bacterium] diamond 927 62.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;