RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA914897", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 25 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA914897 · 25 ✖

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
3445761 3445761 PRJNA914897_P_NODE_323_length_2413_cov_3.842735_g273_i0 PRJNA914897 323 2413 3.842735 92.72519555 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 479 5e-156   NR HAO22905.1 2049433 g273 i0 41.3 0.711147948611687 572 314 68.6 8 1760 105 3 572 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 1716 479 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
7629048 7629048 PRJNA914897_P_NODE_11586_length_543_cov_2.551064_g11166_i0 PRJNA914897 11586 543 2.551064 13.85227752 Pelobacter propionicus 29543 Bacteria Bacteria 58.5 1.62e-6   NR WP_011735919.1 29543 g11166 i0 59.6 0.773480662983425 47 19 26 0 30 170 58 104 WP_011735919.1 translation elongation factor Ts [Pelobacter propionicus] diamond 420 58.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
14922846 14922846 PRJNA914897_P_NODE_31312_length_281_cov_1.250000_g30888_i0 PRJNA914897 31312 281 1.25 3.5125 root 1 Root_unresolved Root_unresolved 147 7.2799999999999994e-40   NR PLX74580.1 892 g30888 i0 83.9 48.6725978647687 87 14 92.9 0 10 270 6 92 PLX74580.1 MAG: adenosylhomocysteinase [Desulfuromonas sp.] diamond 13677 147 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
17473195 17473195 PRJNA914897_P_NODE_41294_length_243_cov_0.905882_g40870_i0 PRJNA914897 41294 243 0.905882 2.20129326 Desulfovibrio sp. 86 2666132 Bacteria Bacteria 424 4.03e-114   NTclustered gi|1862956133|emb|LR738849.1| 2666132 g40870 i0 98.34 0.991769547325103 241 4 99 0 3 243 1003169 1002929 Desulfovibrio sp. 86 genome assembly, chromosome: DESU86 blastn 241 424 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. 86
23847186 23847186 PRJNA914897_P_NODE_30759_length_284_cov_1.431280_g30335_i0 PRJNA914897 30759 284 1.43128 4.0648352 Caldimicrobium thiodismutans 1653476 Bacteria Bacteria 52.8 0.026   NTclustered gi|972621738|dbj|AP014945.1| 1653476 g30335 i0 96.774 0.109154929577465 31 1 11 0 65 95 486875 486905 Caldimicrobium thiodismutans DNA, complete genome blastn 31 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Caldimicrobium Caldimicrobium thiodismutans
25121142 25121142 PRJNA914897_P_NODE_80_length_3451_cov_6.974245_g70_i0 PRJNA914897 80 3451 6.974245 240.68119495 Pseudodesulfovibrio piezophilus 879567 Bacteria Bacteria 69.4 3.57e-6   NTclustered gi|451894361|emb|FO203427.1| 1322246 g70 i0 78.992 0.794262532599247 119 11 3 10 3285 3393 2361904 2362018 Desulfovibrio piezophilus C1TLV30 complete genome blastn 2741 69.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio piezophilus
26866558 26866558 PRJNA914897_P_NODE_23821_length_337_cov_1.738636_g23397_i0 PRJNA914897 23821 337 1.738636 5.85920332 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 64.7 1.69e-9   NR MEA2114881.1 2202153 g23397 i0 35 1.90504451038576 103 65 91.7 2 323 15 42 142 MEA2114881.1 glucokinase [Thermodesulfobacteriota bacterium] diamond 642 64.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27656561 27656561 PRJNA914897_P_NODE_13544_length_492_cov_0.906921_g13122_i0 PRJNA914897 13544 492 0.906921 4.46205132 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 135 1.88e-33   NR HAO22905.1 2049433 g13122 i0 35.6 1.07926829268293 177 99 98.8 3 486 1 243 419 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 531 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
27656571 27656571 PRJNA914897_P_NODE_20484_length_373_cov_1.283333_g20061_i0 PRJNA914897 20484 373 1.283333 4.78683209 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 53.1 2.38e-6   NR GJM17551.1 2202153 g20061 i0 39.3 0.490616621983914 61 37 49.1 0 345 163 14 74 GJM17551.1 MAG: hypothetical protein DHS20C13_28780 [Thermodesulfobacteriota bacterium] diamond 183 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27663899 27663899 PRJNA914897_P_NODE_1544_length_1457_cov_3.802023_g1393_i0 PRJNA914897 1544 1457 3.802023 55.39547511 Pseudomonadati 3379134 Bacteria Bacteria 49.7 0.0247   NR WP_367360148.1 48412 g1393 i0 27.5 1.398078242965 142 86 27.6 6 440 39 139 271 WP_367360148.1 hypothetical protein [Syntrophus sp. (in: bacteria)] diamond 2037 50.1 0.992015968063872 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus Syntrophus sp. (in: bacteria)
28571985 28571985 PRJNA914897_P_NODE_20327_length_375_cov_1.145695_g19905_i0 PRJNA914897 20327 375 1.145695 4.29635625 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 147 2.0099999999999999e-38   NR HAO22905.1 2049433 g19905 i0 55 0.888 111 50 88.8 0 336 4 375 485 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 333 147 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28792924 28792924 PRJNA914897_P_NODE_6487_length_775_cov_1.650997_g6112_i0 PRJNA914897 6487 775 1.650997 12.79522675 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 57.4 7.05e-6   NR GJM17643.1 2202153 g6112 i0 35 0.309677419354839 80 51 30.6 1 136 372 133 212 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 240 57.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29172083 29172083 PRJNA914897_P_NODE_12629_length_514_cov_1.916100_g12209_i0 PRJNA914897 12629 514 1.9161 9.848754 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 146 2.1599999999999996e-37   NR HAO22905.1 2049433 g12209 i0 41.9 0.933852140077821 160 91 93.4 2 513 34 150 307 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 480 146 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29329797 29329797 PRJNA914897_P_NODE_2369_length_1258_cov_2.191561_g2158_i0 PRJNA914897 2369 1258 2.191561 27.56983738 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 235 2.97e-67   NR HAO22905.1 2049433 g2158 i0 32.7 0.977742448330684 410 269 97.8 6 1258 29 186 588 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 1230 235 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30056016 30056016 PRJNA914897_P_NODE_4771_length_919_cov_1.113475_g4443_i0 PRJNA914897 4771 919 1.113475 10.23283525 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 158 5.3899999999999986e-40   NR HAO22905.1 2049433 g4443 i0 31.6 1.0544069640914 323 197 99.6 9 919 5 135 451 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 969 158 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30529983 30529983 PRJNA914897_P_NODE_25953_length_319_cov_0.939024_g25529_i0 PRJNA914897 25953 319 0.939024 2.99548656 Desulfuromonas sp. 892 Bacteria Bacteria 47.4 0.002   NR PLX79391.1 892 g25529 i0 24.8 0.949843260188088 101 72 92.2 2 20 313 47 146 PLX79391.1 MAG: cytochrome B6 [Desulfuromonas sp.] diamond 303 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
30719589 30719589 PRJNA914897_P_NODE_26174_length_317_cov_1.229508_g25750_i0 PRJNA914897 26174 317 1.229508 3.89754036 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 79.7 7.54e-15   NR MCG6907650.1 2049433 g25750 i0 53.6 7.83596214511041 69 31 64.4 1 315 112 203 271 MCG6907650.1 insulinase family protein [Desulfobacteraceae bacterium] diamond 2484 79.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30726968 30726968 PRJNA914897_P_NODE_18754_length_396_cov_1.034056_g18332_i0 PRJNA914897 18754 396 1.034056 4.09486176 Pseudomonadati 3379134 Bacteria Bacteria 62.4 2.79e-8   NR WP_052812718.1 617001 g18332 i0 40 7.42424242424242 90 44 64.4 3 49 303 646 730 WP_052812718.1 PAS domain S-box protein [Desulfonatronum thioautotrophicum] diamond 2940 62.8 0.993630573248408 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronaceae Desulfonatronum Desulfonatronum thioautotrophicum
31004105 31004105 PRJNA914897_P_NODE_41454_length_243_cov_0.905882_g41030_i0 PRJNA914897 41454 243 0.905882 2.20129326 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 78.2 7.53e-17   NR MFP4037996.1 2049433 g41030 i0 60 1.48148148148148 60 23 74.1 1 60 239 2 60 MFP4037996.1 ATP-binding cassette domain-containing protein [Desulfobacteraceae bacterium] diamond 360 78.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31256823 31256823 PRJNA914897_P_NODE_775_length_1798_cov_2.339130_g680_i0 PRJNA914897 775 1798 2.33913 42.0575574 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 337 5.6e-104   NR HAO22905.1 2049433 g680 i0 36.5 0.782536151279199 469 279 75.6 6 1364 6 18 483 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 1407 337 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31549128 31549128 PRJNA914897_P_NODE_16556_length_429_cov_3.688202_g16134_i0 PRJNA914897 16556 429 3.688202 15.82238658 Bacteria 2 Bacteria Bacteria 45.4 0.0156   NR PLY05436.1 892 g16134 i0 44.7 1.31468531468531 47 26 32.9 0 133 273 33 79 PLY05436.1 MAG: NAD(P)H-dependent oxidoreductase [Desulfuromonas sp.] diamond 564 45.8 0.991266375545852 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
31604824 31604824 PRJNA914897_P_NODE_22956_length_346_cov_1.128205_g22532_i0 PRJNA914897 22956 346 1.128205 3.9035893 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 49.3 3.74e-4   NR GJM17643.1 2202153 g22532 i0 32.5 0.69364161849711 80 53 68.5 1 279 43 134 213 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 240 49.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32174432 32174432 PRJNA914897_P_NODE_32938_length_271_cov_1.555556_g32514_i0 PRJNA914897 32938 271 1.555556 4.21555676 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 43.5 0.0211   NR GJM17643.1 2202153 g32514 i0 30.1 0.808118081180812 73 43 72 2 72 266 112 184 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 219 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32774230 32774230 PRJNA914897_P_NODE_20640_length_371_cov_1.305369_g20217_i0 PRJNA914897 20640 371 1.305369 4.84291899 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 123 8.049999999999998e-30   NR HAO22905.1 2049433 g20217 i0 50.5 0.849056603773585 105 51 84.9 1 315 1 73 176 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 315 123 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
32781519 32781519 PRJNA914897_P_NODE_20440_length_373_cov_2.303333_g20017_i0 PRJNA914897 20440 373 2.303333 8.59143209 Pseudomonadati 3379134 Bacteria Bacteria 89.7 4.32e-18   NR WP_066605373.1 132132 g20017 i0 69.4 10.544235924933 62 19 49.9 0 186 1 3 64 WP_066605373.1 ATP-dependent protease ATPase subunit HslU [Desulfomicrobium orale] diamond 3933 90.1 0.995560488346282 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium orale

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