RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA613025 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_kingdom 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
13345737 13345737 PRJNA613025_S_NODE_17251_length_247_cov_2.166667_g17097_i0 PRJNA613025 17251 247 2.166667 5.35166749 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 98.2 2e-24   NR HRN86953.1 2099670 g17097 i0 72.2 0.959514170040486 79 21 96 1 237 1 20 97 HRN86953.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 237 98.2 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
26731715 26731715 PRJNA613025_S_NODE_14921_length_280_cov_2.493506_g14767_i0 PRJNA613025 14921 280 2.493506 6.9818168 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 123 1.68e-34   NR HRN86952.1 2099670 g14767 i0 73.5 0.889285714285714 83 22 88.9 0 278 30 1 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 249 123 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
27314729 27314729 PRJNA613025_S_NODE_24303_length_192_cov_1.426573_g24149_i0 PRJNA613025 24303 192 1.426573 2.73902016 Pseudomonadati 3379134 Bacteria Bacteria 86.7 3.19e-19   NR OPZ66528.1 1852830 g24149 i0 69.5 3.765625 59 18 92.2 0 177 1 122 180 OPZ66528.1 MAG: DNA polymerase III subunit epsilon [Candidatus Aerophobetes bacterium ADurb.Bin490] diamond 723 86.7 1 Bacteria Bacteria candidate phyla   Candidatus Aerophobota         Candidatus Aerophobetes bacterium ADurb.Bin490
31597524 31597524 PRJNA613025_S_NODE_24556_length_191_cov_1.063380_g24402_i0 PRJNA613025 24556 191 1.06338 2.0310558 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 43.9 0.00292   NR MFM2357808.1 2762014 g24402 i0 38.3 0.738219895287958 47 29 73.8 0 34 174 4 50 MFM2357808.1 hypothetical protein [Candidatus Parcubacteria bacterium] diamond 141 43.9 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria 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);;