RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA700095" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA700095 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1959149 1959149 PRJNA700095_P_NODE_25882_length_337_cov_2.159091_g24618_i0 PRJNA700095 25882 337 2.159091 7.27613667 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 154 8.47e-33   NTclustered gi|76574292|gb|DQ139440.1| 171953 g24618 i0 76.689 135.237388724036 296 58 86 11 47 337 304 15 Uncultured Acidobacteria bacterium clone CAL7 23S ribosomal RNA gene, partial sequence blastn 45575 154 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
3234335 3234335 PRJNA700095_P_NODE_69123_length_227_cov_2.532468_g67858_i0 PRJNA700095 69123 227 2.532468 5.74870236 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 398 2.25e-106   NTclustered gi|112980866|gb|DQ829670.1| 171953 g67858 i0 98.238 100.969162995595 227 4 100 0 1 227 549 323 Uncultured Acidobacteria bacterium clone DON12 23S ribosomal RNA gene, partial sequence blastn 22920 398 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
4511263 4511263 PRJNA700095_P_NODE_43724_length_266_cov_4.720207_g42460_i0 PRJNA700095 43724 266 4.720207 12.55575062 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 291 4.74e-74   NTclustered gi|2621707050|emb|OY764903.1| 2212468 g42460 i0 86.415 170.214285714286 265 36 99 0 2 266 3559018 3559282 MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 blastn 45277 291 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
8336453 8336453 PRJNA700095_P_NODE_51207_length_251_cov_1.370787_g49943_i0 PRJNA700095 51207 251 1.370787 3.44067537 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 433 6.95e-117   NTclustered gi|389545423|gb|JQ400351.1| 171953 g49943 i0 98.374 98.2350597609562 246 4 98 0 3 248 212 457 Uncultured Acidobacteria bacterium clone CNY_00167 16S ribosomal RNA gene, partial sequence blastn 24657 433 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14712209 14712209 PRJNA700095_P_NODE_40352_length_275_cov_1.366337_g39088_i0 PRJNA700095 40352 275 1.366337 3.75742675 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 412 1.0099999999999997e-110   NTclustered gi|341941922|gb|JN225540.1| 171953 g39088 i0 93.818 100.887272727273 275 16 100 1 1 275 315 588 Uncultured Acidobacteria bacterium clone GSY-XJ5 16S ribosomal RNA gene, partial sequence blastn 27744 412 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);;