RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA168635 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
20765964 20765964 PRJNA168635_P_NODE_18137_length_189_cov_1.371429_g17721_i0 PRJNA168635 18137 189 1.371429 2.59200081 Geobacter sp. 46610 Bacteria Bacteria 119 3.41e-30   NR HBA87978.1 46610 g17721 i0 91.5 3.79365079365079 59 5 93.7 0 178 2 319 377 HBA87978.1 acyl-CoA dehydrogenase [Geobacter sp.] diamond 717 119 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
26820923 26820923 PRJNA168635_P_NODE_35321_length_152_cov_2.339806_g34905_i0 PRJNA168635 35321 152 2.339806 3.55650512 Desulfobacterales bacterium 2044940 Bacteria Bacteria 60.1 1.16e-9   NR MCJ7704803.1 2044940 g34905 i0 65.2 4.65789473684211 46 14 90.8 1 139 2 55 98 MCJ7704803.1 HAMP domain-containing histidine kinase [Desulfobacterales bacterium] diamond 708 60.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27042326 27042326 PRJNA168635_P_NODE_9882_length_264_cov_4.372093_g9467_i0 PRJNA168635 9882 264 4.372093 11.54232552 Desulfacinum hydrothermale 109258 Bacteria Bacteria 43.5 0.0219   NR WP_084057252.1 109258 g9467 i0 37.1 0.704545454545455 62 37 69.3 2 198 16 27 87 WP_084057252.1 4Fe-4S binding protein [Desulfacinum hydrothermale] diamond 186 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Desulfacinum Desulfacinum hydrothermale
27263657 27263657 PRJNA168635_P_NODE_19743_length_183_cov_2.029851_g19327_i0 PRJNA168635 19743 183 2.029851 3.71462733 Desulfobacula sp. 2593537 Bacteria Bacteria 47.8 2.53e-4   NR MCK5163105.1 2593537 g19327 i0 61.3 0.508196721311475 31 12 50.8 0 128 36 70 100 MCK5163105.1 PEP-CTERM sorting domain-containing protein [Desulfobacula sp.] diamond 93 47.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacula Desulfobacula sp.
27295169 27295169 PRJNA168635_P_NODE_18703_length_187_cov_1.355072_g18287_i0 PRJNA168635 18703 187 1.355072 2.53398464 Desulfobulbus rhabdoformis 34032 Bacteria Bacteria 99 2.83e-22   NR WP_240194921.1 34032 g18287 i0 78 0.946524064171123 59 13 94.7 0 178 2 5 63 WP_240194921.1 DUF3560 domain-containing protein [Desulfobulbus rhabdoformis] diamond 177 99 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus rhabdoformis
27421787 27421787 PRJNA168635_P_NODE_30103_length_164_cov_0.904348_g29687_i0 PRJNA168635 30103 164 0.904348 1.48313072 Geobacteraceae bacterium 2282154 Bacteria Bacteria 43.9 0.00501   NR HEY6873884.1 2282154 g29687 i0 36.1 1.11585365853659 61 30 95.1 2 158 3 61 121 HEY6873884.1 hypothetical protein [Geobacteraceae bacterium] diamond 183 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
27800609 27800609 PRJNA168635_P_NODE_31084_length_163_cov_0.912281_g30668_i0 PRJNA168635 31084 163 0.912281 1.48701803 Candidatus Mailhella merdavium 2838657 Bacteria Bacteria 68.9 7.3e-12   NR HJB66249.1 2838657 g30668 i0 62.7 14.079754601227 51 19 93.9 0 159 7 559 609 HJB66249.1 DUF927 domain-containing protein [Candidatus Mailhella merdavium] diamond 2295 68.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella Candidatus Mailhella merdavium
28052972 28052972 PRJNA168635_P_NODE_30965_length_163_cov_0.912281_g30549_i0 PRJNA168635 30965 163 0.912281 1.48701803 Smithellaceae bacterium 2964540 Bacteria Bacteria 58.2 5.45e-9   NR MFA5284161.1 2964540 g30549 i0 67.5 0.736196319018405 40 13 73.6 0 34 153 5 44 MFA5284161.1 hypothetical protein [Smithellaceae bacterium] diamond 120 58.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae   Smithellaceae bacterium
28210726 28210726 PRJNA168635_P_NODE_15146_length_206_cov_6.121019_g14730_i0 PRJNA168635 15146 206 6.121019 12.60929914 Bilophila sp. 1929485 Bacteria Bacteria 50.1 4.15e-5   NR CAK7047752.1 1929485 g14730 i0 47.8 0.669902912621359 46 21 62.6 1 62 190 52 97 CAK7047752.1 MAG: hypothetical protein MEBIL_04188 [Bilophila sp.] diamond 138 50.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila sp.
28354946 28354946 PRJNA168635_P_NODE_22946_length_174_cov_1.632000_g22530_i0 PRJNA168635 22946 174 1.632 2.83968 Pseudomonadati 3379134 Bacteria Bacteria 68.2 1.56e-11   NR MBQ3060196.1 885 g22530 i0 58.2 17.948275862069 55 23 94.8 0 167 3 920 974 MBQ3060196.1 DEAD/DEAH box helicase family protein [Desulfovibrio sp.] diamond 3123 68.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28431975 28431975 PRJNA168635_P_NODE_18606_length_187_cov_2.108696_g18190_i0 PRJNA168635 18606 187 2.108696 3.94326152 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 99.4 1.5099999999999998e-23   NR KAF0234417.1 2049043 g18190 i0 77 0.978609625668449 61 14 97.9 0 186 4 144 204 KAF0234417.1 MAG: hypothetical protein FD177_798 [Desulfovibrionaceae bacterium] diamond 183 99.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
28810445 28810445 PRJNA168635_P_NODE_23488_length_172_cov_6.560976_g23072_i0 PRJNA168635 23488 172 6.560976 11.28487872 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 44.7 0.00306   NR HZX13696.1 2202153 g23072 i0 46.4 0.976744186046512 56 29 97.7 1 1 168 225 279 HZX13696.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 168 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
28842249 28842249 PRJNA168635_P_NODE_22548_length_175_cov_1.531746_g22132_i0 PRJNA168635 22548 175 1.531746 2.6805555 Desulfovibrio cuneatus 159728 Bacteria Bacteria 63.2 8.7e-10   NR WP_156907870.1 159728 g22132 i0 65 0.685714285714286 40 14 68.6 0 174 55 119 158 WP_156907870.1 hypothetical protein [Desulfovibrio cuneatus] diamond 120 63.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio cuneatus
28905270 28905270 PRJNA168635_P_NODE_18608_length_187_cov_2.086957_g18192_i0 PRJNA168635 18608 187 2.086957 3.90260959 Desulfogranum japonicum 231447 Bacteria Bacteria 51.6 1.35e-5   NR WP_028580529.1 231447 g18192 i0 37.1 0.994652406417112 62 39 99.5 0 2 187 746 807 WP_028580529.1 SdrD B-like domain-containing protein [Desulfogranum japonicum] diamond 186 51.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfogranum Desulfogranum japonicum
29347654 29347654 PRJNA168635_P_NODE_28269_length_166_cov_0.888889_g27853_i0 PRJNA168635 28269 166 0.888889 1.47555574 Desulfosarcina sp. 2027861 Bacteria Bacteria 60.1 1e-8   NR MBC2712876.1 2027861 g27853 i0 53.8 0.939759036144578 52 24 94 0 4 159 305 356 MBC2712876.1 terminase [Desulfosarcina sp.] diamond 156 60.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina Desulfosarcina sp.
30200075 30200075 PRJNA168635_P_NODE_33372_length_158_cov_2.816514_g32956_i0 PRJNA168635 33372 158 2.816514 4.45009212 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 50.1 1.04e-5   NR KAF0233831.1 2049043 g32956 i0 96.3 1.0253164556962 27 1 51.3 0 82 2 1 27 KAF0233831.1 MAG: hypothetical protein FD177_1243 [Desulfovibrionaceae bacterium] diamond 162 50.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
30674123 30674123 PRJNA168635_P_NODE_31613_length_162_cov_1.831858_g31197_i0 PRJNA168635 31613 162 1.831858 2.96760996 Geobacteraceae bacterium 2282154 Bacteria Bacteria 62.4 2.92e-10   NR MDA8428194.1 2282154 g31197 i0 51 1.81481481481481 49 24 90.7 0 5 151 123 171 MDA8428194.1 phage major tail tube protein [Geobacteraceae bacterium] diamond 294 62.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
30818430 30818430 PRJNA168635_P_NODE_33874_length_156_cov_4.299065_g33458_i0 PRJNA168635 33874 156 4.299065 6.7065414 Pseudomonadati 3379134 Bacteria Bacteria 63.5 3.58e-10   NR WP_319409048.1 218289 g33458 i0 62.5 22.1153846153846 48 18 92.3 0 152 9 192 239 WP_319409048.1 IS3 family transposase [uncultured Desulfosarcina sp.] diamond 3450 63.9 0.993740219092332 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina uncultured Desulfosarcina sp.
31829931 31829931 PRJNA168635_P_NODE_23617_length_172_cov_2.447154_g23201_i0 PRJNA168635 23617 172 2.447154 4.20910488 Bacteria 2 Bacteria Bacteria 44.3 0.00334   NR MCR5257244.1 885 g23201 i0 47.1 2.66860465116279 34 17 59.3 1 68 169 26 58 MCR5257244.1 hypothetical protein [Desulfovibrio sp.] diamond 459 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32381887 32381887 PRJNA168635_P_NODE_23819_length_172_cov_1.455285_g23403_i0 PRJNA168635 23819 172 1.455285 2.5030902 Geobacter sp. 46610 Bacteria Bacteria 118 8.13e-32   NR RQW79298.1 46610 g23403 i0 96.5 1.98837209302326 57 2 99.4 0 1 171 52 108 RQW79298.1 MAG: glycoside hydrolase family 19 protein [Geobacter sp.] diamond 342 118 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
32540271 32540271 PRJNA168635_P_NODE_30279_length_164_cov_0.904348_g29863_i0 PRJNA168635 30279 164 0.904348 1.48313072 Fundidesulfovibrio putealis 270496 Bacteria Bacteria 111 9.6e-29   NR WP_027191813.1 270496 g29863 i0 100 0.969512195121951 53 0 97 0 1 159 161 213 WP_027191813.1 FAD-dependent thymidylate synthase [Fundidesulfovibrio putealis] diamond 159 111 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Fundidesulfovibrio Fundidesulfovibrio putealis
32571873 32571873 PRJNA168635_P_NODE_20019_length_182_cov_2.052632_g19603_i0 PRJNA168635 20019 182 2.052632 3.73579024 Desulfovibrio desulfuricans 876 Bacteria Bacteria 77.4 9.76e-15   NR WP_227118091.1 876 g19603 i0 60 3.95604395604396 60 24 98.9 0 1 180 146 205 WP_227118091.1 terminase large subunit [Desulfovibrio desulfuricans] diamond 720 77.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
32729123 32729123 PRJNA168635_P_NODE_32080_length_162_cov_0.920354_g31664_i0 PRJNA168635 32080 162 0.920354 1.49097348 Desulfuromonadales bacterium C 2099678 Bacteria Bacteria 100 2.38e-24   NR OEU75202.1 1869312 g31664 i0 80.8 0.962962962962963 52 10 96.3 0 5 160 50 101 OEU75202.1 MAG: hypothetical protein BA874_03705 [Desulfuromonadales bacterium C00003068] diamond 156 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales     Desulfuromonadales bacterium C00003068

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