RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1022139", tax_clade = "FCB group" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA1022139 · 4 ✖

analysis 1

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
26591466 26591466 PRJNA1022139_P_NODE_20941_length_306_cov_1.326180_g20836_i0 PRJNA1022139 20941 306 1.32618 4.0581108 Balneolaceae bacterium 2053516 Bacteria Bacteria 43.9 0.00958   NR MFA5670265.1 2053516 g20836 i0 36.4 0.647058823529412 66 42 64.7 0 2 199 61 126 MFA5670265.1 hypothetical protein [Balneolaceae bacterium] diamond 198 43.9 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
29403420 29403420 PRJNA1022139_P_NODE_39229_length_245_cov_1.645349_g39124_i0 PRJNA1022139 39229 245 1.645349 4.03110505 Balneolales bacterium 2497613 Bacteria Bacteria 47.8 3.18e-4   NR MCH8495708.1 2497613 g39124 i0 52.8 1.32244897959184 36 17 44.1 0 76 183 26 61 MCH8495708.1 cyclic nucleotide-binding domain-containing protein [Balneolales bacterium] diamond 324 47.8 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales     Balneolales bacterium
30540487 30540487 PRJNA1022139_P_NODE_42193_length_242_cov_0.911243_g42088_i0 PRJNA1022139 42193 242 0.911243 2.20520806 Balneolaceae bacterium 2053516 Bacteria Bacteria 72.4 4.27e-14   NR HKL15208.1 2053516 g42088 i0 64.6 0.59504132231405 48 17 59.5 0 97 240 5 52 HKL15208.1 hypothetical protein [Balneolaceae bacterium] diamond 144 72.4 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
31290906 31290906 PRJNA1022139_P_NODE_34315_length_251_cov_0.865169_g34210_i0 PRJNA1022139 34315 251 0.865169 2.17157419 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00623   NR WP_165779107.1 2053187 g34210 i0 70.8 1.1593625498008 24 7 28.7 0 10 81 283 306 WP_165779107.1 BspA family leucine-rich repeat surface protein [Rhodohalobacter barkolensis] diamond 291 45.1 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Rhodohalobacter Rhodohalobacter barkolensis

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