RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA1022139", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 27 ✖

tax_kingdom 1

  • Pseudomonadati · 27 ✖

bioproject 1

  • PRJNA1022139 · 27 ✖

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
1436534 1436534 PRJNA1022139_P_NODE_41122_length_243_cov_0.905882_g41017_i0 PRJNA1022139 41122 243 0.905882 2.20129326 Desulfomicrobium baculatum 899 Bacteria Bacteria 148 2.72e-31   NTclustered gi|256576994|gb|CP001629.1| 525897 g41017 i0 78.151 10.3909465020576 238 48 97 4 1 236 3683026 3682791 Desulfomicrobium baculatum DSM 4028, complete genome blastn 2525 148 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium baculatum
2712143 2712143 PRJNA1022139_P_NODE_39743_length_245_cov_0.895349_g39638_i0 PRJNA1022139 39743 245 0.895349 2.19360505 Bacteria 2 Bacteria Bacteria 79.7 1.44e-15   NR OGR25613.1 1797914 g39638 i0 54.3 5.95102040816327 81 35 99.2 2 243 1 27 105 OGR25613.1 MAG: short-chain dehydrogenase [Desulfobacterales bacterium RIFOXYA12_FULL_46_15] diamond 1458 80.5 0.990062111801242 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium RIFOXYA12_FULL_46_15
3988321 3988321 PRJNA1022139_P_NODE_38084_length_247_cov_0.885057_g37979_i0 PRJNA1022139 38084 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 128 6.51e-33   NR KQC13565.1 1735325 g37979 i0 77.8 22.5910931174089 81 18 98.4 0 245 3 217 297 KQC13565.1 MAG: UDP-glucose 6-dehydrogenase [Desulfuromonas sp. SDB] diamond 5580 128 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. SDB
4831579 4831579 PRJNA1022139_P_NODE_14024_length_363_cov_2.655172_g13919_i0 PRJNA1022139 14024 363 2.655172 9.63827436 Desulfarculus 453229 Bacteria Bacteria 141 7.14e-29   NTclustered gi|301638057|gb|CP002085.1| 644282 g13919 i0 83.125 35.3911845730028 160 21 42 4 163 316 831033 830874 Desulfarculus baarsii DSM 2075, complete genome blastn 12847 141 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus baarsii
9089179 9089179 PRJNA1022139_P_NODE_21908_length_299_cov_2.743363_g21803_i0 PRJNA1022139 21908 299 2.743363 8.20265537 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 135 1.9e-36   NR PLX91744.1 892 g21803 i0 62.6 12.7625418060201 99 37 99.3 0 298 2 30 128 PLX91744.1 MAG: alcohol dehydrogenase [Desulfuromonas sp.] diamond 3816 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
13756976 13756976 PRJNA1022139_P_NODE_28351_length_273_cov_1.155000_g28246_i0 PRJNA1022139 28351 273 1.155 3.15315 Desulfobacterales bacterium 2044940 Bacteria Bacteria 70.5 9.43e-12   NR MCG8685746.1 2044940 g28246 i0 58.9 2.92307692307692 56 23 61.5 0 28 195 147 202 MCG8685746.1 long-chain fatty acid--CoA ligase [Desulfobacterales bacterium] diamond 798 70.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
26749620 26749620 PRJNA1022139_P_NODE_16201_length_342_cov_2.174721_g16096_i0 PRJNA1022139 16201 342 2.174721 7.43754582 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 53.5 1.88e-5   NR MFC1834884.1 2202153 g16096 i0 32.3 0.842105263157895 96 57 83.3 3 4 288 40 128 MFC1834884.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 288 53.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27501277 27501277 PRJNA1022139_P_NODE_26943_length_278_cov_1.200000_g26838_i0 PRJNA1022139 26943 278 1.2 3.336 Pseudomonadati 3379134 Bacteria Bacteria 89.4 2.64e-19   NR HON58027.1 2053614 g26838 i0 44.1 3 93 51 99.3 1 2 277 42 134 HON58027.1 SDR family NAD(P)-dependent oxidoreductase [Smithella sp.] diamond 834 89.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp.
27532677 27532677 PRJNA1022139_P_NODE_21683_length_301_cov_1.350877_g21578_i0 PRJNA1022139 21683 301 1.350877 4.06613977 Pseudomonadati 3379134 Bacteria Bacteria 57.4 5.41e-7   NR MFQ5585789.1 2202153 g21578 i0 54.2 0.956810631229236 48 22 47.8 0 249 106 727 774 MFQ5585789.1 glycoside hydrolase family 15 protein [Thermodesulfobacteriota bacterium] diamond 288 57.8 0.993079584775087 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27698725 27698725 PRJNA1022139_P_NODE_28484_length_272_cov_1.547739_g28379_i0 PRJNA1022139 28484 272 1.547739 4.20985008 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 47 7.01e-4   NR HBT97328.1 2053307 g28379 i0 39.4 0.783088235294118 71 43 78.3 0 27 239 41 111 HBT97328.1 hypothetical protein [Desulfobulbaceae bacterium] diamond 213 47 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
27730304 27730304 PRJNA1022139_P_NODE_6104_length_527_cov_8.555066_g6000_i0 PRJNA1022139 6104 527 8.555066 45.08519782 Smithellaceae bacterium 2964540 Bacteria Bacteria 64.3 1.57e-8   NR HPD56940.1 2964540 g6000 i0 38 2.53889943074004 121 59 67.7 5 438 82 239 345 HPD56940.1 RHS repeat-associated core domain-containing protein [Smithellaceae bacterium] diamond 1338 64.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae   Smithellaceae bacterium
27761766 27761766 PRJNA1022139_P_NODE_15844_length_346_cov_0.959707_g15739_i0 PRJNA1022139 15844 346 0.959707 3.32058622 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 95.9 2.69e-20   NR HAO22905.1 2049433 g15739 i0 41.2 0.988439306358382 114 67 98.8 0 344 3 432 545 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 342 95.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29498070 29498070 PRJNA1022139_P_NODE_40250_length_244_cov_0.900585_g40145_i0 PRJNA1022139 40250 244 0.900585 2.1974274 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 95.9 7.44e-21   NR HAO22905.1 2049433 g40145 i0 51.8 1.02049180327869 83 37 99.6 2 1 243 93 174 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 249 95.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29718881 29718881 PRJNA1022139_P_NODE_8790_length_446_cov_1.265416_g8685_i0 PRJNA1022139 8790 446 1.265416 5.64375536 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 69.3 1.33e-10   NR MEW6271972.1 2202153 g8685 i0 38.8 1.72869955156951 129 55 75.3 6 436 101 138 259 MEW6271972.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 771 69.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29742614 29742614 PRJNA1022139_P_NODE_24770_length_285_cov_2.023585_g24665_i0 PRJNA1022139 24770 285 2.023585 5.76721725 Bacteria 2 Bacteria Bacteria 117 4.83e-28   NR WP_207683226.1 45655 g24665 i0 60.2 2.02105263157895 98 35 98.9 1 283 2 306 403 WP_207683226.1 S8 family serine peptidase [Desulfonema magnum] diamond 576 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfonema Desulfonema magnum
29750423 29750423 PRJNA1022139_P_NODE_33971_length_252_cov_1.206704_g33866_i0 PRJNA1022139 33971 252 1.206704 3.04089408 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 43.9 0.0132   NR HYA94282.1 2202153 g33866 i0 34.8 1.05952380952381 89 48 94 2 243 7 42 130 HYA94282.1 CAP domain-containing protein [Thermodesulfobacteriota bacterium] diamond 267 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30224424 30224424 PRJNA1022139_P_NODE_14292_length_361_cov_1.069444_g14187_i0 PRJNA1022139 14292 361 1.069444 3.86069284 Bilophila sp. 1929485 Bacteria Bacteria 43.5 0.0227   NR MEG1610719.1 1929485 g14187 i0 29.4 0.706371191135734 85 58 70.6 1 20 274 27 109 MEG1610719.1 S-methyl-5-thioribose-1-phosphate isomerase [Bilophila sp.] diamond 255 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila sp.
30351461 30351461 PRJNA1022139_P_NODE_31512_length_261_cov_1.457447_g31407_i0 PRJNA1022139 31512 261 1.457447 3.80393667 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 92 2.06e-19   NR HAO22905.1 2049433 g31407 i0 45.3 0.988505747126437 86 47 98.9 0 259 2 302 387 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 258 92 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30666833 30666833 PRJNA1022139_P_NODE_22153_length_298_cov_1.368889_g22048_i0 PRJNA1022139 22153 298 1.368889 4.07928922 Desulfobacterales bacterium 2044940 Bacteria Bacteria 44.7 0.00339   NR MCK7514598.1 2044940 g22048 i0 35.6 0.593959731543624 59 35 56.4 1 51 218 45 103 MCK7514598.1 acylphosphatase [Desulfobacterales bacterium] diamond 177 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
30761756 30761756 PRJNA1022139_P_NODE_5594_length_549_cov_1.285714_g5490_i0 PRJNA1022139 5594 549 1.285714 7.05856986 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 58.5 2.39e-6   NR MEW6351608.1 2202153 g5490 i0 37.2 0.704918032786885 129 76 68.3 3 143 517 232 359 MEW6351608.1 ankyrin repeat domain-containing protein [Thermodesulfobacteriota bacterium] diamond 387 58.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30817007 30817007 PRJNA1022139_P_NODE_23914_length_289_cov_1.069444_g23809_i0 PRJNA1022139 23914 289 1.069444 3.09069316 Pseudomonadati 3379134 Bacteria Bacteria 92 3.09e-19   NR MSN26524.1 46610 g23809 i0 46.3 14.9688581314879 95 49 98.6 1 286 2 482 574 MSN26524.1 5-histidylcysteine sulfoxide synthase [Geobacter sp.] diamond 4326 92 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
31014380 31014380 PRJNA1022139_P_NODE_21075_length_305_cov_1.336207_g20970_i0 PRJNA1022139 21075 305 1.336207 4.07543135 Desulfatibacillum sp. 2794877 Bacteria Bacteria 54.3 6.72e-6   NR MBI9074616.1 2794877 g20970 i0 48 0.491803278688525 50 26 49.2 0 303 154 634 683 MBI9074616.1 CHASE2 domain-containing protein [Desulfatibacillum sp.] diamond 150 54.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum sp.
31046336 31046336 PRJNA1022139_P_NODE_455_length_1532_cov_4.274160_g432_i0 PRJNA1022139 455 1532 4.27416 65.4801312 Desulfobacula sp. 2593537 Bacteria Bacteria 55.8 3.03e-4   NR WP_291461510.1 2593537 g432 i0 21.8 0.648172323759791 331 193 64.8 12 1325 333 138 402 WP_291461510.1 PQQ-binding-like beta-propeller repeat protein, partial [Desulfobacula sp.] diamond 993 55.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacula Desulfobacula sp.
31520433 31520433 PRJNA1022139_P_NODE_41076_length_243_cov_0.905882_g40971_i0 PRJNA1022139 41076 243 0.905882 2.20129326 Desulfobacterales bacterium 2044940 Bacteria Bacteria 66.6 1.41e-10   NR MBT9438311.1 2044940 g40971 i0 46.3 0.987654320987654 80 36 97.5 4 1 237 336 409 MBT9438311.1 hypothetical protein [Desulfobacterales bacterium] diamond 240 66.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31828529 31828529 PRJNA1022139_P_NODE_20397_length_310_cov_0.970464_g20292_i0 PRJNA1022139 20397 310 0.970464 3.0084384 Pseudomonadati 3379134 Bacteria Bacteria 83.2 5e-16   NR MEA2038536.1 2202153 g20292 i0 58.9 4.23870967741935 73 30 70.6 0 3 221 160 232 MEA2038536.1 elongation factor G [Thermodesulfobacteriota bacterium] diamond 1314 83.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31986798 31986798 PRJNA1022139_P_NODE_2098_length_847_cov_6.303618_g2017_i0 PRJNA1022139 2098 847 6.303618 53.39164446 Pseudomonadati 3379134 Bacteria Bacteria 142 6.9199999999999995e-37   NR WP_321495025.1 240139 g2017 i0 40.7 5.82998819362456 204 112 71.2 4 24 626 61 258 WP_321495025.1 DUF4197 domain-containing protein [uncultured Desulfobacter sp.] diamond 4938 143 0.993006993006993 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter uncultured Desulfobacter sp.
32532918 32532918 PRJNA1022139_P_NODE_30959_length_263_cov_1.621053_g30854_i0 PRJNA1022139 30959 263 1.621053 4.26336939 Desulfurivibrio sp. D14AmB 3374370 Bacteria Bacteria 42.7 0.0477   NR WP_395499993.1 3374370 g30854 i0 35.5 0.707224334600761 62 38 68.4 1 200 21 398 459 WP_395499993.1 sensor domain-containing diguanylate cyclase [Desulfurivibrio sp. D14AmB] diamond 186 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfurivibrio Desulfurivibrio sp. D14AmB

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