RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB81171" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJEB81171 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1414062 1414062 PRJEB81171_P_NODE_6882_length_265_cov_0.932292_g6755_i0 PRJEB81171 6882 265 0.932292 2.4705738 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 396 9.71e-106   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g6755 i0 93.633 102.509433962264 267 13 100 4 1 265 2002387 2002651 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 27165 396 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
2689393 2689393 PRJEB81171_P_NODE_2243_length_443_cov_1.629730_g2118_i0 PRJEB81171 2243 443 1.62973 7.2197039 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 449 1.3e-121   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g2118 i0 85.045 221.851015801354 448 59 100 8 1 443 2002086 2001642 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 98280 449 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
9066731 9066731 PRJEB81171_P_NODE_6568_length_270_cov_1.583756_g6441_i0 PRJEB81171 6568 270 1.583756 4.2761412 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 228 3.8299999999999994e-55   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g6441 i0 83.534 8.01851851851852 249 35 91 6 25 270 6489338 6489093 Planctomyces sp. SH-PL62, complete genome blastn 2165 228 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
11617943 11617943 PRJEB81171_P_NODE_4290_length_321_cov_0.943548_g4163_i0 PRJEB81171 4290 321 0.943548 3.02878908 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 250 9.95e-62   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g4163 i0 81.21 2.90965732087227 314 55 97 4 1 312 2178613 2178924 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 934 250 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
15441880 15441880 PRJEB81171_P_NODE_4913_length_300_cov_1.682819_g4786_i0 PRJEB81171 4913 300 1.682819 5.048457 Limnoglobus roseus 2598579 Bacteria Bacteria 429 1.1e-115   NTclustered gi|1733446852|gb|CP042425.1| 2598579 g4786 i0 92.667 126.216666666667 300 19 99 3 3 300 2957123 2956825 Limnoglobus roseus strain PX52 chromosome, complete genome blastn 37865 429 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Limnoglobus Limnoglobus roseus
16716222 16716222 PRJEB81171_P_NODE_8734_length_248_cov_0.891429_g8607_i0 PRJEB81171 8734 248 0.891429 2.21074392 Phycisphaera mikurensis 547188 Bacteria Bacteria 52.8 0.022   NTclustered gi|381385343|dbj|AP012338.1| 1142394 g8607 i0 100 0.112903225806452 28 0 11 0 127 154 2362396 2362423 Phycisphaera mikurensis NBRC 102666 DNA, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera mikurensis
24365146 24365146 PRJEB81171_P_NODE_2980_length_382_cov_1.669903_g2853_i0 PRJEB81171 2980 382 1.669903 6.37902946 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 542 1.7699999999999999e-149   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g2853 i0 92.228 99.8586387434555 386 24 100 6 1 382 2003086 2002703 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 38146 542 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae 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);;