RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJEB17675" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJEB17675 · 10 ✖

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
7673950 7673950 PRJEB17675_P_NODE_4487_length_460_cov_1.548235_g4190_i0 PRJEB17675 4487 460 1.548235 7.121881 Geomonas sp. Red32 2912856 Bacteria Bacteria 178 2.76e-49   NR WP_250677316.1 2912856 g4190 i0 56.6 5.94130434782609 152 64 99.1 2 458 3 127 276 WP_250677316.1 5-histidylcysteine sulfoxide synthase [Geomonas sp. Red32] diamond 2733 178 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas sp. Red32
11189207 11189207 PRJEB17675_P_NODE_3669_length_512_cov_10.987421_g3386_i0 PRJEB17675 3669 512 10.987421 56.25559552 Desulfomicrobium 898 Bacteria Bacteria 320 1.24e-82   NTclustered gi|470484403|ref|NR_076646.1| 899 g3386 i0 78.42 152.69921875 519 92 99 17 1 510 518 11 Desulfomicrobium baculatum strain INMI strain X 23S ribosomal RNA gene, complete sequence blastn 78182 320 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium baculatum
26716172 26716172 PRJEB17675_P_NODE_10941_length_260_cov_1.697778_g10637_i0 PRJEB17675 10941 260 1.697778 4.4142228 Candidatus Electrothrix gigas 2202844 Bacteria Bacteria 73.9 1.36e-13   NR WYD82073.1 2202844 g10637 i0 45.3 1.89230769230769 86 46 99.2 1 258 1 14 98 WYD82073.1 MAG: glucose 1-dehydrogenase [Candidatus Electrothrix gigas] diamond 492 73.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix gigas
27001321 27001321 PRJEB17675_P_NODE_23282_length_158_cov_1.414634_g22978_i0 PRJEB17675 23282 158 1.414634 2.23512172 Syntrophaceae bacterium 2052184 Bacteria Bacteria 74.7 6.18e-14   NR HBH86569.1 2052184 g22978 i0 65.2 0.873417721518987 46 15 85.4 1 8 142 523 568 HBH86569.1 hypothetical protein [Syntrophaceae bacterium] diamond 138 74.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium
27696943 27696943 PRJEB17675_P_NODE_7124_length_348_cov_1.277955_g6820_i0 PRJEB17675 7124 348 1.277955 4.4472834 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 131 5.5800000000000005e-33   NR HAO22905.1 2049433 g6820 i0 47 0.991379310344828 115 61 99.1 0 1 345 286 400 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 345 131 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29086007 29086007 PRJEB17675_P_NODE_24888_length_152_cov_1.358974_g24584_i0 PRJEB17675 24888 152 1.358974 2.06564048 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 41.6 0.0278   NR MCP4109772.1 2049433 g24584 i0 32.7 1.93421052631579 49 33 96.7 0 151 5 17 65 MCP4109772.1 WD40 repeat domain-containing protein [Desulfobacteraceae bacterium] diamond 294 41.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29370079 29370079 PRJEB17675_P_NODE_869_length_1005_cov_2.376289_g731_i0 PRJEB17675 869 1005 2.376289 23.88170445 Desulfobaccales bacterium 3064668 Bacteria Bacteria 60.5 3.59e-6   NR MFA4904166.1 3064668 g731 i0 42.9 0.352238805970149 70 38 20.3 1 631 834 179 248 MFA4904166.1 hypothetical protein [Desulfobaccales bacterium] diamond 354 60.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobaccia Desulfobaccales     Desulfobaccales bacterium
30318068 30318068 PRJEB17675_P_NODE_4592_length_454_cov_2.164678_g4295_i0 PRJEB17675 4592 454 2.164678 9.82763812 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 73.9 4.32e-12   NR MFC1834884.1 2202153 g4295 i0 35.8 0.79295154185022 120 70 79.3 3 452 93 269 381 MFC1834884.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 360 73.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32182921 32182921 PRJEB17675_P_NODE_12598_length_236_cov_1.592040_g12294_i0 PRJEB17675 12598 236 1.59204 3.7572144 Desulfurivibrionaceae bacterium 3024425 Bacteria Bacteria 75.5 7.48e-14   NR HSH12524.1 3024425 g12294 i0 52.8 0.915254237288136 72 30 86.4 1 208 5 97 168 HSH12524.1 PKD domain-containing protein [Desulfurivibrionaceae bacterium] diamond 216 75.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfurivibrionaceae   Desulfurivibrionaceae bacterium
32239930 32239930 PRJEB17675_P_NODE_9958_length_277_cov_1.780992_g9654_i0 PRJEB17675 9958 277 1.780992 4.93334784 Pseudomonadati 3379134 Bacteria Bacteria 63.9 6.2e-10   NR MEX0998865.1 2202153 g9654 i0 42.5 4.4187725631769 80 46 86.6 0 275 36 2 81 MEX0998865.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 1224 64.3 0.993779160186625 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota 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);;