RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1180292 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
28051316 28051316 PRJNA1180292_P_NODE_12585_length_243_cov_0.917647_g12453_i0 PRJNA1180292 12585 243 0.917647 2.22988221 Chitinispirillaceae bacterium 2813024 Bacteria Bacteria 112 2.98e-28   NR MBN2188612.1 2813024 g12453 i0 64.6 0.975308641975309 79 28 97.5 0 2 238 203 281 MBN2188612.1 ABC transporter permease [Chitinispirillaceae bacterium] diamond 237 112 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae   Chitinispirillaceae bacterium
29282543 29282543 PRJNA1180292_P_NODE_8749_length_251_cov_0.876404_g8617_i0 PRJNA1180292 8749 251 0.876404 2.19977404 Fibrobacterota bacterium 2052160 Bacteria Bacteria 80.5 2.1e-15   NR MDB5050581.1 2052160 g8617 i0 72.2 0.645418326693227 54 15 64.5 0 3 164 587 640 MDB5050581.1 hypothetical protein [Fibrobacterota bacterium] diamond 162 80.5 1 Bacteria FCB group Pseudomonadati Fibrobacterota         Fibrobacterota bacterium
29440287 29440287 PRJNA1180292_P_NODE_11110_length_246_cov_0.901734_g10978_i0 PRJNA1180292 11110 246 0.901734 2.21826564 Chitinispirillaceae bacterium 2813024 Bacteria Bacteria 94.4 2.46e-20   NR MBN1759391.1 2813024 g10978 i0 52.4 1 82 39 100 0 1 246 105 186 MBN1759391.1 NAD(P)/FAD-dependent oxidoreductase [Chitinispirillaceae bacterium] diamond 246 94.4 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae   Chitinispirillaceae bacterium
29566800 29566800 PRJNA1180292_P_NODE_11610_length_245_cov_0.906977_g11478_i0 PRJNA1180292 11610 245 0.906977 2.22209365 Chitinispirillaceae bacterium 2813024 Bacteria Bacteria 157 1.72e-44   NR MBN2035679.1 2813024 g11478 i0 86.4 0.991836734693878 81 11 99.2 0 245 3 244 324 MBN2035679.1 hypothetical protein [Chitinispirillaceae bacterium] diamond 243 157 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae   Chitinispirillaceae bacterium
30988592 30988592 PRJNA1180292_P_NODE_10614_length_247_cov_0.896552_g10482_i0 PRJNA1180292 10614 247 0.896552 2.21448344 Chitinivibrionales bacterium 2663014 Bacteria Bacteria 103 1.41e-23   NR HEX7510783.1 2663014 g10482 i0 65.3 0.874493927125506 72 25 87.4 0 224 9 3 74 HEX7510783.1 cytochrome c biogenesis protein CcdA [Chitinivibrionales bacterium] diamond 216 103 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinivibrionia Chitinivibrionales     Chitinivibrionales bacterium
31778882 31778882 PRJNA1180292_P_NODE_11317_length_246_cov_0.901734_g11185_i0 PRJNA1180292 11317 246 0.901734 2.21826564 Chitinispirillaceae bacterium 2813024 Bacteria Bacteria 57.8 1.98e-7   NR MBN2189140.1 2813024 g11185 i0 43.3 0.817073170731707 67 38 81.7 0 24 224 308 374 MBN2189140.1 DUF2341 domain-containing protein [Chitinispirillaceae bacterium] diamond 201 57.8 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae   Chitinispirillaceae 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);;