RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA758398" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA758398 · 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
4567969 4567969 PRJNA758398_S_NODE_18684_length_233_cov_1.663043_g18543_i0 PRJNA758398 18684 233 1.663043 3.87489019 Pseudomonadati 3379134 Bacteria Bacteria 121 6.1099999999999994e-30   NR WP_011697768.1 119484 g18543 i0 75.3 13.7768240343348 77 19 99.1 0 231 1 311 387 WP_011697768.1 phosphoenolpyruvate carboxykinase (GTP) [Syntrophobacter fumaroxidans] diamond 3210 122 0.991803278688525 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter fumaroxidans
7118661 7118661 PRJNA758398_S_NODE_39446_length_172_cov_1.243902_g39305_i0 PRJNA758398 39446 172 1.243902 2.13951144 uncultured Desulfobacterium sp. 201089 Bacteria Bacteria 60.2 8.62e-5   NTclustered gi|2814788371|emb|OY764894.2| 201089 g39305 i0 97.143 2.57558139534884 35 1 20 0 130 164 146400 146366 MAG: uncultured Desulfobacterium sp. isolate 35125921-b51f-40db-957b-bccbeeb29ead genome assembly, chromosome: 1 blastn 443 60.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
7582344 7582344 PRJNA758398_S_NODE_18146_length_236_cov_1.379679_g18005_i0 PRJNA758398 18146 236 1.379679 3.25604244 Pelobacter propionicus 29543 Bacteria Bacteria 58.5 7.85e-8   NR WP_011735919.1 29543 g18005 i0 59.6 1.77966101694915 47 19 59.7 0 55 195 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
9668499 9668499 PRJNA758398_S_NODE_5508_length_405_cov_2.148876_g5367_i0 PRJNA758398 5508 405 2.148876 8.7029478 Desulfovibrio litoralis 466107 Bacteria Bacteria 75.9 4.47e-14   NR WP_072697495.1 466107 g5367 i0 34.9 2.42222222222222 109 68 80.7 2 391 65 24 129 WP_072697495.1 hypoxanthine phosphoribosyltransferase [Desulfovibrio litoralis] diamond 981 75.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio litoralis
17782022 17782022 PRJNA758398_S_NODE_37194_length_177_cov_1.054688_g37053_i0 PRJNA758398 37194 177 1.054688 1.86679776 Pseudomonadati 3379134 Bacteria Bacteria 110 2.7300000000000003e-26   NR WP_011697768.1 119484 g37053 i0 78 15 59 13 100 0 177 1 82 140 WP_011697768.1 phosphoenolpyruvate carboxykinase (GTP) [Syntrophobacter fumaroxidans] diamond 2655 110 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter fumaroxidans
21142059 21142059 PRJNA758398_S_NODE_13837_length_265_cov_1.328704_g13696_i0 PRJNA758398 13837 265 1.328704 3.5210656 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 103 5.79e-26   NR MDX1815211.1 2202153 g13696 i0 68.5 0.826415094339623 73 22 82.6 1 46 264 15 86 MDX1815211.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Thermodesulfobacteriota bacterium] diamond 219 103 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
21142108 21142108 PRJNA758398_S_NODE_17477_length_240_cov_1.068063_g17336_i0 PRJNA758398 17477 240 1.068063 2.5633512 Desulfuromonas versatilis 2802975 Bacteria Bacteria 196 9.42e-46   NTclustered gi|2065532709|dbj|AP024355.1| 2802975 g17336 i0 82.805 88.9625 221 36 92 2 1 220 4581178 4581397 Desulfuromonas versatilis NIT-T3 DNA, complete genome blastn 21351 196 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas versatilis
23692750 23692750 PRJNA758398_S_NODE_359_length_1263_cov_3.182043_g316_i0 PRJNA758398 359 1263 3.182043 40.18920309 Syntrophobacteraceae bacterium 2052185 Bacteria Bacteria 223 3.01e-61   NR MDR3556234.1 2052185 g316 i0 40.1 2.58669833729216 352 184 82.2 8 1116 79 57 387 MDR3556234.1 Ig-like domain repeat protein [Syntrophobacteraceae bacterium] diamond 3267 223 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium
26841516 26841516 PRJNA758398_S_NODE_32781_length_187_cov_1.079710_g32640_i0 PRJNA758398 32781 187 1.07971 2.0190577 root 1 Root_unresolved Root_unresolved 59.3 2.54e-8   NR WP_073475523.1 259354 g32640 i0 45.9 3.78609625668449 61 31 97.9 2 183 1 258 316 WP_073475523.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum alkenivorans] diamond 708 59.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum alkenivorans
27116069 27116069 PRJNA758398_S_NODE_46002_length_165_cov_0.879310_g45861_i0 PRJNA758398 46002 165 0.87931 1.4508615 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 97.4 4.44e-24   NR GJM17675.1 2202153 g45861 i0 83.3 0.981818181818182 54 9 98.2 0 2 163 46 99 GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium] diamond 162 97.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27379096 27379096 PRJNA758398_S_NODE_16143_length_248_cov_1.025126_g16002_i0 PRJNA758398 16143 248 1.025126 2.54231248 Bilophila 35832 Bacteria Bacteria 89.4 1.13e-19   NR WP_347865643.1 35833 g16002 i0 48.1 2.89112903225806 79 40 95.6 1 240 4 43 120 WP_347865643.1 thrombospondin type-1 domain-containing protein [Bilophila wadsworthia] diamond 717 89.7 0.996655518394649 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila wadsworthia
28852888 28852888 PRJNA758398_S_NODE_1828_length_672_cov_4.240770_g1707_i0 PRJNA758398 1828 672 4.24077 28.4979744 Desulfamplus sp. 2006184 Bacteria Bacteria 171 3.45e-49   NR MBF0303540.1 2006184 g1707 i0 63.6 6.09375 132 47 58.9 1 585 190 104 234 MBF0303540.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Desulfamplus sp.] diamond 4095 171 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus sp.
28948058 28948058 PRJNA758398_S_NODE_12248_length_279_cov_2.191304_g12107_i0 PRJNA758398 12248 279 2.191304 6.11373816 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 130 3.14e-33   NR MDY7001464.1 2202153 g12107 i0 66.3 6.90322580645161 92 30 98.9 1 278 3 147 237 MDY7001464.1 catalase [Thermodesulfobacteriota bacterium] diamond 1926 130 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29421260 29421260 PRJNA758398_S_NODE_4449_length_449_cov_2.397500_g4308_i0 PRJNA758398 4449 449 2.3975 10.764775 Syntrophales bacterium 2928017 Bacteria Bacteria 100 2.85e-22   NR HEX7504117.1 2928017 g4308 i0 54.5 2.18485523385301 101 41 65.5 4 305 12 2 100 HEX7504117.1 C1 family peptidase [Syntrophales bacterium] diamond 981 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
29989939 29989939 PRJNA758398_S_NODE_52691_length_162_cov_0.902655_g52550_i0 PRJNA758398 52691 162 0.902655 1.4623011 Candidatus Electrothrix sp. AUS4 2249220 Bacteria Bacteria 44.7 0.00263   NR MCI5120711.1 2249220 g52550 i0 59.3 0.5 27 11 50 0 70 150 4 30 MCI5120711.1 hypothetical protein [Candidatus Electrothrix sp. AUS4] diamond 81 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. AUS4
30558346 30558346 PRJNA758398_S_NODE_15413_length_253_cov_1.053922_g15272_i0 PRJNA758398 15413 253 1.053922 2.66642266 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 42.7 0.0257   NR HJX60397.1 2202153 g15272 i0 61.3 0.367588932806324 31 12 36.8 0 251 159 142 172 HJX60397.1 biotin/lipoyl-containing protein [Thermodesulfobacteriota bacterium] diamond 93 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30779775 30779775 PRJNA758398_S_NODE_50694_length_163_cov_0.894737_g50553_i0 PRJNA758398 50694 163 0.894737 1.45842131 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 99.8 5.48e-25   NR GJM17675.1 2202153 g50553 i0 90.6 0.975460122699387 53 5 97.5 0 162 4 39 91 GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium] diamond 159 99.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32370876 32370876 PRJNA758398_S_NODE_31219_length_191_cov_1.014085_g31078_i0 PRJNA758398 31219 191 1.014085 1.93690235 Candidatus Electrothrix 1859128 Bacteria Bacteria 63.9 6.23e-10   NR MCI5142094.1 2249221 g31078 i0 54 5.49738219895288 50 23 78.5 0 150 1 323 372 MCI5142094.1 PAS domain S-box protein [Candidatus Electrothrix sp. ATG1] diamond 1050 63.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. ATG1_2 ATG1
32613864 32613864 PRJNA758398_S_NODE_36660_length_178_cov_1.186047_g36519_i0 PRJNA758398 36660 178 1.186047 2.11116366 Desulfobacterales bacterium HSG16 3055594 Bacteria Bacteria 68.6 1.17e-11   NR MDM8516206.1 3055594 g36519 i0 66.7 8.62921348314607 57 14 96.1 1 1 171 345 396 MDM8516206.1 phosphoglycerate kinase [Desulfobacterales bacterium HSG16] diamond 1536 68.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium HSG16

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