RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA881257" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA881257 · 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
6344636 6344636 PRJNA881257_P_NODE_6785_length_278_cov_0.951965_g6540_i0 PRJNA881257 6785 278 0.951965 2.6464627 Opitutaceae 134623 Bacteria Bacteria 303 6.4e-78   NTclustered gi|470483113|ref|NR_076574.1| 107709 g6540 i0 87.984 215.046762589928 258 29 92 2 9 265 631 375 Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence blastn 59783 303 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
8511510 8511510 PRJNA881257_P_NODE_16227_length_165_cov_1.568966_g15982_i0 PRJNA881257 16227 165 1.568966 2.5887939 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 220 3.57e-53   NTclustered gi|2874253847|emb|OY969903.1| 904075 g15982 i0 91.772 105.957575757576 158 13 96 0 8 165 1831080 1831237 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 17483 220 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
9786456 9786456 PRJNA881257_P_NODE_14628_length_168_cov_1.310924_g14383_i0 PRJNA881257 14628 168 1.310924 2.20235232 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 267 4.63e-67   NTclustered gi|22203534|gb|AY124344.1| 120965 g14383 i0 95.238 116.541666666667 168 8 100 0 1 168 956 789 Uncultured planctomycete small subunit ribosomal RNA gene, partial sequence blastn 19579 267 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
13612248 13612248 PRJNA881257_P_NODE_6191_length_294_cov_1.485714_g5946_i0 PRJNA881257 6191 294 1.485714 4.36799916 Nibricoccus sp. IMCC34717 3034021 Bacteria Bacteria 527 3.719999999999999e-145   NTclustered gi|2850969968|gb|CP119759.1| 3034021 g5946 i0 99.313 46.0102040816327 291 2 99 0 1 291 1405740 1406030 Nibricoccus sp. IMCC34717 chromosome, complete genome blastn 13527 527 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus sp. IMCC34717
16543205 16543205 PRJNA881257_P_NODE_13093_length_177_cov_1.398438_g12848_i0 PRJNA881257 13093 177 1.398438 2.47523526 Prosthecobacter 48463 Bacteria Bacteria 283 4.87e-72   NTclustered gi|12583974|gb|AF245378.1|AF245378 48464 g12848 i0 95.48 71.1977401129944 177 8 100 0 1 177 1000 824 Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence blastn 12602 283 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter fusiformis
23810738 23810738 PRJNA881257_P_NODE_10039_length_209_cov_2.275000_g9794_i0 PRJNA881257 10039 209 2.275 4.75475 Nibricoccus sp. IMCC34717 3034021 Bacteria Bacteria 353 4.489999999999999e-93   NTclustered gi|2850969968|gb|CP119759.1| 3034021 g9794 i0 97.129 180.693779904306 209 6 100 0 1 209 1404252 1404460 Nibricoccus sp. IMCC34717 chromosome, complete genome blastn 37765 353 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus sp. IMCC34717

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