RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB14803", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 7 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 7 ✖

bioproject 1

  • PRJEB14803 · 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
8948475 8948475 PRJEB14803_P_NODE_32568_length_188_cov_1.437908_g32102_i0 PRJEB14803 32568 188 1.437908 2.70326704 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 207 3.25e-49   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g32102 i0 91.892 70.1276595744681 148 12 79 0 2 149 3680929 3681076 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 13184 207 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
10224179 10224179 PRJEB14803_P_NODE_2809_length_857_cov_27.083942_g2501_i0 PRJEB14803 2809 857 27.083942 232.10938294 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 647 0   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g2501 i0 80.8 793.634772462077 875 127 99 37 5 857 3681115 3681970 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 680145 647 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
13739257 13739257 PRJEB14803_P_NODE_23531_length_232_cov_1.416244_g23065_i0 PRJEB14803 23531 232 1.416244 3.28568608 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 120 2.2000000000000002e-30   NR OGI16987.1 1801611 g23065 i0 69.7 3.93103448275862 76 23 98.3 0 3 230 189 264 OGI16987.1 MAG: glutamate-5-semialdehyde dehydrogenase [Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9] diamond 912 121 0.991735537190083 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9
26652975 26652975 PRJEB14803_P_NODE_321_length_1998_cov_5.926133_g263_i0 PRJEB14803 321 1998 5.926133 118.40413734 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 72 7.71e-10   NR HEY9814218.1 2364082 g263 i0 28.1 0.39039039039039 260 168 38 7 573 1331 11 258 HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 780 72 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28170179 28170179 PRJEB14803_P_NODE_42066_length_161_cov_0.944444_g41600_i0 PRJEB14803 42066 161 0.944444 1.52055484 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 98.6 4.5e-24   NR MBX9771135.1 2364082 g41600 i0 88.5 0.968944099378882 52 6 96.9 0 5 160 63 114 MBX9771135.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 156 98.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28643949 28643949 PRJEB14803_P_NODE_41247_length_162_cov_1.889764_g40781_i0 PRJEB14803 41247 162 1.889764 3.06141768 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 43.1 0.00907   NR MBC7998684.1 2052166 g40781 i0 34.7 0.907407407407407 49 32 90.7 0 9 155 714 762 MBC7998684.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 147 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
29875219 29875219 PRJEB14803_P_NODE_11051_length_382_cov_2.005764_g10586_i0 PRJEB14803 11051 382 2.005764 7.66201848 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 176 9.49e-52   NR MFN5538728.1 2052166 g10586 i0 65.1 3.91099476439791 126 44 99 0 378 1 179 304 MFN5538728.1 dihydroorotase [Candidatus Melainabacteria bacterium] diamond 1494 176 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria 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);;