RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 8 ✖

analysis 1

  • blastn · 8 ✖

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

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