RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA909412 · 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
1249231 1249231 PRJNA909412_P_NODE_12981_length_161_cov_2.008197_g12840_i0 PRJNA909412 12981 161 2.008197 3.23319717 Rosistilla 2795779 Bacteria Bacteria 167 4.5799999999999995e-37   NTclustered gi|1712438206|gb|CP036261.1| 1930277 g12840 i0 85.976 115.062111801242 164 14 99 9 3 161 974730 974889 Rosistilla ulvae strain EC9 chromosome blastn 18525 167 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rosistilla Rosistilla ulvae
5077425 5077425 PRJNA909412_P_NODE_12184_length_163_cov_1.725806_g12043_i0 PRJNA909412 12184 163 1.725806 2.81306378 Gemmataceae 1914233 Bacteria Bacteria 209 7.62e-50   NTclustered gi|1804905141|emb|LR593886.1| 1210884 g12043 i0 90.244 356.398773006135 164 10 98 6 1 160 3633834 3633673 Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 blastn 58093 209 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
12728684 12728684 PRJNA909412_P_NODE_9410_length_175_cov_1.220588_g9269_i0 PRJNA909412 9410 175 1.220588 2.136029 Gimesia 1649453 Bacteria Bacteria 95.3 2.42e-15   NTclustered gi|1712496122|gb|CP036269.1| 2527973 g9269 i0 77.64 21.5085714285714 161 33 92 3 1 161 2394735 2394892 Gimesia alba strain Pan241w chromosome blastn 3764 95.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia alba
17468980 17468980 PRJNA909412_P_NODE_3274_length_291_cov_1.416667_g3133_i0 PRJNA909412 3274 291 1.416667 4.12250097 Lignipirellula cremea 2528010 Bacteria Bacteria 315 3.11e-81   NTclustered gi|1712668320|gb|CP036433.1| 2528010 g3133 i0 89.02 96.7457044673539 255 26 87 2 35 288 1144396 1144143 Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome blastn 28153 315 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Lignipirellula Lignipirellula cremea
20375513 20375513 PRJNA909412_P_NODE_17536_length_150_cov_2.846847_g17395_i0 PRJNA909412 17536 150 2.846847 4.2702705 Bacteria 2 Bacteria Bacteria 207 2.46e-49   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g17395 i0 91.946 10.04 149 10 99 2 2 150 2582829 2582975 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 1506 207 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
23842953 23842953 PRJNA909412_P_NODE_7139_length_197_cov_4.392405_g6998_i0 PRJNA909412 7139 197 4.392405 8.65303785 Planctomycetota bacterium 2026780 Bacteria Bacteria 63.9 7.88e-6   NTclustered gi|2907625648|emb|OZ223208.1| 2026780 g6998 i0 95.122 1.11675126903553 41 1 20 1 104 143 1495077 1495117 MAG: Planctomycetota bacterium isolate 604ccff8-4b2f-4b13-82eb-4b7433267518 genome assembly, chromosome: 1 blastn 220 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;