RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA924320" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA924320 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
26866716 26866716 PRJNA924320_S_NODE_41_length_4015_cov_24.011346_g38_i1 PRJNA924320 41 4015 24.011346 964.0555419 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 54.7 6.45e-4   NR GJM17643.1 2202153 g38 i1 25.3 0.168119551681196 225 133 15.8 7 1835 1203 10 213 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 675 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27277694 27277694 PRJNA924320_S_NODE_503_length_1166_cov_2.981200_g460_i0 PRJNA924320 503 1166 2.9812 34.760792 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 155 4.38e-38   NR HAO22905.1 2049433 g460 i0 39.5 0.501715265866209 195 112 49.1 4 592 1164 3 195 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 585 155 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
27404099 27404099 PRJNA924320_S_NODE_31463_length_195_cov_1.397260_g31321_i0 PRJNA924320 31463 195 1.39726 2.724657 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 49.3 9.47e-5   NR HAO22905.1 2049433 g31321 i0 35.4 1 65 41 98.5 1 2 193 347 411 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 195 49.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
27783041 27783041 PRJNA924320_S_NODE_6484_length_375_cov_2.733129_g6342_i0 PRJNA924320 6484 375 2.733129 10.24923375 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 85.5 1.72e-16   NR HAO22905.1 2049433 g6342 i0 34.4 1.024 128 79 98.4 2 6 374 411 538 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 384 85.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28667072 28667072 PRJNA924320_S_NODE_47_length_3504_cov_19.902171_g38_i2 PRJNA924320 47 3504 19.902171 697.37207184 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 54.7 5.55e-4   NR GJM17643.1 2202153 g38 i2 25.3 0.19263698630137 225 133 18.1 7 1324 692 10 213 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 675 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
28982890 28982890 PRJNA924320_S_NODE_20108_length_231_cov_1.500000_g19966_i0 PRJNA924320 20108 231 1.5 3.465 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 42 0.0123   NR GJM17551.1 2202153 g19966 i0 41 0.506493506493506 39 23 50.6 0 231 115 33 71 GJM17551.1 MAG: hypothetical protein DHS20C13_28780 [Thermodesulfobacteriota bacterium] diamond 117 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29613798 29613798 PRJNA924320_S_NODE_4850_length_429_cov_2.136842_g4709_i0 PRJNA924320 4850 429 2.136842 9.16705218 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 60.5 6.4e-8   NR GJM17643.1 2202153 g4709 i0 28.6 0.832167832167832 119 82 83.2 2 4 360 97 212 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 357 60.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30024876 30024876 PRJNA924320_S_NODE_29631_length_200_cov_0.913907_g29489_i0 PRJNA924320 29631 200 0.913907 1.827814 Syntrophaceae bacterium 2052184 Bacteria Bacteria 44.7 0.00432   NR MEN6321577.1 2052184 g29489 i0 34.3 1.005 67 42 97.5 1 4 198 167 233 MEN6321577.1 arginine deiminase family protein [Syntrophaceae bacterium] diamond 201 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium
30277840 30277840 PRJNA924320_S_NODE_52_length_3264_cov_6.682115_g48_i0 PRJNA924320 52 3264 6.682115 218.1042336 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 75.9 3.14e-11   NR GJM17643.1 2202153 g48 i0 29.5 0.202205882352941 220 134 19.4 7 741 1373 5 212 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 660 75.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30309553 30309553 PRJNA924320_S_NODE_21932_length_224_cov_0.874286_g21790_i0 PRJNA924320 21932 224 0.874286 1.95840064 Desulfovibrio sp. 885 Bacteria Bacteria 43.1 0.0217   NR MBI5519213.1 885 g21790 i0 54.3 0.46875 35 16 46.9 0 72 176 204 238 MBI5519213.1 [protein-PII] uridylyltransferase [Desulfovibrio sp.] diamond 105 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30348441 30348441 PRJNA924320_S_NODE_3552_length_496_cov_2.013423_g3412_i0 PRJNA924320 3552 496 2.013423 9.98657808 Pseudomonadati 3379134 Bacteria Bacteria 117 9.59e-29   NR WP_199263131.1 1909699 g3412 i0 34.5 18.6350806451613 165 108 99.8 0 2 496 43 207 WP_199263131.1 slipin family protein [Desulfobulbus oligotrophicus] diamond 9243 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus oligotrophicus
30688099 30688099 PRJNA924320_S_NODE_7853_length_345_cov_1.378378_g7711_i0 PRJNA924320 7853 345 1.378378 4.7554041 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 90.1 2.87e-18   NR HAO22905.1 2049433 g7711 i0 37.7 0.921739130434783 106 65 92.2 1 326 9 354 458 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 318 90.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30790222 30790222 PRJNA924320_S_NODE_9334_length_320_cov_1.372694_g9192_i0 PRJNA924320 9334 320 1.372694 4.3926208 Pseudomonadati 3379134 Bacteria Bacteria 50.4 1.76e-4   NR WP_027186307.1 102109 g9192 i0 37.2 3.61875 86 45 72.2 2 303 73 277 362 WP_027186307.1 amidohydrolase [Desulfovibrio inopinatus] diamond 1158 50.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio inopinatus
30941192 30941192 PRJNA924320_S_NODE_54394_length_162_cov_2.707965_g54252_i0 PRJNA924320 54394 162 2.707965 4.3869033 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 47.4 2.83e-4   NR MEW6186487.1 2202153 g54252 i0 43.4 0.981481481481482 53 29 98.1 1 160 2 25 76 MEW6186487.1 lipid-A-disaccharide synthase [Thermodesulfobacteriota bacterium] diamond 159 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31359269 31359269 PRJNA924320_S_NODE_28416_length_203_cov_1.311688_g28274_i0 PRJNA924320 28416 203 1.311688 2.66272664 Pseudomonadati 3379134 Bacteria Bacteria 83.6 8.04e-17   NR WP_092231385.1 90732 g28274 i0 59.7 24.3103448275862 67 27 99 0 202 2 368 434 WP_092231385.1 ATP-dependent protease ATPase subunit HslU [Desulfobacula phenolica] diamond 4935 83.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacula Desulfobacula phenolica
31668104 31668104 PRJNA924320_S_NODE_53477_length_163_cov_0.894737_g53335_i0 PRJNA924320 53477 163 0.894737 1.45842131 Desulfocapsa sp. 2066021 Bacteria Bacteria 46.2 3.98e-4   NR MCK5070273.1 2066021 g53335 i0 69.7 1.14110429447853 33 10 60.7 0 8 106 129 161 MCK5070273.1 DNA mismatch repair protein MutS [Desulfocapsa sp.] diamond 186 46.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfocapsa Desulfocapsa sp.
32181716 32181716 PRJNA924320_S_NODE_44438_length_169_cov_1.700000_g44296_i0 PRJNA924320 44438 169 1.7 2.873 Desulfovibrio 872 Bacteria Bacteria 42.4 0.0192   NR MBQ4567684.1 885 g44296 i0 72 6.79881656804734 25 7 44.4 0 105 31 463 487 MBQ4567684.1 AMP-binding protein [Desulfovibrio sp.] diamond 1149 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32427555 32427555 PRJNA924320_S_NODE_39_length_4054_cov_26.094382_g38_i0 PRJNA924320 39 4054 26.094382 1057.86624628 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 54.7 6.52e-4   NR GJM17643.1 2202153 g38 i0 25.3 0.1665022200296 225 133 15.6 7 2181 2813 10 213 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 675 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32837425 32837425 PRJNA924320_S_NODE_820_length_958_cov_3.633663_g747_i0 PRJNA924320 820 958 3.633663 34.81049154 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 273 4.27e-83   NR HAO22905.1 2049433 g747 i0 43.6 0.905010438413361 289 162 90.2 1 3 866 284 572 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 867 273 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae 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);;