RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1136505" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1136505 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
13038226 13038226 PRJNA1136505_P_NODE_17271_length_1387_cov_4.478691_g12075_i0 PRJNA1136505 17271 1387 4.478691 62.11944417 Candidatus Acidiferrum 2817524 Bacteria Bacteria 602 3.239999999999999e-211   NR HUI42780.1 2081523 g12075 i0 70.2 17.6085075702956 426 121 92.1 2 1288 11 17 436 HUI42780.1 aldehyde dehydrogenase family protein [Terriglobia bacterium] diamond 24423 602 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
22708878 22708878 PRJNA1136505_P_NODE_94738_length_297_cov_1.031250_g87878_i0 PRJNA1136505 94738 297 1.03125 3.0628125 Acidobacteriota bacterium 1978231 Bacteria Bacteria 156 3.7399999999999997e-42   NR MDY7094637.1 1978231 g87878 i0 70.4 7.91919191919192 98 23 99 1 295 2 264 355 MDY7094637.1 acetate--CoA ligase [Acidobacteriota bacterium] diamond 2352 156 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26838081 26838081 PRJNA1136505_P_NODE_23961_length_912_cov_1.206198_g17596_i0 PRJNA1136505 23961 912 1.206198 11.00052576 Pseudomonadati 3379134 Bacteria Bacteria 137 3.1599999999999997e-32   NR MDX2437036.1 1978231 g17596 i0 45.6 4.46381578947368 149 78 48.7 2 858 415 552 698 MDX2437036.1 M4 family metallopeptidase [Acidobacteriota bacterium] diamond 4071 138 0.992753623188406 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27228308 27228308 PRJNA1136505_P_NODE_157483_length_233_cov_2.075000_g150623_i0 PRJNA1136505 157483 233 2.075 4.83475 Acidobacteriota bacterium 1978231 Bacteria Bacteria 49.7 1.06e-4   NR MDJ0840724.1 1978231 g150623 i0 53.7 0.527896995708155 41 18 52.8 1 28 150 248 287 MDJ0840724.1 class II glutamine amidotransferase [Acidobacteriota bacterium] diamond 123 49.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27449760 27449760 PRJNA1136505_P_NODE_140543_length_247_cov_0.885057_g133683_i0 PRJNA1136505 140543 247 0.885057 2.18609079 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 113 5.64e-27   NR HLA94760.1 2283092 g133683 i0 67.8 2.05263157894737 87 23 99.6 1 1 246 298 384 HLA94760.1 carboxypeptidase-like regulatory domain-containing protein [Pyrinomonadaceae bacterium] diamond 507 113 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27481153 27481153 PRJNA1136505_P_NODE_14503_length_1698_cov_7.166154_g3863_i1 PRJNA1136505 14503 1698 7.166154 121.68129492 Acidobacteriota bacterium 1978231 Bacteria Bacteria 210 4.1199999999999996e-54   NR MFN7973827.1 1978231 g3863 i1 36.6 1.54240282685512 451 252 76.5 17 1448 150 785 1219 MFN7973827.1 putative Ig domain-containing protein [Acidobacteriota bacterium] diamond 2619 210 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28018033 28018033 PRJNA1136505_P_NODE_40925_length_522_cov_1.371938_g34075_i0 PRJNA1136505 40925 522 1.371938 7.16151636 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 157 6.199999999999998e-43   NR HEY2290900.1 2651171 g34075 i0 46.4 5.09195402298851 181 79 97.7 4 518 9 168 341 HEY2290900.1 DUF4331 domain-containing protein [Thermoanaerobaculia bacterium] diamond 2658 157 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28112534 28112534 PRJNA1136505_P_NODE_26245_length_816_cov_2.923284_g19699_i0 PRJNA1136505 26245 816 2.923284 23.85399744 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 61.2 3.66e-7   NR HKR00228.1 2283092 g19699 i0 29.7 1.41176470588235 209 114 73.5 8 31 630 7 191 HKR00228.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 1152 61.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28144428 28144428 PRJNA1136505_P_NODE_106205_length_280_cov_1.487923_g99345_i0 PRJNA1136505 106205 280 1.487923 4.1661844 Acidobacteriota bacterium 1978231 Bacteria Bacteria 57.4 4.18e-7   NR PYV15782.1 1978231 g99345 i0 39.6 0.975 91 53 97.5 2 274 2 377 465 PYV15782.1 MAG: hypothetical protein DMG21_14015 [Acidobacteriota bacterium] diamond 273 57.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28965297 28965297 PRJNA1136505_P_NODE_66968_length_363_cov_1.241379_g60108_i0 PRJNA1136505 66968 363 1.241379 4.50620577 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 76.6 2.05e-13   NR HEY8228483.1 2283092 g60108 i0 44.5 0.983471074380165 119 58 98.3 3 359 3 513 623 HEY8228483.1 Ig-like domain-containing protein [Pyrinomonadaceae bacterium] diamond 357 76.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29280723 29280723 PRJNA1136505_P_NODE_100049_length_288_cov_1.432558_g93189_i0 PRJNA1136505 100049 288 1.432558 4.12576704 Acidobacteriota bacterium 1978231 Bacteria Bacteria 57.8 2.63e-7   NR MDT7540848.1 1978231 g93189 i0 38.8 1.80208333333333 85 50 88.5 1 257 3 1 83 MDT7540848.1 hypothetical protein [Acidobacteriota bacterium] diamond 519 57.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30196574 30196574 PRJNA1136505_P_NODE_127492_length_254_cov_0.977901_g120632_i0 PRJNA1136505 127492 254 0.977901 2.48386854 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 62 5.29e-9   NR HEY6928187.1 2651171 g120632 i0 53.8 0.767716535433071 65 27 76.8 1 236 42 179 240 HEY6928187.1 NAD-dependent epimerase/dehydratase family protein [Thermoanaerobaculia bacterium] diamond 195 62 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31050137 31050137 PRJNA1136505_P_NODE_118275_length_265_cov_1.296875_g111415_i0 PRJNA1136505 118275 265 1.296875 3.43671875 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 41.6 0.0244   NR HSY17237.1 2952895 g111415 i0 33.3 0.713207547169811 63 38 71.3 1 8 196 13 71 HSY17237.1 hypothetical protein [Candidatus Acidiferrales bacterium] diamond 189 41.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
31334192 31334192 PRJNA1136505_P_NODE_94416_length_297_cov_1.718750_g87556_i0 PRJNA1136505 94416 297 1.71875 5.1046875 Acidobacteriota bacterium 1978231 Bacteria Bacteria 68.9 3.51e-11   NR MDJ0842140.1 1978231 g87556 i0 49.3 1.5050505050505 73 33 73.7 3 30 248 284 352 MDJ0842140.1 M43 family zinc metalloprotease [Acidobacteriota bacterium] diamond 447 68.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31671254 31671254 PRJNA1136505_P_NODE_98437_length_290_cov_1.898618_g91577_i0 PRJNA1136505 98437 290 1.898618 5.5059922 Terriglobus 392733 Bacteria Bacteria 47 0.00217   NR WP_246153361.1 1592106 g91577 i0 38.6 2.60689655172414 88 51 91 2 264 1 401 485 WP_246153361.1 tetratricopeptide repeat protein [Terriglobus albidus] diamond 756 47.4 0.991561181434599 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus albidus
31903597 31903597 PRJNA1136505_P_NODE_35417_length_594_cov_3.203455_g28602_i0 PRJNA1136505 35417 594 3.203455 19.0285227 Terracidiphilus sp. 1964191 Bacteria Bacteria 54.3 5.01e-5   NR HVC45749.1 1964191 g28602 i0 46.6 0.292929292929293 58 31 29.3 0 6 179 24 81 HVC45749.1 ankyrin repeat domain-containing protein [Terracidiphilus sp.] diamond 174 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
32378358 32378358 PRJNA1136505_P_NODE_137399_length_248_cov_0.880000_g130539_i0 PRJNA1136505 137399 248 0.88 2.1824 Luteitalea sp. 2004800 Bacteria Bacteria 59.7 4.15e-8   NR MQA31037.1 2004800 g130539 i0 82.9 0.423387096774194 35 6 42.3 0 107 3 1 35 MQA31037.1 PAS domain S-box protein [Luteitalea sp.] diamond 105 59.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp.
32820015 32820015 PRJNA1136505_P_NODE_98880_length_290_cov_1.133641_g92020_i0 PRJNA1136505 98880 290 1.133641 3.2875589 Terriglobia bacterium 2081523 Bacteria Bacteria 63.9 2.22e-9   NR HXH47748.1 2081523 g92020 i0 46.1 5.35862068965517 76 37 76.6 2 287 66 260 333 HXH47748.1 sugar porter family MFS transporter [Terriglobia bacterium] diamond 1554 63.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
32851437 32851437 PRJNA1136505_P_NODE_147260_length_244_cov_0.900585_g140400_i0 PRJNA1136505 147260 244 0.900585 2.1974274 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 60.5 2.12e-8   NR HYE13637.1 2283092 g140400 i0 45 0.983606557377049 80 33 97.1 4 3 239 390 459 HYE13637.1 M4 family metallopeptidase [Pyrinomonadaceae bacterium] diamond 240 60.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;