RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA976345 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
13701760 13701760 PRJNA976345_P_NODE_177891_length_156_cov_1.826446_g176283_i0 PRJNA976345 177891 156 1.826446 2.84925576 Pseudomonadati 3379134 Bacteria Bacteria 103 4.189999999999999e-24   NR WP_031388344.1 159290 g176283 i0 96.1 11.7692307692308 51 2 98.1 0 3 155 332 382 WP_031388344.1 type I restriction-modification system subunit M [Desulfonatronum thiodismutans] diamond 1836 103 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronaceae Desulfonatronum Desulfonatronum thiodismutans
16250447 16250447 PRJNA976345_P_NODE_100213_length_190_cov_1.012903_g98605_i0 PRJNA976345 100213 190 1.012903 1.9245157 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 100 2.6e-26   NR GJM17324.1 2202153 g98605 i0 78.3 0.947368421052632 60 13 94.7 0 188 9 10 69 GJM17324.1 MAG: hypothetical protein DHS20C13_26510 [Thermodesulfobacteriota bacterium] diamond 180 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
19118455 19118455 PRJNA976345_P_NODE_148175_length_167_cov_1.696970_g146567_i0 PRJNA976345 148175 167 1.69697 2.8339399 Desulfovibrio 872 Bacteria Bacteria 97.8 1.2999999999999998e-24   NR WP_302548726.1 167968 g146567 i0 100 1.83233532934132 51 0 91.6 0 5 157 1 51 WP_302548726.1 2-oxoacid:acceptor oxidoreductase family protein, partial [uncultured Desulfovibrio sp.] diamond 306 97.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
21349903 21349903 PRJNA976345_P_NODE_142297_length_170_cov_0.933333_g140689_i0 PRJNA976345 142297 170 0.933333 1.5866661 Desulfovibrio legallii 571438 Bacteria Bacteria 88.2 1.34e-18   NR WP_092154167.1 571438 g140689 i0 94.6 3.9 56 3 98.8 0 170 3 616 671 WP_092154167.1 methyl-accepting chemotaxis protein [Desulfovibrio legallii] diamond 663 88.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
27380134 27380134 PRJNA976345_P_NODE_119663_length_178_cov_2.867133_g118055_i0 PRJNA976345 119663 178 2.867133 5.10349674 Desulfovibrio 872 Bacteria Bacteria 53.1 3.23e-6   NR WP_303192801.1 167968 g118055 i0 100 0.808988764044944 24 0 40.4 0 3 74 825 848 WP_303192801.1 DNA polymerase III subunit alpha, partial [uncultured Desulfovibrio sp.] diamond 144 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
27815998 27815998 PRJNA976345_P_NODE_47984_length_251_cov_4.675926_g46376_i0 PRJNA976345 47984 251 4.675926 11.73657426 Desulfocapsa sp. 2066021 Bacteria Bacteria 79.3 5.31e-15   NR RUM45435.1 2066021 g46376 i0 48.6 1.68525896414343 72 37 86.1 0 218 3 414 485 RUM45435.1 MAG: hypothetical protein DSY80_03320, partial [Desulfocapsa sp.] diamond 423 79.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfocapsa Desulfocapsa sp.
28415803 28415803 PRJNA976345_P_NODE_169326_length_159_cov_1.596774_g167718_i0 PRJNA976345 169326 159 1.596774 2.53887066 Desulfovibrio legallii 571438 Bacteria Bacteria 107 5.13e-26   NR WP_118230701.1 571438 g167718 i0 98.1 0.981132075471698 52 1 98.1 0 157 2 72 123 WP_118230701.1 (Fe-S)-binding protein [Desulfovibrio legallii] diamond 156 107 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
28737694 28737694 PRJNA976345_P_NODE_134727_length_173_cov_1.753623_g133119_i0 PRJNA976345 134727 173 1.753623 3.03376779 root 1 Root_unresolved Root_unresolved 42.7 0.0144   NR WP_022854953.1 886 g133119 i0 45 1.35260115606936 40 22 69.4 0 173 54 79 118 WP_022854953.1 ankyrin repeat domain-containing protein [Thermodesulfobacterium thermophilum] diamond 234 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium thermophilum
29047308 29047308 PRJNA976345_P_NODE_84828_length_201_cov_2.825301_g83220_i0 PRJNA976345 84828 201 2.825301 5.67885501 Desulfovibrio desulfuricans 876 Bacteria Bacteria 87 5.51e-18   NR WP_022657687.1 876 g83220 i0 71.2 1.97014925373134 66 18 98.5 1 1 198 155 219 WP_022657687.1 complex I subunit 5 family protein [Desulfovibrio desulfuricans] diamond 396 87 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
29173660 29173660 PRJNA976345_P_NODE_72329_length_214_cov_1.379888_g70721_i0 PRJNA976345 72329 214 1.379888 2.95296032 Desulfovibrio 872 Bacteria Bacteria 100 1.7e-23   NR WP_143142718.1 872 g70721 i0 68.4 1.06542056074766 76 17 96.7 1 207 1 13 88 WP_143142718.1 MULTISPECIES: hypothetical protein [Desulfovibrio] diamond 228 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio  
29899817 29899817 PRJNA976345_P_NODE_139511_length_171_cov_1.455882_g137903_i0 PRJNA976345 139511 171 1.455882 2.48955822 Desulfocapsa sp. 2066021 Bacteria Bacteria 42.7 0.0147   NR RUM46947.1 2066021 g137903 i0 47.6 0.736842105263158 42 22 73.7 0 126 1 529 570 RUM46947.1 MAG: hypothetical protein DSY80_01375, partial [Desulfocapsa sp.] diamond 126 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfocapsa Desulfocapsa sp.
30026179 30026179 PRJNA976345_P_NODE_117011_length_179_cov_2.520833_g115403_i0 PRJNA976345 117011 179 2.520833 4.51229107 Desulfovibrio sp. 885 Bacteria Bacteria 108 2.4e-26   NR WP_366525785.1 885 g115403 i0 94.9 0.988826815642458 59 3 98.9 0 178 2 168 226 WP_366525785.1 NAD(P)-dependent malic enzyme [Desulfovibrio sp.] diamond 177 108 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30026229 30026229 PRJNA976345_P_NODE_61431_length_227_cov_3.005208_g59823_i0 PRJNA976345 61431 227 3.005208 6.82182216 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 134 3.79e-38   NR WP_288908471.1 167968 g59823 i0 100 0.991189427312775 75 0 99.1 0 2 226 5 79 WP_288908471.1 ABC transporter permease, partial [uncultured Desulfovibrio sp.] diamond 225 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
31131612 31131612 PRJNA976345_P_NODE_22495_length_355_cov_1.584375_g20894_i0 PRJNA976345 22495 355 1.584375 5.62453125 Desulfobacterales bacterium 2044940 Bacteria Bacteria 144 6.16e-41   NR MDO8942014.1 2044940 g20894 i0 95.2 0.709859154929578 84 4 71 0 102 353 1 84 MDO8942014.1 cation transporter [Desulfobacterales bacterium] diamond 252 144 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31732638 31732638 PRJNA976345_P_NODE_142657_length_169_cov_2.694030_g141049_i0 PRJNA976345 142657 169 2.69403 4.5529107 Desulfovibrio sp. 885 Bacteria Bacteria 117 1.23e-32   NR WP_291331891.1 885 g141049 i0 98.2 0.994082840236686 56 1 99.4 0 1 168 22 77 WP_291331891.1 hypothetical protein [Desulfovibrio sp.] diamond 168 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32049083 32049083 PRJNA976345_P_NODE_11498_length_507_cov_2.078390_g9952_i0 PRJNA976345 11498 507 2.07839 10.5374373 Humidesulfovibrio mexicanus 147047 Bacteria Bacteria 79.7 3.6e-15   NR WP_143337396.1 147047 g9952 i0 57.7 0.420118343195266 71 28 42 1 480 268 32 100 WP_143337396.1 hypothetical protein [Humidesulfovibrio mexicanus] diamond 213 79.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Humidesulfovibrio Humidesulfovibrio mexicanus

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