RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA690592 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
4498762 4498762 PRJNA690592_S_NODE_101224_length_326_cov_1.371542_g100210_i0 PRJNA690592 101224 326 1.371542 4.47122692 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 54.7 0.009   NTclustered gi|2874254106|emb|OY970189.1| 100233 g100210 i0 96.875 0.098159509202454 32 1 10 0 100 131 1498363 1498332 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 32 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
5775306 5775306 PRJNA690592_S_NODE_41745_length_475_cov_2.838308_g40731_i0 PRJNA690592 41745 475 2.838308 13.481963 Planctomycetales bacterium ZRK34 2723666 Bacteria Bacteria 54.7 0.013   NTclustered gi|1898316769|gb|CP050848.1| 2723666 g40731 i0 100 0.0610526315789474 29 0 6 0 270 298 2922813 2922785 Planctomycetales bacterium ZRK34 chromosome, complete genome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium ZRK34
7050495 7050495 PRJNA690592_S_NODE_57366_length_414_cov_1.841642_g56352_i0 PRJNA690592 57366 414 1.841642 7.62439788 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 527 5.419999999999999e-145   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g56352 i0 89.688 182.93961352657 417 38 100 4 1 414 2002311 2001897 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 75737 527 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
10876053 10876053 PRJNA690592_S_NODE_76249_length_366_cov_3.139932_g75235_i0 PRJNA690592 76249 366 3.139932 11.49215112 Schlesneria sphaerica 3373610 Bacteria Bacteria 60.2 2.08e-4   NTclustered gi|2844279856|gb|CP172346.1| 3373610 g75235 i0 94.872 0.10655737704918 39 0 11 2 302 340 6286491 6286527 Schlesneria sp. T3-172 chromosome, complete genome blastn 39 60.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Schlesneria Schlesneria sphaerica
19798138 19798138 PRJNA690592_S_NODE_176116_length_257_cov_1.847826_g175102_i0 PRJNA690592 176116 257 1.847826 4.74891282 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 289 1.64e-73   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g175102 i0 88.655 147.988326848249 238 26 93 1 1 238 2001635 2001871 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 38033 289 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24130851 24130851 PRJNA690592_S_NODE_14719_length_767_cov_1.717579_g13835_i0 PRJNA690592 14719 767 1.717579 13.17383093 Engelhardtia 139931 Bacteria Bacteria 54.7 0.021   NTclustered gi|1712638177|gb|CP036287.1| 2528011 g13835 i0 100 0.075619295958279 29 0 4 0 132 160 304603 304575 Planctomycetes bacterium Pla133 chromosome, complete genome blastn 58 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Engelhardtia Engelhardtia mirabilis
24897515 24897515 PRJNA690592_S_NODE_185360_length_251_cov_1.556180_g184346_i0 PRJNA690592 185360 251 1.55618 3.9060118 Lacipirellula parvula 2650471 Bacteria Bacteria 122 1.7099999999999998e-23   NTclustered gi|1761017769|dbj|AP021861.1| 2650471 g184346 i0 83.969 7.1394422310757 131 17 51 3 123 251 2454744 2454616 Lacipirellula parvula PX69 DNA, complete genome blastn 1792 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula parvula
24898438 24898438 PRJNA690592_S_NODE_97620_length_331_cov_1.069767_g96606_i0 PRJNA690592 97620 331 1.069767 3.54092877 Isosphaera pallida 128 Bacteria Bacteria 65.8 4e-6   NTclustered gi|319748837|gb|CP002353.1| 575540 g96606 i0 91.489 1.62235649546828 47 4 14 0 129 175 1374069 1374115 Isosphaera pallida ATCC 43644, complete genome blastn 537 65.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera pallida

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