RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB6054" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 3 ✖

bioproject 1

  • PRJEB6054 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
25751912 25751912 PRJEB6054_S_NODE_8426_length_186_cov_1.682119_g8337_i0 PRJEB6054 8426 186 1.682119 3.12874134 Bacillati 1783272 Bacteria Bacteria 344 2.34e-90   NTclustered gi|355000455|gb|JN810743.1| 1211 g8337 i0 100 99.8172043010753 186 0 100 0 1 186 318 503 Uncultured cyanobacterium clone pr 4j 16S ribosomal RNA gene, partial sequence blastn 18566 344 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
25931124 25931124 PRJEB6054_S_NODE_11564_length_167_cov_7.522727_g11475_i0 PRJEB6054 11564 167 7.522727 12.56295409 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 265 1.65e-66   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g11475 i0 95.21 79.9461077844311 167 8 100 0 1 167 3682517 3682683 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 13351 265 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
25931402 25931402 PRJEB6054_S_NODE_6260_length_207_cov_1.860465_g6171_i0 PRJEB6054 6260 207 1.860465 3.85116255 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 198 2.2e-46   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g6171 i0 85.714 82.1062801932367 189 25 91 2 20 207 3681168 3680981 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 16996 198 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);;