RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA884104 · 3 ✖

analysis 1

  • blastn · 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
2137043 2137043 PRJNA884104_S_NODE_82722_length_243_cov_0.905882_g81979_i0 PRJNA884104 82722 243 0.905882 2.20129326 Candidatus Nanosynbacter sp. HMT-348_TM7c-JB 2933970 Bacteria Bacteria 444 3.09e-120   NTclustered gi|2179907571|gb|CP090820.1| 2933970 g81979 i0 99.588 1 243 1 100 0 1 243 681487 681245 MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome blastn 243 444 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Nanosynbacterales Candidatus Nanosynbacteraceae Candidatus Nanosynbacter Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
5963749 5963749 PRJNA884104_S_NODE_27005_length_391_cov_1.534591_g26262_i0 PRJNA884104 27005 391 1.534591 6.00025081 Candidatus Poribacteria bacterium 2026781 Bacteria Bacteria 75 7.98e-9   NTclustered gi|2893358452|emb|OZ220744.1| 2026781 g26262 i0 90.909 0.140664961636829 55 5 14 0 95 149 6194080 6194134 MAG: Candidatus Poribacteria bacterium isolate 67f587a8-c379-43ee-8694-439c00dbce40 genome assembly, chromosome: 1 blastn 55 75 1 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria bacterium
22538261 22538261 PRJNA884104_S_NODE_76918_length_246_cov_1.236994_g76175_i0 PRJNA884104 76918 246 1.236994 3.04300524 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 124 4.64e-24   NTclustered gi|2621702180|emb|OY760177.1| 2044595 g76175 i0 86.087 5.34552845528455 115 16 47 0 122 236 1581428 1581314 MAG: Candidatus Gracilibacteria bacterium isolate ba77f91b-d06a-446b-8ae6-f296fa1be4ef genome assembly, chromosome: 1 blastn 1315 124 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota 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);;