RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA515078", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 16 ✖

tax_kingdom 1

  • Pseudomonadati · 16 ✖

bioproject 1

  • PRJNA515078 · 16 ✖

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
8139864 8139864 PRJNA515078_P_NODE_19207_length_198_cov_1.447205_g18974_i0 PRJNA515078 19207 198 1.447205 2.8654659 root 1 Root_unresolved Root_unresolved 99 2.94e-23   NR OIQ01478.1 1805379 g18974 i0 75 6.87878787878788 64 16 97 0 194 3 125 188 OIQ01478.1 MAG: 3-hydroxybutyryl-CoA dehydrogenase [Syntrophobacteraceae bacterium CG2_30_61_12] diamond 1362 100 0.99 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium CG2_30_61_12
13240792 13240792 PRJNA515078_P_NODE_311_length_1507_cov_3.927211_g267_i0 PRJNA515078 311 1507 3.927211 59.18306977 Thermodesulfobacterium commune 1741 Bacteria Bacteria 78.7 2.55e-9   NTclustered gi|668351138|gb|CP008796.1| 289377 g267 i0 91.228 0.0643662906436629 57 5 4 0 98 154 272278 272334 Thermodesulfobacterium commune DSM 2178, complete genome blastn 97 78.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium commune
27077182 27077182 PRJNA515078_P_NODE_19002_length_199_cov_1.444444_g18769_i0 PRJNA515078 19002 199 1.444444 2.87444356 Syntrophales bacterium 2928017 Bacteria Bacteria 47.4 3.94e-4   NR HPC02843.1 2928017 g18769 i0 57.1 0.527638190954774 35 15 52.8 0 75 179 30 64 HPC02843.1 hypothetical protein [Syntrophales bacterium] diamond 105 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
27519541 27519541 PRJNA515078_P_NODE_14463_length_231_cov_1.582474_g14230_i0 PRJNA515078 14463 231 1.582474 3.65551494 Syntrophales bacterium 2928017 Bacteria Bacteria 87 7.36e-18   NR HYA14554.1 2928017 g14230 i0 57.1 1.68831168831169 70 29 89.6 1 20 226 289 358 HYA14554.1 OmpH family outer membrane protein [Syntrophales bacterium] diamond 390 87 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
29666231 29666231 PRJNA515078_P_NODE_6970_length_354_cov_1.599369_g6737_i0 PRJNA515078 6970 354 1.599369 5.66176626 Desulfobacterales bacterium 2044940 Bacteria Bacteria 43.9 0.0489   NR MDJ0987005.1 2044940 g6737 i0 36.9 0.550847457627119 65 38 53.4 2 8 196 90 153 MDJ0987005.1 adenine deaminase C-terminal domain-containing protein [Desulfobacterales bacterium] diamond 195 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
29697727 29697727 PRJNA515078_P_NODE_18430_length_202_cov_1.890909_g18197_i0 PRJNA515078 18430 202 1.890909 3.81963618 Desulfobulbus propionicus 894 Bacteria Bacteria 59.7 1.96e-8   NR WP_015725419.1 894 g18197 i0 49.2 1.93069306930693 65 29 96.5 2 6 200 254 314 WP_015725419.1 malate dehydrogenase [Desulfobulbus propionicus] diamond 390 59.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
29744861 29744861 PRJNA515078_P_NODE_28610_length_163_cov_1.238095_g28377_i0 PRJNA515078 28610 163 1.238095 2.01809485 Pseudomonadati 3379134 Bacteria Bacteria 50.4 2.42e-5   NR WP_027184579.1 102109 g28377 i0 46.9 3.60736196319018 49 26 90.2 0 156 10 485 533 WP_027184579.1 hypothetical protein [Desulfovibrio inopinatus] diamond 588 50.8 0.992125984251969 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio inopinatus
29982379 29982379 PRJNA515078_P_NODE_18051_length_205_cov_1.220238_g17818_i0 PRJNA515078 18051 205 1.220238 2.5014879 Syntrophales bacterium 2928017 Bacteria Bacteria 80.9 8.03e-16   NR MCK9362855.1 2928017 g17818 i0 56.3 0.936585365853659 64 28 93.7 0 6 197 355 418 MCK9362855.1 hypothetical protein [Syntrophales bacterium] diamond 192 80.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
30171883 30171883 PRJNA515078_P_NODE_22932_length_181_cov_1.555556_g22699_i0 PRJNA515078 22932 181 1.555556 2.81555636 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 69.7 4.55e-12   NR MEE4607445.1 2049433 g22699 i0 60.7 5.61878453038674 56 22 92.8 0 1 168 247 302 MEE4607445.1 NAD(P)-dependent oxidoreductase [Desulfobacteraceae bacterium] diamond 1017 69.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31008838 31008838 PRJNA515078_P_NODE_14434_length_231_cov_2.010309_g14201_i0 PRJNA515078 14434 231 2.010309 4.64381379 root 1 Root_unresolved Root_unresolved 57.4 1.22e-7   NR MDO9584633.1 52017 g14201 i0 52.6 5.18181818181818 57 24 74 1 229 59 165 218 MDO9584633.1 metal-dependent hydrolase [Desulfomicrobium sp.] diamond 1197 57.8 0.993079584775087 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp.
31594398 31594398 PRJNA515078_P_NODE_23976_length_177_cov_1.671429_g23743_i0 PRJNA515078 23976 177 1.671429 2.95842933 Geobacter sp. DSM 9736 1277350 Bacteria Bacteria 54.3 1.12e-6   NR WP_172825491.1 1277350 g23743 i0 55.1 0.830508474576271 49 21 81.4 1 33 176 67 115 WP_172825491.1 EamA family transporter [Geobacter sp. DSM 9736] diamond 147 54.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp. DSM 9736
31594414 31594414 PRJNA515078_P_NODE_6636_length_363_cov_2.769939_g6403_i0 PRJNA515078 6636 363 2.769939 10.05487857 Geotalea daltonii 1203471 Bacteria Bacteria 109 7.14e-25   NR WP_012648379.1 1203471 g6403 i0 48.8 2.03305785123967 123 58 97.5 2 7 360 164 286 WP_012648379.1 IgGFc-binding protein [Geotalea daltonii] diamond 738 109 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geotalea Geotalea daltonii
31910502 31910502 PRJNA515078_P_NODE_30497_length_158_cov_1.933884_g30264_i0 PRJNA515078 30497 158 1.933884 3.05553672 Desulfobacterales bacterium 2044940 Bacteria Bacteria 43.1 0.00858   NR MCG8687949.1 2044940 g30264 i0 73.1 0.493670886075949 26 7 49.4 0 155 78 299 324 MCG8687949.1 ornithine--oxo-acid transaminase [Desulfobacterales bacterium] diamond 78 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32179203 32179203 PRJNA515078_P_NODE_31038_length_157_cov_1.475000_g30805_i0 PRJNA515078 31038 157 1.475 2.31575 Desulfovibrio 872 Bacteria Bacteria 79.3 1.27e-15   NR MDR2055083.1 885 g30805 i0 66.7 7.79617834394904 51 17 97.5 0 3 155 203 253 MDR2055083.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Desulfovibrio sp.] diamond 1224 79.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32527376 32527376 PRJNA515078_P_NODE_30279_length_159_cov_1.278689_g30046_i0 PRJNA515078 30279 159 1.278689 2.03311551 Desulfovibrionales 213115 Bacteria Bacteria 43.5 0.0037   NR MBO4317853.1 1981029 g30046 i0 47.7 1.66037735849057 44 23 83 0 140 9 70 113 MBO4317853.1 universal stress protein [Mailhella sp.] diamond 264 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella Mailhella sp.
32575176 32575176 PRJNA515078_P_NODE_7099_length_350_cov_1.741214_g6866_i0 PRJNA515078 7099 350 1.741214 6.094249 Desulfobacterales bacterium 2044940 Bacteria Bacteria 131 1.11e-34   NR MDJ0668974.1 2044940 g6866 i0 67.8 2.51142857142857 90 29 77.1 0 349 80 207 296 MDJ0668974.1 NAD(P)-dependent oxidoreductase [Desulfobacterales bacterium] diamond 879 131 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);;