RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA415856 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_clade 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
419133 419133 PRJNA415856_P_NODE_10901_length_267_cov_2.798165_g10640_i0 PRJNA415856 10901 267 2.798165 7.47110055 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 399 7.569999999999998e-107   NTclustered gi|112980852|gb|DQ829656.1| 171953 g10640 i0 94.275 97.8838951310861 262 13 98 2 4 265 567 826 Uncultured Acidobacteria bacterium clone DON25 23S ribosomal RNA gene, partial sequence blastn 26135 399 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
4246413 4246413 PRJNA415856_P_NODE_37684_length_166_cov_0.940171_g37423_i0 PRJNA415856 37684 166 0.940171 1.56068386 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 239 9.94e-59   NTclustered gi|2874253931|emb|OY970256.1| 2283092 g37423 i0 92.771 275.963855421687 166 11 99 1 1 165 359907 360072 MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1 blastn 45810 239 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
10623097 10623097 PRJNA415856_P_NODE_20289_length_194_cov_1.772414_g20028_i0 PRJNA415856 20289 194 1.772414 3.43848316 Edaphobacter sp. 12200R-103 2703788 Bacteria Bacteria 337 4.13e-88   NTclustered gi|1804497213|gb|CP048114.1| 2703788 g20028 i0 97.938 41.819587628866 194 4 100 0 1 194 2670872 2671065 Edaphobacter sp. 12200R-103 chromosome, complete genome blastn 8113 337 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp. 12200R-103
16996585 16996585 PRJNA415856_P_NODE_11474_length_259_cov_2.576190_g11213_i0 PRJNA415856 11474 259 2.57619 6.6723321 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 320 5.86e-83   NTclustered gi|112980870|gb|DQ829674.1| 171953 g11213 i0 89.535 413.324324324324 258 19 99 6 1 256 312 61 Uncultured Acidobacteria bacterium clone DON24 23S ribosomal RNA gene, partial sequence blastn 107051 320 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;