RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1008624 · 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
4829375 4829375 PRJNA1008624_P_NODE_8104_length_294_cov_1.130612_g7916_i0 PRJNA1008624 8104 294 1.130612 3.32399928 Oscillatoriales 1150 Bacteria Bacteria 532 7.989999999999998e-147   NTclustered gi|1241187607|dbj|LC319764.1| 1160 g7916 i0 99.656 113.826530612245 291 1 99 0 1 291 848 558 Planktothrix agardhii gene for 16S ribosomal RNA, partial sequence, strain: NIES-1265 blastn 33465 532 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
12908065 12908065 PRJNA1008624_P_NODE_28591_length_168_cov_0.873950_g28403_i0 PRJNA1008624 28591 168 0.87395 1.468236 Leptolyngbya sp. NK1-12 2547451 Bacteria Bacteria 52.8 0.014   NTclustered gi|2591945363|gb|CP053586.1| 2547451 g28403 i0 100 0.166666666666667 28 0 17 0 44 71 1631016 1631043 Leptolyngbya sp. NK1-12 chromosome 1, complete sequence blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NK1-12
13754770 13754770 PRJNA1008624_P_NODE_7391_length_308_cov_3.289575_g7203_i0 PRJNA1008624 7391 308 3.289575 10.131891 Gloeocapsopsis 693222 Bacteria Bacteria 462 1.12e-125   NTclustered gi|1142095202|gb|KU847399.1| 1433147 g7203 i0 93.851 105.366883116883 309 15 100 2 1 308 3648 3343 Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence blastn 32453 462 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsopsis Gloeocapsopsis dulcis
16730916 16730916 PRJNA1008624_P_NODE_15734_length_213_cov_3.030488_g15546_i0 PRJNA1008624 15734 213 3.030488 6.45493944 Brasilonema sennae 1397703 Bacteria Bacteria 327 2.78e-85   NTclustered gi|1702166658|gb|CP030118.1| 415709 g15546 i0 94.762 114.164319248826 210 11 99 0 1 210 1168419 1168628 Brasilonema sennae CENA114 chromosome blastn 24317 327 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Brasilonema Brasilonema sennae
17579225 17579225 PRJNA1008624_P_NODE_8774_length_282_cov_2.549356_g8586_i0 PRJNA1008624 8774 282 2.549356 7.18918392 root 1 Root_unresolved Root_unresolved 512 9.93e-141   NTclustered gi|781846478|emb|LN807669.1| 1211 g8586 i0 99.643 101.322695035461 280 1 99 0 1 280 280 1 Uncultured cyanobacterium partial 16S rRNA gene, clone FJ628262 blastn 28573 514 0.996108949416342 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
25227562 25227562 PRJNA1008624_P_NODE_24620_length_176_cov_1.614173_g24432_i0 PRJNA1008624 24620 176 1.614173 2.84094448 Planktothrix 54304 Bacteria Bacteria 320 3.69e-83   NTclustered gi|2261196917|emb|LR882969.1| 1160 g24432 i0 100 153.5 173 0 98 0 4 176 622157 621985 Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I blastn 27016 320 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii

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