RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_phylum = "Candidatus Daviesiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Daviesiibacteriota · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB2368 · 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
27949198 27949198 PRJEB2368_P_NODE_9825_length_287_cov_1.352000_g9507_i0 PRJEB2368 9825 287 1.352 3.88024 Candidatus Daviesbacteria bacterium 2053542 Bacteria Bacteria 45.8 0.00155   NR MBI2196827.1 2053542 g9507 i0 34.7 1.05574912891986 101 60 99.3 2 3 287 19 119 MBI2196827.1 four helix bundle protein [Candidatus Daviesbacteria bacterium] diamond 303 45.8 1 Bacteria Bacteria candidate phyla   Candidatus Daviesiibacteriota         Candidatus Daviesbacteria bacterium
28359512 28359512 PRJEB2368_P_NODE_8346_length_287_cov_1.652000_g8028_i0 PRJEB2368 8346 287 1.652 4.74124 Candidatus Daviesbacteria bacterium 2053542 Bacteria Bacteria 45.1 0.0098   NR MBI2314665.1 2053542 g8028 i0 80 0.78397212543554 25 5 26.1 0 3 77 249 273 MBI2314665.1 UDP-N-acetylmuramate--L-alanine ligase [Candidatus Daviesbacteria bacterium] diamond 225 45.1 1 Bacteria Bacteria candidate phyla   Candidatus Daviesiibacteriota         Candidatus Daviesbacteria bacterium
28391212 28391212 PRJEB2368_P_NODE_9406_length_287_cov_1.412000_g9088_i0 PRJEB2368 9406 287 1.412 4.05244 Candidatus Daviesbacteria bacterium 2053542 Bacteria Bacteria 46.2 0.00211   NR MDP3733586.1 2053542 g9088 i0 82.6 0.240418118466899 23 4 24 0 212 280 125 147 MDP3733586.1 alpha/beta hydrolase [Candidatus Daviesbacteria bacterium] diamond 69 46.2 1 Bacteria Bacteria candidate phyla   Candidatus Daviesiibacteriota         Candidatus Daviesbacteria bacterium
31012629 31012629 PRJEB2368_P_NODE_10595_length_287_cov_1.096000_g10277_i0 PRJEB2368 10595 287 1.096 3.14552 Candidatus Daviesbacteria bacterium 2053542 Bacteria Bacteria 48.5 4.97e-4   NR MBI3485962.1 2053542 g10277 i0 83.3 0.250871080139373 24 4 25.1 0 214 285 31 54 MBI3485962.1 MerR family transcriptional regulator [Candidatus Daviesbacteria bacterium] diamond 72 48.5 1 Bacteria Bacteria candidate phyla   Candidatus Daviesiibacteriota         Candidatus Daviesbacteria 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);;