RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1102048", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 20 ✖

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA1102048 · 20 ✖

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
4038485 4038485 PRJNA1102048_P_NODE_16844_length_243_cov_0.905882_g16740_i0 PRJNA1102048 16844 243 0.905882 2.20129326 Acidobacteriota 57723 Bacteria Bacteria 81.6 7.35e-16   NR MBK5293495.1 2081523 g16740 i0 58.4 8.5679012345679 77 31 93.8 1 14 241 109 185 MBK5293495.1 protein kinase [Terriglobia bacterium] diamond 2082 81.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
7864446 7864446 PRJNA1102048_P_NODE_18267_length_223_cov_6.666667_g18163_i0 PRJNA1102048 18267 223 6.666667 14.86666741 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 211 3.09e-50   NTclustered gi|2874254120|emb|OY970205.1| 194844 g18163 i0 84.305 3.8206278026905802 223 28 99 7 5 223 7041516 7041735 MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1 blastn 852 211 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
18063456 18063456 PRJNA1102048_P_NODE_17835_length_241_cov_0.916667_g17731_i0 PRJNA1102048 17835 241 0.916667 2.20916747 Acidobacteriota bacterium 1978231 Bacteria Bacteria 372 1.47e-98   NTclustered gi|2621701354|emb|OY760074.1| 1978231 g17731 i0 94.606 258.390041493776 241 12 100 1 1 241 1226749 1226510 MAG: Acidobacteriota bacterium isolate e8b00ceb-3b51-4674-b3e1-58c3ce2e7457 genome assembly, chromosome: 1 blastn 62272 372 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26624454 26624454 PRJNA1102048_P_NODE_6401_length_341_cov_1.436567_g6297_i0 PRJNA1102048 6401 341 1.436567 4.89869347 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 86.7 2.15e-17   NR MDR3734819.1 2052142 g6297 i0 48.8 4.74193548387097 84 40 73.9 1 88 339 173 253 MDR3734819.1 asparagine--tRNA ligase [Acidobacteriaceae bacterium] diamond 1617 86.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
26774274 26774274 PRJNA1102048_P_NODE_4181_length_416_cov_3.545190_g4077_i0 PRJNA1102048 4181 416 3.54519 14.7479904 Pseudomonadati 3379134 Bacteria Bacteria 92.4 3.03e-19   NR WP_263410967.1 1111115 g4077 i0 53.7 2.80528846153846 95 44 68.5 0 132 416 1 95 WP_263410967.1 zinc-binding alcohol dehydrogenase family protein [Terriglobus tenax] diamond 1167 92.8 0.995689655172414 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus tenax
28046776 28046776 PRJNA1102048_P_NODE_12765_length_251_cov_0.865169_g12661_i0 PRJNA1102048 12765 251 0.865169 2.17157419 Acidobacteriota bacterium 1978231 Bacteria Bacteria 158 5.66e-46   NR MDE3226897.1 1978231 g12661 i0 98.8 0.99203187250996006 83 1 99.2 0 3 251 74 156 MDE3226897.1 DMT family transporter [Acidobacteriota bacterium] diamond 249 158 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28235973 28235973 PRJNA1102048_P_NODE_16826_length_243_cov_0.905882_g16722_i0 PRJNA1102048 16826 243 0.905882 2.20129326 Acidobacteriota bacterium 1978231 Bacteria Bacteria 127 2.22e-32   NR MCI0353541.1 1978231 g16722 i0 77.5 0.987654320987654 80 18 98.8 0 3 242 235 314 MCI0353541.1 ISKra4 family transposase [Acidobacteriota bacterium] diamond 240 127 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28394047 28394047 PRJNA1102048_P_NODE_5746_length_359_cov_2.541958_g5642_i0 PRJNA1102048 5746 359 2.541958 9.12562922 Acidobacteriota bacterium 1978231 Bacteria Bacteria 53.1 2.79e-5   NR MBI4850725.1 1978231 g5642 i0 37.9 0.96100278551532 58 36 48.5 0 358 185 292 349 MBI4850725.1 lipase [Acidobacteriota bacterium] diamond 345 53.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29246555 29246555 PRJNA1102048_P_NODE_14609_length_247_cov_0.885057_g14505_i0 PRJNA1102048 14609 247 0.885057 2.18609079 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 113 3.66e-27   NR MDX1582111.1 2651171 g14505 i0 65.9 2.98785425101215 82 28 99.6 0 2 247 265 346 MDX1582111.1 serine hydrolase domain-containing protein [Thermoanaerobaculia bacterium] diamond 738 113 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
30636186 30636186 PRJNA1102048_P_NODE_4713_length_393_cov_1.818750_g4609_i0 PRJNA1102048 4713 393 1.81875 7.1476875 Blastocatellia bacterium 2052146 Bacteria Bacteria 169 2.13e-47   NR HKS42096.1 2052146 g4609 i0 61.2 0.984732824427481 129 50 98.5 0 7 393 17 145 HKS42096.1 aminotransferase class V-fold PLP-dependent enzyme [Blastocatellia bacterium] diamond 387 169 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30848866 30848866 PRJNA1102048_P_NODE_2694_length_509_cov_1.337156_g2590_i0 PRJNA1102048 2694 509 1.337156 6.80612404 Bacteria 2 Bacteria Bacteria 228 1.33e-69   NR HYL74937.1 2212468 g2590 i0 61.7 12.6011787819253 167 63 98.4 1 502 2 207 372 HYL74937.1 pyridoxal-dependent decarboxylase [Bryobacteraceae bacterium] diamond 6414 228 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31291164 31291164 PRJNA1102048_P_NODE_1055_length_725_cov_4.383436_g959_i0 PRJNA1102048 1055 725 4.383436 31.779911 Pseudomonadati 3379134 Bacteria Bacteria 96.3 5.8700000000000006e-21   NR HPS68479.1 2582906 g959 i0 45.9 2.83448275862069 111 58 45.5 2 379 50 42 151 HPS68479.1 Hsp20/alpha crystallin family protein [Holophaga sp.] diamond 2055 96.3 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Holophaga Holophaga sp.
31900953 31900953 PRJNA1102048_P_NODE_13837_length_249_cov_0.875000_g13733_i0 PRJNA1102048 13837 249 0.875 2.17875 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 92.8 3.8600000000000005e-21   NR HVG83526.1 2910147 g13733 i0 75 0.771084337349398 64 16 77.1 0 192 1 1 64 HVG83526.1 hypothetical protein [Vicinamibacterales bacterium] diamond 192 92.8 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32280878 32280878 PRJNA1102048_P_NODE_15459_length_245_cov_1.627907_g15355_i0 PRJNA1102048 15459 245 1.627907 3.98837215 Terriglobales bacterium 2282142 Bacteria Bacteria 80.9 7.52e-16   NR HTK95499.1 2282142 g15355 i0 50 0.979591836734694 80 40 98 0 5 244 105 184 HTK95499.1 zinc-binding dehydrogenase [Terriglobales bacterium] diamond 240 80.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
32312590 32312590 PRJNA1102048_P_NODE_10079_length_277_cov_2.186275_g9975_i0 PRJNA1102048 10079 277 2.186275 6.05598175 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 42.7 0.0435   NR HEV8269103.1 2651171 g9975 i0 35.8 0.877256317689531 81 38 72.6 2 233 33 102 182 HEV8269103.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 243 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32312605 32312605 PRJNA1102048_P_NODE_4439_length_405_cov_2.807229_g4335_i0 PRJNA1102048 4439 405 2.807229 11.36927745 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 54.3 1.88e-5   NR HZF09337.1 2651171 g4335 i0 35.8 1.51111111111111 109 63 79.3 3 392 72 22 125 HZF09337.1 IPTL-CTERM sorting domain-containing protein [Thermoanaerobaculia bacterium] diamond 612 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32650943 32650943 PRJNA1102048_P_NODE_14200_length_248_cov_0.880000_g14096_i0 PRJNA1102048 14200 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 151 2.1399999999999996e-41   NR MBU6254064.1 1978231 g14096 i0 96.3 6.94354838709677 82 3 99.2 0 1 246 366 447 MBU6254064.1 acyltransferase [Acidobacteriota bacterium] diamond 1722 151 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32691266 32691266 PRJNA1102048_P_NODE_9500_length_284_cov_1.369668_g9396_i0 PRJNA1102048 9500 284 1.369668 3.88985712 Terriglobales bacterium 2282142 Bacteria Bacteria 71.6 2.97e-12   NR HTK95499.1 2282142 g9396 i0 41.1 1.00352112676056 95 54 98.2 1 280 2 68 162 HTK95499.1 zinc-binding dehydrogenase [Terriglobales bacterium] diamond 285 71.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
32785691 32785691 PRJNA1102048_P_NODE_13900_length_249_cov_0.875000_g13796_i0 PRJNA1102048 13900 249 0.875 2.17875 Bryobacterales bacterium 2026791 Bacteria Bacteria 66.2 1.38e-10   NR MBL8237167.1 2026791 g13796 i0 78 0.493975903614458 41 8 48.2 1 248 129 256 296 MBL8237167.1 AAA family ATPase [Bryobacterales bacterium] diamond 123 66.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
32817303 32817303 PRJNA1102048_P_NODE_10720_length_270_cov_1.705584_g10616_i0 PRJNA1102048 10720 270 1.705584 4.6050768 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 83.2 1.68e-18   NR NNE66525.1 2283092 g10616 i0 54.9 1.65555555555556 71 32 78.9 0 56 268 1 71 NNE66525.1 RNA-binding protein [Pyrinomonadaceae bacterium] diamond 447 83.2 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);;