RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA206070", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA206070 · 7 ✖

analysis 1

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
27231980 27231980 PRJNA206070_S_NODE_26763_length_165_cov_2.125000_g24887_i0 PRJNA206070 26763 165 2.125 3.50625 uncultured Desulfobulbus sp. 239745 Bacteria Bacteria 47.8 2.16e-4   NR WP_297952607.1 239745 g24887 i0 47.7 5.76363636363636 44 23 80 0 158 27 113 156 WP_297952607.1 DEAD/DEAH box helicase [uncultured Desulfobulbus sp.] diamond 951 47.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus uncultured Desulfobulbus sp.
27895106 27895106 PRJNA206070_S_NODE_11905_length_326_cov_2.799308_g10029_i0 PRJNA206070 11905 326 2.799308 9.12574408 Desulfovibrio desulfuricans 876 Bacteria Bacteria 50.8 1.87e-5   NR WP_227118024.1 876 g10029 i0 50 0.515337423312883 56 15 51.5 1 178 11 1 43 WP_227118024.1 zinc ribbon domain-containing protein [Desulfovibrio desulfuricans] diamond 168 50.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
29347696 29347696 PRJNA206070_S_NODE_15149_length_263_cov_1.548673_g13273_i0 PRJNA206070 15149 263 1.548673 4.07300999 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 104 7.17e-26   NR MDD5759089.1 2053307 g13273 i0 79.7 1.40304182509506 59 12 67.3 0 187 11 5 63 MDD5759089.1 DUF1643 domain-containing protein [Desulfobulbaceae bacterium] diamond 369 104 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
30769156 30769156 PRJNA206070_S_NODE_6454_length_573_cov_2.343284_g2629_i1 PRJNA206070 6454 573 2.343284 13.42701732 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 44.7 0.0319   NR WP_300719079.1 167968 g2629 i1 45.2 0.219895287958115 42 18 19.4 1 180 70 3 44 WP_300719079.1 hypothetical protein [uncultured Desulfovibrio sp.] diamond 126 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
31102649 31102649 PRJNA206070_S_NODE_14855_length_267_cov_3.078261_g12979_i0 PRJNA206070 14855 267 3.078261 8.21895687 root 1 Root_unresolved Root_unresolved 57.8 3.13e-8   NR WP_300719079.1 167968 g12979 i0 36.6 2.13483146067416 101 50 97.8 3 7 267 3 103 WP_300719079.1 hypothetical protein [uncultured Desulfovibrio sp.] diamond 570 57.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
31306223 31306223 PRJNA206070_S_NODE_6175_length_597_cov_2.550000_g4344_i0 PRJNA206070 6175 597 2.55 15.2235 Desulfoplanes sp. 3018273 Bacteria Bacteria 47 0.0298   NR MFA7166900.1 3018273 g4344 i0 54.8 0.21105527638191 42 19 21.1 0 521 396 619 660 MFA7166900.1 hypothetical protein [Desulfoplanes sp.] diamond 126 47 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfoplanaceae Desulfoplanes Desulfoplanes sp.
31748975 31748975 PRJNA206070_S_NODE_30777_length_152_cov_1.939130_g28901_i0 PRJNA206070 30777 152 1.93913 2.9474776 Desulfonauticus submarinus 206665 Bacteria Bacteria 53.1 1.29e-7   NR WP_092065846.1 206665 g28901 i0 69.4 2.40789473684211 36 11 71.1 0 118 11 7 42 WP_092065846.1 translation initiation factor IF-1 [Desulfonauticus submarinus] diamond 366 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonauticaceae Desulfonauticus Desulfonauticus submarinus

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