RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA177642" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA177642 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
1055177 1055177 PRJNA177642_P_NODE_6021_length_568_cov_3.239332_g4913_i0 PRJNA177642 6021 568 3.239332 18.39940576 Flavobacteriales bacterium 2021391 Bacteria Bacteria 152 2.38e-43   NR TXI78817.1 2021391 g4913 i0 80 0.897887323943662 85 17 44.9 0 1 255 67 151 TXI78817.1 MAG: peptide-methionine (S)-S-oxide reductase MsrA [Flavobacteriales bacterium] diamond 510 152 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
14394607 14394607 PRJNA177642_P_NODE_17652_length_166_cov_1.051095_g16427_i0 PRJNA177642 17652 166 1.051095 1.7448177 Taibaiella 1434702 Bacteria Bacteria 90.1 2.71e-19   NR MBX2904774.1 1869185 g16427 i0 77.8 10.2469879518072 54 12 97.6 0 2 163 660 713 MBX2904774.1 alanine--tRNA ligase [Taibaiella sp.] diamond 1701 90.9 0.991199119911991 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Taibaiella Taibaiella sp.
27295193 27295193 PRJNA177642_P_NODE_18383_length_163_cov_1.052239_g17158_i0 PRJNA177642 18383 163 1.052239 1.71514957 Cloacibacterium normanense 237258 Bacteria Bacteria 113 1.71e-27   NR MFN8364792.1 237258 g17158 i0 100 1.98773006134969 54 0 99.4 0 163 2 132 185 MFN8364792.1 insulinase family protein [Cloacibacterium normanense] diamond 324 113 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium normanense
27706145 27706145 PRJNA177642_P_NODE_15284_length_191_cov_1.000000_g14059_i0 PRJNA177642 15284 191 1 1.91 Leyella stercorea 363265 Bacteria Bacteria 44.7 0.00383   NR MDD7211033.1 363265 g14059 i0 40.4 0.895287958115183 57 34 89.5 0 2 172 106 162 MDD7211033.1 hypothetical protein [Leyella stercorea] diamond 171 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Leyella Leyella stercorea
27926773 27926773 PRJNA177642_P_NODE_17745_length_165_cov_2.757353_g16520_i0 PRJNA177642 17745 165 2.757353 4.54963245 Flavobacterium sp. 239 Bacteria Bacteria 53.5 1.97e-6   NR MDK2773354.1 239 g16520 i0 57.1 0.890909090909091 49 21 89.1 0 164 18 306 354 MDK2773354.1 transposase [Flavobacterium sp.] diamond 147 53.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
29176111 29176111 PRJNA177642_P_NODE_17069_length_168_cov_3.043165_g15844_i0 PRJNA177642 17069 168 3.043165 5.1125172 Cloacibacterium 501783 Bacteria Bacteria 117 1.2399999999999998e-29   NR MEN9486694.1 1898104 g15844 i0 100 1.96428571428571 55 0 98.2 0 165 1 70 124 MEN9486694.1 hypothetical protein [Bacteroidota bacterium] diamond 330 117 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29884549 29884549 PRJNA177642_P_NODE_13791_length_234_cov_2.253659_g12566_i0 PRJNA177642 13791 234 2.253659 5.27356206 Tenacibaculum polynesiense 3137857 Bacteria Bacteria 83.2 1.92e-16   NR WP_348727290.1 3137857 g12566 i0 55.3 0.974358974358974 76 32 96.2 2 3 227 3095 3169 WP_348727290.1 gliding motility-associated C-terminal domain-containing protein [Tenacibaculum polynesiense] diamond 228 83.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Tenacibaculum Tenacibaculum polynesiense
31306185 31306185 PRJNA177642_P_NODE_10915_length_336_cov_1.612378_g9691_i0 PRJNA177642 10915 336 1.612378 5.41759008 Flavobacteriales bacterium 2021391 Bacteria Bacteria 72 9.4e-13   NR TXI78802.1 2021391 g9691 i0 87.5 1.75 32 4 28.6 0 7 102 62 93 TXI78802.1 MAG: sulfite oxidase-like oxidoreductase [Flavobacteriales bacterium] diamond 588 72 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
31306188 31306188 PRJNA177642_P_NODE_16695_length_170_cov_1.950355_g15470_i0 PRJNA177642 16695 170 1.950355 3.3156035 Hallella colorans 1703337 Bacteria Bacteria 115 6.5e-30   NR WP_116616452.1 1703337 g15470 i0 96.4 0.988235294117647 56 2 98.8 0 168 1 168 223 WP_116616452.1 50S ribosomal protein L11 methyltransferase [Hallella colorans] diamond 168 115 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Hallella Hallella colorans

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