RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA792582 · 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
777111 777111 PRJNA792582_P_NODE_54661_length_246_cov_0.890173_g53847_i0 PRJNA792582 54661 246 0.890173 2.18982558 Lignipirellula cremea 2528010 Bacteria Bacteria 239 1.59e-58   NTclustered gi|1712668320|gb|CP036433.1| 2528010 g53847 i0 85.59 1.73577235772358 229 31 93 2 4 231 6914594 6914367 Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome blastn 427 239 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Lignipirellula Lignipirellula cremea
14805364 14805364 PRJNA792582_P_NODE_16712_length_422_cov_1.501433_g15898_i0 PRJNA792582 16712 422 1.501433 6.33604726 Caulifigura coniformis 2527983 Bacteria Bacteria 510 5.58e-140   NTclustered gi|1712508784|gb|CP036271.1| 2527983 g15898 i0 89.383 151.791469194313 405 43 96 0 18 422 2926116 2925712 Caulifigura coniformis strain Pan44 chromosome blastn 64056 510 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Caulifigura Caulifigura coniformis
16518176 16518176 PRJNA792582_P_NODE_22093_length_366_cov_3.064846_g21279_i0 PRJNA792582 22093 366 3.064846 11.21733636 Bacteria 2 Bacteria Bacteria 466 1.05e-126   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g21279 i0 90.055 282.448087431694 362 32 98 4 3 362 3893881 3894240 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 103376 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
21179289 21179289 PRJNA792582_P_NODE_20057_length_384_cov_2.424437_g19243_i0 PRJNA792582 20057 384 2.424437 9.30983808 Rohdeia mirabilis 2528008 Bacteria Bacteria 449 1.11e-121   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g19243 i0 88.021 176.213541666667 384 40 99 5 4 384 3894999 3894619 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 67666 449 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
21179423 21179423 PRJNA792582_P_NODE_3557_length_862_cov_2.861850_g2913_i0 PRJNA792582 3557 862 2.86185 24.669147 planctomycete str. 139 149588 Bacteria Bacteria 994 0   NTclustered gi|12583967|gb|AF245371.1|AF245371 149588 g2913 i0 89.122 113.185614849188 809 75 93 10 18 815 630 1436 Planctomycete str. 139 23S ribosomal RNA gene, partial sequence blastn 97566 994 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 139
25003421 25003421 PRJNA792582_P_NODE_36600_length_287_cov_0.976636_g35786_i0 PRJNA792582 36600 287 0.976636 2.80294532 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 357 5.02e-94   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g35786 i0 89.236 206.219512195122 288 28 100 2 1 287 2502481 2502766 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 59185 357 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae 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);;