RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Bipolaricaulota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Bipolaricaulota · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA1148190 · 21 ✖

analysis 1

  • diamond · 21 ✖

tax_kingdom 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
18151369 18151369 PRJNA1148190_P_NODE_744255_length_243_cov_0.905882_g733082_i0 PRJNA1148190 744255 243 0.905882 2.20129326 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 126 1.6299999999999996e-31   NR MCX6096618.1 2306012 g733082 i0 71.6 1 81 23 100 0 1 243 533 613 MCX6096618.1 DEAD/DEAH box helicase family protein [Candidatus Bipolaricaulota bacterium] diamond 243 126 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
26882016 26882016 PRJNA1148190_P_NODE_719581_length_244_cov_0.900585_g708408_i0 PRJNA1148190 719581 244 0.900585 2.1974274 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 96.3 3.46e-21   NR MBI1730870.1 2053493 g708408 i0 62 1.88114754098361 71 27 87.3 0 214 2 239 309 MBI1730870.1 hypothetical protein [Candidatus Acetothermia bacterium] diamond 459 96.3 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
27134268 27134268 PRJNA1148190_P_NODE_573302_length_252_cov_2.229050_g562129_i0 PRJNA1148190 573302 252 2.22905 5.617206 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 75.9 4.53e-14   NR MBI1743626.1 2053493 g562129 i0 52.5 0.952380952380952 80 38 95.2 0 12 251 112 191 MBI1743626.1 histidine kinase [Candidatus Acetothermia bacterium] diamond 240 75.9 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
27229167 27229167 PRJNA1148190_P_NODE_433403_length_280_cov_0.898551_g422230_i0 PRJNA1148190 433403 280 0.898551 2.5159428 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 64.7 1.06e-9   NR HUT22193.1 2306012 g422230 i0 42.7 2.03571428571429 96 51 99.6 2 280 2 99 193 HUT22193.1 tyrosine/phenylalanine carboxypeptidase domain-containing protein [Candidatus Bipolaricaulota bacterium] diamond 570 64.7 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
27292793 27292793 PRJNA1148190_P_NODE_610663_length_250_cov_0.870056_g599490_i0 PRJNA1148190 610663 250 0.870056 2.17514 Candidatus Bipolaricaulia bacterium 3121610 Bacteria Bacteria 99.4 4.11e-22   NR MFB6287141.1 3121610 g599490 i0 64.7 2.004 85 25 98.4 2 246 1 166 248 MFB6287141.1 Eco57I restriction-modification methylase domain-containing protein [Candidatus Bipolaricaulia bacterium] diamond 501 99.4 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota Candidatus Bipolaricaulia       Candidatus Bipolaricaulia bacterium
27576226 27576226 PRJNA1148190_P_NODE_155444_length_422_cov_1.126074_g144277_i0 PRJNA1148190 155444 422 1.126074 4.75203228 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 60.5 8.33e-9   NR MEA3356607.1 2306012 g144277 i0 50.9 1.11611374407583 53 24 37.7 1 207 365 1 51 MEA3356607.1 MazG nucleotide pyrophosphohydrolase domain-containing protein [Candidatus Bipolaricaulota bacterium] diamond 471 60.5 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
27672015 27672015 PRJNA1148190_P_NODE_661144_length_247_cov_0.885057_g649971_i0 PRJNA1148190 661144 247 0.885057 2.18609079 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 85.5 1.51e-17   NR RLE33564.1 2053493 g649971 i0 55.7 3.78947368421053 79 35 96 0 2 238 236 314 RLE33564.1 MAG: hypothetical protein DRJ24_05115 [Candidatus Acetothermia bacterium] diamond 936 85.5 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
27975484 27975484 PRJNA1148190_P_NODE_290945_length_324_cov_0.916335_g279774_i0 PRJNA1148190 290945 324 0.916335 2.9689254 Bacillati 1783272 Bacteria Bacteria 90.9 1.24e-18   NR HDL85094.1 2053493 g279774 i0 39.1 3.23148148148148 115 49 99.1 3 1 321 288 389 HDL85094.1 hypothetical protein [Candidatus Acetothermia bacterium] diamond 1047 90.9 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
28271699 28271699 PRJNA1148190_P_NODE_764606_length_242_cov_0.911243_g753433_i0 PRJNA1148190 764606 242 0.911243 2.20520806 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 49.7 1.31e-4   NR HCP32013.1 2053493 g753433 i0 38.4 1.74793388429752 73 42 90.5 1 226 8 381 450 HCP32013.1 cell division protein FtsH [Candidatus Acetothermia bacterium] diamond 423 49.7 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
28523548 28523548 PRJNA1148190_P_NODE_143367_length_439_cov_1.579235_g132202_i0 PRJNA1148190 143367 439 1.579235 6.93284165 Candidatus Bipolaricaulis anaerobius 2026885 Bacteria Bacteria 72 7.67e-12   NR HQM38402.1 2026885 g132202 i0 50 2.58314350797267 64 32 43.7 0 247 56 83 146 HQM38402.1 hypothetical protein [Candidatus Bipolaricaulis anaerobius] diamond 1134 72 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota Candidatus Bipolaricaulia Candidatus Bipolaricaulales Candidatus Bipolaricaulaceae Candidatus Bipolaricaulis Candidatus Bipolaricaulis anaerobius
29503202 29503202 PRJNA1148190_P_NODE_782910_length_241_cov_0.916667_g771737_i0 PRJNA1148190 782910 241 0.916667 2.20916747 Candidatus Bipolaricaulis sp. 2814139 Bacteria Bacteria 43.9 0.0146   NR MDD5219019.1 2814139 g771737 i0 58.3 0.448132780082988 36 14 44.8 1 109 2 533 567 MDD5219019.1 hypothetical protein [Candidatus Bipolaricaulis sp.] diamond 108 43.9 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota Candidatus Bipolaricaulia Candidatus Bipolaricaulales Candidatus Bipolaricaulaceae Candidatus Bipolaricaulis Candidatus Bipolaricaulis sp.
29743385 29743385 PRJNA1148190_P_NODE_177550_length_396_cov_3.046440_g166381_i0 PRJNA1148190 177550 396 3.04644 12.0639024 Bacteria 2 Bacteria Bacteria 48.9 0.00144   NR MCI2426493.1 2053493 g166381 i0 30.8 2.76515151515152 117 78 87.1 2 378 34 927 1042 MCI2426493.1 DNA polymerase III subunit alpha [Candidatus Acetothermia bacterium] diamond 1095 49.3 0.991886409736308 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
29818002 29818002 PRJNA1148190_P_NODE_266571_length_335_cov_1.175573_g255400_i0 PRJNA1148190 266571 335 1.175573 3.93816955 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 188 2.7199999999999995e-55   NR MCK4682108.1 2306012 g255400 i0 77.5 2.98208955223881 111 25 99.4 0 3 335 228 338 MCK4682108.1 group II intron reverse transcriptase/maturase [Candidatus Bipolaricaulota bacterium] diamond 999 188 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
29913371 29913371 PRJNA1148190_P_NODE_414871_length_283_cov_1.576190_g403698_i0 PRJNA1148190 414871 283 1.57619 4.4606177 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 104 9.28e-24   NR HDL86511.1 2053493 g403698 i0 63.7 0.964664310954064 91 30 93.3 2 279 16 272 362 HDL86511.1 hypothetical protein [Candidatus Acetothermia bacterium] diamond 273 104 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
30451085 30451085 PRJNA1148190_P_NODE_726033_length_244_cov_0.900585_g714860_i0 PRJNA1148190 726033 244 0.900585 2.1974274 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 41.6 0.0417   NR MCK4356881.1 2306012 g714860 i0 35.7 1.0327868852459 84 34 78.7 2 10 201 16 99 MCK4356881.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Bipolaricaulota bacterium] diamond 252 41.6 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
30987143 30987143 PRJNA1148190_P_NODE_176454_length_398_cov_0.923077_g165285_i0 PRJNA1148190 176454 398 0.923077 3.67384646 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 48.9 7.5e-4   NR MCX6092913.1 2306012 g165285 i0 60.5 0.324120603015075 43 17 32.4 0 12 140 1 43 MCX6092913.1 hypothetical protein [Candidatus Bipolaricaulota bacterium] diamond 129 48.9 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
31588792 31588792 PRJNA1148190_P_NODE_689296_length_246_cov_0.890173_g678123_i0 PRJNA1148190 689296 246 0.890173 2.18982558 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 82 1.42e-16   NR MEE8566219.1 2306012 g678123 i0 56 0.914634146341463 75 31 89 2 245 27 130 204 MEE8566219.1 hypothetical protein [Candidatus Bipolaricaulota bacterium] diamond 225 82 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota bacterium
31810021 31810021 PRJNA1148190_P_NODE_673997_length_246_cov_1.982659_g662824_i0 PRJNA1148190 673997 246 1.982659 4.87734114 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 92 2.04e-21   NR MBI1743260.1 2053493 g662824 i0 64.1 3.10975609756098 64 23 78 0 46 237 1 64 MBI1743260.1 ATP-binding protein [Candidatus Acetothermia bacterium] diamond 765 92 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
32284866 32284866 PRJNA1148190_P_NODE_632519_length_249_cov_0.875000_g621346_i0 PRJNA1148190 632519 249 0.875 2.17875 Candidatus Bipolaricaulis sp. 2814139 Bacteria Bacteria 127 3.9999999999999997e-32   NR MDD5220728.1 2814139 g621346 i0 65.9 0.987951807228916 82 28 98.8 0 2 247 402 483 MDD5220728.1 DNA methyltransferase [Candidatus Bipolaricaulis sp.] diamond 246 127 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota Candidatus Bipolaricaulia Candidatus Bipolaricaulales Candidatus Bipolaricaulaceae Candidatus Bipolaricaulis Candidatus Bipolaricaulis sp.
32694352 32694352 PRJNA1148190_P_NODE_192080_length_383_cov_1.296774_g180910_i0 PRJNA1148190 192080 383 1.296774 4.96664442 Candidatus Bipolaricaulis anaerobius 2026885 Bacteria Bacteria 57.4 4.86e-8   NR HOD74145.1 2026885 g180910 i0 44.9 0.994778067885117 69 37 53.3 1 178 381 1 69 HOD74145.1 hypothetical protein [Candidatus Bipolaricaulis anaerobius] diamond 381 57.4 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota Candidatus Bipolaricaulia Candidatus Bipolaricaulales Candidatus Bipolaricaulaceae Candidatus Bipolaricaulis Candidatus Bipolaricaulis anaerobius
32821456 32821456 PRJNA1148190_P_NODE_79280_length_615_cov_1.977860_g68156_i0 PRJNA1148190 79280 615 1.97786 12.163839 Candidatus Bipolaricaulota bacterium 2306012 Bacteria Bacteria 48.5 0.00168   NR MCK4599544.1 2306012 g68156 i0 31.6 0.385365853658537 79 54 38.5 0 500 264 11 89 MCK4599544.1 hypothetical protein [Candidatus Bipolaricaulota bacterium] diamond 237 48.5 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Bipolaricaulota 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);;