RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA415856" 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 · 5 ✖

bioproject 1

  • PRJNA415856 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2970124 2970124 PRJNA415856_P_NODE_45003_length_164_cov_0.886957_g44742_i0 PRJNA415856 45003 164 0.886957 1.45460948 Candidatus Nanosynbacter sp. BB002 3393757 Bacteria Bacteria 303 3.42e-78   NTclustered gi|2692798772|gb|CP146064.1| 3393757 g44742 i0 100 2 164 0 100 0 1 164 197879 197716 Candidatus Nanosynbacter sp. BB002 chromosome, complete genome blastn 328 303 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Nanosynbacterales Candidatus Nanosynbacteraceae Candidatus Nanosynbacter Candidatus Nanosynbacter sp. BB002
9347350 9347350 PRJNA415856_P_NODE_20888_length_192_cov_1.069930_g20627_i0 PRJNA415856 20888 192 1.06993 2.0542656 Candidatus Nanogingivalaceae bacterium 2725942 Bacteria Bacteria 340 3.15e-89   NTclustered gi|2070571752|gb|CP072208.2| 2725942 g20627 i0 98.947 52.8177083333333 190 2 99 0 3 192 111642 111453 MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome blastn 10141 340 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Nanosyncoccalia Candidatus Nanogingivales Candidatus Nanogingivalaceae   Candidatus Nanogingivalaceae bacterium
18270937 18270937 PRJNA415856_P_NODE_33335_length_169_cov_1.641667_g33074_i0 PRJNA415856 33335 169 1.641667 2.77441723 Candidatus Saccharibacteria bacterium oral taxon 488 713059 Bacteria Bacteria 267 4.63e-67   NTclustered gi|1805660319|gb|CP047920.1| 713059 g33074 i0 96.296 19.491124260355 162 6 96 0 1 162 689702 689863 Candidatus Saccharibacteria bacterium oral taxon 488 strain FS07P chromosome, complete genome blastn 3294 267 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
21485246 21485246 PRJNA415856_P_NODE_42617_length_164_cov_1.773913_g42356_i0 PRJNA415856 42617 164 1.773913 2.90921732 Candidatus Saccharimonas 1331051 Bacteria Bacteria 272 9.65e-69   NTclustered gi|499052612|gb|CP005957.1| 1332188 g42356 i0 96.933 58.8048780487805 163 3 99 2 1 162 697274 697435 Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome blastn 9644 272 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales Candidatus Saccharimonadaceae Candidatus Saccharimonas Candidatus Saccharimonas aalborgensis
25309734 25309734 PRJNA415856_P_NODE_55260_length_152_cov_2.106796_g54999_i0 PRJNA415856 55260 152 2.106796 3.20232992 Bacteria 2 Bacteria Bacteria 209 6.97e-50   NTclustered gi|563351663|gb|CP006913.1| 1394709 g54999 i0 91.447 118.394736842105 152 13 100 0 1 152 126776 126927 Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome blastn 17996 209 1 Bacteria Bacteria candidate phyla   Candidatus Absconditibacteriota         candidate division SR1 bacterium RAAC1_SR1_1

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