RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA414036", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 13 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 13 ✖

bioproject 1

  • PRJNA414036 · 13 ✖
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
418843 418843 PRJNA414036_P_NODE_80901_length_161_cov_7.468254_g79162_i0 PRJNA414036 80901 161 7.468254 12.02388894 Gemmataceae bacterium 2052164 Bacteria Bacteria 246 5.7199999999999986e-61   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g79162 i0 97.241 341.571428571429 145 4 90 0 8 152 318029 317885 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 54993 246 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
16996268 16996268 PRJNA414036_P_NODE_66454_length_193_cov_4.291139_g64715_i0 PRJNA414036 66454 193 4.291139 8.28189827 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 89.8 1.27e-13   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g64715 i0 78.986 0.715025906735751 138 24 70 3 10 144 417502 417367 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 138 89.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
18270461 18270461 PRJNA414036_P_NODE_85835_length_154_cov_2.512605_g84096_i0 PRJNA414036 85835 154 2.512605 3.8694117 Singulisphaera sp. Ch08 3120278 Bacteria Bacteria 52.8 0.013   NTclustered gi|2732846650|gb|CP155447.1| 3120278 g84096 i0 100 0.181818181818182 28 0 18 0 16 43 6544913 6544886 Singulisphaera sp. Ch08 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. Ch08
19544563 19544563 PRJNA414036_P_NODE_42576_length_231_cov_4.209184_g40837_i0 PRJNA414036 42576 231 4.209184 9.72321504 Saltatorellus ferox 2528018 Bacteria Bacteria 95.3 3.38e-15   NTclustered gi|1712682957|gb|CP036434.1| 2528018 g40837 i0 92.424 67.0649350649351 66 5 29 0 157 222 2930170 2930105 Planctomycetes bacterium Poly30 chromosome, complete genome blastn 15492 95.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Saltatorellus Saltatorellus ferox
20209065 20209065 PRJNA414036_P_NODE_2916_length_586_cov_8.186933_g2330_i0 PRJNA414036 2916 586 8.186933 47.97542738 Gemmata 113 Bacteria Bacteria 468 4.85e-127   NTclustered gi|1804905141|emb|LR593886.1| 1210884 g2330 i0 84.362 85.1962457337884 486 46 97 6 103 581 3633931 3633469 Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 blastn 49925 468 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
22095231 22095231 PRJNA414036_P_NODE_59718_length_217_cov_8.939560_g57979_i0 PRJNA414036 59718 217 8.93956 19.3988452 Frigoriglobus tundricola 2774151 Bacteria Bacteria 254 4.9e-63   NTclustered gi|1870286614|gb|CP053452.2| 2774151 g57979 i0 90.452 29.4976958525346 199 10 92 1 10 208 4959862 4959673 Frigoriglobus tundricola strain PL17 chromosome, complete genome blastn 6401 254 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola
23370748 23370748 PRJNA414036_P_NODE_15579_length_375_cov_11.400000_g13893_i0 PRJNA414036 15579 375 11.4 42.75 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 599 1.0199999999999998e-166   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g13893 i0 96.429 126.072 364 12 97 1 4 366 2002687 2002324 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 47277 599 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24645156 24645156 PRJNA414036_P_NODE_40580_length_231_cov_6.581633_g38841_i0 PRJNA414036 40580 231 6.581633 15.20357223 Planctomycetes bacterium syqfu 2896527 Bacteria Bacteria 87.9 5.66e-13   NTclustered gi|2155219436|gb|CP087563.1| 2896527 g38841 i0 93.333 19.3290043290043 60 3 26 1 16 75 4645381 4645323 Planctomycetes bacterium syqfu chromosome, complete genome blastn 4465 87.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium syqfu
27549388 27549388 PRJNA414036_P_NODE_28864_length_280_cov_2.020408_g27129_i0 PRJNA414036 28864 280 2.020408 5.6571424 Gemmata obscuriglobus UQM 2246 214688 Bacteria Bacteria 52 1.77e-5   NR VTS08183.1 214688 g27129 i0 45.3 0.803571428571429 75 37 80.4 2 45 269 95 165 VTS08183.1 Putative uncharacterized protein (Fragment) OS=uncultured alpha proteobacterium HF0070_14E07 PE=4 SV=1 [Gemmata obscuriglobus UQM 2246] diamond 225 52 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
28023188 28023188 PRJNA414036_P_NODE_51365_length_231_cov_1.974490_g49626_i0 PRJNA414036 51365 231 1.97449 4.5610719 Phycisphaera sp. 2030824 Bacteria Bacteria 46.6 0.00128   NR MBI1374130.1 2030824 g49626 i0 79.2 0.584415584415584 24 5 31.2 0 3 74 155 178 MBI1374130.1 hypothetical protein [Phycisphaera sp.] diamond 135 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
28023190 28023190 PRJNA414036_P_NODE_57165_length_227_cov_13.260417_g55426_i0 PRJNA414036 57165 227 13.260417 30.10114659 Planctomycetia bacterium 2052181 Bacteria Bacteria 43.1 0.0222   NR MDZ4779250.1 2052181 g55426 i0 42.4 0.872246696035242 66 32 87.2 3 27 224 58 117 MDZ4779250.1 ATP-binding protein [Planctomycetia bacterium] diamond 198 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
29618088 29618088 PRJNA414036_P_NODE_40350_length_231_cov_10.973118_g38611_i0 PRJNA414036 40350 231 10.973118 25.34790258 Gemmataceae 1914233 Bacteria Bacteria 48.1 3.82e-4   NR MEZ6140059.1 1914240 g38611 i0 95.5 7.42857142857143 22 1 28.6 0 223 158 91 112 MEZ6140059.1 response regulator [Zavarzinella sp.] diamond 1716 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Zavarzinella Zavarzinella sp.
30850424 30850424 PRJNA414036_P_NODE_41394_length_231_cov_5.035714_g39655_i0 PRJNA414036 41394 231 5.035714 11.63249934 Anatilimnocola 2807414 Bacteria Bacteria 61.6 7.03e-9   NR MBI3461457.1 2026780 g39655 i0 44.7 4.41558441558442 85 36 96.1 1 10 231 91 175 MBI3461457.1 nucleotide sugar dehydrogenase [Planctomycetota bacterium] diamond 1020 61.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;