RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA315314", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 15 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 15 ✖

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
1655645 1655645 PRJNA315314_S_NODE_24622_length_168_cov_197.258993_g24301_i0 PRJNA315314 24622 168 197.258993 331.39510824 Desulfoglaeba alkanexedens 361111 Bacteria Bacteria 171 3.73e-38   NTclustered gi|1649181537|gb|CP040098.1| 980445 g24301 i0 85.227 285.291666666667 176 15 99 8 2 168 1351652 1351825 Desulfoglaeba alkanexedens ALDC chromosome, complete genome blastn 47929 171 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Desulfoglaeba Desulfoglaeba alkanexedens
2931560 2931560 PRJNA315314_S_NODE_2883_length_466_cov_2.892449_g2567_i0 PRJNA315314 2883 466 2.892449 13.47881234 Desulfovibrio desulfuricans 876 Bacteria Bacteria 634 3.5299999999999998e-177   NTclustered gi|2022650692|gb|CP072608.1| 876 g2567 i0 91.202 2.00643776824034 466 41 100 0 1 466 59298 59763 Desulfovibrio desulfuricans strain L4 chromosome, complete genome blastn 935 634 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
4207873 4207873 PRJNA315314_S_NODE_13804_length_220_cov_1.764398_g13483_i0 PRJNA315314 13804 220 1.764398 3.8816756 Salidesulfovibrio onnuriiensis 2583823 Bacteria Bacteria 54.7 0.005   NTclustered gi|1725298512|gb|CP040751.1| 2583823 g13483 i0 100 0.259090909090909 29 0 13 0 192 220 2199579 2199551 Salidesulfovibrio onnuriiensis strain IOR2 chromosome, complete genome blastn 57 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Salidesulfovibrio Salidesulfovibrio onnuriiensis
5484483 5484483 PRJNA315314_S_NODE_4505_length_377_cov_3.508621_g4184_i0 PRJNA315314 4505 377 3.508621 13.22750117 Desulfovibrio desulfuricans 876 Bacteria Bacteria 316 1.15e-81   NTclustered gi|2022650692|gb|CP072608.1| 876 g4184 i0 90.123 0.644562334217507 243 24 64 0 135 377 62825 62583 Desulfovibrio desulfuricans strain L4 chromosome, complete genome blastn 243 316 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
6758433 6758433 PRJNA315314_S_NODE_18366_length_192_cov_5.840491_g18045_i0 PRJNA315314 18366 192 5.840491 11.21374272 Desulfofustis limnaeus 2740163 Bacteria Bacteria 198 2.0099999999999997e-46   NTclustered gi|2211518257|dbj|AP025516.1| 2740163 g18045 i0 87.5 159.046875 176 16 90 5 11 183 1952478 1952306 Desulfobulbaceae bacterium PPLL DNA, complete genome blastn 30537 198 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfofustis Desulfofustis limnaeus
11268454 11268454 PRJNA315314_S_NODE_13289_length_223_cov_149.505155_g12968_i0 PRJNA315314 13289 223 149.505155 333.39649565 Thermodesulfobacteriota 200940 Bacteria Bacteria 296 8.28e-76   NTclustered gi|1583991466|gb|CP036313.1| 2291 g12968 i0 90.909 257.90134529148 220 20 100 0 4 223 503580 503361 Desulfobacter hydrogenophilus strain AcRS1 chromosome blastn 57512 296 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter hydrogenophilus
11268458 11268458 PRJNA315314_S_NODE_13929_length_218_cov_3538.767196_g13608_i0 PRJNA315314 13929 218 3538.767196 7714.51248728 Candidatus Electrothrix 1859128 Bacteria Bacteria 169 1.83e-37   NTclustered gi|2755823080|gb|CP159373.1| 3062594 g13608 i0 87.333 86.9587155963303 150 16 68 3 1 148 141603 141751 MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome blastn 18957 169 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix aestuarii
14409782 14409782 PRJNA315314_S_NODE_25652_length_165_cov_12.647059_g25331_i0 PRJNA315314 25652 165 12.647059 20.86764735 Desulfovibrio mangrovi 2976983 Bacteria Bacteria 97.1 6.28e-16   NTclustered gi|2330538096|gb|CP104208.1| 2976983 g25331 i0 88.889 27.5333333333333 81 5 48 3 1 79 1675188 1675266 Desulfovibrio mangrovi strain FT415 chromosome, complete genome blastn 4543 97.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio mangrovi
27786990 27786990 PRJNA315314_S_NODE_24924_length_168_cov_1.489209_g24603_i0 PRJNA315314 24924 168 1.489209 2.50187112 Desulfocapsaceae 2886822 Bacteria Bacteria 87.4 8.52e-19   NR WP_073614043.1 231440 g24603 i0 77.8 4.78571428571429 54 12 96.4 0 5 166 210 263 WP_073614043.1 malate dehydrogenase [Desulfopila aestuarii] diamond 804 87.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfopila Desulfopila aestuarii
28291813 28291813 PRJNA315314_S_NODE_18046_length_194_cov_2.757576_g17725_i0 PRJNA315314 18046 194 2.757576 5.34969744 Pseudomonadati 3379134 Bacteria Bacteria 42.7 0.00899   NR MEW6263850.1 2202153 g17725 i0 58.6 0.865979381443299 29 12 44.8 0 88 2 13 41 MEW6263850.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 168 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29144814 29144814 PRJNA315314_S_NODE_26829_length_162_cov_4.015038_g26508_i0 PRJNA315314 26829 162 4.015038 6.50436156 Pseudomonadati 3379134 Bacteria Bacteria 84 6.24e-18   NR WP_009182997.1 345370 g26508 i0 69.8 3.90740740740741 53 16 98.1 0 160 2 154 206 WP_009182997.1 cytidylyltransferase domain-containing protein [Solidesulfovibrio carbinoliphilus] diamond 633 84 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio carbinoliphilus
29284682 29284682 PRJNA315314_S_NODE_10609_length_249_cov_2.513636_g10288_i0 PRJNA315314 10609 249 2.513636 6.25895364 Desulfobulbus sp. 895 Bacteria Bacteria 43.5 0.0216   NR MDD2467979.1 895 g10288 i0 36.5 0.759036144578313 63 40 75.9 0 27 215 188 250 MDD2467979.1 hypothetical protein [Desulfobulbus sp.] diamond 189 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus sp.
30548243 30548243 PRJNA315314_S_NODE_4273_length_387_cov_6.857542_g3952_i0 PRJNA315314 4273 387 6.857542 26.53868754 Desulfomonilia bacterium 3041274 Bacteria Bacteria 100 1.4e-21   NR HEY9161941.1 3041274 g3952 i0 51.4 1.84496124031008 107 51 82.2 1 387 70 141 247 HEY9161941.1 alginate lyase family protein [Desulfomonilia bacterium] diamond 714 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia       Desulfomonilia bacterium
31514239 31514239 PRJNA315314_S_NODE_14236_length_216_cov_6.989305_g13915_i0 PRJNA315314 14236 216 6.989305 15.0968988 Bacteria 2 Bacteria Bacteria 42 0.0397   NR PHR26009.1 2030813 g13915 i0 46.2 1.52777777777778 52 17 59.7 2 44 172 123 172 PHR26009.1 MAG: hypothetical protein COA36_13230 [Desulfotalea sp.] diamond 330 42.4 0.990566037735849 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfotalea Desulfotalea sp.
32886761 32886761 PRJNA315314_S_NODE_1220_length_690_cov_13.588502_g989_i0 PRJNA315314 1220 690 13.588502 93.7606638 Desulfobacterales bacterium HSG2 3055596 Bacteria Bacteria 80.1 2.26e-13   NR MDM8549572.1 3055596 g989 i0 31.9 2.27391304347826 182 107 73 5 563 60 33 211 MDM8549572.1 peptidase inhibitor family I36 protein [Desulfobacterales bacterium HSG2] diamond 1569 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium HSG2

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