RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA431371", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 17 ✖

tax_phylum 1

  • Chloroflexota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA431371 · 17 ✖

analysis 1

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
23380246 23380246 PRJNA431371_P_NODE_18539_length_297_cov_1.375000_g18466_i0 PRJNA431371 18539 297 1.375 4.08375 FCB group 1783270 Bacteria Bacteria 111 3.57e-28   NR HEC23500.1 2026724 g18466 i0 53.6 7.86868686868687 97 45 98 0 293 3 72 168 HEC23500.1 superoxide dismutase [Chloroflexota bacterium] diamond 2337 111 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26934036 26934036 PRJNA431371_P_NODE_6002_length_494_cov_1.684086_g5929_i0 PRJNA431371 6002 494 1.684086 8.31938484 Chloroflexota 200795 Bacteria Bacteria 56.2 9.56e-6   NR MCL0079142.1 2026734 g5929 i0 32.1 1.90080971659919 106 70 63.2 1 6 317 581 686 MCL0079142.1 Ig-like domain-containing protein [Dehalococcoidia bacterium] diamond 939 56.2 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
27613015 27613015 PRJNA431371_P_NODE_9004_length_414_cov_1.302053_g8931_i0 PRJNA431371 9004 414 1.302053 5.39049942 Chloroflexota bacterium 2026724 Bacteria Bacteria 48.1 0.00303   NR MEM9775433.1 2026724 g8931 i0 31 0.608695652173913 84 55 58.7 1 43 285 480 563 MEM9775433.1 cyclic nucleotide-binding domain-containing protein [Chloroflexota bacterium] diamond 252 48.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27676242 27676242 PRJNA431371_P_NODE_20944_length_279_cov_1.373786_g20871_i0 PRJNA431371 20944 279 1.373786 3.83286294 Chloroflexota bacterium 2026724 Bacteria Bacteria 43.1 0.0401   NR HVA23224.1 2026724 g20871 i0 32.1 0.602150537634409 56 38 60.2 0 250 83 31 86 HVA23224.1 allantoinase AllB [Chloroflexota bacterium] diamond 168 43.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27991892 27991892 PRJNA431371_P_NODE_4885_length_538_cov_1.432258_g4812_i0 PRJNA431371 4885 538 1.432258 7.70554804 Chloroflexota bacterium 2026724 Bacteria Bacteria 45.8 0.0482   NR NCF64937.1 2026724 g4812 i0 29.4 0.607806691449814 109 67 60.8 2 5 331 19 117 NCF64937.1 response regulator [Chloroflexota bacterium] diamond 327 45.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28117927 28117927 PRJNA431371_P_NODE_15325_length_327_cov_1.066929_g15252_i0 PRJNA431371 15325 327 1.066929 3.48885783 Chloroflexota bacterium 2026724 Bacteria Bacteria 43.9 0.0385   NR MCY3896106.1 2026724 g15252 i0 48.9 0.412844036697248 45 20 38.5 1 187 62 765 809 MCY3896106.1 type I DNA topoisomerase [Chloroflexota bacterium] diamond 135 43.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28370557 28370557 PRJNA431371_P_NODE_1486_length_826_cov_1.907039_g1420_i0 PRJNA431371 1486 826 1.907039 15.75214214 Anaerolineae bacterium 2052143 Bacteria Bacteria 115 5.92e-25   NR MCB0191143.1 2052143 g1420 i0 42.9 0.566585956416465 156 76 55.6 3 48 506 39 184 MCB0191143.1 glycosyltransferase [Anaerolineae bacterium] diamond 468 115 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28875776 28875776 PRJNA431371_P_NODE_15728_length_323_cov_1.232000_g15655_i0 PRJNA431371 15728 323 1.232 3.97936 Chloroflexota bacterium 2026724 Bacteria Bacteria 68.9 6.06e-11   NR MEI7469404.1 2026724 g15655 i0 37.8 0.910216718266254 98 59 91 2 323 30 14 109 MEI7469404.1 RHS repeat-associated core domain-containing protein [Chloroflexota bacterium] diamond 294 68.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28939101 28939101 PRJNA431371_P_NODE_8128_length_433_cov_1.991667_g8055_i0 PRJNA431371 8128 433 1.991667 8.62391811 Aggregatilineales bacterium 2952883 Bacteria Bacteria 87.4 7.44e-17   NR MEQ8675514.1 2952883 g8055 i0 40 0.969976905311778 140 74 92.8 5 429 28 101 236 MEQ8675514.1 protein kinase [Aggregatilineales bacterium] diamond 420 87.4 1 Bacteria   Bacillati Chloroflexota Anaerolineae Aggregatilineales     Aggregatilineales bacterium
29349512 29349512 PRJNA431371_P_NODE_24589_length_251_cov_1.297753_g24516_i0 PRJNA431371 24589 251 1.297753 3.25736003 Candidatus Villigracilis vicinus 3140679 Bacteria Bacteria 63.9 1.18e-10   NR WP_345101659.1 3140679 g24516 i0 50 1.86454183266932 52 26 62.2 0 249 94 65 116 WP_345101659.1 alpha/beta hydrolase [Candidatus Villigracilis vicinus] diamond 468 63.9 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Candidatus Villigracilaceae Candidatus Villigracilis Candidatus Villigracilis vicinus
29917959 29917959 PRJNA431371_P_NODE_5571_length_510_cov_1.295195_g5498_i0 PRJNA431371 5571 510 1.295195 6.6054945 Chloroflexota bacterium 2026724 Bacteria Bacteria 104 6.18e-23   NR MDA0769156.1 2026724 g5498 i0 40.4 1.82941176470588 146 80 81.8 3 13 429 138 283 MDA0769156.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Chloroflexota bacterium] diamond 933 104 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30044092 30044092 PRJNA431371_P_NODE_28451_length_248_cov_0.880000_g28378_i0 PRJNA431371 28451 248 0.88 2.1824 Candidatus Thermofonsia Clade 3 bacterium 2364212 Bacteria Bacteria 43.1 0.0277   NR PJF47227.1 2364212 g28378 i0 36.5 0.895161290322581 74 42 84.7 2 248 39 191 263 PJF47227.1 MAG: hypothetical protein CUN48_09760 [Candidatus Thermofonsia Clade 3 bacterium] diamond 222 43.1 1 Bacteria Candidatus Thermofonsia Clade 3 Bacillati Chloroflexota Candidatus Thermofontia       Candidatus Thermofonsia Clade 3 bacterium
30218558 30218558 PRJNA431371_P_NODE_4232_length_569_cov_3.008065_g4159_i0 PRJNA431371 4232 569 3.008065 17.11588985 root 1 Root_unresolved Root_unresolved 136 7.659999999999999e-37   NR HID14894.1 2052143 g4159 i0 52.3 8.3884007029877 132 61 69.6 1 397 2 18 147 HID14894.1 biotin transporter BioY [Anaerolineae bacterium] diamond 4773 137 0.992700729927007 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30707619 30707619 PRJNA431371_P_NODE_3874_length_588_cov_1.634951_g3801_i0 PRJNA431371 3874 588 1.634951 9.61351188 Chloroflexota bacterium 2026724 Bacteria Bacteria 89 2.18e-17   NR MEX0710518.1 2026724 g3801 i0 51.3 3.26020408163265 80 38 40.3 1 548 312 215 294 MEX0710518.1 phosphoglycerate kinase [Chloroflexota bacterium] diamond 1917 89 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31103175 31103175 PRJNA431371_P_NODE_16255_length_318_cov_1.571429_g16182_i0 PRJNA431371 16255 318 1.571429 4.99714422 Chloroflexota 200795 Bacteria Bacteria 77 4.86e-14   NR RPH61200.1 2026724 g16182 i0 45.6 3.39622641509434 90 49 84.9 0 48 317 193 282 RPH61200.1 MAG: alpha/beta hydrolase [Chloroflexota bacterium] diamond 1080 77 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31339646 31339646 PRJNA431371_P_NODE_21036_length_278_cov_1.848780_g20963_i0 PRJNA431371 21036 278 1.84878 5.1396084 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 43.5 0.0309   NR HEU0244959.1 2952938 g20963 i0 54.9 0.550359712230216 51 18 55 1 3 155 100 145 HEU0244959.1 tetratricopeptide repeat protein [Candidatus Limnocylindrales bacterium] diamond 153 43.5 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
32130744 32130744 PRJNA431371_P_NODE_14098_length_339_cov_1.157895_g14025_i0 PRJNA431371 14098 339 1.157895 3.92526405 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 56.6 4.05e-7   NR MBL7208863.1 2026734 g14025 i0 31.6 1.69026548672566 98 62 82.3 1 282 4 66 163 MBL7208863.1 hypothetical protein [Dehalococcoidia bacterium] diamond 573 56.6 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia 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);;