RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1204310", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJNA1204310 · 18 ✖

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
9256623 9256623 PRJNA1204310_P_NODE_14008_length_473_cov_2.795000_g13711_i0 PRJNA1204310 14008 473 2.795 13.22035 Desulfarculaceae bacterium 2528248 Bacteria Bacteria 174 1.55e-51   NR MCB2227561.1 2528248 g13711 i0 58.6 2.66384778012685 140 58 88.8 0 49 468 26 165 MCB2227561.1 M15 family metallopeptidase [Desulfarculaceae bacterium] diamond 1260 174 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae   Desulfarculaceae bacterium
15631723 15631723 PRJNA1204310_P_NODE_21593_length_391_cov_1.471698_g21296_i0 PRJNA1204310 21593 391 1.471698 5.75433918 Desulfuromonadia 3031651 Bacteria Bacteria 215 4.56e-64   NR WP_088535434.1 1277350 g21296 i0 72.8 6.79795396419437 125 34 95.9 0 387 13 484 608 WP_088535434.1 phosphoenolpyruvate carboxykinase (GTP) [Geobacter sp. DSM 9736] diamond 2658 215 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp. DSM 9736
23281363 23281363 PRJNA1204310_P_NODE_36979_length_306_cov_2.008584_g36682_i0 PRJNA1204310 36979 306 2.008584 6.14626704 Bacteria 2 Bacteria Bacteria 144 1.4e-38   NR WP_020674886.1 225196 g36682 i0 69.3 3.90196078431373 101 31 99 0 304 2 257 357 WP_020674886.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Geopsychrobacter electrodiphilus] diamond 1194 145 0.993103448275862 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae Geopsychrobacter Geopsychrobacter electrodiphilus
26755889 26755889 PRJNA1204310_P_NODE_37441_length_304_cov_1.658009_g37144_i0 PRJNA1204310 37441 304 1.658009 5.04034736 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 46.6 0.00321   NR MEA3230822.1 2202153 g37144 i0 40.4 0.5625 57 24 46.4 2 157 297 275 331 MEA3230822.1 protein kinase [Thermodesulfobacteriota bacterium] diamond 171 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27293847 27293847 PRJNA1204310_P_NODE_29703_length_341_cov_1.455224_g29406_i0 PRJNA1204310 29703 341 1.455224 4.96231384 Maridesulfovibrio sp. 2795000 Bacteria Bacteria 58.9 2.22e-7   NR WP_320008088.1 2795000 g29406 i0 44.6 1.35483870967742 74 38 62.5 1 123 335 11 84 WP_320008088.1 iron-containing alcohol dehydrogenase [Maridesulfovibrio sp.] diamond 462 58.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Maridesulfovibrio Maridesulfovibrio sp.
27452031 27452031 PRJNA1204310_P_NODE_33623_length_322_cov_1.253012_g33326_i0 PRJNA1204310 33623 322 1.253012 4.03469864 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 44.3 0.0257   NR MFC1811464.1 2202153 g33326 i0 38 0.46583850931677 50 31 46.6 0 2 151 400 449 MFC1811464.1 ion transporter [Thermodesulfobacteriota bacterium] diamond 150 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27736346 27736346 PRJNA1204310_P_NODE_62804_length_242_cov_0.923077_g62507_i0 PRJNA1204310 62804 242 0.923077 2.23384634 Desulfobacter sp. 2294 Bacteria Bacteria 43.5 0.0191   NR WDP91230.1 2294 g62507 i0 39.5 0.533057851239669 43 26 53.3 0 86 214 293 335 WDP91230.1 MAG: SAM-dependent methyltransferase [Desulfobacter sp.] diamond 129 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter sp.
27893765 27893765 PRJNA1204310_P_NODE_50345_length_254_cov_1.292818_g50048_i0 PRJNA1204310 50345 254 1.292818 3.28375772 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 53.5 6.43e-6   NR MCF8030462.1 2683721 g50048 i0 38.6 0.826771653543307 70 42 82.7 1 33 242 46 114 MCF8030462.1 pyridoxal phosphate-dependent aminotransferase [Desulfohalobiaceae bacterium] diamond 210 53.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
28367346 28367346 PRJNA1204310_P_NODE_40826_length_290_cov_1.244240_g40529_i0 PRJNA1204310 40826 290 1.24424 3.608296 Desulfonema magnum 45655 Bacteria Bacteria 43.9 0.0243   NR WP_207680799.1 45655 g40529 i0 34 0.972413793103448 94 56 94.1 2 3 275 89 179 WP_207680799.1 multidrug effflux MFS transporter [Desulfonema magnum] diamond 282 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfonema Desulfonema magnum
28430710 28430710 PRJNA1204310_P_NODE_12226_length_504_cov_1.266821_g11929_i0 PRJNA1204310 12226 504 1.266821 6.38477784 Desulfonema magnum 45655 Bacteria Bacteria 90.1 5.65e-18   NR WP_207678242.1 45655 g11929 i0 48.7 1.45238095238095 78 40 46.4 0 502 269 186 263 WP_207678242.1 hypothetical protein [Desulfonema magnum] diamond 732 90.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfonema Desulfonema magnum
29977783 29977783 PRJNA1204310_P_NODE_52011_length_252_cov_0.871508_g51714_i0 PRJNA1204310 52011 252 0.871508 2.19620016 Salidesulfovibrio onnuriiensis 2583823 Bacteria Bacteria 73.2 9.23e-15   NR WP_147820799.1 2583823 g51714 i0 49.4 5.70238095238095 83 35 90.5 1 234 7 3 85 WP_147820799.1 RNA recognition motif domain-containing protein [Salidesulfovibrio onnuriiensis] diamond 1437 73.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Salidesulfovibrio Salidesulfovibrio onnuriiensis
30217774 30217774 PRJNA1204310_P_NODE_53012_length_251_cov_0.876404_g52715_i0 PRJNA1204310 53012 251 0.876404 2.19977404 Bacteria 2 Bacteria Bacteria 63.5 1e-9   NR OPY06726.1 1811717 g52715 i0 56 2.24701195219123 50 19 59.8 1 101 250 2 48 OPY06726.1 MAG: Amidohydrolase [Syntrophaceae bacterium PtaB.Bin095] diamond 564 63.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium PtaB.Bin095
30357464 30357464 PRJNA1204310_P_NODE_28452_length_348_cov_0.883636_g28155_i0 PRJNA1204310 28452 348 0.883636 3.07505328 Desulfofustis glycolicus 51195 Bacteria Bacteria 99.4 1.66e-21   NR WP_073372825.1 51195 g28155 i0 42.1 0.982758620689655 114 64 97.4 2 347 9 64 176 WP_073372825.1 MEDS domain-containing protein [Desulfofustis glycolicus] diamond 342 99.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfofustis Desulfofustis glycolicus
30451993 30451993 PRJNA1204310_P_NODE_48073_length_263_cov_1.642105_g47776_i0 PRJNA1204310 48073 263 1.642105 4.31873615 Desulfamplus sp. 2006184 Bacteria Bacteria 65.1 6.51e-10   NR MBF0389460.1 2006184 g47776 i0 43.8 2.13307984790875 64 36 73 0 253 62 472 535 MBF0389460.1 calcium-translocating P-type ATPase, PMCA-type [Desulfamplus sp.] diamond 561 65.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus sp.
32082907 32082907 PRJNA1204310_P_NODE_40118_length_292_cov_1.589041_g39821_i0 PRJNA1204310 40118 292 1.589041 4.63999972 root 1 Root_unresolved Root_unresolved 43.9 0.0257   NR PLY02200.1 892 g39821 i0 29.9 6.49315068493151 97 52 86.3 3 33 284 484 577 PLY02200.1 MAG: DNA internalization-related competence protein ComEC/Rec2 [Desulfuromonas sp.] diamond 1896 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
32095717 32095717 PRJNA1204310_P_NODE_46798_length_269_cov_0.795918_g46501_i0 PRJNA1204310 46798 269 0.795918 2.14101942 Pseudodesulfovibrio portus 231439 Bacteria Bacteria 73.9 2.76e-13   NR WP_264982004.1 231439 g46501 i0 44.6 0.925650557620818 83 46 92.6 0 267 19 200 282 WP_264982004.1 choice-of-anchor A family protein [Pseudodesulfovibrio portus] diamond 249 73.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio portus
32159185 32159185 PRJNA1204310_P_NODE_12638_length_496_cov_0.893617_g12341_i0 PRJNA1204310 12638 496 0.893617 4.43234032 Desulfovibrionales bacterium 2448050 Bacteria Bacteria 97.4 4.11e-20   NR NLY42189.1 2448050 g12341 i0 43.4 2.38306451612903 136 66 81 2 411 10 1 127 NLY42189.1 hydroxylamine reductase [Desulfovibrionales bacterium] diamond 1182 97.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales     Desulfovibrionales bacterium
32822257 32822257 PRJNA1204310_P_NODE_55620_length_249_cov_0.886364_g55323_i0 PRJNA1204310 55620 249 0.886364 2.20704636 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 44.7 0.00838   NR HWP92572.1 2202153 g55323 i0 40.3 0.807228915662651 67 35 80.7 1 206 6 49 110 HWP92572.1 M1 family metallopeptidase [Thermodesulfobacteriota bacterium] diamond 201 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota 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);;