RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1122875 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
4104418 4104418 PRJNA1122875_P_NODE_10564_length_510_cov_2.466819_g10343_i0 PRJNA1122875 10564 510 2.466819 12.5807769 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 283 1.63e-71   NTclustered gi|2874254065|emb|OY970130.1| 412056 g10343 i0 76.908 78.2294117647059 511 110 99 6 1 507 1489827 1489321 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 blastn 39897 283 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16854635 16854635 PRJNA1122875_P_NODE_11894_length_482_cov_2.100244_g11671_i0 PRJNA1122875 11894 482 2.100244 10.12317608 Roseibacillus persicicus 454148 Bacteria Bacteria 52.8 0.047   NTclustered gi|2889362999|gb|CP151838.1| 454148 g11671 i0 100 0.0580912863070539 28 0 6 0 9 36 770285 770258 Roseibacillus persicicus strain AS69 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Roseibacillus Roseibacillus persicicus
23229805 23229805 PRJNA1122875_P_NODE_18179_length_391_cov_2.012579_g17955_i0 PRJNA1122875 18179 391 2.012579 7.86918389 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 538 2.3499999999999992e-148   NTclustered gi|2874254096|emb|OY970179.1| 412056 g17955 i0 92.593 171.953964194373 378 23 96 4 16 391 1728256 1728630 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 blastn 67234 538 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
24503846 24503846 PRJNA1122875_P_NODE_52760_length_242_cov_0.911243_g52536_i0 PRJNA1122875 52760 242 0.911243 2.20520806 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 52.8 0.022   NTclustered gi|2874253779|emb|OY969763.1| 412056 g52536 i0 100 0.115702479338843 28 0 12 0 112 139 3371446 3371473 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae 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);;