RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA285816 · 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
2922710 2922710 PRJNA285816_S_NODE_24843_length_168_cov_0.873950_g24741_i0 PRJNA285816 24843 168 0.87395 1.468236 Phycisphaerales bacterium 2052180 Bacteria Bacteria 215 1.7e-51   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g24741 i0 89.881 9.05357142857143 168 16 100 1 1 168 2191348 2191182 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 1521 215 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
2922721 2922721 PRJNA285816_S_NODE_26043_length_166_cov_1.324786_g25941_i0 PRJNA285816 26043 166 1.324786 2.19914476 Caulifigura coniformis 2527983 Bacteria Bacteria 56.5 0.001   NTclustered gi|1712508784|gb|CP036271.1| 2527983 g25941 i0 100 0.180722891566265 30 0 18 0 101 130 250837 250866 Caulifigura coniformis strain Pan44 chromosome blastn 30 56.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Caulifigura Caulifigura coniformis
11850748 11850748 PRJNA285816_S_NODE_29950_length_159_cov_2.381818_g29848_i0 PRJNA285816 29950 159 2.381818 3.78709062 Aquisphaera giovannonii 406548 Bacteria Bacteria 176 7.49e-40   NTclustered gi|1730068067|gb|CP042997.1| 406548 g29848 i0 87.179 341.779874213836 156 18 97 2 5 159 9143375 9143221 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 54343 176 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
13125788 13125788 PRJNA285816_S_NODE_19071_length_183_cov_2.380597_g18969_i0 PRJNA285816 19071 183 2.380597 4.35649251 Phycisphaerales bacterium 2052180 Bacteria Bacteria 224 3.1199999999999996e-54   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g18969 i0 90.23 42.6885245901639 174 14 95 3 11 183 2190391 2190220 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 7812 224 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
16361650 16361650 PRJNA285816_S_NODE_8933_length_241_cov_1.333333_g8831_i0 PRJNA285816 8933 241 1.333333 3.21333253 Gemmata 113 Bacteria Bacteria 296 9.08e-76   NTclustered gi|1015440974|gb|CP011271.1| 1630693 g8831 i0 90.991 106.107883817427 222 16 91 4 20 239 558741 558522 Gemmata sp. SH-PL17, complete genome blastn 25572 296 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp. SH-PL17
24598266 24598266 PRJNA285816_S_NODE_7120_length_264_cov_2.283721_g7018_i0 PRJNA285816 7120 264 2.283721 6.02902344 Urbifossiella limnaea 2528023 Bacteria Bacteria 287 6.07e-73   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g7018 i0 86.232 44.9015151515151 276 24 100 8 1 264 2020310 2020037 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 11854 287 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea

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