RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 7 ✖

bioproject 1

  • PRJEB25789 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
10225948 10225948 PRJEB25789_S_NODE_18229_length_246_cov_0.890173_g18150_i0 PRJEB25789 18229 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 99.4 2.1899999999999998e-25   NR WP_392481730.1 1307 g18150 i0 98 1.19512195121951 49 1 59.8 0 2 148 21 69 WP_392481730.1 hypothetical protein, partial [Streptococcus suis] diamond 294 100 0.994 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
27633575 27633575 PRJEB25789_S_NODE_7224_length_344_cov_2.177122_g7145_i0 PRJEB25789 7224 344 2.177122 7.48929968 Chloroflexota bacterium 2026724 Bacteria Bacteria 108 2.0900000000000003e-27   NR MEZ4515128.1 2026724 g7145 i0 45 2.97383720930233 111 60 95.9 1 14 343 12 122 MEZ4515128.1 coactosin family protein [Chloroflexota bacterium] diamond 1023 108 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28226642 28226642 PRJEB25789_S_NODE_15526_length_258_cov_0.956757_g15447_i0 PRJEB25789 15526 258 0.956757 2.46843306 root 1 Root_unresolved Root_unresolved 153 6.879999999999999e-45   NR MBX9718074.1 1873462 g15447 i0 81.4 19 86 16 100 0 1 258 108 193 MBX9718074.1 30S ribosomal protein S17 [Microbacteriaceae bacterium] diamond 4902 154 0.993506493506494 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
28889880 28889880 PRJEB25789_S_NODE_7948_length_332_cov_2.463320_g7869_i0 PRJEB25789 7948 332 2.46332 8.1782224 Bacteria 2 Bacteria Bacteria 64.3 2.73e-9   NR HUN31675.1 2767075 g7869 i0 36.8 7.51807228915663 106 67 95.8 0 11 328 66 171 HUN31675.1 NADH-quinone oxidoreductase subunit M [Trebonia sp.] diamond 2496 64.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Treboniaceae Trebonia Trebonia sp.
32049787 32049787 PRJEB25789_S_NODE_14198_length_267_cov_1.195876_g14119_i0 PRJEB25789 14198 267 1.195876 3.19298892 Bacteria 2 Bacteria Bacteria 82.8 4.11e-16   NR MEW6085138.1 2026724 g14119 i0 47.7 4.84269662921348 88 45 97.8 1 263 3 1614 1701 MEW6085138.1 RHS repeat-associated core domain-containing protein [Chloroflexota bacterium] diamond 1293 82.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32556409 32556409 PRJEB25789_S_NODE_18799_length_244_cov_1.707602_g18720_i0 PRJEB25789 18799 244 1.707602 4.16654888 Bacillati 1783272 Bacteria Bacteria 43.9 0.014   NR MDP2948679.1 2026724 g18720 i0 37.5 1.18032786885246 48 27 59 1 4 147 225 269 MDP2948679.1 SAM-dependent methyltransferase [Chloroflexota bacterium] diamond 288 44.3 0.99097065462754 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32594168 32594168 PRJEB25789_S_NODE_18920_length_244_cov_0.900585_g18841_i0 PRJEB25789 18920 244 0.900585 2.1974274 Rubrobacter sp. 2036010 Bacteria Bacteria 86.7 3.35e-18   NR MCA3749008.1 2036010 g18841 i0 100 0.55327868852459 45 0 55.3 0 137 3 1 45 MCA3749008.1 universal stress protein [Rubrobacter sp.] diamond 135 86.7 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae Rubrobacter Rubrobacter 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);;