RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA577580 · 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
5667716 5667716 PRJNA577580_P_NODE_13925_length_251_cov_1.752809_g13847_i0 PRJNA577580 13925 251 1.752809 4.39955059 Rohdeia mirabilis 2528008 Bacteria Bacteria 202 2.13e-47   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g13847 i0 81.323 271.462151394422 257 40 99 6 2 251 3894538 3894793 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 68137 202 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
5667726 5667726 PRJNA577580_P_NODE_15145_length_246_cov_3.560694_g15067_i0 PRJNA577580 15145 246 3.560694 8.75930724 Rohdeia mirabilis 2528008 Bacteria Bacteria 211 3.46e-50   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g15067 i0 85.572 5.74390243902439 201 29 82 0 1 201 3894812 3895012 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 1413 211 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
9492479 9492479 PRJNA577580_P_NODE_6168_length_362_cov_1.328720_g6090_i0 PRJNA577580 6168 362 1.32872 4.8099664 Saltatorellus ferox 2528018 Bacteria Bacteria 226 1.91e-54   NTclustered gi|1712682957|gb|CP036434.1| 2528018 g6090 i0 83.004 242.914364640884 253 39 69 4 2 252 2930756 2931006 Planctomycetes bacterium Poly30 chromosome, complete genome blastn 87935 226 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Saltatorellus Saltatorellus ferox
13317976 13317976 PRJNA577580_P_NODE_11451_length_272_cov_3.125628_g11373_i0 PRJNA577580 11451 272 3.125628 8.50170816 Stieleria maiorica 2795974 Bacteria Bacteria 71.3 6.89e-8   NTclustered gi|1726207917|gb|CP036264.1| 2795974 g11373 i0 97.561 5.30882352941176 41 1 15 0 105 145 8440264 8440304 Stieleria maiorica strain Mal15 chromosome blastn 1444 71.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Stieleria Stieleria maiorica
17141708 17141708 PRJNA577580_P_NODE_6354_length_356_cov_2.530035_g6276_i0 PRJNA577580 6354 356 2.530035 9.0069246 Planctomycetota bacterium 2026780 Bacteria Bacteria 56.5 0.003   NTclustered gi|2107958177|gb|CP070790.1| 2026780 g6276 i0 100 0.0842696629213483 30 0 8 0 321 350 338829 338858 MAG: Planctomycetota bacterium isolate bin1449 chromosome blastn 30 56.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
21540078 21540078 PRJNA577580_P_NODE_8337_length_314_cov_1.153527_g8259_i0 PRJNA577580 8337 314 1.153527 3.62207478 Engelhardtia 139931 Bacteria Bacteria 416 9.039999999999999e-112   NTclustered gi|1712638177|gb|CP036287.1| 2528011 g8259 i0 90.764 216.445859872611 314 25 99 4 3 314 5248522 5248211 Planctomycetes bacterium Pla133 chromosome, complete genome blastn 67964 416 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Engelhardtia Engelhardtia mirabilis

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