RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA781196 · 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
8412435 8412435 PRJNA781196_P_NODE_39507_length_284_cov_2.293839_g39130_i0 PRJNA781196 39507 284 2.293839 6.51450276 Paludibaculum fermentans 1473598 Bacteria Bacteria 385 2.28e-102   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g39130 i0 91.786 125.031690140845 280 18 99 3 5 284 4784596 4784870 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 35509 385 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
17337478 17337478 PRJNA781196_P_NODE_34454_length_302_cov_1.021834_g34077_i0 PRJNA781196 34454 302 1.021834 3.08593868 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 525 1.3799999999999995e-144   NTclustered gi|2874253744|emb|OY969603.1| 171953 g34077 i0 98.013 101.215231788079 302 6 100 0 1 302 5803291 5803592 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1 blastn 30567 525 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
17789065 17789065 PRJNA781196_P_NODE_67134_length_242_cov_0.923077_g66757_i0 PRJNA781196 67134 242 0.923077 2.23384634 Bryobacterales 332160 Bacteria Bacteria 259 1.2e-64   NTclustered gi|470468228|ref|NR_076103.1| 332163 g66757 i0 86.066 33.2561983471074 244 30 100 4 1 242 1416 1657 Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence blastn 8048 259 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Solibacteraceae Candidatus Solibacter Candidatus Solibacter usitatus
24986128 24986128 PRJNA781196_P_NODE_59880_length_246_cov_2.699422_g59503_i0 PRJNA781196 59880 246 2.699422 6.64057812 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 364 2.509999999999999e-96   NTclustered gi|2621707050|emb|OY764903.1| 2212468 g59503 i0 93.496 102.451219512195 246 15 100 1 1 246 3558653 3558409 MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 blastn 25203 364 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae 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);;