RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA753112" 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

  • PRJNA753112 · 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
4557490 4557490 PRJNA753112_P_NODE_28544_length_254_cov_1.138122_g28202_i0 PRJNA753112 28544 254 1.138122 2.89082988 Synechococcus sp. A10-1-5-1 2936507 Bacteria Bacteria 63.9 1.07e-5   NTclustered gi|2230632934|gb|CP096032.1| 2936507 g28202 i0 93.023 0.464566929133858 43 3 17 0 81 123 2154291 2154333 Synechococcus sp. A10-1-5-1 chromosome, complete genome blastn 118 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. A10-1-5-1
21131404 21131404 PRJNA753112_P_NODE_16317_length_336_cov_1.258555_g15975_i0 PRJNA753112 16317 336 1.258555 4.2287448 Synechococcus sp. CB0101 232348 Bacteria Bacteria 52.8 0.032   NTclustered gi|1626690261|gb|CP039373.1| 232348 g15975 i0 100 0.0833333333333333 28 0 8 0 161 188 1687046 1687073 Synechococcus sp. CB0101 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CB0101
24955703 24955703 PRJNA753112_P_NODE_32060_length_245_cov_1.813953_g31718_i0 PRJNA753112 32060 245 1.813953 4.44418485 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 448 2.41e-121   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g31718 i0 99.592 73.1673469387755 245 1 100 0 1 245 3680916 3681160 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 17926 448 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);;