RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 15 ✖

bioproject 1

  • PRJNA930380 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
14937293 14937293 PRJNA930380_P_NODE_13712_length_243_cov_0.905882_g13659_i0 PRJNA930380 13712 243 0.905882 2.20129326 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 132 5.700000000000001e-34   NR MFO7292305.1 2080302 g13659 i0 100 0.864197530864197 70 0 86.4 0 3 212 217 286 MFO7292305.1 DivIVA domain-containing protein [Acidimicrobiia bacterium] diamond 210 132 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
16212250 16212250 PRJNA930380_P_NODE_12093_length_249_cov_0.875000_g12040_i0 PRJNA930380 12093 249 0.875 2.17875 Actinomycetota bacterium 2900548 Bacteria Bacteria 145 8.26e-40   NR HEU4866131.1 2900548 g12040 i0 98.7 1.83132530120482 76 1 91.6 0 21 248 1 76 HEU4866131.1 TrkA C-terminal domain-containing protein [Actinomycetota bacterium] diamond 456 145 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
21311443 21311443 PRJNA930380_P_NODE_13837_length_243_cov_0.905882_g13784_i0 PRJNA930380 13837 243 0.905882 2.20129326 Ruthenibacterium sp. 1905345 Bacteria Bacteria 70.1 1.02e-13   NR MEG2435696.1 1905345 g13784 i0 70.4 0.666666666666667 54 15 66.7 1 219 58 24 76 MEG2435696.1 hypothetical protein [Ruthenibacterium sp.] diamond 162 70.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruthenibacterium Ruthenibacterium sp.
26613234 26613234 PRJNA930380_P_NODE_10681_length_263_cov_1.484211_g10628_i0 PRJNA930380 10681 263 1.484211 3.90347493 Polycladomyces zharkentensis 2807616 Bacteria Bacteria 43.1 0.0351   NR WP_205492801.1 2807616 g10628 i0 31.9 0.821292775665399 72 39 70.7 2 213 28 1 72 WP_205492801.1 DNA internalization-related competence protein ComEC/Rec2 [Polycladomyces zharkentensis] diamond 216 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Polycladomyces Polycladomyces zharkentensis
26835202 26835202 PRJNA930380_P_NODE_6321_length_290_cov_1.244240_g6268_i0 PRJNA930380 6321 290 1.24424 3.608296 Kitasatospora sp. NPDC 1871188 Bacteria Bacteria 45.8 0.00422   NR WP_359821280.1 3154600 g6268 i0 40.9 0.682758620689655 66 31 60 2 41 214 58 123 WP_359821280.1 TOMM precursor leader peptide-binding protein [Kitasatospora sp. NPDC036755] diamond 198 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora sp. NPDC036755
27688786 27688786 PRJNA930380_P_NODE_4744_length_302_cov_3.401747_g4691_i0 PRJNA930380 4744 302 3.401747 10.27327594 Brockia lithotrophica 933949 Bacteria Bacteria 43.5 0.00591   NR MBE3550665.1 933949 g4691 i0 44.7 0.754966887417219 38 21 37.7 0 158 271 29 66 MBE3550665.1 hypothetical protein [Brockia lithotrophica] diamond 228 43.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Brockia Brockia lithotrophica
28446295 28446295 PRJNA930380_P_NODE_6906_length_287_cov_1.883178_g6853_i0 PRJNA930380 6906 287 1.883178 5.40472086 Nostoc sp. KVJ2 457943 Bacteria Bacteria 43.1 0.0425   NR WP_069072706.1 457944 g6853 i0 29.1 0.574912891986063 55 39 57.5 0 55 219 135 189 WP_069072706.1 vWA domain-containing protein [Nostoc sp. KVJ20] diamond 165 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. KVJ20
29014795 29014795 PRJNA930380_P_NODE_7408_length_285_cov_1.452830_g7355_i0 PRJNA930380 7408 285 1.45283 4.1405655 Candidatus Hakubella thermalkaliphila 2754717 Bacteria Bacteria 44.7 0.00847   NR GFP31743.1 2754717 g7355 i0 40.5 0.38947368421052603 37 22 38.9 0 47 157 143 179 GFP31743.1 hypothetical protein HKBW3S42_00050 [Candidatus Hakubella thermalkaliphila] diamond 111 44.7 1 Bacteria   Bacillati Actinomycetota   Candidatus Hakubellales Candidatus Hakubellaceae Candidatus Hakubella Candidatus Hakubella thermalkaliphila
29803749 29803749 PRJNA930380_P_NODE_11791_length_250_cov_0.870056_g11738_i0 PRJNA930380 11791 250 0.870056 2.17514 Chloroflexota bacterium 2026724 Bacteria Bacteria 61.6 8.6e-9   NR TMC16449.1 2026724 g11738 i0 40 4.176 65 39 78 0 196 2 145 209 TMC16449.1 MAG: DDE-type integrase/transposase/recombinase, partial [Chloroflexota bacterium] diamond 1044 61.6 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30948468 30948468 PRJNA930380_P_NODE_8114_length_282_cov_1.129187_g8061_i0 PRJNA930380 8114 282 1.129187 3.18430734 root 1 Root_unresolved Root_unresolved 54.3 5.04e-6   NR WP_330942623.1 1328 g8061 i0 40.9 7.02127659574468 66 37 68.1 1 69 260 429 494 WP_330942623.1 reverse transcriptase domain-containing protein, partial [Streptococcus anginosus] diamond 1980 54.7 0.992687385740402 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus anginosus
31099058 31099058 PRJNA930380_P_NODE_11795_length_250_cov_0.870056_g11742_i0 PRJNA930380 11795 250 0.870056 2.17514 Terrisporobacter sp. 1965305 Bacteria Bacteria 50.4 9.49e-6   NR MEG1411258.1 1965305 g11742 i0 76.7 0.36 30 7 36 0 90 1 1 30 MEG1411258.1 hypothetical protein [Terrisporobacter sp.] diamond 90 50.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Terrisporobacter Terrisporobacter sp.
31193610 31193610 PRJNA930380_P_NODE_8675_length_279_cov_1.495146_g8622_i0 PRJNA930380 8675 279 1.495146 4.17145734 Cyanobacteria bacterium UBA9273 2055791 Bacteria Bacteria 43.9 0.0202   NR HBB31562.1 2055791 g8622 i0 40 0.591397849462366 55 29 59.1 1 18 182 9 59 HBB31562.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Cyanobacteria bacterium UBA9273] diamond 165 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA9273
31478833 31478833 PRJNA930380_P_NODE_14256_length_241_cov_0.916667_g14203_i0 PRJNA930380 14256 241 0.916667 2.20916747 Frankia sp. R82 2950553 Bacteria Bacteria 65.5 3.51e-10   NR WP_251734420.1 2950553 g14203 i0 52.2 1.71784232365145 69 28 84.6 2 240 37 435 499 WP_251734420.1 SMP-30/gluconolactonase/LRE family protein, partial [Frankia sp. R82] diamond 414 65.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae Frankia Frankia sp. R82
31858106 31858106 PRJNA930380_P_NODE_5997_length_291_cov_2.110092_g5944_i0 PRJNA930380 5997 291 2.110092 6.14036772 Candidatus Limnocylindria bacterium 3047546 Bacteria Bacteria 44.7 0.0124   NR HEX7195257.1 3047546 g5944 i0 46.3 0.422680412371134 41 22 42.3 0 245 123 102 142 HEX7195257.1 DHHA1 domain-containing protein [Candidatus Limnocylindria bacterium] diamond 123 44.7 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria       Candidatus Limnocylindria bacterium
32364603 32364603 PRJNA930380_P_NODE_8139_length_282_cov_0.832536_g8086_i0 PRJNA930380 8139 282 0.832536 2.34775152 Roseofilum acuticapitatum 3082945 Bacteria Bacteria 44.3 0.0167   NR WP_283753735.1 3082945 g8086 i0 35.2 0.574468085106383 54 35 57.4 0 260 99 27 80 WP_283753735.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Roseofilum acuticapitatum] diamond 162 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Desertifilales Desertifilaceae Roseofilum Roseofilum acuticapitatum

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