RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB15333" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB15333 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
26716168 26716168 PRJEB15333_P_NODE_14081_length_183_cov_3.380597_g13997_i0 PRJEB15333 14081 183 3.380597 6.18649251 Algibacter sp. L4_22 2942477 Bacteria Bacteria 49.7 5.79e-5   NR WP_249755517.1 2942477 g13997 i0 55.1 0.80327868852459 49 16 70.5 3 41 169 210 258 WP_249755517.1 RNA-directed DNA polymerase, partial [Algibacter sp. L4_22] diamond 147 49.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Algibacter Algibacter sp. L4_22
28043882 28043882 PRJEB15333_P_NODE_19565_length_164_cov_0.904348_g19481_i0 PRJEB15333 19565 164 0.904348 1.48313072 Pedobacter cryoconitis 188932 Bacteria Bacteria 79.3 6.3e-16   NR WP_184657472.1 188932 g19481 i0 97.4 0.713414634146341 39 1 71.3 0 47 163 1 39 WP_184657472.1 alpha/beta hydrolase [Pedobacter cryoconitis] diamond 117 79.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter cryoconitis
28201554 28201554 PRJEB15333_P_NODE_20206_length_163_cov_0.912281_g20122_i0 PRJEB15333 20206 163 0.912281 1.48701803 Pedobacter cryoconitis 188932 Bacteria Bacteria 97.1 7.87e-23   NR WP_068405685.1 188932 g20122 i0 90.7 0.993865030674847 54 5 99.4 0 162 1 17 70 WP_068405685.1 N-acetylmuramic acid 6-phosphate etherase [Pedobacter cryoconitis] diamond 162 97.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter cryoconitis
31392129 31392129 PRJEB15333_P_NODE_14396_length_182_cov_0.774436_g14312_i0 PRJEB15333 14396 182 0.774436 1.40947352 Bacteroidaceae bacterium 2212467 Bacteria Bacteria 43.9 0.00365   NR MBQ3622304.1 2212467 g14312 i0 43.2 0.725274725274725 44 24 70.9 1 35 163 90 133 MBQ3622304.1 DUF805 domain-containing protein [Bacteroidaceae bacterium] diamond 132 43.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae   Bacteroidaceae 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);;