RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA889065 · 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
1242239 1242239 PRJNA889065_S_NODE_8941_length_319_cov_1.851449_g8703_i0 PRJNA889065 8941 319 1.851449 5.90612231 Cyanophyceae 3028117 Bacteria Bacteria 523 5.269999999999999e-144   NTclustered gi|225696232|gb|FJ805899.1| 259957 g8703 i0 96.238 119.034482758621 319 12 100 0 1 319 2774 2456 Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 37972 523 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
9791222 9791222 PRJNA889065_S_NODE_12148_length_276_cov_1.974249_g11910_i0 PRJNA889065 12148 276 1.974249 5.44892724 Aliterella chasmolithica 2739056 Bacteria Bacteria 488 1.6299999999999995e-133   NTclustered gi|1713066352|gb|MN243145.1| 2599943 g11910 i0 98.551 183.094202898551 276 4 100 0 1 276 2142 2417 Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 50534 488 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella chasmolithica
11445998 11445998 PRJNA889065_S_NODE_26389_length_189_cov_1.465753_g26151_i0 PRJNA889065 26389 189 1.465753 2.77027317 Cyanophyceae 3028117 Bacteria Bacteria 350 5.14e-92   NTclustered gi|192337910|gb|EU751519.1| 1211 g26151 i0 100 99.989417989418 189 0 100 0 1 189 79 267 Uncultured cyanobacterium clone HK03-F07 16S ribosomal RNA gene, partial sequence blastn 18898 350 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
14891426 14891426 PRJNA889065_S_NODE_8412_length_328_cov_2.259649_g8174_i0 PRJNA889065 8412 328 2.259649 7.41164872 Prochlorococcus marinus 1219 Bacteria Bacteria 54.7 0.009   NTclustered gi|2417453599|gb|CP114781.1| 1570012 g8174 i0 96.875 0.0975609756097561 32 1 10 0 6 37 997237 997268 Prochlorococcus marinus str. MIT 0915 chromosome, complete genome blastn 32 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus marinus
18714688 18714688 PRJNA889065_S_NODE_16755_length_237_cov_3.572165_g16517_i0 PRJNA889065 16755 237 3.572165 8.46603105 Pleurocapsa sp. FMAR1 3040204 Bacteria Bacteria 52.8 0.021   NTclustered gi|2621703423|emb|OY762512.1| 3040204 g16517 i0 100 0.118143459915612 28 0 12 0 10 37 981024 981051 Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. FMAR1

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