RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA986547", 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

  • PRJNA986547 · 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
26773278 26773278 PRJNA986547_P_NODE_16621_length_203_cov_7.430769_g16539_i0 PRJNA986547 16621 203 7.430769 15.08446107 Geobacter sulfurreducens 35554 Bacteria Bacteria 46.6 6.94e-5   NR WP_286352257.1 35554 g16539 i0 90 1.18226600985222 20 2 29.6 0 144 203 23 42 WP_286352257.1 hypothetical protein [Geobacter sulfurreducens] diamond 240 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sulfurreducens
27026395 27026395 PRJNA986547_P_NODE_13142_length_234_cov_4.099379_g13060_i0 PRJNA986547 13142 234 4.099379 9.59254686 Desulforhopalus sp. 2099376 Bacteria Bacteria 108 7.11e-29   NR MFT5699794.1 2099376 g13060 i0 73.4 1.64102564102564 64 17 82.1 0 233 42 38 101 MFT5699794.1 hypothetical protein [Desulforhopalus sp.] diamond 384 108 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulforhopalus Desulforhopalus sp.
27184322 27184322 PRJNA986547_P_NODE_11622_length_242_cov_1.928994_g11540_i0 PRJNA986547 11622 242 1.928994 4.66816548 Desulfarculales bacterium 2478484 Bacteria Bacteria 42.4 0.0472   NR MDR1396339.1 2478484 g11540 i0 69.6 0.285123966942149 23 7 28.5 0 69 1 1 23 MDR1396339.1 type I-C CRISPR-associated protein Cas7/Csd2 [Desulfarculales bacterium] diamond 69 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales     Desulfarculales bacterium
27279399 27279399 PRJNA986547_P_NODE_10523_length_245_cov_2.238372_g10441_i0 PRJNA986547 10523 245 2.238372 5.4840114 Pseudodesulfovibrio tunisiensis 463192 Bacteria Bacteria 68.2 1.85e-11   NR WP_243544277.1 463192 g10441 i0 59.3 0.661224489795918 54 22 66.1 0 237 76 188 241 WP_243544277.1 NTP transferase domain-containing protein [Pseudodesulfovibrio tunisiensis] diamond 162 68.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio tunisiensis
27279413 27279413 PRJNA986547_P_NODE_6663_length_264_cov_1.256545_g6581_i0 PRJNA986547 6663 264 1.256545 3.3172788 Desulfomicrobiaceae bacterium 2053547 Bacteria Bacteria 166 5.0999999999999995e-49   NR MEJ5242385.1 2053547 g6581 i0 85.2 1 88 13 100 0 264 1 170 257 MEJ5242385.1 OmpA family protein [Desulfomicrobiaceae bacterium] diamond 264 166 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae   Desulfomicrobiaceae bacterium
31954507 31954507 PRJNA986547_P_NODE_3877_length_292_cov_2.840183_g3795_i0 PRJNA986547 3877 292 2.840183 8.29333436 Geopsychrobacter electrodiphilus 225196 Bacteria Bacteria 60.1 5.48e-8   NR WP_026362143.1 225196 g3795 i0 47.9 0.493150684931507 48 25 49.3 0 143 286 777 824 WP_026362143.1 PKD domain-containing protein [Geopsychrobacter electrodiphilus] diamond 144 60.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae Geopsychrobacter Geopsychrobacter electrodiphilus
32366158 32366158 PRJNA986547_P_NODE_17179_length_199_cov_4.785714_g17097_i0 PRJNA986547 17179 199 4.785714 9.52357086 Desulfamplus sp. 2006184 Bacteria Bacteria 60.1 1.58e-8   NR MBF0230039.1 2006184 g17097 i0 48.4 2.53266331658291 62 30 90.5 1 180 1 37 98 MBF0230039.1 ATP-binding protein [Desulfamplus sp.] diamond 504 60.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus sp.

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