RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax_phylum = "Candidatus Peregrinibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Peregrinibacteriota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA293022 · 4 ✖

analysis 1

  • blastn · 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
6750889 6750889 PRJNA293022_P_NODE_23466_length_292_cov_3.469136_g22729_i0 PRJNA293022 23466 292 3.469136 10.12987712 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 248 3.22e-61   NTclustered gi|2258833497|gb|CP060226.1| 2053688 g22729 i0 86.344 41.9178082191781 227 31 78 0 25 251 813885 813659 MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome blastn 12240 248 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
9301485 9301485 PRJNA293022_P_NODE_6888_length_543_cov_3.076923_g6178_i0 PRJNA293022 6888 543 3.076923 16.70769189 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 200 1.8e-46   NTclustered gi|2258832001|gb|CP060225.1| 2053688 g6178 i0 74.506 37.2265193370166 557 97 99 36 4 541 628565 628035 MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome blastn 20214 200 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
16950555 16950555 PRJNA293022_P_NODE_12514_length_404_cov_1.985915_g11777_i0 PRJNA293022 12514 404 1.985915 8.0230966 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 237 9.97e-58   NTclustered gi|2258833497|gb|CP060226.1| 2053688 g11777 i0 83.658 63.1163366336634 257 37 63 4 1 254 813237 813491 MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome blastn 25499 237 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
23325466 23325466 PRJNA293022_P_NODE_72219_length_166_cov_0.888889_g71482_i0 PRJNA293022 72219 166 0.888889 1.47555574 Candidatus Peribacter riflensis 1735162 Bacteria Bacteria 69.4 1.38e-7   NTclustered gi|946529367|gb|CP013062.1| 1735162 g71482 i0 82.143 2.53012048192771 84 11 49 4 15 96 1195085 1195004 MAG: Candidatus Peribacter riflensis, complete genome blastn 420 69.4 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria Candidatus Peribacterales   Candidatus Peribacter Candidatus Peribacter riflensis

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