RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJDB14274" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJDB14274 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27759321 27759321 PRJDB14274_S_NODE_6224_length_252_cov_1.251309_g6146_i0 PRJDB14274 6224 252 1.251309 3.15329868 Streptomyces thinghirensis 551547 Bacteria Bacteria 42.7 0.0387   NR MCF2436382.1 551547 g6146 i0 47.7 0.523809523809524 44 21 52.4 1 164 33 226 267 MCF2436382.1 hypothetical protein [Streptomyces thinghirensis] diamond 132 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces thinghirensis
28485238 28485238 PRJDB14274_S_NODE_9047_length_211_cov_1.093333_g8969_i0 PRJDB14274 9047 211 1.093333 2.30693263 Amycolatopsis orientalis 31958 Bacteria Bacteria 42 0.0434   NR WP_044855237.1 31958 g8969 i0 39 0.838862559241706 59 35 83.9 1 27 203 185 242 WP_044855237.1 hypothetical protein [Amycolatopsis orientalis] diamond 177 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis orientalis
28674716 28674716 PRJDB14274_S_NODE_3247_length_340_cov_1.458781_g3169_i0 PRJDB14274 3247 340 1.458781 4.9598554 Actinomycetota bacterium 2900548 Bacteria Bacteria 93.2 7.270000000000001e-21   NR MBC7464176.1 2900548 g3169 i0 54.4 0.794117647058823 90 41 79.4 0 3 272 118 207 MBC7464176.1 NAD(P)H-dependent oxidoreductase [Actinomycetota bacterium] diamond 270 93.2 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30411894 30411894 PRJDB14274_S_NODE_5313_length_271_cov_1.776190_g5235_i0 PRJDB14274 5313 271 1.77619 4.8134749 Mycolicibacterium iranicum 912594 Bacteria Bacteria 46.6 0.00171   NR WP_064281344.1 912594 g5235 i0 35.6 0.653136531365314 59 37 64.2 1 51 224 151 209 WP_064281344.1 GAP family protein [Mycolicibacterium iranicum] diamond 177 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium iranicum
31992204 31992204 PRJDB14274_S_NODE_3778_length_316_cov_1.211765_g3700_i0 PRJDB14274 3778 316 1.211765 3.8291774 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 43.9 0.02   NR HSO95603.1 2080302 g3700 i0 41.7 1.36708860759494 48 28 45.6 0 131 274 87 134 HSO95603.1 YbhB/YbcL family Raf kinase inhibitor-like protein [Acidimicrobiia bacterium] diamond 432 43.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
32562078 32562078 PRJDB14274_S_NODE_9139_length_210_cov_1.302013_g9061_i0 PRJDB14274 9139 210 1.302013 2.7342273 Rhodococcus sp. (in: high G+C Gram-positive bacteria) 1831 Bacteria Bacteria 42.7 0.00706   NR MER2208681.1 1831 g9061 i0 39.7 0.828571428571429 58 31 81.4 2 172 2 44 98 MER2208681.1 ADP-ribosylglycohydrolase family protein [Rhodococcus sp. (in: high G+C Gram-positive bacteria)] diamond 174 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. (in: high G+C Gram-positive bacteria)

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