RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA773625" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773625 · 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
27284131 27284131 PRJNA773625_P_NODE_4243_length_210_cov_1.024845_g4228_i0 PRJNA773625 4243 210 1.024845 2.1521745 Legionella 445 Bacteria Bacteria 56.6 3.02e-7   NR WP_019233145.1 28082 g4228 i0 58.1 5.88571428571429 43 18 61.4 0 57 185 162 204 WP_019233145.1 hypothetical protein [Legionella anisa] diamond 1236 56.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Legionellaceae Legionella Legionella anisa
28032637 28032637 PRJNA773625_P_NODE_11065_length_162_cov_0.920354_g11050_i0 PRJNA773625 11065 162 0.920354 1.49097348 Pseudomonas sp. 306 Bacteria Bacteria 92.4 1.68e-20   NR WP_340664408.1 306 g11050 i0 85.2 1 54 8 100 0 162 1 10 63 WP_340664408.1 fatty acid desaturase [Pseudomonas sp.] diamond 162 92.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
28821546 28821546 PRJNA773625_P_NODE_9888_length_164_cov_0.904348_g9873_i0 PRJNA773625 9888 164 0.904348 1.48313072 Francisella sp. 2047875 Bacteria Bacteria 124 2.67e-33   NR PZU04837.1 2047875 g9873 i0 100 0.98780487804878 54 0 98.8 0 3 164 56 109 PZU04837.1 MAG: thymidylate synthase [Francisella sp.] diamond 162 124 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Francisellaceae Francisella Francisella sp.
29990186 29990186 PRJNA773625_P_NODE_7611_length_168_cov_0.873950_g7596_i0 PRJNA773625 7611 168 0.87395 1.468236 uncultured Psychrobacter sp. 259303 Bacteria Bacteria 95.9 5.21e-22   NR WP_339663848.1 259303 g7596 i0 82.1 1 56 10 100 0 1 168 194 249 WP_339663848.1 PilW family protein [uncultured Psychrobacter sp.] diamond 168 95.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter uncultured Psychrobacter sp.
30274778 30274778 PRJNA773625_P_NODE_7872_length_168_cov_0.873950_g7857_i0 PRJNA773625 7872 168 0.87395 1.468236 Klebsiella pneumoniae 573 Bacteria Bacteria 40 0.0403   NR WP_416532971.1 573 g7857 i0 85.7 0.375 21 3 37.5 0 82 144 48 68 WP_416532971.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 63 40 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32370940 32370940 PRJNA773625_P_NODE_3459_length_227_cov_0.938202_g3444_i0 PRJNA773625 3459 227 0.938202 2.12971854 Legionella 445 Bacteria Bacteria 52.4 1.22e-5   NR WP_045096350.1 96230 g3444 i0 42.6 1.87665198237885 68 39 89.9 0 19 222 99 166 WP_045096350.1 cyclic nucleotide-binding domain-containing protein [Legionella fallonii] diamond 426 52.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Legionellaceae Legionella Legionella fallonii

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