RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA855894" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA855894 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
1235037 1235037 PRJNA855894_P_NODE_30921_length_249_cov_0.875000_g30799_i0 PRJNA855894 30921 249 0.875 2.17875 Pseudolysinimonas 2680005 Bacteria Bacteria 120 7.349999999999999e-31   NR WP_309709767.1 2680009 g30799 i0 81.7 2.92771084337349 82 15 98.8 0 3 248 76 157 WP_309709767.1 DMT family transporter [Pseudolysinimonas sp.] diamond 729 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Pseudolysinimonas Pseudolysinimonas sp.
9770225 9770225 PRJNA855894_P_NODE_27608_length_266_cov_1.595855_g27486_i0 PRJNA855894 27608 266 1.595855 4.2449743 Micrococcus flavus 384602 Bacteria Bacteria 156 2.44e-45   NR WP_135027581.1 384602 g27486 i0 88.6 0.992481203007519 88 10 99.2 0 265 2 131 218 WP_135027581.1 triose-phosphate isomerase [Micrococcus flavus] diamond 264 156 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus flavus
16145050 16145050 PRJNA855894_P_NODE_32093_length_246_cov_0.890173_g31971_i0 PRJNA855894 32093 246 0.890173 2.18982558 Micrococcus endophyticus 455343 Bacteria Bacteria 154 4.0899999999999985e-43   NR WP_184172599.1 455343 g31971 i0 100 1 82 0 100 0 1 246 224 305 WP_184172599.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Micrococcus endophyticus] diamond 246 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus endophyticus
28223471 28223471 PRJNA855894_P_NODE_32046_length_246_cov_1.104046_g31924_i0 PRJNA855894 32046 246 1.104046 2.71595316 Nocardioides sp. 35761 Bacteria Bacteria 85.5 5.56e-18   NR MFL6004500.1 35761 g31924 i0 76.9 1.95121951219512 52 12 63.4 0 1 156 43 94 MFL6004500.1 transglycosylase SLT domain-containing protein [Nocardioides sp.] diamond 480 85.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
28326389 28326389 PRJNA855894_P_NODE_32966_length_244_cov_0.900585_g32844_i0 PRJNA855894 32966 244 0.900585 2.1974274 Pseudolysinimonas 2680005 Bacteria Bacteria 119 4.39e-29   NR WP_395639570.1 2680009 g32844 i0 74.1 1.99180327868852 81 21 99.6 0 2 244 792 872 WP_395639570.1 hypothetical protein [Pseudolysinimonas sp.] diamond 486 120 0.991666666666667 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Pseudolysinimonas Pseudolysinimonas sp.
29873727 29873727 PRJNA855894_P_NODE_30651_length_249_cov_0.875000_g30529_i0 PRJNA855894 30651 249 0.875 2.17875 Branchiibius 908251 Bacteria Bacteria 114 2.25e-29   NR WP_109684873.1 672460 g30529 i0 91.4 2.09638554216867 58 5 69.9 0 2 175 160 217 WP_109684873.1 SGNH/GDSL hydrolase family protein [Branchiibius hedensis] diamond 522 114 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Branchiibius Branchiibius hedensis
30686844 30686844 PRJNA855894_P_NODE_33593_length_243_cov_0.905882_g33471_i0 PRJNA855894 33593 243 0.905882 2.20129326 Rubrobacteraceae bacterium 2740537 Bacteria Bacteria 113 2.81e-28   NR HSL00552.1 2740537 g33471 i0 72.5 3.95061728395062 80 22 98.8 0 3 242 2 81 HSL00552.1 ATP-dependent 6-phosphofructokinase [Rubrobacteraceae bacterium] diamond 960 113 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae   Rubrobacteraceae bacterium
32710217 32710217 PRJNA855894_P_NODE_32280_length_246_cov_0.890173_g32158_i0 PRJNA855894 32280 246 0.890173 2.18982558 Actinomycetota bacterium 2900548 Bacteria Bacteria 120 1.33e-29   NR MDP9466133.1 2900548 g32158 i0 78 2 82 18 100 0 246 1 105 186 MDP9466133.1 ABC transporter substrate-binding protein [Actinomycetota bacterium] diamond 492 120 1 Bacteria   Bacillati Actinomycetota         Actinomycetota 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);;