RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA832865" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 6 ✖

bioproject 1

  • PRJNA832865 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1228627 1228627 PRJNA832865_S_NODE_93241_length_252_cov_1.648045_g88155_i0 PRJNA832865 93241 252 1.648045 4.1530734 Planktothrix 54304 Bacteria Bacteria 52.8 0.023   NTclustered gi|224581510|gb|FJ184461.1| 603417 g88155 i0 100 0.333333333333333 28 0 11 0 225 252 564 537 Planktothrix mougeotii HAB3342 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; and RbcX (rbcX) gene, complete cds blastn 84 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix mougeotii
2099240 2099240 PRJNA832865_S_NODE_79082_length_276_cov_1.472906_g73996_i0 PRJNA832865 79082 276 1.472906 4.06522056 Cyanobacterium sp. HL-69 2054282 Bacteria Bacteria 52.8 0.025   NTclustered gi|1298149266|gb|CP024912.1| 2054282 g73996 i0 100 0.101449275362319 28 0 10 0 103 130 3042692 3042719 Cyanobacterium sp. HL-69 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium sp. HL-69
3374538 3374538 PRJNA832865_S_NODE_78963_length_276_cov_1.822660_g73877_i0 PRJNA832865 78963 276 1.82266 5.0305416 Gloeothece verrucosa 2546359 Bacteria Bacteria 54.7 0.007   NTclustered gi|306980173|gb|CP002198.1| 497965 g73877 i0 96.97 0.119565217391304 33 0 12 1 68 99 1255595 1255627 Cyanothece sp. PCC 7822, complete genome blastn 33 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Gloeothece Gloeothece verrucosa
4650479 4650479 PRJNA832865_S_NODE_103884_length_245_cov_0.895349_g98798_i0 PRJNA832865 103884 245 0.895349 2.19360505 Cyanobacterium stanieri 102235 Bacteria Bacteria 52.8 0.022   NTclustered gi|428686127|gb|CP003940.1| 292563 g98798 i0 100 0.114285714285714 28 0 11 0 146 173 1369336 1369309 Cyanobacterium stanieri PCC 7202, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium stanieri
9751154 9751154 PRJNA832865_S_NODE_42408_length_402_cov_1.291793_g37322_i0 PRJNA832865 42408 402 1.291793 5.19300786 Cyanobacterium stanieri 102235 Bacteria Bacteria 52.8 0.039   NTclustered gi|428686127|gb|CP003940.1| 292563 g37322 i0 100 0.0696517412935323 28 0 7 0 110 137 1369336 1369309 Cyanobacterium stanieri PCC 7202, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium stanieri
17402146 17402146 PRJNA832865_S_NODE_87354_length_261_cov_1.638298_g82268_i0 PRJNA832865 87354 261 1.638298 4.27595778 Synechocystis sp. PCC 7339 2782213 Bacteria Bacteria 52.8 0.024   NTclustered gi|2092583171|gb|CP063659.1| 2782213 g82268 i0 100 0.10727969348659 28 0 11 0 186 213 821098 821071 Synechocystis sp. PCC 7339 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7339

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);;