RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJEB10140" 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 · 10 ✖

bioproject 1

  • PRJEB10140 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
11779 11779 PRJEB10140_P_NODE_16261_length_1717_cov_6.985012_g9111_i1 PRJEB10140 16261 1717 6.985012 119.93265604 Simkania negevensis 83561 Bacteria Bacteria 54.7 0.049   NTclustered gi|336481279|emb|FR872582.1| 331113 g9111 i1 100 0.0168899242865463 29 0 2 0 1473 1501 975538 975510 Simkania negevensis Z main chromosome, complete genome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania negevensis
1287433 1287433 PRJEB10140_P_NODE_46222_length_783_cov_106.664850_g30955_i0 PRJEB10140 46222 783 106.66485 835.1857755 Gimesia algae 2527971 Bacteria Bacteria 54.7 0.022   NTclustered gi|1712549334|gb|CP036343.1| 2527971 g30955 i0 100 0.037037037037037 29 0 4 0 728 756 7522186 7522158 Gimesia algae strain Pan161 chromosome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia algae
1287664 1287664 PRJEB10140_P_NODE_84382_length_434_cov_2.428571_g67112_i0 PRJEB10140 84382 434 2.428571 10.53999814 Lentisphaera profundi 1658616 Bacteria Bacteria 62.1 6.96e-5   NTclustered gi|2445967839|gb|CP117812.1| 1658616 g67112 i0 97.222 0.370967741935484 36 1 8 0 147 182 2019611 2019646 Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence blastn 161 62.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae Lentisphaera Lentisphaera profundi
3837779 3837779 PRJEB10140_P_NODE_134344_length_273_cov_4.330357_g117037_i0 PRJEB10140 134344 273 4.330357 11.82187461 Gimesia algae 2527971 Bacteria Bacteria 54.7 0.007   NTclustered gi|1712549334|gb|CP036343.1| 2527971 g117037 i0 100 0.208791208791209 29 0 11 0 239 267 7522158 7522186 Gimesia algae strain Pan161 chromosome blastn 57 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia algae
3839475 3839475 PRJEB10140_P_NODE_65644_length_559_cov_4.078431_g48664_i0 PRJEB10140 65644 559 4.078431 22.79842929 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 58.4 0.001   NTclustered gi|2874253811|emb|OY969795.1| 464461 g48664 i0 100 0.0554561717352415 31 0 6 0 71 101 1194943 1194913 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 31 58.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
7664035 7664035 PRJEB10140_P_NODE_16007_length_1733_cov_7.245843_g9111_i0 PRJEB10140 16007 1733 7.245843 125.57045919 Simkania negevensis 83561 Bacteria Bacteria 54.7 0.05   NTclustered gi|336481279|emb|FR872582.1| 331113 g9111 i0 100 0.016733987305251 29 0 2 0 217 245 975510 975538 Simkania negevensis Z main chromosome, complete genome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania negevensis
7665176 7665176 PRJEB10140_P_NODE_284007_length_163_cov_0.912281_g266698_i0 PRJEB10140 284007 163 0.912281 1.48701803 Akkermansia glycaniphila 1679444 Bacteria Bacteria 152 1.3e-32   NTclustered gi|1093279401|emb|LT629973.1| 1679444 g266698 i0 83.436 4.36196319018405 163 27 100 0 1 163 1553956 1554118 Akkermansia glycaniphila isolate APytT genome assembly, chromosome: I blastn 711 152 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia glycaniphila
15315119 15315119 PRJEB10140_P_NODE_284513_length_163_cov_0.903509_g267204_i0 PRJEB10140 284513 163 0.903509 1.47271967 Phycisphaera sp. 2030824 Bacteria Bacteria 207 2.74e-49   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g267204 i0 89.571 4.80981595092025 163 17 100 0 1 163 1554269 1554107 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 784 207 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
19137573 19137573 PRJEB10140_P_NODE_208876_length_189_cov_1.557143_g191567_i0 PRJEB10140 208876 189 1.557143 2.94300027 Singulisphaera sp. Ch08 3120278 Bacteria Bacteria 52.8 0.016   NTclustered gi|2732846650|gb|CP155447.1| 3120278 g191567 i0 100 0.148148148148148 28 0 15 0 24 51 4441849 4441876 Singulisphaera sp. Ch08 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. Ch08
21384481 21384481 PRJEB10140_P_NODE_288617_length_162_cov_0.920354_g271308_i0 PRJEB10140 288617 162 0.920354 1.49097348 Chlamydia 810 Bacteria Bacteria 137 3.6199999999999997e-28   NTclustered gi|1032413971|gb|CP015840.1| 1143323 g271308 i0 82.895 71.5925925925926 152 26 94 0 1 152 328520 328369 Chlamydia gallinacea 08-1274/3, complete genome blastn 11598 137 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia gallinacea

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