RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA986481", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 17 ✖

tax_kingdom 1

  • Pseudomonadati · 17 ✖

bioproject 1

  • PRJNA986481 · 17 ✖

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
9901676 9901676 PRJNA986481_P_NODE_32188_length_288_cov_1.690377_g31663_i0 PRJNA986481 32188 288 1.690377 4.86828576 Pseudomonadati 3379134 Bacteria Bacteria 148 3.31e-41   NR WP_319522255.1 218289 g31663 i0 78.9 8.90625 95 20 99 0 1 285 83 177 WP_319522255.1 NAD-dependent epimerase/dehydratase family protein [uncultured Desulfosarcina sp.] diamond 2565 148 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina uncultured Desulfosarcina sp.
13727410 13727410 PRJNA986481_P_NODE_50931_length_251_cov_1.000000_g50406_i0 PRJNA986481 50931 251 1 2.51 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 329 9.38e-86   NTclustered gi|2575803239|emb|OY729416.1| 2202153 g50406 i0 90.476 108.788844621514 252 21 100 3 1 251 76409 76160 MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 blastn 27306 329 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
16574698 16574698 PRJNA986481_P_NODE_51033_length_251_cov_1.000000_g50508_i0 PRJNA986481 51033 251 1 2.51 Bacteria 2 Bacteria Bacteria 182 2.78e-41   NTclustered gi|316941978|gb|CP002431.1| 643562 g50508 i0 80.816 65.7609561752988 245 35 95 7 11 249 2475509 2475747 Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome blastn 16506 183 0.994535519125683 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio aespoeensis
21376102 21376102 PRJNA986481_P_NODE_60057_length_241_cov_1.052083_g59532_i0 PRJNA986481 60057 241 1.052083 2.53552003 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 296 9.08e-76   NTclustered gi|2891482145|emb|OZ219878.1| 2202153 g59532 i0 88.843 109.269709543568 242 26 100 1 1 241 215623 215864 MAG: Thermodesulfobacteriota bacterium isolate 5b8d878f-b741-4c1d-a9b4-bc29eff46044 genome assembly, chromosome: 1 blastn 26334 296 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27279354 27279354 PRJNA986481_P_NODE_29103_length_304_cov_1.074510_g28578_i0 PRJNA986481 29103 304 1.07451 3.2665104 Desulfobacterales bacterium 2044940 Bacteria Bacteria 98.6 2.55e-22   NR MCP4349549.1 2044940 g28578 i0 50.5 6.09868421052632 103 49 99.7 1 2 304 168 270 MCP4349549.1 pyridoxal-phosphate dependent enzyme [Desulfobacterales bacterium] diamond 1854 98.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27405857 27405857 PRJNA986481_P_NODE_11783_length_477_cov_3.670561_g11259_i0 PRJNA986481 11783 477 3.670561 17.50857597 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 46.2 0.0138   NR MFC1877323.1 2202153 g11259 i0 32.3 0.584905660377358 93 39 47.2 4 451 227 80 166 MFC1877323.1 PEP-CTERM sorting domain-containing protein [Thermodesulfobacteriota bacterium] diamond 279 46.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27468936 27468936 PRJNA986481_P_NODE_21723_length_352_cov_1.132013_g21198_i0 PRJNA986481 21723 352 1.132013 3.98468576 Desulfobacterales bacterium 2044940 Bacteria Bacteria 114 1.56e-28   NR MCU0557909.1 2044940 g21198 i0 48.7 3.76704545454545 115 59 98 0 350 6 45 159 MCU0557909.1 DUF4197 domain-containing protein [Desulfobacterales bacterium] diamond 1326 114 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27500549 27500549 PRJNA986481_P_NODE_50303_length_252_cov_0.995074_g49778_i0 PRJNA986481 50303 252 0.995074 2.50758648 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 115 1.28e-29   NR MBC2694805.1 2049433 g49778 i0 65.1 1.96428571428571 83 28 97.6 1 246 1 50 132 MBC2694805.1 5'-methylthioadenosine nucleosidase [Desulfobacteraceae bacterium] diamond 495 115 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28573837 28573837 PRJNA986481_P_NODE_46227_length_256_cov_1.951691_g45702_i0 PRJNA986481 46227 256 1.951691 4.99632896 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 53.1 8.48e-6   NR MEW6220043.1 2202153 g45702 i0 54.5 1.27734375 55 25 64.5 0 254 90 246 300 MEW6220043.1 choice-of-anchor A family protein [Thermodesulfobacteriota bacterium] diamond 327 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29710218 29710218 PRJNA986481_P_NODE_41550_length_262_cov_0.948357_g41025_i0 PRJNA986481 41550 262 0.948357 2.48469534 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 87 6.75e-18   NR MDA8141644.1 2049433 g41025 i0 44.8 0.99618320610687 87 43 98.5 2 3 260 110 192 MDA8141644.1 PQQ-dependent sugar dehydrogenase [Desulfobacteraceae bacterium] diamond 261 87 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29811089 29811089 PRJNA986481_P_NODE_29991_length_299_cov_1.212000_g29466_i0 PRJNA986481 29991 299 1.212 3.62388 Pseudomonadati 3379134 Bacteria Bacteria 171 7.02e-48   NR WP_286351014.1 28231 g29466 i0 77.8 12.9130434782609 99 21 99.3 1 1 297 141 238 WP_286351014.1 MULTISPECIES: phosphoenolpyruvate carboxykinase (GTP) [Geobacter] diamond 3861 171 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter  
31385351 31385351 PRJNA986481_P_NODE_22636_length_345_cov_1.047297_g22111_i0 PRJNA986481 22636 345 1.047297 3.61317465 Desulfobacteria bacterium 3024420 Bacteria Bacteria 63.2 6.63e-9   NR HEX3015182.1 3024420 g22111 i0 56.4 0.478260869565217 55 23 47 1 344 183 95 149 HEX3015182.1 6-bladed beta-propeller [Desulfobacteria bacterium] diamond 165 63.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria       Desulfobacteria bacterium
31575198 31575198 PRJNA986481_P_NODE_58756_length_242_cov_3.139896_g58231_i0 PRJNA986481 58756 242 3.139896 7.59854832 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 84.7 6.15e-18   NR THB79199.1 2049433 g58231 i0 65.1 0.78099173553719 63 20 75.6 1 188 6 120 182 THB79199.1 MAG: AIM24 family protein [Desulfobacteraceae bacterium] diamond 189 84.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31638168 31638168 PRJNA986481_P_NODE_5816_length_663_cov_6.490228_g5360_i0 PRJNA986481 5816 663 6.490228 43.03021164 Desulfobacterales bacterium 2044940 Bacteria Bacteria 219 4.64e-68   NR MCU0604158.1 2044940 g5360 i0 63.6 0.846153846153846 187 59 83.7 4 40 594 60 239 MCU0604158.1 SDR family oxidoreductase [Desulfobacterales bacterium] diamond 561 219 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31738887 31738887 PRJNA986481_P_NODE_55237_length_246_cov_1.685279_g54712_i0 PRJNA986481 55237 246 1.685279 4.14578634 Pseudomonadati 3379134 Bacteria Bacteria 119 4.2799999999999994e-31   NR RUM35362.1 895 g54712 i0 69.2 3.85365853658537 78 23 95.1 1 246 13 131 207 RUM35362.1 MAG: hypothetical protein DSY50_04930 [Desulfobulbus sp.] diamond 948 120 0.991666666666667 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus sp.
32176272 32176272 PRJNA986481_P_NODE_28958_length_304_cov_5.396078_g28433_i0 PRJNA986481 28958 304 5.396078 16.40407712 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 152 6.369999999999998e-42   NR MCC6711939.1 2080303 g28433 i0 92 0.858552631578947 87 7 85.9 0 283 23 329 415 MCC6711939.1 competence/damage-inducible protein A [Candidatus Dadabacteria bacterium] diamond 261 152 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
32713187 32713187 PRJNA986481_P_NODE_47340_length_255_cov_0.980583_g46815_i0 PRJNA986481 47340 255 0.980583 2.50048665 Desulfogranum mediterraneum 160661 Bacteria Bacteria 43.1 0.03   NR WP_028583958.1 160661 g46815 i0 38.3 0.952941176470588 81 45 89.4 2 244 17 133 213 WP_028583958.1 MFS transporter [Desulfogranum mediterraneum] diamond 243 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfogranum Desulfogranum mediterraneum

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);;