RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA454503 · 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
26664329 26664329 PRJNA454503_P_NODE_72541_length_206_cov_0.896552_g72212_i0 PRJNA454503 72541 206 0.896552 1.84689712 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 58.2 6.31e-9   NR MCC6977383.1 2052166 g72212 i0 66.1 0.815533980582524 56 18 80.1 1 166 2 1 56 MCC6977383.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 168 58.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
26696185 26696185 PRJNA454503_P_NODE_54821_length_211_cov_0.866667_g54492_i0 PRJNA454503 54821 211 0.866667 1.82866737 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 65.1 2.9e-10   NR HNB23727.1 2052166 g54492 i0 67.3 0.696682464454976 49 16 69.7 0 62 208 7 55 HNB23727.1 serine/threonine-protein kinase [Candidatus Melainabacteria bacterium] diamond 147 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
27834163 27834163 PRJNA454503_P_NODE_63244_length_208_cov_2.353741_g62915_i0 PRJNA454503 63244 208 2.353741 4.89578128 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 136 2.24e-35   NR PZM77956.1 2052166 g62915 i0 97.1 0.995192307692308 69 2 99.5 0 207 1 4000 4068 PZM77956.1 MAG: hypothetical protein DKT66_27160 [Candidatus Melainabacteria bacterium] diamond 207 136 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
28623793 28623793 PRJNA454503_P_NODE_47107_length_218_cov_2.923567_g46778_i0 PRJNA454503 47107 218 2.923567 6.37337606 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 143 5.299999999999999e-38   NR PZM81424.1 2052166 g46778 i0 95.8 0.990825688073395 72 3 99.1 0 216 1 195 266 PZM81424.1 MAG: hypothetical protein DKT66_19630 [Candidatus Melainabacteria bacterium] diamond 216 143 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
31972719 31972719 PRJNA454503_P_NODE_32678_length_236_cov_1.291429_g32349_i0 PRJNA454503 32678 236 1.291429 3.04777244 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 140 1.23e-37   NR PZM82883.1 2052166 g32349 i0 92.3 0.991525423728814 78 6 99.2 0 235 2 255 332 PZM82883.1 MAG: hypothetical protein DKT66_12915 [Candidatus Melainabacteria bacterium] diamond 234 140 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
32067553 32067553 PRJNA454503_P_NODE_39078_length_228_cov_1.329341_g38749_i0 PRJNA454503 39078 228 1.329341 3.03089748 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 78.2 9.7e-15   NR MBC7999982.1 2052166 g38749 i0 85.7 1.13157894736842 42 6 55.3 0 102 227 438 479 MBC7999982.1 PAS domain S-box protein [Candidatus Melainabacteria bacterium] diamond 258 78.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
32067558 32067558 PRJNA454503_P_NODE_85798_length_202_cov_0.921986_g85469_i0 PRJNA454503 85798 202 0.921986 1.86241172 Candidatus Gastranaerophilales bacterium HUM_9 1916320 Bacteria Bacteria 124 1.47e-31   NR DAA96876.1 1916320 g85469 i0 89.6 0.995049504950495 67 7 99.5 0 2 202 103 169 DAA96876.1 MAG TPA: hypothetical protein CPT80_03445 [Candidatus Gastranaerophilales bacterium HUM_9] diamond 201 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium HUM_9

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