RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA473201", tax_kingdom = "Bacillati" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 11 ✖

tax_kingdom 1

  • Bacillati · 11 ✖

bioproject 1

  • PRJNA473201 · 11 ✖

analysis 1

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
26854917 26854917 PRJNA473201_P_NODE_67441_length_250_cov_1.502825_g66699_i0 PRJNA473201 67441 250 1.502825 3.7570625 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 156 3.5099999999999995e-46   NR MBX9722793.1 2364082 g66699 i0 92.8 1.992 83 6 99.6 0 1 249 57 139 MBX9722793.1 oligopeptide:H+ symporter [Candidatus Obscuribacterales bacterium] diamond 498 156 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27360845 27360845 PRJNA473201_P_NODE_85603_length_241_cov_0.916667_g84861_i0 PRJNA473201 85603 241 0.916667 2.20916747 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 63.2 1.22e-10   NR MDR3615454.1 2364082 g84861 i0 77.5 0.49792531120332 40 9 49.8 0 121 240 2 41 MDR3615454.1 helix-turn-helix transcriptional regulator [Candidatus Obscuribacterales bacterium] diamond 120 63.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28086757 28086757 PRJNA473201_P_NODE_66725_length_251_cov_0.865169_g65983_i0 PRJNA473201 66725 251 0.865169 2.17157419 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 57.8 2.06e-7   NR MBX9722685.1 2364082 g65983 i0 52.5 0.729083665338645 61 27 72.9 2 186 4 18 76 MBX9722685.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 183 57.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28513514 28513514 PRJNA473201_P_NODE_81567_length_243_cov_0.905882_g80825_i0 PRJNA473201 81567 243 0.905882 2.20129326 Bacillati 1783272 Bacteria Bacteria 123 3.3499999999999993e-34   NR MBX9686888.1 2364082 g80825 i0 82.5 3.95061728395062 80 14 98.8 0 3 242 41 120 MBX9686888.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 960 123 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29129056 29129056 PRJNA473201_P_NODE_75429_length_246_cov_0.890173_g74687_i0 PRJNA473201 75429 246 0.890173 2.18982558 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 90.9 1.86e-20   NR MBX9570298.1 2364082 g74687 i0 57.3 1 82 35 100 0 1 246 86 167 MBX9570298.1 class I SAM-dependent methyltransferase [Candidatus Obscuribacterales bacterium] diamond 246 90.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29160671 29160671 PRJNA473201_P_NODE_83609_length_242_cov_0.911243_g82867_i0 PRJNA473201 83609 242 0.911243 2.20520806 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 77.4 2.32e-14   NR MBX9685885.1 2364082 g82867 i0 48.8 1.01652892561983 82 39 97.9 2 3 239 545 626 MBX9685885.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 246 77.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29949861 29949861 PRJNA473201_P_NODE_81231_length_243_cov_0.905882_g80489_i0 PRJNA473201 81231 243 0.905882 2.20129326 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 91.3 4.1e-20   NR MBX9571606.1 2364082 g80489 i0 61.3 1.91358024691358 80 31 98.8 0 241 2 5 84 MBX9571606.1 rod shape-determining protein MreC [Candidatus Obscuribacterales bacterium] diamond 465 91.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30676331 30676331 PRJNA473201_P_NODE_73353_length_247_cov_0.885057_g72611_i0 PRJNA473201 73353 247 0.885057 2.18609079 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 80.1 2.85e-16   NR MBX9722793.1 2364082 g72611 i0 79.6 0.595141700404858 49 10 59.5 0 245 99 165 213 MBX9722793.1 oligopeptide:H+ symporter [Candidatus Obscuribacterales bacterium] diamond 147 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31782769 31782769 PRJNA473201_P_NODE_44757_length_305_cov_1.176724_g44015_i0 PRJNA473201 44757 305 1.176724 3.5890082 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 99.8 1.35e-23   NR MBY0356572.1 2364082 g44015 i0 52 1.00327868852459 102 48 99.3 1 305 3 13 114 MBY0356572.1 LPS export ABC transporter periplasmic protein LptC [Candidatus Obscuribacterales bacterium] diamond 306 99.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31846102 31846102 PRJNA473201_P_NODE_79077_length_244_cov_0.900585_g78335_i0 PRJNA473201 79077 244 0.900585 2.1974274 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 57.4 2.6e-7   NR MBX9687176.1 2364082 g78335 i0 55 0.737704918032787 60 25 73.8 1 65 244 1 58 MBX9687176.1 argininosuccinate synthase [Candidatus Obscuribacterales bacterium] diamond 180 57.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32636638 32636638 PRJNA473201_P_NODE_85260_length_241_cov_0.916667_g84518_i0 PRJNA473201 85260 241 0.916667 2.20916747 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 57.4 2.5e-7   NR MBX9723093.1 2364082 g84518 i0 43.5 0.771784232365145 62 31 72.2 1 29 202 2 63 MBX9723093.1 HAMP domain-containing histidine kinase [Candidatus Obscuribacterales bacterium] diamond 186 57.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales 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);;