RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240804 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
1621473 1621473 PRJNA1240804_P_NODE_108282_length_169_cov_0.866667_g107916_i0 PRJNA1240804 108282 169 0.866667 1.46466723 Desulfovibrio legallii 571438 Bacteria Bacteria 84.3 3.03e-17   NR WP_288908444.1 571438 g107916 i0 92.2 0.905325443786982 51 4 90.5 0 2 154 586 636 WP_288908444.1 heavy metal translocating P-type ATPase [uncultured Desulfovibrio sp.] diamond 153 84.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
24001902 24001902 PRJNA1240804_P_NODE_108799_length_169_cov_0.866667_g108433_i0 PRJNA1240804 108799 169 0.866667 1.46466723 Syntrophaceae bacterium 2052184 Bacteria Bacteria 106 1.07e-25   NR NTW77460.1 2052184 g108433 i0 98.1 2.87573964497041 54 1 95.9 0 8 169 93 146 NTW77460.1 cell division protein FtsZ [Syntrophaceae bacterium] diamond 486 106 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium
27136254 27136254 PRJNA1240804_P_NODE_131142_length_165_cov_0.896552_g130776_i0 PRJNA1240804 131142 165 0.896552 1.4793108 Desulfovibrio legallii 571438 Bacteria Bacteria 94 2.63e-21   NR WP_092153330.1 571438 g130776 i0 94.1 0.927272727272727 51 3 92.7 0 1 153 93 143 WP_092153330.1 hypothetical protein [Desulfovibrio legallii] diamond 153 94 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
27389712 27389712 PRJNA1240804_P_NODE_139483_length_164_cov_0.904348_g139117_i0 PRJNA1240804 139483 164 0.904348 1.48313072 Desulfobulbus elongatus 53332 Bacteria Bacteria 69.3 4.62e-12   NR WP_157470236.1 53332 g139117 i0 65.3 0.896341463414634 49 17 89.6 0 149 3 89 137 WP_157470236.1 FecCD family ABC transporter permease [Desulfobulbus elongatus] diamond 147 69.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus elongatus
27389713 27389713 PRJNA1240804_P_NODE_139683_length_164_cov_0.904348_g139317_i0 PRJNA1240804 139683 164 0.904348 1.48313072 Desulfovibrio legallii 571438 Bacteria Bacteria 93.2 2.06e-20   NR WP_118230423.1 571438 g139317 i0 95.9 0.896341463414634 49 2 89.6 0 148 2 65 113 WP_118230423.1 acetolactate synthase large subunit [Desulfovibrio legallii] diamond 147 93.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
27547392 27547392 PRJNA1240804_P_NODE_120144_length_167_cov_0.881356_g119778_i0 PRJNA1240804 120144 167 0.881356 1.47186452 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 66.6 3.29e-11   NR MFC1798608.1 2202153 g119778 i0 56.9 0.916167664670659 51 21 89.8 1 165 16 141 191 MFC1798608.1 FkbM family methyltransferase [Thermodesulfobacteriota bacterium] diamond 153 66.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27642362 27642362 PRJNA1240804_P_NODE_133044_length_165_cov_0.896552_g132678_i0 PRJNA1240804 133044 165 0.896552 1.4793108 Syntrophobacteraceae bacterium 2052185 Bacteria Bacteria 49.3 3.59e-5   NR HQN20313.1 2052185 g132678 i0 92 1.4 25 2 45.5 0 48 122 151 175 HQN20313.1 ATP phosphoribosyltransferase [Syntrophobacteraceae bacterium] diamond 231 49.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium
28115630 28115630 PRJNA1240804_P_NODE_148405_length_162_cov_0.920354_g148039_i0 PRJNA1240804 148405 162 0.920354 1.49097348 Desulfovibrio legallii 571438 Bacteria Bacteria 105 6.95e-25   NR WP_092155334.1 571438 g148039 i0 98 0.907407407407407 49 1 90.7 0 161 15 269 317 WP_092155334.1 selenocysteine-specific translation elongation factor [Desulfovibrio legallii] diamond 147 105 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
28860021 28860021 PRJNA1240804_P_NODE_24268_length_289_cov_2.008333_g23902_i0 PRJNA1240804 24268 289 2.008333 5.80408237 Bacteria 2 Bacteria Bacteria 45.1 0.00958   NR WP_073372975.1 51195 g23902 i0 73.1 1.88927335640138 26 7 27 0 196 273 1 26 WP_073372975.1 phosphopyruvate hydratase [Desulfofustis glycolicus] diamond 546 45.4 0.993392070484582 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfofustis Desulfofustis glycolicus
29031712 29031712 PRJNA1240804_P_NODE_85948_length_182_cov_1.984962_g85582_i0 PRJNA1240804 85948 182 1.984962 3.61263084 Desulfobacterales bacterium 2044940 Bacteria Bacteria 41.2 0.0312   NR MDZ7833567.1 2044940 g85582 i0 49.2 1.00549450549451 61 23 97.3 2 180 4 85 139 MDZ7833567.1 hypothetical protein [Desulfobacterales bacterium] diamond 183 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
29378747 29378747 PRJNA1240804_P_NODE_146509_length_162_cov_1.672566_g146143_i0 PRJNA1240804 146509 162 1.672566 2.70955692 Humidesulfovibrio sp. 2910988 Bacteria Bacteria 58.2 4.4e-8   NR MDO9631277.1 2910988 g146143 i0 59.6 0.87037037037037 47 19 87 0 160 20 421 467 MDO9631277.1 VWA domain-containing protein [Humidesulfovibrio sp.] diamond 141 58.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Humidesulfovibrio Humidesulfovibrio sp.
29410183 29410183 PRJNA1240804_P_NODE_125929_length_166_cov_0.888889_g125563_i0 PRJNA1240804 125929 166 0.888889 1.47555574 Desulfobacterales bacterium 2044940 Bacteria Bacteria 40 0.0124   NR MDH3883889.1 2044940 g125563 i0 51.7 0.524096385542169 29 14 52.4 0 88 2 2 30 MDH3883889.1 NAD-dependent epimerase/dehydratase family protein [Desulfobacterales bacterium] diamond 87 40 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
29852401 29852401 PRJNA1240804_P_NODE_125171_length_166_cov_0.888889_g124805_i0 PRJNA1240804 125171 166 0.888889 1.47555574 Desulfovibrio legallii 571438 Bacteria Bacteria 102 5.8e-24   NR WP_092152886.1 571438 g124805 i0 90.6 0.957831325301205 53 5 95.8 0 3 161 40 92 WP_092152886.1 hypothetical protein [Desulfovibrio legallii] diamond 159 102 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
30041842 30041842 PRJNA1240804_P_NODE_144311_length_163_cov_0.912281_g143945_i0 PRJNA1240804 144311 163 0.912281 1.48701803 Syntrophobacter fumaroxidans 119484 Bacteria Bacteria 42.4 0.0177   NR WP_011697391.1 119484 g143945 i0 65.5 0.533742331288344 29 10 53.4 0 1 87 658 686 WP_011697391.1 hypothetical protein [Syntrophobacter fumaroxidans] diamond 87 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter fumaroxidans
30105021 30105021 PRJNA1240804_P_NODE_39472_length_239_cov_1.284211_g39106_i0 PRJNA1240804 39472 239 1.284211 3.06926429 Geobacter sp. 46610 Bacteria Bacteria 44.3 0.0018   NR WP_298266535.1 46610 g39106 i0 35.8 0.665271966527197 53 34 66.5 0 54 212 13 65 WP_298266535.1 hypothetical protein [Geobacter sp.] diamond 159 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
30105040 30105040 PRJNA1240804_P_NODE_57292_length_208_cov_3.012579_g56926_i0 PRJNA1240804 57292 208 3.012579 6.26616432 Desulfobacula sp. 2593537 Bacteria Bacteria 52.4 9.38e-6   NR WP_299979699.1 2593537 g56926 i0 48.9 1.38461538461538 45 23 64.9 0 22 156 418 462 WP_299979699.1 metallophosphoesterase family protein [Desulfobacula sp.] diamond 288 52.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacula Desulfobacula sp.
30136298 30136298 PRJNA1240804_P_NODE_132852_length_165_cov_0.896552_g132486_i0 PRJNA1240804 132852 165 0.896552 1.4793108 Desulfobacula sp. 2593537 Bacteria Bacteria 72.4 4.59e-13   NR MBT6339183.1 2593537 g132486 i0 66 2.70909090909091 50 17 90.9 0 13 162 601 650 MBT6339183.1 response regulator [Desulfobacula sp.] diamond 447 72.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacula Desulfobacula sp.
30610422 30610422 PRJNA1240804_P_NODE_109293_length_169_cov_0.866667_g108927_i0 PRJNA1240804 109293 169 0.866667 1.46466723 Desulfovibrio legallii 571438 Bacteria Bacteria 98.6 5.24e-24   NR WP_092155246.1 571438 g108927 i0 97.9 0.834319526627219 47 1 83.4 0 168 28 154 200 WP_092155246.1 DUF1989 domain-containing protein [Desulfovibrio legallii] diamond 141 98.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
30976475 30976475 PRJNA1240804_P_NODE_133034_length_165_cov_0.896552_g132668_i0 PRJNA1240804 133034 165 0.896552 1.4793108 Pseudomonadati 3379134 Bacteria Bacteria 72.8 2.54e-13   NR MSM39697.1 46610 g132668 i0 72.7 8.70909090909091 44 12 80 0 17 148 287 330 MSM39697.1 response regulator [Geobacter sp.] diamond 1437 73.2 0.994535519125683 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
31021394 31021394 PRJNA1240804_P_NODE_147455_length_162_cov_0.920354_g147089_i0 PRJNA1240804 147455 162 0.920354 1.49097348 Syntrophales bacterium LBB04 2914040 Bacteria Bacteria 65.9 5.6e-11   NR MCG6538248.1 2914040 g147089 i0 93.8 4.14814814814815 32 2 59.3 0 58 153 3 34 MCG6538248.1 N-6 DNA methylase [Syntrophales bacterium LBB04] diamond 672 65.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium LBB04
31053173 31053173 PRJNA1240804_P_NODE_102335_length_172_cov_1.170732_g101969_i0 PRJNA1240804 102335 172 1.170732 2.01365904 Desulfocurvibacter africanus 873 Bacteria Bacteria 95.1 4.850000000000001e-21   NR WP_027368604.1 873 g101969 i0 77.4 0.924418604651163 53 12 92.4 0 171 13 264 316 WP_027368604.1 diguanylate cyclase [Desulfocurvibacter africanus] diamond 159 95.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus
31197098 31197098 PRJNA1240804_P_NODE_139995_length_164_cov_0.904348_g139629_i0 PRJNA1240804 139995 164 0.904348 1.48313072 Pseudomonadati 3379134 Bacteria Bacteria 84.7 7.95e-19   NR PLX82442.1 892 g139629 i0 71.4 3.53048780487805 49 14 89.6 0 149 3 58 106 PLX82442.1 MAG: hypothetical protein C0616_02180 [Desulfuromonas sp.] diamond 579 85.1 0.995299647473561 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
31260742 31260742 PRJNA1240804_P_NODE_112975_length_168_cov_1.008403_g112609_i0 PRJNA1240804 112975 168 1.008403 1.69411704 Pseudomonadati 3379134 Bacteria Bacteria 63.2 8.62e-10   NR MBI1921718.1 46610 g112609 i0 60.9 6.55357142857143 46 18 82.1 0 16 153 516 561 MBI1921718.1 potassium transporter Kup [Geobacter sp.] diamond 1101 63.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
31355748 31355748 PRJNA1240804_P_NODE_108916_length_169_cov_0.866667_g108550_i0 PRJNA1240804 108916 169 0.866667 1.46466723 Candidatus Electrothrix 1859128 Bacteria Bacteria 70.5 1.85e-12   NR MCI5142164.1 2249221 g108550 i0 58.2 3.88757396449704 55 23 97.6 0 3 167 164 218 MCI5142164.1 hypothetical protein [Candidatus Electrothrix sp. ATG1] diamond 657 70.9 0.994358251057828 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. ATG1_2 ATG1
31400846 31400846 PRJNA1240804_P_NODE_108316_length_169_cov_0.866667_g107950_i0 PRJNA1240804 108316 169 0.866667 1.46466723 Desulfuromonadales bacterium 2099678 Bacteria Bacteria 58.2 5.07e-8   NR MCL2760375.1 2099678 g107950 i0 62.7 1.79289940828402 51 18 90.5 1 156 4 255 304 MCL2760375.1 autotransporter outer membrane beta-barrel domain-containing protein [Desulfuromonadales bacterium] diamond 303 58.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales     Desulfuromonadales bacterium
31464138 31464138 PRJNA1240804_P_NODE_103636_length_171_cov_1.295082_g103270_i0 PRJNA1240804 103636 171 1.295082 2.21459022 Desulfovibrio legallii 571438 Bacteria Bacteria 99 1.7699999999999998e-23   NR WP_092153344.1 571438 g103270 i0 91.8 0.859649122807018 49 4 86 0 170 24 227 275 WP_092153344.1 substrate-binding domain-containing protein [Desulfovibrio legallii] diamond 147 99 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii
31545553 31545553 PRJNA1240804_P_NODE_136236_length_164_cov_0.904348_g135870_i0 PRJNA1240804 136236 164 0.904348 1.48313072 Pseudomonadati 3379134 Bacteria Bacteria 62 1.52e-9   NR HEX5679872.1 2044940 g135870 i0 84.4 9.89634146341463 32 5 58.5 0 109 14 175 206 HEX5679872.1 quinone oxidoreductase [Desulfobacterales bacterium] diamond 1623 62.4 0.993589743589744 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32571477 32571477 PRJNA1240804_P_NODE_144339_length_163_cov_0.912281_g143973_i0 PRJNA1240804 144339 163 0.912281 1.48701803 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 50.1 3.62e-6   NR MEW6352318.1 2202153 g143973 i0 73.5 0.625766871165644 34 9 62.6 0 6 107 56 89 MEW6352318.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 102 50.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32683662 32683662 PRJNA1240804_P_NODE_149920_length_162_cov_0.920354_g149554_i0 PRJNA1240804 149920 162 0.920354 1.49097348 Bacteria 2 Bacteria Bacteria 67.8 6.65e-13   NR WP_028324484.1 340467 g149554 i0 80.5 2.2962962962963 41 8 75.9 0 147 25 71 111 WP_028324484.1 type II toxin-antitoxin system RelE/ParE family toxin [Desulfatirhabdium butyrativorans] diamond 372 67.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatirhabdiaceae Desulfatirhabdium Desulfatirhabdium butyrativorans
32697028 32697028 PRJNA1240804_P_NODE_142920_length_163_cov_0.912281_g142554_i0 PRJNA1240804 142920 163 0.912281 1.48701803 Desulfovibrio legallii 571438 Bacteria Bacteria 60.8 1.05e-9   NR WP_092153808.1 571438 g142554 i0 100 0.533742331288344 29 0 53.4 0 101 15 1 29 WP_092153808.1 N-acetyltransferase [Desulfovibrio legallii] diamond 87 60.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio legallii

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