RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA846486 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
2108678 2108678 PRJNA846486_P_NODE_30942_length_238_cov_1.915344_g30846_i0 PRJNA846486 30942 238 1.915344 4.55851872 Planktothrix agardhii 1160 Bacteria Bacteria 429 8.45e-116   NTclustered gi|2261168159|emb|LR882952.1| 1160 g30846 i0 99.16 10.9831932773109 238 2 100 0 1 238 220316 220079 Planktothrix agardhii strain No.976 genome assembly, chromosome: I blastn 2614 429 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
10159931 10159931 PRJNA846486_P_NODE_15808_length_316_cov_2.681648_g15712_i0 PRJNA846486 15808 316 2.681648 8.47400768 Planktothrix 54304 Bacteria Bacteria 584 2.359999999999999e-162   NTclustered gi|2261183531|emb|LR882963.1| 1160 g15712 i0 100 46.3354430379747 316 0 100 0 1 316 1935457 1935142 Planktothrix agardhii strain No.66 genome assembly, chromosome: I blastn 14642 584 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
11435234 11435234 PRJNA846486_P_NODE_52429_length_194_cov_2.262069_g52333_i0 PRJNA846486 52429 194 2.262069 4.38841386 Planktothrix 54304 Bacteria Bacteria 359 8.809999999999999e-95   NTclustered gi|2261196917|emb|LR882969.1| 1160 g52333 i0 100 154.654639175258 194 0 100 0 1 194 622745 622552 Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I blastn 30003 359 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
18684669 18684669 PRJNA846486_P_NODE_84875_length_165_cov_1.793103_g84779_i0 PRJNA846486 84875 165 1.793103 2.95861995 Chroococcidiopsis sp. CCMEE 010 2941234 Bacteria Bacteria 213 5.98e-51   NTclustered gi|2594665719|gb|OR413562.1| 2941234 g84779 i0 91.139 72.4727272727273 158 12 95 2 10 165 2340 2497 Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 11958 213 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 010
20357801 20357801 PRJNA846486_P_NODE_83756_length_166_cov_0.888889_g83660_i0 PRJNA846486 83756 166 0.888889 1.47555574 Bacillati 1783272 Bacteria Bacteria 122 1.0399999999999997e-23   NTclustered gi|2812421464|gb|CP120853.1| 2705319 g83660 i0 82.963 16.4277108433735 135 23 81 0 17 151 1402998 1402864 MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome blastn 2727 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus anatoxicus
24183044 24183044 PRJNA846486_P_NODE_95599_length_157_cov_2.407407_g95503_i0 PRJNA846486 95599 157 2.407407 3.77962899 Planktothrix 54304 Bacteria Bacteria 291 2.52e-74   NTclustered gi|2261196917|emb|LR882969.1| 1160 g95503 i0 100 177.063694267516 157 0 100 0 1 157 621930 621774 Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I blastn 27799 291 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
25458013 25458013 PRJNA846486_P_NODE_50160_length_198_cov_1.046980_g50064_i0 PRJNA846486 50160 198 1.04698 2.0730204 Planktothrix 54304 Bacteria Bacteria 366 5.4e-97   NTclustered gi|2261196917|emb|LR882969.1| 1160 g50064 i0 100 22.979797979798 198 0 100 0 1 198 4612338 4612141 Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I blastn 4550 366 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);;