RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA437204", 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 · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJNA437204 · 18 ✖

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
1707478 1707478 PRJNA437204_P_NODE_41622_length_320_cov_1.246964_g41323_i0 PRJNA437204 41622 320 1.246964 3.9902848 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 235 2.78e-57   NTclustered gi|2556892445|gb|CP129479.1| 2202153 g41323 i0 80.374 159.85 321 54 99 8 3 320 887359 887045 MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome blastn 51152 235 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
6811198 6811198 PRJNA437204_P_NODE_87206_length_250_cov_0.870056_g86907_i0 PRJNA437204 87206 250 0.870056 2.17514 Pseudodesulfovibrio aespoeensis 182210 Bacteria Bacteria 52.8 0.023   NTclustered gi|316941978|gb|CP002431.1| 643562 g86907 i0 100 0.112 28 0 11 0 68 95 3384275 3384302 Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio aespoeensis
14461707 14461707 PRJNA437204_P_NODE_60072_length_281_cov_1.110577_g59773_i0 PRJNA437204 60072 281 1.110577 3.12072137 Trichlorobacter ammonificans 2916410 Bacteria Bacteria 143 9.78e-38   NR WP_305731090.1 2916410 g59773 i0 69.9 6.95017793594306 93 28 99.3 0 1 279 48 140 WP_305731090.1 phosphoenolpyruvate carboxykinase (GTP) [Trichlorobacter ammonificans] diamond 1953 143 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter ammonificans
18283273 18283273 PRJNA437204_P_NODE_109375_length_245_cov_0.895349_g109076_i0 PRJNA437204 109375 245 0.895349 2.19360505 Pseudodesulfovibrio aespoeensis 182210 Bacteria Bacteria 54.7 0.006   NTclustered gi|316941978|gb|CP002431.1| 643562 g109076 i0 100 0.346938775510204 29 0 12 0 6 34 357178 357150 Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome blastn 85 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio aespoeensis
24659029 24659029 PRJNA437204_P_NODE_49120_length_302_cov_1.676856_g48821_i0 PRJNA437204 49120 302 1.676856 5.06410512 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 134 2.61e-38   NR GJM17742.1 2202153 g48821 i0 73 0.993377483443709 100 22 99.3 1 1 300 3 97 GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium] diamond 300 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
26980930 26980930 PRJNA437204_P_NODE_68122_length_268_cov_1.158974_g67823_i0 PRJNA437204 68122 268 1.158974 3.10605032 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 44.3 0.0111   NR GJM17643.1 2202153 g67823 i0 32.7 0.615671641791045 55 37 61.6 0 104 268 134 188 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 165 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27265645 27265645 PRJNA437204_P_NODE_91723_length_249_cov_0.875000_g91424_i0 PRJNA437204 91723 249 0.875 2.17875 Desulfosudis oleivorans 181663 Bacteria Bacteria 48.5 3.69e-4   NR WP_041280381.1 181663 g91424 i0 55 0.481927710843373 40 18 48.2 0 236 117 800 839 WP_041280381.1 ankyrin repeat domain-containing protein [Desulfosudis oleivorans] diamond 120 48.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosudaceae Desulfosudis Desulfosudis oleivorans
27328881 27328881 PRJNA437204_P_NODE_17423_length_434_cov_1.396122_g17124_i0 PRJNA437204 17423 434 1.396122 6.05916948 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 53.9 1.68e-5   NR GJM17643.1 2202153 g17124 i0 31.3 0.573732718894009 83 56 56.7 1 341 96 130 212 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 249 53.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27423765 27423765 PRJNA437204_P_NODE_102143_length_246_cov_0.890173_g101844_i0 PRJNA437204 102143 246 0.890173 2.18982558 Desulforegula conservatrix 153026 Bacteria Bacteria 82.4 9.23e-17   NR WP_051284050.1 153026 g101844 i0 45.7 0.98780487804878 81 44 98.8 0 244 2 38 118 WP_051284050.1 MBL fold metallo-hydrolase [Desulforegula conservatrix] diamond 243 82.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulforegulaceae Desulforegula Desulforegula conservatrix
28654954 28654954 PRJNA437204_P_NODE_120487_length_242_cov_0.911243_g120188_i0 PRJNA437204 120487 242 0.911243 2.20520806 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 113 8.669999999999998e-31   NR NQS70723.1 2053307 g120188 i0 85.7 2.86363636363636 77 11 95.5 0 232 2 1 77 NQS70723.1 30S ribosomal protein S20 [Desulfobulbaceae bacterium] diamond 693 113 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
29065501 29065501 PRJNA437204_P_NODE_75248_length_257_cov_1.489130_g74949_i0 PRJNA437204 75248 257 1.48913 3.8270641 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 88.2 1.28e-19   NR HSG31940.1 2202153 g74949 i0 53.8 1.8326848249027201 78 36 91.1 0 237 4 6 83 HSG31940.1 RNA 2'-phosphotransferase [Thermodesulfobacteriota bacterium] diamond 471 88.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29317906 29317906 PRJNA437204_P_NODE_116589_length_243_cov_0.905882_g116290_i0 PRJNA437204 116589 243 0.905882 2.20129326 Halodesulfovibrio spirochaetisodalis 1560234 Bacteria Bacteria 42.7 0.0339   NR WP_066852169.1 1560234 g116290 i0 43.2 0.45679012345679 37 21 45.7 0 133 243 85 121 WP_066852169.1 tetratricopeptide repeat protein [Halodesulfovibrio spirochaetisodalis] diamond 111 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Halodesulfovibrio Halodesulfovibrio spirochaetisodalis
30897558 30897558 PRJNA437204_P_NODE_85954_length_250_cov_0.870056_g85655_i0 PRJNA437204 85954 250 0.870056 2.17514 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 71.6 9.49e-13   NR NLZ17732.1 2053307 g85655 i0 81.3 0.576 48 8 56.4 1 147 7 1 48 NLZ17732.1 porin family protein [Desulfobulbaceae bacterium] diamond 144 71.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
31624468 31624468 PRJNA437204_P_NODE_73676_length_259_cov_1.655914_g73377_i0 PRJNA437204 73676 259 1.655914 4.28881726 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 46.6 2.64e-4   NR GJM17551.1 2202153 g73377 i0 34.4 0.741312741312741 64 41 73 1 1 189 20 83 GJM17551.1 MAG: hypothetical protein DHS20C13_28780 [Thermodesulfobacteriota bacterium] diamond 192 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31687700 31687700 PRJNA437204_P_NODE_13357_length_480_cov_1.321867_g13058_i0 PRJNA437204 13357 480 1.321867 6.3449616 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 48.1 0.00287   NR GJM17643.1 2202153 g13058 i0 40.9 0.4125 66 38 40.6 1 3 197 147 212 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 198 48.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31909231 31909231 PRJNA437204_P_NODE_89777_length_249_cov_0.875000_g89478_i0 PRJNA437204 89777 249 0.875 2.17875 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 43.5 0.0176   NR HYA94282.1 2202153 g89478 i0 39.5 0.518072289156627 43 26 51.8 0 1 129 171 213 HYA94282.1 CAP domain-containing protein [Thermodesulfobacteriota bacterium] diamond 129 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32527084 32527084 PRJNA437204_P_NODE_100919_length_247_cov_0.885057_g100620_i0 PRJNA437204 100919 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 55.8 8.05e-7   NR MCR5256762.1 885 g100620 i0 47.9 3.47368421052632 71 36 86.2 1 9 221 57 126 MCR5256762.1 ankyrin repeat domain-containing protein [Desulfovibrio sp.] diamond 858 55.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32699433 32699433 PRJNA437204_P_NODE_123080_length_242_cov_0.911243_g122781_i0 PRJNA437204 123080 242 0.911243 2.20520806 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 134 4.37e-39   NR NQS72096.1 2053307 g122781 i0 89.2 0.91735537190082606 74 8 91.7 0 20 241 1 74 NQS72096.1 30S ribosomal protein S17 [Desulfobulbaceae bacterium] diamond 222 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae 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);;