RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA815356 · 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
3370006 3370006 PRJNA815356_P_NODE_9623_length_248_cov_1.091429_g9460_i0 PRJNA815356 9623 248 1.091429 2.70674392 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 398 2.5e-106   NTclustered gi|2874254167|emb|OY970399.1| 171953 g9460 i0 95.582 100.229838709677 249 10 100 1 1 248 2284361 2284609 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1 blastn 24857 398 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
18670507 18670507 PRJNA815356_P_NODE_7015_length_278_cov_1.141463_g6852_i0 PRJNA815356 7015 278 1.141463 3.17326714 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 460 3.5899999999999995e-125   NTclustered gi|2874254049|emb|OY970373.1| 171953 g6852 i0 96.751 93.2985611510791 277 8 99 1 1 276 4652980 4652704 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 25937 460 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19945756 19945756 PRJNA815356_P_NODE_9756_length_247_cov_1.275862_g9593_i0 PRJNA815356 9756 247 1.275862 3.15137914 Paludibaculum fermentans 1473598 Bacteria Bacteria 394 3.22e-105   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g9593 i0 98.222 442.465587044534 225 4 91 0 1 225 4785647 4785871 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 109289 394 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
25045483 25045483 PRJNA815356_P_NODE_8460_length_257_cov_1.532609_g8297_i0 PRJNA815356 8460 257 1.532609 3.93880513 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 370 5.68e-98   NTclustered gi|31789464|gb|AY281356.1| 171953 g8297 i0 92.636 163.455252918288 258 17 100 2 1 257 12141 11885 Uncultured Acidobacteria bacterium clone 41b15 genomic sequence blastn 42008 370 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);;