RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1249042 · 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
4880198 4880198 PRJNA1249042_S_NODE_104464_length_158_cov_1.669565_g104250_i0 PRJNA1249042 104464 158 1.669565 2.6379127000000002 Nostoc 1177 Bacteria Bacteria 52.8 0.013   NTclustered gi|186463002|gb|CP001037.1| 63737 g104250 i0 100 0.708860759493671 28 0 18 0 42 69 7834513 7834486 Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome blastn 112 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc punctiforme
9282722 9282722 PRJNA1249042_S_NODE_40108_length_224_cov_1.751381_g39894_i0 PRJNA1249042 40108 224 1.751381 3.92309344 Gloeotrichia echinulata 212360 Bacteria Bacteria 52.8 0.02   NTclustered gi|2813986847|gb|CP170511.1| 3350243 g39894 i0 100 0.125 28 0 13 0 70 97 3607193 3607220 MAG: Gloeotrichia echinulata GP01 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Gloeotrichiaceae Gloeotrichia Gloeotrichia echinulata
14383939 14383939 PRJNA1249042_S_NODE_88532_length_170_cov_2.842520_g88318_i0 PRJNA1249042 88532 170 2.84252 4.832284 cyanobacterium endosymbiont of Rhopalodia gibberula 1763363 Bacteria Bacteria 171 3.7599999999999997e-38   NTclustered gi|1264230396|dbj|AP018341.1| 1763363 g88318 i0 88.079 87.5117647058824 151 9 86 7 1 147 1576145 1576000 Cyanobacterium endosymbiont of Rhopalodia gibberula DNA, complete genome, isolate: RgSB blastn 14877 171 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium endosymbiont of Rhopalodia gibberula
16931921 16931921 PRJNA1249042_S_NODE_65614_length_192_cov_1.845638_g65400_i0 PRJNA1249042 65614 192 1.845638 3.54362496 Leptolyngbya sp. 7M 2812896 Bacteria Bacteria 126 9.6e-25   NTclustered gi|2028908486|gb|CP070897.1| 2812896 g65400 i0 80.22 3.71875 182 25 92 10 10 185 2366807 2366983 Leptolyngbya sp. 7M chromosome blastn 714 126 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. 7M
20755795 20755795 PRJNA1249042_S_NODE_15817_length_278_cov_2.885106_g15603_i0 PRJNA1249042 15817 278 2.885106 8.02059468 Prochlorococcus marinus 1219 Bacteria Bacteria 54.7 0.007   NTclustered gi|2895549752|gb|CP138919.1| 1570015 g15603 i0 100 0.10431654676259 29 0 10 0 30 58 850389 850361 Prochlorococcus marinus str. MIT 1012 chromosome, complete genome blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus marinus

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