RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA798511" 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 · 5 ✖

bioproject 1

  • PRJNA798511 · 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
3769460 3769460 PRJNA798511_P_NODE_87303_length_252_cov_1.648045_g83037_i0 PRJNA798511 87303 252 1.648045 4.1530734 Planktothrix 54304 Bacteria Bacteria 52.8 0.023   NTclustered gi|224581510|gb|FJ184461.1| 603417 g83037 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
8444173 8444173 PRJNA798511_P_NODE_86447_length_254_cov_1.276243_g82181_i0 PRJNA798511 86447 254 1.276243 3.24165722 Cyanobacterium stanieri 102235 Bacteria Bacteria 52.8 0.023   NTclustered gi|428686127|gb|CP003940.1| 292563 g82181 i0 100 0.110236220472441 28 0 11 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
13544659 13544659 PRJNA798511_P_NODE_82571_length_261_cov_1.638298_g78305_i0 PRJNA798511 82571 261 1.638298 4.27595778 Synechocystis sp. PCC 7339 2782213 Bacteria Bacteria 52.8 0.024   NTclustered gi|2092583171|gb|CP063659.1| 2782213 g78305 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
19917875 19917875 PRJNA798511_P_NODE_79776_length_267_cov_1.494845_g75510_i0 PRJNA798511 79776 267 1.494845 3.99123615 Cyanobacterium sp. HL-69 2054282 Bacteria Bacteria 52.8 0.024   NTclustered gi|1298149266|gb|CP024912.1| 2054282 g75510 i0 100 0.104868913857678 28 0 10 0 147 174 3042719 3042692 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
21193475 21193475 PRJNA798511_P_NODE_77857_length_271_cov_1.939394_g73591_i0 PRJNA798511 77857 271 1.939394 5.25575774 Gloeothece verrucosa 2546359 Bacteria Bacteria 54.7 0.007   NTclustered gi|306980173|gb|CP002198.1| 497965 g73591 i0 96.97 0.121771217712177 33 0 12 1 78 109 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

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