RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA683669" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA683669 · 11 ✖

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
1940925 1940925 PRJNA683669_P_NODE_19382_length_293_cov_1.050000_g19150_i0 PRJNA683669 19382 293 1.05 3.0765 Solidesulfovibrio magneticus 184917 Bacteria Bacteria 54.7 0.008   NTclustered gi|239794502|dbj|AP010904.1| 573370 g19150 i0 100 0.194539249146758 29 0 10 0 169 197 2410739 2410767 Desulfovibrio magneticus RS-1 DNA, complete genome blastn 57 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio magneticus
9593701 9593701 PRJNA683669_P_NODE_7248_length_475_cov_1.532338_g7017_i0 PRJNA683669 7248 475 1.532338 7.2786055 Pseudomonadati 3379134 Bacteria Bacteria 248 3.14e-75   NR MBI4804583.1 885 g7017 i0 73.9 53.8926315789474 161 39 99.8 1 2 475 391 551 MBI4804583.1 malate synthase G [Desulfovibrio sp.] diamond 25599 250 0.992 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28029791 28029791 PRJNA683669_P_NODE_14905_length_336_cov_1.015209_g14674_i0 PRJNA683669 14905 336 1.015209 3.41110224 Desulfuromonadaceae bacterium 2099677 Bacteria Bacteria 59.7 1.23e-7   NR MDD2272822.1 2099677 g14674 i0 33.7 1.72321428571429 95 59 84.8 2 19 303 80 170 MDD2272822.1 ankyrin repeat domain-containing protein [Desulfuromonadaceae bacterium] diamond 579 59.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae   Desulfuromonadaceae bacterium
29198116 29198116 PRJNA683669_P_NODE_31249_length_245_cov_0.895349_g31017_i0 PRJNA683669 31249 245 0.895349 2.19360505 Desulfovibrio sp. OttesenSCG-928-C14 2885168 Bacteria Bacteria 45.8 0.00308   NR MDL2314207.1 2885168 g31017 i0 31.3 0.783673469387755 64 43 77.1 1 12 200 471 534 MDL2314207.1 bacteriohemerythrin [Desulfovibrio sp. OttesenSCG-928-C14] diamond 192 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. OttesenSCG-928-C14
29556735 29556735 PRJNA683669_P_NODE_7130_length_479_cov_1.517241_g6899_i0 PRJNA683669 7130 479 1.517241 7.26758439 root 1 Root_unresolved Root_unresolved 130 1.11e-31   NR WP_324352141.1 885 g6899 i0 43.6 19.5093945720251 156 87 97.7 1 6 473 22 176 WP_324352141.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase, partial [Desulfovibrio sp.] diamond 9345 130 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
29797725 29797725 PRJNA683669_P_NODE_18831_length_297_cov_2.223214_g18599_i0 PRJNA683669 18831 297 2.223214 6.60294558 Desulfotalea psychrophila 84980 Bacteria Bacteria 50.4 1.09e-4   NR WP_011188944.1 84980 g18599 i0 38.6 0.888888888888889 88 49 84.8 3 263 12 4 90 WP_011188944.1 J domain-containing protein [Desulfotalea psychrophila] diamond 264 50.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfotalea Desulfotalea psychrophila
30315448 30315448 PRJNA683669_P_NODE_5612_length_544_cov_0.970276_g5384_i0 PRJNA683669 5612 544 0.970276 5.27830144 Pseudomonadati 3379134 Bacteria Bacteria 127 6.55e-33   NR WP_066065804.1 1621989 g5384 i0 48 1.60477941176471 150 74 82.7 1 468 19 42 187 WP_066065804.1 carbonic anhydrase [Candidatus Desulfofervidus auxilii] diamond 873 127 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Desulfofervidia Candidatus Desulfofervidales Candidatus Desulfofervidaceae Candidatus Desulfofervidus Candidatus Desulfofervidus auxilii
30335348 30335348 PRJNA683669_P_NODE_292_length_1969_cov_2.775844_g249_i0 PRJNA683669 292 1969 2.775844 54.65636836 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 174 2.6399999999999992e-43   NR MFC1834884.1 2202153 g249 i0 37.7 0.359573387506348 236 122 35.8 8 682 1386 8 219 MFC1834884.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 708 174 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30366935 30366935 PRJNA683669_P_NODE_31172_length_245_cov_0.895349_g30940_i0 PRJNA683669 31172 245 0.895349 2.19360505 Desulfuromonas soudanensis 1603606 Bacteria Bacteria 42 0.047   NR WP_053550702.1 1603606 g30940 i0 41.2 0.624489795918367 51 30 62.4 0 173 21 113 163 WP_053550702.1 PCYCGC motif-containing (lipo)protein [Desulfuromonas soudanensis] diamond 153 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas soudanensis
30461738 30461738 PRJNA683669_P_NODE_19193_length_294_cov_1.742081_g18961_i0 PRJNA683669 19193 294 1.742081 5.12171814 Desulfobacteraceae bacterium 4572_88 1972444 Bacteria Bacteria 69.7 2.28e-11   NR OQY57789.1 1972444 g18961 i0 46.7 1.53061224489796 75 38 76.5 1 59 283 55 127 OQY57789.1 MAG: hypothetical protein B6245_15245 [Desulfobacteraceae bacterium 4572_88] diamond 450 69.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium 4572_88
32370266 32370266 PRJNA683669_P_NODE_30199_length_246_cov_0.890173_g29967_i0 PRJNA683669 30199 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 92.4 9.59e-21   NR MBS3809639.1 2044940 g29967 i0 53.7 4.63414634146341 82 37 100 1 1 246 80 160 MBS3809639.1 NAD-dependent protein deacylase [Desulfobacterales bacterium] diamond 1140 92.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales 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);;