RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJDB4470 · 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
7359132 7359132 PRJDB4470_P_NODE_85866_length_189_cov_1.178571_g84711_i0 PRJDB4470 85866 189 1.178571 2.22749919 Candidatus Nanosynbacter 2093823 Bacteria Bacteria 222 1.17e-53   NTclustered gi|1842054184|gb|CP039999.1| 713059 g84711 i0 90.964 138.724867724868 166 13 87 2 4 168 142368 142204 Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome blastn 26219 222 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
7662190 7662190 PRJDB4470_P_NODE_83787_length_192_cov_1.517483_g82632_i0 PRJDB4470 83787 192 1.517483 2.91356736 uncultured Candidatus Saccharibacteria bacterium 179883 Bacteria Bacteria 316 5.31e-82   NTclustered gi|2874254068|emb|OY970151.1| 179883 g82632 i0 96.354 270.348958333333 192 7 100 0 1 192 658750 658941 MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1 blastn 51907 316 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         uncultured Candidatus Saccharibacteria bacterium
10212018 10212018 PRJDB4470_P_NODE_123329_length_162_cov_0.902655_g122174_i0 PRJDB4470 123329 162 0.902655 1.4623011 Candidatus Nanosynbacter sp. HMT-348_TM7c-JB 2933970 Bacteria Bacteria 300 4.36e-77   NTclustered gi|2179907571|gb|CP090820.1| 2933970 g122174 i0 100 1 162 0 100 0 1 162 114622 114461 MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome blastn 162 300 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Nanosynbacterales Candidatus Nanosynbacteraceae Candidatus Nanosynbacter Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14037568 14037568 PRJDB4470_P_NODE_45612_length_312_cov_1.083650_g44459_i0 PRJDB4470 45612 312 1.08365 3.380988 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 281 3.42e-71   NTclustered gi|2575803556|emb|OY729432.1| 2838779 g44459 i0 83.333 152.685897435897 318 40 100 11 1 312 2239197 2239507 MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1 blastn 47638 281 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
16586411 16586411 PRJDB4470_P_NODE_47434_length_302_cov_1.644269_g46281_i0 PRJDB4470 47434 302 1.644269 4.96569238 Candidatus Peregrinibacteria bacterium 2030811 Bacteria Bacteria 52.8 0.028   NTclustered gi|1958112918|gb|CP065009.1| 2030811 g46281 i0 100 0.0927152317880795 28 0 9 0 125 152 628714 628741 MAG: Candidatus Peregrinibacteria bacterium isolate Lyne_18-Q3-R50-59_MAXAC.411_cln chromosome, complete genome blastn 28 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota         Candidatus Peregrinibacteria 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);;