RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 14 ✖

bioproject 1

  • PRJEB7799 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
25527053 25527053 PRJEB7799f_S_NODE_3449_length_179_cov_1.902778_g3433_i0 PRJEB7799 3449 179 1.902778 3.40597262 PVC group 1783257 Bacteria Bacteria 107 2.72e-28   NR WP_148597875.1 406548 g3433 i0 84.5 1.94413407821229 58 9 97.2 0 177 4 55 112 WP_148597875.1 DUF3140 domain-containing protein [Aquisphaera giovannonii] diamond 348 108 0.990740740740741 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
32913352 32913352 PRJEB7799l_S_NODE_7745_length_185_cov_1.626667_g7716_i0 PRJEB7799 7745 185 1.626667 3.00933395 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 62.4 3.59e-10   NR MEY2493788.1 2026799 g7716 i0 50.8 1.88108108108108 59 29 95.7 0 185 9 62 120 MEY2493788.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 348 62.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32982269 32982269 PRJEB7799p_S_NODE_15763_length_175_cov_6.414286_g15740_i0 PRJEB7799 15763 175 6.414286 11.2250005 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 70.9 7.31e-13   NR MFO1002852.1 2026779 g15740 i0 64.6 5.50285714285714 48 17 82.3 0 1 144 209 256 MFO1002852.1 imidazole glycerol phosphate synthase subunit HisF [Planctomycetaceae bacterium] diamond 963 70.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32991815 32991815 PRJEB7799p_S_NODE_17107_length_172_cov_1.408759_g17084_i0 PRJEB7799 17107 172 1.408759 2.42306548 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00212   NR HWG43726.1 2052164 g17084 i0 50.9 2.73837209302326 55 27 95.9 0 170 6 60 114 HWG43726.1 tetratricopeptide repeat protein [Gemmataceae bacterium] diamond 471 45.4 0.993392070484582 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
33015728 33015728 PRJEB7799i_S_NODE_6964_length_184_cov_6.275168_g6934_i0 PRJEB7799 6964 184 6.275168 11.54630912 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42 0.0282   NR MDB5304208.1 2052180 g6934 i0 42.1 0.619565217391304 38 22 62 0 43 156 24 61 MDB5304208.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
33033149 33033149 PRJEB7799n_S_NODE_2212_length_288_cov_16.470356_g2175_i0 PRJEB7799 2212 288 16.470356 47.43462528 Chlamydiales bacterium 2047757 Bacteria Bacteria 85.5 1.22e-18   NR MCP5470420.1 2047757 g2175 i0 73.3 0.78125 75 20 78.1 0 282 58 81 155 MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] diamond 225 85.5 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
33050166 33050166 PRJEB7799n_S_NODE_3637_length_237_cov_2.440594_g3600_i0 PRJEB7799 3637 237 2.440594 5.78420778 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 99.8 4.939999999999999e-23   NR MBI5770155.1 2026799 g3600 i0 69.1 1.72151898734177 68 21 86.1 0 235 32 168 235 MBI5770155.1 glycosyltransferase [Verrucomicrobiota bacterium] diamond 408 99.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
33066551 33066551 PRJEB7799d_S_NODE_3037_length_192_cov_2.515924_g3027_i0 PRJEB7799 3037 192 2.515924 4.83057408 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.00513   NR MCC6575321.1 2026780 g3027 i0 53.6 0.4375 28 13 43.8 0 38 121 24 51 MCC6575321.1 transposase [Planctomycetota bacterium] diamond 84 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33083403 33083403 PRJEB7799a_S_NODE_10590_length_181_cov_2.493151_g10555_i0 PRJEB7799 10590 181 2.493151 4.51260331 Gemmata obscuriglobus UQM 2246 214688 Bacteria Bacteria 46.2 7.45e-4   NR VTS08183.1 214688 g10555 i0 56.1 0.679558011049724 41 18 68 0 53 175 57 97 VTS08183.1 Putative uncharacterized protein (Fragment) OS=uncultured alpha proteobacterium HF0070_14E07 PE=4 SV=1 [Gemmata obscuriglobus UQM 2246] diamond 123 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
33083781 33083781 PRJEB7799g_S_NODE_3638_length_189_cov_2.733766_g3422_i0 PRJEB7799 3638 189 2.733766 5.16681774 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42.7 0.0154   NR MDB5304208.1 2052180 g3422 i0 42.1 0.603174603174603 38 22 60.3 0 128 15 24 61 MDB5304208.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
33151789 33151789 PRJEB7799a_S_NODE_3616_length_248_cov_20.305164_g3581_i0 PRJEB7799 3616 248 20.305164 50.35680672 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42.4 0.0441   NR MDB5304208.1 2052180 g3581 i0 42.1 0.459677419354839 38 22 46 0 107 220 24 61 MDB5304208.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
33169500 33169500 PRJEB7799n_S_NODE_11040_length_157_cov_10.245902_g11003_i0 PRJEB7799 11040 157 10.245902 16.08606614 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.2 0.0397   NR MEY2747018.1 2026780 g11003 i0 51.7 0.554140127388535 29 14 55.4 0 92 6 190 218 MEY2747018.1 Sensor protein FixL [Planctomycetota bacterium] diamond 87 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33169724 33169724 PRJEB7799o_S_NODE_2656_length_177_cov_3.267606_g2648_i0 PRJEB7799 2656 177 3.267606 5.78366262 Phycisphaerales bacterium 2052180 Bacteria Bacteria 44.3 4.02e-4   NR MDF1810128.1 2052180 g2648 i0 70.8 0.406779661016949 24 7 40.7 0 5 76 33 56 MDF1810128.1 YqaE/Pmp3 family membrane protein [Phycisphaerales bacterium] diamond 72 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
33169934 33169934 PRJEB7799p_S_NODE_7872_length_204_cov_6.786982_g7849_i0 PRJEB7799 7872 204 6.786982 13.84544328 Phycisphaerales bacterium 2052180 Bacteria Bacteria 41.6 0.049   NR MDB5304208.1 2052180 g7849 i0 42.1 0.558823529411765 38 22 55.9 0 63 176 24 61 MDB5304208.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;