RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA929924" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA929924 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
2184252 2184252 PRJNA929924_P_NODE_17782_length_163_cov_0.912281_g17619_i0 PRJNA929924 17782 163 0.912281 1.48701803 Acidobacteriota bacterium 1978231 Bacteria Bacteria 252 1.25e-62   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g17619 i0 94.479 84.0122699386503 163 9 100 0 1 163 4652312 4652150 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 13694 252 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
3459805 3459805 PRJNA929924_P_NODE_17683_length_163_cov_0.912281_g17520_i0 PRJNA929924 17683 163 0.912281 1.48701803 Paludibaculum fermentans 1473598 Bacteria Bacteria 296 5.68e-76   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g17520 i0 99.387 181.59509202454 163 1 100 0 1 163 4787232 4787394 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 29600 296 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
3459938 3459938 PRJNA929924_P_NODE_9683_length_254_cov_5.336585_g9520_i0 PRJNA929924 9683 254 5.336585 13.5549259 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 364 2.6099999999999993e-96   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g9520 i0 92.549 179.700787401575 255 17 100 2 1 254 636140 635887 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 45644 364 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183
4737236 4737236 PRJNA929924_P_NODE_13844_length_181_cov_1.181818_g13681_i0 PRJNA929924 13844 181 1.181818 2.13909058 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 215 1.85e-51   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g13681 i0 94.286 0.773480662983425 140 8 77 0 38 177 638512 638651 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 140 215 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183
12388057 12388057 PRJNA929924_P_NODE_17050_length_164_cov_1.765217_g16887_i0 PRJNA929924 17050 164 1.765217 2.89495588 Acidobacteria bacterium Mor1 1660251 Bacteria Bacteria 204 3.5699999999999997e-48   NTclustered gi|1037405666|gb|CP011806.1| 1660251 g16887 i0 89.091 56.4817073170732 165 16 100 2 1 164 1850470 1850307 Acidobacteria bacterium Mor1 chromosome blastn 9263 204 1 Bacteria Acidobacteriota subdivision 22 Pseudomonadati Acidobacteriota         Acidobacteria bacterium Mor1
14936855 14936855 PRJNA929924_P_NODE_17952_length_162_cov_1.831858_g17789_i0 PRJNA929924 17952 162 1.831858 2.96760996 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 169 1.28e-37   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g17789 i0 86.538 1.5679012345679 156 17 95 4 1 154 6082288 6082135 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 254 169 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183

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);;