RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA656952 · 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
1898498 1898498 PRJNA656952_P_NODE_30922_length_251_cov_1.488764_g30735_i0 PRJNA656952 30922 251 1.488764 3.73679764 Aquisphaera giovannonii 406548 Bacteria Bacteria 270 5.77e-68   NTclustered gi|1730068067|gb|CP042997.1| 406548 g30735 i0 86.111 5.82470119521912 252 33 100 2 1 251 273092 272842 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 1462 270 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
4450043 4450043 PRJNA656952_P_NODE_22864_length_288_cov_1.320930_g22677_i0 PRJNA656952 22864 288 1.32093 3.8042784 Phycisphaerales bacterium 2052180 Bacteria Bacteria 337 6.57e-88   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g22677 i0 88.136 4.04513888888889 295 19 99 6 1 286 577547 577834 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 1165 337 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
10826628 10826628 PRJNA656952_P_NODE_32489_length_250_cov_0.870056_g32302_i0 PRJNA656952 32489 250 0.870056 2.17514 Lacipirellula limnantheis 2528024 Bacteria Bacteria 307 4.3800000000000005e-79   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g32302 i0 89.627 0.964 241 25 96 0 10 250 5092434 5092674 Lacipirellula limnantheis strain I41 chromosome blastn 241 307 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
10826785 10826785 PRJNA656952_P_NODE_39669_length_244_cov_0.900585_g39482_i0 PRJNA656952 39669 244 0.900585 2.1974274 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 75 4.7e-9   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g39482 i0 83.544 0.733606557377049 79 13 32 0 143 221 4625057 4625135 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 179 75 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
17200455 17200455 PRJNA656952_P_NODE_37494_length_246_cov_0.890173_g37307_i0 PRJNA656952 37494 246 0.890173 2.18982558 Lignipirellula cremea 2528010 Bacteria Bacteria 178 3.5099999999999993e-40   NTclustered gi|1712668320|gb|CP036433.1| 2528010 g37307 i0 80.672 0.967479674796748 238 38 95 6 1 234 3224211 3223978 Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome blastn 238 178 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Lignipirellula Lignipirellula cremea
18474653 18474653 PRJNA656952_P_NODE_32955_length_250_cov_0.870056_g32768_i0 PRJNA656952 32955 250 0.870056 2.17514 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 388 1.5199999999999998e-103   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g32768 i0 96.97 282.532 231 7 92 0 1 231 2501336 2501106 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 70633 388 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);;