RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1012699" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJNA1012699 · 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
5260884 5260884 PRJNA1012699_P_NODE_345_length_575_cov_3.585657_g315_i0 PRJNA1012699 345 575 3.585657 20.61752775 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 782 0   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g315 i0 91.364 232.368695652174 579 39 99 9 1 572 1599871 1600445 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 133612 782 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
7380069 7380069 PRJNA1012699_P_NODE_2846_length_251_cov_1.685393_g2814_i0 PRJNA1012699 2846 251 1.685393 4.23033643 Telmatocola 1382832 Bacteria Bacteria 300 7.36e-77   NTclustered gi|2041266541|gb|CP074694.1| 1123043 g2814 i0 88.189 172.581673306773 254 26 99 4 2 251 3724028 3723775 Telmatocola sphagniphila strain SP2T chromosome, complete genome blastn 43318 300 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Telmatocola Telmatocola sphagniphila
24384157 24384157 PRJNA1012699_P_NODE_960_length_370_cov_1.898990_g928_i0 PRJNA1012699 960 370 1.89899 7.026263 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 527 4.7899999999999985e-145   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g928 i0 92.513 45.1324324324324 374 18 99 8 1 369 1600412 1600780 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 16699 527 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
28677187 28677187 PRJNA1012699_P_NODE_507_length_486_cov_1.283293_g475_i0 PRJNA1012699 507 486 1.283293 6.23680398 Phycisphaerae bacterium 2026778 Bacteria Bacteria 46.2 0.02   NR MFQ5807405.1 2026778 g475 i0 29.4 0.672839506172839 109 46 54.9 5 163 429 188 285 MFQ5807405.1 type II secretion system protein [Phycisphaerae bacterium] diamond 327 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29434536 29434536 PRJNA1012699_P_NODE_2010_length_279_cov_2.480583_g1978_i0 PRJNA1012699 2010 279 2.480583 6.92082657 Phycisphaerales bacterium 2052180 Bacteria Bacteria 53.1 1.27e-5   NR NLX12618.1 2052180 g1978 i0 64.7 0.365591397849462 34 12 36.6 0 223 122 1069 1102 NLX12618.1 fibronectin type III domain-containing protein [Phycisphaerales bacterium] diamond 102 53.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29877030 29877030 PRJNA1012699_P_NODE_3471_length_246_cov_0.901734_g3439_i0 PRJNA1012699 3471 246 0.901734 2.21826564 Planctomycetota bacterium 2026780 Bacteria Bacteria 52.4 1.01e-5   NR MBL4845093.1 2026780 g3439 i0 36.4 0.939024390243902 77 42 93.9 1 240 10 76 145 MBL4845093.1 PQQ-like beta-propeller repeat protein [Planctomycetota bacterium] diamond 231 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32406104 32406104 PRJNA1012699_P_NODE_2779_length_252_cov_0.871508_g2747_i0 PRJNA1012699 2779 252 0.871508 2.19620016 Thalassoroseus pseudoceratinae 2713176 Bacteria Bacteria 78.2 1.46e-14   NR WP_166819670.1 2713176 g2747 i0 50.6 0.988095238095238 83 40 98.8 1 4 252 281 362 WP_166819670.1 MG2 domain-containing protein [Thalassoroseus pseudoceratinae] diamond 249 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoroseus Thalassoroseus pseudoceratinae

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