RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA605033" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA605033 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
583176 583176 PRJNA605033_P_NODE_95901_length_222_cov_2.042781_g94332_i0 PRJNA605033 95901 222 2.042781 4.53497382 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 89.8 1.5e-13   NTclustered gi|2729058729|emb|OZ007029.1| 2137880 g94332 i0 96.296 41.0585585585586 54 2 24 0 1 54 1355027 1355080 MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1 blastn 9115 89.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
1857244 1857244 PRJNA605033_P_NODE_130482_length_216_cov_2.011050_g128913_i0 PRJNA605033 130482 216 2.01105 4.343868 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 122 1.43e-23   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g128913 i0 93.902 33.662037037037 82 4 38 1 45 126 1725669 1725589 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 7271 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
9510147 9510147 PRJNA605033_P_NODE_163028_length_184_cov_3.187919_g161459_i0 PRJNA605033 163028 184 3.187919 5.86577096 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 141 3.26e-29   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g161459 i0 92.157 4.26630434782609 102 4 57 4 19 120 2111077 2110980 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 785 141 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
17159594 17159594 PRJNA605033_P_NODE_171694_length_179_cov_2.243056_g170125_i0 PRJNA605033 171694 179 2.243056 4.01507024 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 148 1.8799999999999999e-31   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g170125 i0 83.333 0.905027932960894 162 25 90 2 4 164 3711612 3711452 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 162 148 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
17160769 17160769 PRJNA605033_P_NODE_60534_length_226_cov_1.958115_g58966_i0 PRJNA605033 60534 226 1.958115 4.4253399 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 117 7.03e-22   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g58966 i0 94.667 0.331858407079646 75 4 33 0 1 75 642076 642002 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 75 117 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);;