RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA857857", 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 · 12 ✖

tax_kingdom 1

  • Pseudomonadati · 12 ✖

bioproject 1

  • PRJNA857857 · 12 ✖

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
22913042 22913042 PRJNA857857_P_NODE_11238_length_469_cov_1.411616_g10798_i0 PRJNA857857 11238 469 1.411616 6.62047904 Desulfosudis 2904716 Bacteria Bacteria 119 4.43e-22   NTclustered gi|158508843|gb|CP000859.1| 96561 g10798 i0 75.665 8.13006396588486 263 50 55 13 212 469 683386 683133 Desulfococcus oleovorans Hxd3, complete genome blastn 3813 119 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosudaceae Desulfosudis Desulfosudis oleivorans
26801834 26801834 PRJNA857857_P_NODE_47481_length_244_cov_0.900585_g47032_i0 PRJNA857857 47481 244 0.900585 2.1974274 Desulfovibrio sp. An276 1965618 Bacteria Bacteria 155 2.45e-43   NR WP_087351416.1 1965618 g47032 i0 98.8 0.983606557377049 80 1 98.4 0 242 3 152 231 WP_087351416.1 magnesium transporter [Desulfovibrio sp. An276] diamond 240 155 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. An276
27055197 27055197 PRJNA857857_P_NODE_51882_length_241_cov_0.916667_g51433_i0 PRJNA857857 51882 241 0.916667 2.20916747 Candidatus Electrothrix communis 1859133 Bacteria Bacteria 78.2 1.16e-14   NR WLE95183.1 1859133 g51433 i0 45 2.98755186721992 80 43 98.3 1 239 3 462 541 WLE95183.1 MAG: hypothetical protein QTN59_10835 [Candidatus Electrothrix communis] diamond 720 78.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix communis
27371436 27371436 PRJNA857857_P_NODE_22863_length_327_cov_0.984252_g22414_i0 PRJNA857857 22863 327 0.984252 3.21850404 Desulfovibrio sp. An276 1965618 Bacteria Bacteria 159 2.1e-48   NR WP_087355066.1 1965618 g22414 i0 98.7 0.715596330275229 78 1 71.6 0 2 235 27 104 WP_087355066.1 AtpZ/AtpI family protein [Desulfovibrio sp. An276] diamond 234 159 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. An276
27750312 27750312 PRJNA857857_P_NODE_47524_length_244_cov_0.900585_g47075_i0 PRJNA857857 47524 244 0.900585 2.1974274 Desulfovibrio sp. An276 1965618 Bacteria Bacteria 144 7.109999999999999e-38   NR WP_087354942.1 1965618 g47075 i0 95 1.9672131147541 80 4 98.4 0 3 242 539 618 WP_087354942.1 inverse autotransporter beta domain-containing protein [Desulfovibrio sp. An276] diamond 480 144 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. An276
28823303 28823303 PRJNA857857_P_NODE_40868_length_248_cov_0.880000_g40419_i0 PRJNA857857 40868 248 0.88 2.1824 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 164 6.209999999999999e-48   NR WP_300800557.1 167968 g40419 i0 100 0.943548387096774 78 0 94.4 0 2 235 57 134 WP_300800557.1 class II fructose-1,6-bisphosphate aldolase [uncultured Desulfovibrio sp.] diamond 234 164 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
29620634 29620634 PRJNA857857_P_NODE_5930_length_639_cov_1.084806_g5513_i0 PRJNA857857 5930 639 1.084806 6.93191034 Pseudomonadati 3379134 Bacteria Bacteria 249 1.3e-78   NR MCY4046612.1 2080303 g5513 i0 54 12.8779342723005 213 98 100 0 639 1 34 246 MCY4046612.1 radical SAM protein [Candidatus Dadabacteria bacterium] diamond 8229 251 0.99203187250996006 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
30948132 30948132 PRJNA857857_P_NODE_9094_length_517_cov_1.563063_g8663_i0 PRJNA857857 9094 517 1.563063 8.08103571 root 1 Root_unresolved Root_unresolved 169 3.61e-47   NR MCY4046611.1 2080303 g8663 i0 64.5 2.15860735009671 124 44 72 0 373 2 2 125 MCY4046611.1 glycosyltransferase [Candidatus Dadabacteria bacterium] diamond 1116 169 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
31255748 31255748 PRJNA857857_P_NODE_16035_length_393_cov_0.962500_g15588_i0 PRJNA857857 16035 393 0.9625 3.782625 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 56.6 2.88e-6   NR MCL7489109.1 2053307 g15588 i0 34.7 0.770992366412214 101 61 77.1 1 323 21 10 105 MCL7489109.1 DUF6531 domain-containing protein [Desulfobulbaceae bacterium] diamond 303 56.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
31635250 31635250 PRJNA857857_P_NODE_49016_length_243_cov_0.905882_g48567_i0 PRJNA857857 49016 243 0.905882 2.20129326 Desulfovibrio sp. An276 1965618 Bacteria Bacteria 80.1 1.16e-16   NR WP_087355147.1 1965618 g48567 i0 100 0.530864197530864 43 0 53.1 0 130 2 1 43 WP_087355147.1 GlcG/HbpS family heme-binding protein [Desulfovibrio sp. An276] diamond 129 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. An276
31698600 31698600 PRJNA857857_P_NODE_48957_length_243_cov_0.905882_g48508_i0 PRJNA857857 48957 243 0.905882 2.20129326 Desulfovibrio sp. An276 1965618 Bacteria Bacteria 143 9.12e-39   NR WP_087351663.1 1965618 g48508 i0 98.6 0.901234567901235 73 1 90.1 0 2 220 362 434 WP_087351663.1 phenylacetate--CoA ligase family protein [Desulfovibrio sp. An276] diamond 219 143 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. An276
31983204 31983204 PRJNA857857_P_NODE_51918_length_241_cov_0.916667_g51469_i0 PRJNA857857 51918 241 0.916667 2.20916747 Desulfovibrio sp. An276 1965618 Bacteria Bacteria 117 6.59e-31   NR WP_087349435.1 1965618 g51469 i0 76.3 0.995850622406639 80 19 99.6 0 241 2 71 150 WP_087349435.1 hypothetical protein [Desulfovibrio sp. An276] diamond 240 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. An276

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