RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA812715 · 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
811871 811871 PRJNA812715_P_NODE_107421_length_248_cov_0.880000_g105620_i0 PRJNA812715 107421 248 0.88 2.1824 Fontisphaera persica 2974023 Bacteria Bacteria 115 2.82e-21   NTclustered gi|2439237958|gb|CP116615.1| 2974023 g105620 i0 98.462 23.7258064516129 65 1 26 0 184 248 1847312 1847376 Fontisphaera persica strain B-154 chromosome, complete genome blastn 5884 115 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Fontisphaeraceae Fontisphaera Fontisphaera persica
4642448 4642448 PRJNA812715_P_NODE_62484_length_330_cov_0.898833_g60685_i0 PRJNA812715 62484 330 0.898833 2.9661489 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 418 2.66e-112   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g60685 i0 89.634 82.0666666666667 328 34 99 0 2 329 3573445 3573118 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 27082 418 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
7190832 7190832 PRJNA812715_P_NODE_22186_length_702_cov_1.944356_g20516_i0 PRJNA812715 22186 702 1.944356 13.64937912 Candidatus Xiphinematobacter sp. 1903058 Bacteria Bacteria 545 2.64e-150   NTclustered gi|1966850802|gb|CP068472.1| 1903058 g20516 i0 93.048 0.871794871794872 374 24 53 2 271 643 244070 244442 MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome blastn 612 545 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria     Candidatus Xiphinematobacter Candidatus Xiphinematobacter sp.
9742668 9742668 PRJNA812715_P_NODE_84408_length_277_cov_1.995098_g82608_i0 PRJNA812715 84408 277 1.995098 5.52642146 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 486 5.9e-133   NTclustered gi|2874254019|emb|OY970344.1| 412056 g82608 i0 98.545 143.942238267148 275 4 99 0 3 277 737014 737288 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 39872 486 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);;