RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB2925", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_clade 1

  • Bacteria candidate phyla · 3 ✖

bioproject 1

  • PRJEB2925 · 3 ✖

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
3852245 3852245 PRJEB2925_P_NODE_16744_length_235_cov_2.065000_g15466_i0 PRJEB2925 16744 235 2.065 4.85275 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 78.7 3.47e-10   NTclustered gi|2874253936|emb|OY970261.1| 2052149 g15466 i0 85.333 2.58723404255319 75 11 32 0 1 75 3246564 3246638 MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.29 genome assembly, chromosome: 1 blastn 608 78.7 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes bacterium
31898145 31898145 PRJEB2925_P_NODE_8297_length_428_cov_5.310433_g7063_i0 PRJEB2925 8297 428 5.310433 22.72865324 Candidatus Peribacteraceae bacterium 2735830 Bacteria Bacteria 46.2 0.0147   NR MDD3896750.1 2735830 g7063 i0 35.5 0.434579439252336 62 40 43.5 0 423 238 414 475 MDD3896750.1 ATP-binding protein [Candidatus Peribacteraceae bacterium] diamond 186 46.2 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria Candidatus Peribacterales     Candidatus Peribacteraceae bacterium
32151333 32151333 PRJEB2925_P_NODE_14898_length_263_cov_1.008772_g13620_i0 PRJEB2925 14898 263 1.008772 2.65307036 Candidatus Kaiserbacteria bacterium 2030810 Bacteria Bacteria 134 4.9099999999999995e-37   NR MDB5237788.1 2030810 g13620 i0 75 0.958174904942966 84 21 95.8 0 12 263 34 117 MDB5237788.1 Protein-disulfide isomerase [Candidatus Kaiserbacteria bacterium] diamond 252 134 1 Bacteria Bacteria candidate phyla   Candidatus Kaiseribacteriota         Candidatus Kaiserbacteria 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);;