RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB64798" and tax_phylum = "Candidatus Magasanikiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Candidatus Magasanikiibacteriota · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 7 ✖

tax_kingdom 0

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
14156493 14156493 PRJEB64798_P_NODE_215192_length_163_cov_4.868421_g213426_i0 PRJEB64798 215192 163 4.868421 7.93552623 Candidatus Magasanikbacteria bacterium GW2011_GWA2_56_11 1619044 Bacteria Bacteria 228 2.0999999999999998e-55   NTclustered gi|1118703471|gb|KX123384.1| 1619044 g213426 i0 92.949 93.3251533742331 156 11 96 0 7 162 2107 2262 Candidatus Magasanikbacteria bacterium GW2011_GWA2_56_11 16S ribosomal RNA gene, partial sequence blastn 15212 228 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium GW2011_GWA2_56_11
26716820 26716820 PRJEB64798_P_NODE_206581_length_165_cov_15.034483_g204815_i0 PRJEB64798 206581 165 15.034483 24.80689695 Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_ 2026717 Bacteria Bacteria 43.5 0.00694   NR OGH66457.1 1798676 g204815 i0 40.4 1.03636363636364 57 29 94.5 2 8 163 328 384 OGH66457.1 MAG: hypothetical protein A3B90_00405 [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_02_FULL_41_13] diamond 171 43.5 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_02_FULL_41_13
28044514 28044514 PRJEB64798_P_NODE_237065_length_156_cov_4.112150_g235299_i0 PRJEB64798 237065 156 4.11215 6.414954 Candidatus Magasanikiibacteriota bacterium 2026717 Bacteria Bacteria 67.8 1.3e-11   NR MBI4427263.1 2026717 g235299 i0 63.3 8.57692307692308 49 18 94.2 0 148 2 151 199 MBI4427263.1 deoxyribose-phosphate aldolase [Candidatus Magasanikiibacteriota bacterium] diamond 1338 67.8 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
28732254 28732254 PRJEB64798_P_NODE_110327_length_210_cov_5.434783_g108561_i0 PRJEB64798 110327 210 5.434783 11.4130443 Pseudomonadati 3379134 Bacteria Bacteria 48.9 1.64e-4   NR KKW17394.1 1619043 g108561 i0 59.4 3.9 32 13 45.7 0 209 114 4123 4154 KKW17394.1 MAG: Multiple EGF-like-domain protein 3 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_50_22] diamond 819 49.3 0.991886409736308 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium GW2011_GWA2_50_22
28890002 28890002 PRJEB64798_P_NODE_190488_length_170_cov_3.338843_g188722_i0 PRJEB64798 190488 170 3.338843 5.6760331 root 1 Root_unresolved Root_unresolved 80.1 9.39e-16   NR KKU26732.1 1619042 g188722 i0 65.4 2.80588235294118 52 18 91.8 0 159 4 2443 2494 KKU26732.1 MAG: Carbohydrate binding family 6 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_46_17] diamond 477 80.1 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium GW2011_GWA2_46_17
29584430 29584430 PRJEB64798_P_NODE_218210_length_162_cov_11.805310_g216444_i0 PRJEB64798 218210 162 11.80531 19.124602200000002 Bacteria 2 Bacteria Bacteria 45.1 0.00185   NR HBB38151.1 2026717 g216444 i0 51.4 2.57407407407407 35 17 64.8 0 43 147 75 109 HBB38151.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] diamond 417 45.1 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
30191786 30191786 PRJEB64798_P_NODE_93612_length_212_cov_4.840491_g91846_i0 PRJEB64798 93612 212 4.840491 10.26184092 Candidatus Magasanikbacteria bacterium CG1 2026717 Bacteria Bacteria 68.9 9.9e-12   NR PIR78674.1 1974645 g91846 i0 70.6 1.44339622641509 51 9 63.7 1 141 7 15 65 PIR78674.1 MAG: hypothetical protein COU28_00370 [Candidatus Magasanikbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_16] diamond 306 68.9 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_16

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