RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1193541" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1193541 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27420286 27420286 PRJNA1193541_P_NODE_10763_length_269_cov_1.515306_g10625_i0 PRJNA1193541 10763 269 1.515306 4.07617314 Elizabethkingia anophelis 1117645 Bacteria Bacteria 60.5 2.69e-9   NR MCT4327038.1 1117645 g10625 i0 51.8 2.28624535315985 56 25 61.3 2 1 165 63 117 MCT4327038.1 hypothetical protein [Elizabethkingia anophelis] diamond 615 60.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Elizabethkingia Elizabethkingia anophelis
28304071 28304071 PRJNA1193541_P_NODE_13546_length_246_cov_0.890173_g13408_i0 PRJNA1193541 13546 246 0.890173 2.18982558 Chitinophagia bacterium 2448778 Bacteria Bacteria 70.5 4.82e-12   NR NCW13641.1 2448778 g13408 i0 44.6 0.792682926829268 65 36 79.3 0 3 197 138 202 NCW13641.1 hypothetical protein [Chitinophagia bacterium] diamond 195 70.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia       Chitinophagia bacterium
28588439 28588439 PRJNA1193541_P_NODE_12787_length_249_cov_0.875000_g12649_i0 PRJNA1193541 12787 249 0.875 2.17875 Sphingobacteriales bacterium 2044944 Bacteria Bacteria 181 5.75e-51   NR MBN8853668.1 2044944 g12649 i0 100 2 83 0 100 0 1 249 521 603 MBN8853668.1 M1 family peptidase [Sphingobacteriales bacterium] diamond 498 181 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales     Sphingobacteriales bacterium
29409126 29409126 PRJNA1193541_P_NODE_11049_length_265_cov_1.572917_g10911_i0 PRJNA1193541 11049 265 1.572917 4.16823005 Aureitalea sp. L 1872661 Bacteria Bacteria 45.4 0.00535   NR WP_265198814.1 2816962 g10911 i0 40.4 0.588679245283019 52 31 58.9 0 176 21 252 303 WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47] diamond 156 45.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Aureitalea Aureitalea sp. L0-47
30009366 30009366 PRJNA1193541_P_NODE_15091_length_241_cov_0.916667_g14953_i0 PRJNA1193541 15091 241 0.916667 2.20916747 Spirosoma foliorum 2710596 Bacteria Bacteria 45.8 0.00297   NR WP_182459608.1 2710596 g14953 i0 40 0.684647302904564 55 32 67.2 1 80 241 10 64 WP_182459608.1 hypothetical protein [Spirosoma foliorum] diamond 165 45.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Spirosoma Spirosoma foliorum
30293922 30293922 PRJNA1193541_P_NODE_13052_length_248_cov_0.880000_g12914_i0 PRJNA1193541 13052 248 0.88 2.1824 Chryseolinea sp. 2059303 Bacteria Bacteria 159 3.13e-44   NR HTF18095.1 2059303 g12914 i0 92.7 1.98387096774194 82 6 99.2 0 2 247 62 143 HTF18095.1 DNA repair protein RecN [Chryseolinea sp.] diamond 492 159 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Fulvivirgaceae Chryseolinea Chryseolinea sp.
31842237 31842237 PRJNA1193541_P_NODE_11117_length_264_cov_1.612565_g10979_i0 PRJNA1193541 11117 264 1.612565 4.2571716 Flavobacteriales bacterium 2021391 Bacteria Bacteria 170 3.56e-49   NR MBT3611732.1 2021391 g10979 i0 93 0.977272727272727 86 6 97.7 0 262 5 112 197 MBT3611732.1 hypothetical protein [Flavobacteriales bacterium] diamond 258 170 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales 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);;