RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB43370", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Acidobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJEB43370 · 16 ✖

analysis 1

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
27222915 27222915 PRJEB43370_P_NODE_7503_length_169_cov_0.866667_g7460_i0 PRJEB43370 7503 169 0.866667 1.46466723 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 54.7 8.28e-7   NR HEY2796434.1 2651171 g7460 i0 49.1 0.940828402366864 53 27 94.1 0 160 2 2 54 HEY2796434.1 histone deacetylase [Thermoanaerobaculia bacterium] diamond 159 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27791718 27791718 PRJEB43370_P_NODE_4504_length_211_cov_1.283951_g4461_i0 PRJEB43370 4504 211 1.283951 2.70913661 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 44.7 0.00506   NR HXI45835.1 2952895 g4461 i0 36.9 3.85308056872038 65 38 92.4 1 200 6 588 649 HXI45835.1 carboxypeptidase-like regulatory domain-containing protein [Candidatus Acidiferrales bacterium] diamond 813 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
28391515 28391515 PRJEB43370_P_NODE_9406_length_165_cov_0.896552_g9363_i0 PRJEB43370 9406 165 0.896552 1.4793108 Terriglobia bacterium 2081523 Bacteria Bacteria 47.8 2.17e-4   NR PWU00097.1 2081523 g9363 i0 44.4 0.981818181818182 54 27 98.2 1 163 2 403 453 PWU00097.1 MAG: hypothetical protein C5B51_25935 [Terriglobia bacterium] diamond 162 47.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
28454855 28454855 PRJEB43370_P_NODE_2426_length_277_cov_2.280702_g2383_i0 PRJEB43370 2426 277 2.280702 6.31754454 Acidobacteriota bacterium 1978231 Bacteria Bacteria 60.5 3.25e-8   NR QQS48225.1 1978231 g2383 i0 48.3 2.24187725631769 58 30 62.8 0 1 174 260 317 QQS48225.1 MAG: hypothetical protein IPM66_06180 [Acidobacteriota bacterium] diamond 621 60.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28644268 28644268 PRJEB43370_P_NODE_10967_length_162_cov_0.920354_g10924_i0 PRJEB43370 10967 162 0.920354 1.49097348 Bryobacterales bacterium 2026791 Bacteria Bacteria 90.9 2.56e-20   NR MBL8232142.1 2026791 g10924 i0 74.5 1.01851851851852 55 13 100 1 162 1 54 108 MBL8232142.1 ROK family protein [Bryobacterales bacterium] diamond 165 90.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
28675811 28675811 PRJEB43370_P_NODE_2767_length_260_cov_1.867299_g2724_i0 PRJEB43370 2767 260 1.867299 4.8549774 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 48.9 3.07e-4   NR MFN7919619.1 2212468 g2724 i0 35 0.692307692307692 60 38 69.2 1 15 194 407 465 MFN7919619.1 RICIN domain-containing protein [Bryobacteraceae bacterium] diamond 180 48.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
28801776 28801776 PRJEB43370_P_NODE_4628_length_209_cov_0.975000_g4585_i0 PRJEB43370 4628 209 0.975 2.03775 Acidobacteriota bacterium 1978231 Bacteria Bacteria 57.4 1.57e-8   NR MBI3665728.1 1978231 g4585 i0 42.6 1.95215311004785 68 38 96.2 1 2 202 40 107 MBI3665728.1 RNA-binding protein [Acidobacteriota bacterium] diamond 408 57.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28889949 28889949 PRJEB43370_P_NODE_9828_length_164_cov_0.904348_g9785_i0 PRJEB43370 9828 164 0.904348 1.48313072 Bacteria 2 Bacteria Bacteria 57.4 8.65e-8   NR MDI9627381.1 1978231 g9785 i0 56.3 6.42073170731707 48 20 87.8 1 162 19 315 361 MDI9627381.1 putative Ig domain-containing protein [Acidobacteriota bacterium] diamond 1053 57.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29496616 29496616 PRJEB43370_P_NODE_730_length_509_cov_2.176087_g687_i0 PRJEB43370 730 509 2.176087 11.07628283 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 46.6 0.0116   NR HEX8847449.1 2283092 g687 i0 32.8 0.789783889980354 134 76 71.3 5 388 26 52 184 HEX8847449.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 402 46.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29559622 29559622 PRJEB43370_P_NODE_6390_length_182_cov_1.172932_g6347_i0 PRJEB43370 6390 182 1.172932 2.13473624 Blastocatellia bacterium 2052146 Bacteria Bacteria 87 3.47e-20   NR HQR40340.1 2052146 g6347 i0 75 1.64835164835165 48 12 79.1 0 156 13 20 67 HQR40340.1 peptide-methionine (R)-S-oxide reductase MsrB [Blastocatellia bacterium] diamond 300 87 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30816693 30816693 PRJEB43370_P_NODE_5114_length_200_cov_1.298013_g5071_i0 PRJEB43370 5114 200 1.298013 2.596026 Pseudomonadati 3379134 Bacteria Bacteria 82.8 3.77e-18   NR MDH4063249.1 1978231 g5071 i0 58.1 4.65 62 25 91.5 1 16 198 13 74 MDH4063249.1 DUF1810 domain-containing protein [Acidobacteriota bacterium] diamond 930 82.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31233944 31233944 PRJEB43370_P_NODE_10615_length_162_cov_1.380531_g10572_i0 PRJEB43370 10615 162 1.380531 2.23646022 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 44.7 0.00203   NR HKV34665.1 2283092 g10572 i0 59.5 0.685185185185185 37 15 68.5 0 120 10 109 145 HKV34665.1 MbtH family protein [Pyrinomonadaceae bacterium] diamond 111 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31676829 31676829 PRJEB43370_P_NODE_10757_length_162_cov_0.920354_g10714_i0 PRJEB43370 10757 162 0.920354 1.49097348 Acidobacteriota bacterium 1978231 Bacteria Bacteria 53.1 2.6e-6   NR MEM7247872.1 1978231 g10714 i0 52.5 1.37037037037037 40 19 74.1 0 39 158 1563 1602 MEM7247872.1 hypothetical protein [Acidobacteriota bacterium] diamond 222 53.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31828227 31828227 PRJEB43370_P_NODE_2437_length_277_cov_0.912281_g2394_i0 PRJEB43370 2437 277 0.912281 2.52701837 Pseudomonadati 3379134 Bacteria Bacteria 103 6.1999999999999986e-24   NR HEU0005492.1 2081523 g2394 i0 63.3 6.76895306859206 79 26 85.6 2 32 268 119 194 HEU0005492.1 hypothetical protein [Terriglobia bacterium] diamond 1875 103 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
32214877 32214877 PRJEB43370_P_NODE_5398_length_195_cov_1.424658_g5355_i0 PRJEB43370 5398 195 1.424658 2.7780831 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 80.9 4.91e-17   NR HEV7238021.1 2651171 g5355 i0 63.5 1.95384615384615 63 23 96.9 0 190 2 117 179 HEV7238021.1 metal-dependent phosphohydrolase [Thermoanaerobaculia bacterium] diamond 381 80.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32246763 32246763 PRJEB43370_P_NODE_4398_length_213_cov_1.554878_g4355_i0 PRJEB43370 4398 213 1.554878 3.31189014 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 67.4 4.12e-11   NR MDR3737318.1 2052142 g4355 i0 51.4 1.01408450704225 72 34 100 1 213 1 227 298 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 216 67.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae 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);;