RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA454503 · 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
1717212 1717212 PRJNA454503_P_NODE_35382_length_232_cov_1.941520_g35053_i0 PRJNA454503 35382 232 1.94152 4.5043264 Candidatus Saccharibacteria bacterium oral taxon 488 713059 Bacteria Bacteria 418 1.7799999999999995e-112   NTclustered gi|1842065531|gb|CP040002.1| 713059 g35053 i0 99.138 12.9913793103448 232 2 100 0 1 232 212126 211895 Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome blastn 3014 418 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
9370125 9370125 PRJNA454503_P_NODE_30348_length_239_cov_1.325843_g30019_i0 PRJNA454503 30348 239 1.325843 3.16876477 Candidatus Nanosynbacter sp. HMT-352 2899133 Bacteria Bacteria 425 1.1e-114   NTclustered gi|2166692445|gb|CP089520.1| 2899133 g30019 i0 98.745 46.9037656903766 239 3 100 0 1 239 305136 305374 Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome blastn 11210 425 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Nanosynbacterales Candidatus Nanosynbacteraceae Candidatus Nanosynbacter Candidatus Nanosynbacter sp. HMT-352
11921730 11921730 PRJNA454503_P_NODE_88050_length_196_cov_2.518519_g87721_i0 PRJNA454503 88050 196 2.518519 4.93629724 Candidatus Nanosynbacter sp. HMT-352 2899133 Bacteria Bacteria 329 6.99e-86   NTclustered gi|2166692445|gb|CP089520.1| 2899133 g87721 i0 96.939 1.35714285714286 196 6 100 0 1 196 644109 643914 Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome blastn 266 329 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Nanosynbacterales Candidatus Nanosynbacteraceae Candidatus Nanosynbacter Candidatus Nanosynbacter sp. HMT-352
19568106 19568106 PRJNA454503_P_NODE_31676_length_237_cov_1.477273_g31347_i0 PRJNA454503 31676 237 1.477273 3.50113701 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 206 1.5399999999999998e-48   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g31347 i0 82.278 1 237 42 100 0 1 237 369581 369817 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 237 206 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
19568748 19568748 PRJNA454503_P_NODE_87756_length_197_cov_2.683824_g87427_i0 PRJNA454503 87756 197 2.683824 5.28713328 Candidatus Minimicrobia sp. QA0096 3118470 Bacteria Bacteria 320 4.24e-83   NTclustered gi|2686255593|emb|OZ017288.1| 3118470 g87427 i0 95.939 10.0812182741117 197 8 100 0 1 197 201075 200879 Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001 blastn 1986 320 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota       Candidatus Minimicrobia Candidatus Minimicrobia sp. QA0096

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