RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB14803", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14803 · 20 ✖

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
3847733 3847733 PRJEB14803_P_NODE_47464_length_150_cov_1.373913_g46998_i0 PRJEB14803 47464 150 1.373913 2.0608695 uncultured Desulfobacter sp. 240139 Bacteria Bacteria 54.7 0.003   NTclustered gi|2814788332|emb|OY762228.2| 240139 g46998 i0 100 0.193333333333333 29 0 19 0 98 126 604126 604154 MAG: uncultured Desulfobacter sp. isolate cd87f30c-30a5-471b-81aa-180dc00a34f5 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter uncultured Desulfobacter sp.
5123920 5123920 PRJEB14803_P_NODE_40925_length_163_cov_1.554688_g40459_i0 PRJEB14803 40925 163 1.554688 2.53414144 Desulfosarcina sp. BuS5 933262 Bacteria Bacteria 87.9 3.72e-13   NTclustered gi|2447237393|gb|CP087952.1| 933262 g40459 i0 87.013 0.47239263803681 77 10 47 0 76 152 3332962 3332886 Desulfosarcina sp. BuS5 chromosome, complete genome blastn 77 87.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina Desulfosarcina sp. BuS5
7673680 7673680 PRJEB14803_P_NODE_2987_length_830_cov_3.569811_g2666_i0 PRJEB14803 2987 830 3.569811 29.6294313 Desulfovibrionaceae 194924 Bacteria Bacteria 340 8.17e-115   NR WP_071545125.1 2125990 g2666 i0 65.4 12.4518072289157 246 85 88.9 0 781 44 4 249 WP_071545125.1 SDR family oxidoreductase [Pseudodesulfovibrio hydrargyri] diamond 10335 342 0.994152046783626 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio hydrargyri
20422179 20422179 PRJEB14803_P_NODE_3337_length_779_cov_5.879032_g3000_i0 PRJEB14803 3337 779 5.879032 45.79765928 Syntrophales bacterium 2928017 Bacteria Bacteria 285 6.44e-89   NR HUH64863.1 2928017 g3000 i0 66.5 7.01668806161746 203 67 77.8 1 173 778 1 203 HUH64863.1 phosphoenolpyruvate carboxykinase (GTP) [Syntrophales bacterium] diamond 5466 285 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
26900242 26900242 PRJEB14803_P_NODE_31621_length_191_cov_2.294872_g31155_i0 PRJEB14803 31621 191 2.294872 4.38320552 root 1 Root_unresolved Root_unresolved 50.4 4.35e-6   NR WP_126379932.1 241368 g31155 i0 75 1.33507853403141 32 5 50.3 1 191 96 68 96 WP_126379932.1 peptidylprolyl isomerase [Desulfovibrio ferrophilus] diamond 255 50.8 0.992125984251969 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio ferrophilus
28485893 28485893 PRJEB14803_P_NODE_18867_length_269_cov_1.764957_g18401_i0 PRJEB14803 18867 269 1.764957 4.74773433 uncultured Desulfobacterium sp. 201089 Bacteria Bacteria 55.1 2.43e-6   NR SPD75284.1 201089 g18401 i0 48 1.10408921933085 50 26 55.8 0 266 117 376 425 SPD75284.1 exported hypothetical protein [uncultured Desulfobacterium sp.] diamond 297 55.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
28485936 28485936 PRJEB14803_P_NODE_44547_length_155_cov_2.000000_g44081_i0 PRJEB14803 44547 155 2 3.1 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 83.2 6.14e-17   NR RJP80082.1 2049433 g44081 i0 74.5 1.9741935483871 51 13 98.7 0 1 153 159 209 RJP80082.1 MAG: glucose-6-phosphate isomerase [Desulfobacteraceae bacterium] diamond 306 83.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28896235 28896235 PRJEB14803_P_NODE_30108_length_197_cov_2.061728_g29642_i0 PRJEB14803 30108 197 2.061728 4.06160416 Desulfobaculum xiamenense 995050 Bacteria Bacteria 100 8.87e-23   NR WP_167942360.1 995050 g29642 i0 72.3 1.97969543147208 65 18 99 0 2 196 154 218 WP_167942360.1 translation elongation factor 4 [Desulfobaculum xiamenense] diamond 390 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfobaculum Desulfobaculum xiamenense
28959707 28959707 PRJEB14803_P_NODE_16248_length_297_cov_2.225191_g15782_i0 PRJEB14803 16248 297 2.225191 6.60881727 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 86.3 3.03e-18   NR HZX15097.1 2202153 g15782 i0 53.3 0.757575757575758 75 35 75.8 0 297 73 145 219 HZX15097.1 SGNH/GDSL hydrolase family protein [Thermodesulfobacteriota bacterium] diamond 225 86.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30791389 30791389 PRJEB14803_P_NODE_27934_length_207_cov_1.674419_g27468_i0 PRJEB14803 27934 207 1.674419 3.46604733 Desulfobacterales bacterium 2044940 Bacteria Bacteria 42 0.0435   NR MCG8632563.1 2044940 g27468 i0 66.7 0.391304347826087 27 9 39.1 0 126 206 310 336 MCG8632563.1 response regulator [Desulfobacterales bacterium] diamond 81 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
30974718 30974718 PRJEB14803_P_NODE_37974_length_171_cov_1.176471_g37508_i0 PRJEB14803 37974 171 1.176471 2.01176541 Bacteria 2 Bacteria Bacteria 60.5 8.06e-9   NR HOJ71461.1 2660714 g37508 i0 52.2 2.29824561403509 46 22 80.7 0 19 156 871 916 HOJ71461.1 isoleucine--tRNA ligase [Syntrophorhabdaceae bacterium] diamond 393 60.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae bacterium
31006149 31006149 PRJEB14803_P_NODE_34194_length_182_cov_1.829932_g33728_i0 PRJEB14803 34194 182 1.829932 3.33047624 Pseudomonadati 3379134 Bacteria Bacteria 62.4 1.94e-9   NR MFC1868467.1 2202153 g33728 i0 60.3 2.7032967032967 58 23 95.6 0 181 8 45 102 MFC1868467.1 PilC/PilY family type IV pilus protein [Thermodesulfobacteriota bacterium] diamond 492 62.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31512260 31512260 PRJEB14803_P_NODE_25636_length_219_cov_1.516304_g25170_i0 PRJEB14803 25636 219 1.516304 3.32070576 Bacteria 2 Bacteria Bacteria 72.8 6.84e-13   NR KPA13432.1 1509431 g25170 i0 53.7 6.43835616438356 67 31 91.8 0 9 209 246 312 KPA13432.1 Acyltransferase, WS/DGAT/MGAT [Candidatus Magnetomorum sp. HK-1] diamond 1410 72.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Candidatus Magnetomoraceae Candidatus Magnetomorum Candidatus Magnetomorum sp. HK-1
31866234 31866234 PRJEB14803_P_NODE_46537_length_152_cov_1.025641_g46071_i0 PRJEB14803 46537 152 1.025641 1.55897432 Syntrophus aciditrophicus 316277 Bacteria Bacteria 41.2 0.0375   NR WP_041584988.1 316277 g46071 i0 43.2 0.868421052631579 44 19 86.8 1 135 4 158 195 WP_041584988.1 thiamine pyrophosphate-dependent enzyme [Syntrophus aciditrophicus] diamond 132 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus Syntrophus aciditrophicus
32087873 32087873 PRJEB14803_P_NODE_6718_length_522_cov_1.770021_g6271_i0 PRJEB14803 6718 522 1.770021 9.23950962 Smithellaceae bacterium 2964540 Bacteria Bacteria 191 7.029999999999998e-55   NR MDD4356556.1 2964540 g6271 i0 54.8 0.954022988505747 166 73 95.4 1 518 21 286 449 MDD4356556.1 acetyl-CoA acetyltransferase [Smithellaceae bacterium] diamond 498 191 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae   Smithellaceae bacterium
32151197 32151197 PRJEB14803_P_NODE_30018_length_198_cov_1.165644_g29552_i0 PRJEB14803 30018 198 1.165644 2.30797512 Desulfobacterales bacterium HSG16 3055594 Bacteria Bacteria 42 0.0391   NR MDM8518199.1 3055594 g29552 i0 60 0.454545454545455 30 12 45.5 0 1 90 302 331 MDM8518199.1 DUF2183 domain-containing protein [Desulfobacterales bacterium HSG16] diamond 90 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium HSG16
32176585 32176585 PRJEB14803_P_NODE_22778_length_237_cov_1.415842_g22312_i0 PRJEB14803 22778 237 1.415842 3.35554554 Pseudomonadati 3379134 Bacteria Bacteria 78.6 6.17e-15   NR RJP44945.1 2049433 g22312 i0 43.8 5.64556962025316 89 39 98.7 1 236 3 129 217 RJP44945.1 MAG: hypothetical protein C4548_05215 [Desulfobacteraceae bacterium] diamond 1338 78.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
32182843 32182843 PRJEB14803_P_NODE_13918_length_329_cov_1.302721_g13453_i0 PRJEB14803 13918 329 1.302721 4.28595209 Syntrophorhabdales bacterium 2819264 Bacteria Bacteria 52 3.69e-5   NR HUJ90535.1 2819264 g13453 i0 44.1 0.620060790273556 68 33 61.1 2 202 2 95 158 HUJ90535.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Syntrophorhabdales bacterium] diamond 204 52 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales     Syntrophorhabdales bacterium
32745126 32745126 PRJEB14803_P_NODE_33800_length_184_cov_1.020134_g33334_i0 PRJEB14803 33800 184 1.020134 1.87704656 Thermodesulfatator 241192 Bacteria Bacteria 100 9.15e-23   NR HHI96385.1 501497 g33334 i0 80.3 8.95108695652174 61 12 99.5 0 2 184 283 343 HHI96385.1 imidazole glycerol phosphate synthase subunit HisF [Thermodesulfatator atlanticus] diamond 1647 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfatatoraceae Thermodesulfatator Thermodesulfatator atlanticus
32877292 32877292 PRJEB14803_P_NODE_21940_length_243_cov_1.923077_g21474_i0 PRJEB14803 21940 243 1.923077 4.67307711 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 56.6 4.61e-7   NR RJQ60967.1 2049433 g21474 i0 35.9 2.83950617283951 78 49 96.3 1 238 5 208 284 RJQ60967.1 MAG: FAD-binding oxidoreductase [Desulfobacteraceae bacterium] diamond 690 56.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium

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