RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA975724 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1266808 1266808 PRJNA975724_S_NODE_61_length_1931_cov_9.102260_g53_i0 PRJNA975724 61 1931 9.10226 175.7646406 Cyanophyceae 3028117 Bacteria Bacteria 2490 0   NTclustered gi|427983362|gb|CP003591.1| 1173025 g53 i0 90.245 184.563438632833 1917 171 99 13 1 1908 239856 237947 Geitlerinema sp. PCC 7407 chromosome, complete genome blastn 356392 2507 0.993218986836857 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Geitlerinematales Geitlerinemataceae Geitlerinema Geitlerinema sp. PCC 7407
14020608 14020608 PRJNA975724_S_NODE_16611_length_403_cov_6.412121_g16430_i0 PRJNA975724 16611 403 6.412121 25.84084763 Leptolyngbya 47251 Bacteria Bacteria 584 3.079999999999999e-162   NTclustered gi|965629957|dbj|AP017308.1| 1752064 g16430 i0 92.822 181.578163771712 404 27 100 2 1 403 1243806 1244208 Leptolyngbya sp. NIES-3755 DNA, complete genome blastn 73176 584 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755
16248374 16248374 PRJNA975724_S_NODE_16793_length_402_cov_5.389058_g16612_i0 PRJNA975724 16793 402 5.389058 21.66401316 Leptolyngbya sp. 7M 2812896 Bacteria Bacteria 141 8.000000000000001e-29   NTclustered gi|2028908486|gb|CP070897.1| 2812896 g16612 i0 80.097 3.96766169154229 206 27 50 9 74 274 2367003 2366807 Leptolyngbya sp. 7M chromosome blastn 1595 141 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. 7M
18798215 18798215 PRJNA975724_S_NODE_50655_length_296_cov_1.381166_g50474_i0 PRJNA975724 50655 296 1.381166 4.08825136 Kovacikia minuta 2931930 Bacteria Bacteria 52.8 0.027   NTclustered gi|2098452651|gb|CP083582.1| 2653194 g50474 i0 100 0.0945945945945946 28 0 9 0 155 182 3805526 3805553 Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Kovacikia Kovacikia minuta

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