RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1122875 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
2828172 2828172 PRJNA1122875_P_NODE_20783_length_365_cov_1.630137_g20559_i0 PRJNA1122875 20783 365 1.630137 5.95000005 Phycisphaerales bacterium 2052180 Bacteria Bacteria 209 1.94e-49   NTclustered gi|2108005054|gb|CP070772.1| 2052180 g20559 i0 82.7 2.92876712328767 237 39 65 2 1 236 3896000 3895765 MAG: Phycisphaerales bacterium isolate bin220 chromosome blastn 1069 209 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
9205868 9205868 PRJNA1122875_P_NODE_51408_length_243_cov_0.905882_g51184_i0 PRJNA1122875 51408 243 0.905882 2.20129326 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 150 7.55e-32   NTclustered gi|2621705104|emb|OY763327.1| 2026777 g51184 i0 85.417 34.3909465020576 144 21 59 0 98 241 3235723 3235866 MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1 blastn 8357 150 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
10481106 10481106 PRJNA1122875_P_NODE_16669_length_409_cov_2.276786_g16445_i0 PRJNA1122875 16669 409 2.276786 9.31205474 Planctomycetales bacterium 10988 2603660 Bacteria Bacteria 62.1 6.53e-5   NTclustered gi|1775855904|gb|CP043547.1| 2603660 g16445 i0 100 0.17359413202934 33 0 8 0 338 370 5886971 5887003 Planctomycetales bacterium 10988 chromosome, complete genome blastn 71 62.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium 10988
13782122 13782122 PRJNA1122875_P_NODE_52531_length_242_cov_0.911243_g52307_i0 PRJNA1122875 52531 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 267 7.15e-67   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g52307 i0 86.975 10.3471074380165 238 29 98 2 4 240 8703073 8702837 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 2504 267 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
16331251 16331251 PRJNA1122875_P_NODE_49413_length_245_cov_0.895349_g49189_i0 PRJNA1122875 49413 245 0.895349 2.19360505 Schlesneria 656899 Bacteria Bacteria 97.1 1.01e-15   NTclustered gi|2806767875|gb|CP124747.2| 3044399 g49189 i0 98.182 21.6448979591837 55 1 22 0 1 55 4770029 4769975 Schlesneria sp. DSM 10557 chromosome, complete genome blastn 5303 97.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Schlesneria Schlesneria sp. DSM 10557
21954521 21954521 PRJNA1122875_P_NODE_40798_length_259_cov_1.612903_g40574_i0 PRJNA1122875 40798 259 1.612903 4.17741877 Humisphaera borealis 2807512 Bacteria Bacteria 54.7 0.007   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g40574 i0 100 0.111969111969112 29 0 11 0 219 247 5934336 5934364 Humisphaera borealis strain M1803 chromosome, complete genome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
24503385 24503385 PRJNA1122875_P_NODE_17060_length_405_cov_0.825301_g16836_i0 PRJNA1122875 17060 405 0.825301 3.34246905 Mucisphaera calidilacus 2527982 Bacteria Bacteria 180 1.7099999999999996e-40   NTclustered gi|1712644202|gb|CP036280.1| 2527982 g16836 i0 84.239 40.3160493827161 184 29 45 0 207 390 141340 141157 Mucisphaera calidilacus strain Pan265 chromosome, complete genome blastn 16328 180 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Mucisphaera Mucisphaera calidilacus
24503673 24503673 PRJNA1122875_P_NODE_41340_length_257_cov_1.277174_g41116_i0 PRJNA1122875 41340 257 1.277174 3.28233718 Urbifossiella limnaea 2528023 Bacteria Bacteria 54.7 0.006   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g41116 i0 100 0.221789883268482 29 0 11 0 202 230 4813016 4812988 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 57 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
24503718 24503718 PRJNA1122875_P_NODE_44480_length_250_cov_0.870056_g44256_i0 PRJNA1122875 44480 250 0.870056 2.17514 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 187 5.949999999999998e-43   NTclustered gi|2874253757|emb|OY969698.1| 100233 g44256 i0 81.579 7.568 228 40 91 2 1 227 1689981 1690207 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 1892 187 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae 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);;