RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 9 ✖

bioproject 1

  • PRJNA753704 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
5834612 5834612 PRJNA753704_P_NODE_19685_length_274_cov_0.925373_g19324_i0 PRJNA753704 19685 274 0.925373 2.53552202 Picosynechococcus sp. PCC 7003 374981 Bacteria Bacteria 331 2.89e-86   NTclustered gi|2275105|emb|X97393.1| 374981 g19324 i0 91.057 23.6386861313869 246 20 89 2 28 272 4 248 Synechococcus sp. rnpB gene, strain PCC7003 blastn 6477 331 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Picosynechococcus Picosynechococcus sp. PCC 7003
7109645 7109645 PRJNA753704_P_NODE_11386_length_351_cov_1.122302_g11025_i0 PRJNA753704 11386 351 1.122302 3.93928002 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 353 8.12e-93   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g11025 i0 85.714 0.977207977207977 343 39 97 8 1 339 2647202 2647538 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 343 353 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
8384446 8384446 PRJNA753704_P_NODE_30967_length_208_cov_4.881481_g30606_i0 PRJNA753704 30967 208 4.881481 10.15348048 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 340 3.4699999999999996e-89   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g30606 i0 96.154 2.03365384615385 208 8 100 0 1 208 3682437 3682230 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 423 340 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
8384452 8384452 PRJNA753704_P_NODE_327_length_1751_cov_25.941001_g212_i0 PRJNA753704 327 1751 25.941001 454.22692751 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 1873 0   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g212 i0 86.11 146.216447744146 1771 209 100 35 1 1751 3682673 3680920 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 256025 1873 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
8384455 8384455 PRJNA753704_P_NODE_347_length_1691_cov_22.076638_g212_i1 PRJNA753704 347 1691 22.076638 373.31594858 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 1831 0   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g212 i1 86.276 145.948551153164 1705 210 100 21 1 1691 3680979 3682673 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 246799 1831 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
17779735 17779735 PRJNA753704_P_NODE_17874_length_285_cov_7.650943_g17513_i0 PRJNA753704 17874 285 7.650943 21.80518755 root 1 Root_unresolved Root_unresolved 503 6.049999999999998e-138   NTclustered gi|469665367|gb|KC545738.1| 1211 g17513 i0 98.932 113.228070175439 281 3 99 0 2 282 873 593 Uncultured cyanobacterium clone BFB532 16S ribosomal RNA gene, partial sequence blastn 32270 503 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
17779796 17779796 PRJNA753704_P_NODE_25814_length_248_cov_0.891429_g25453_i0 PRJNA753704 25814 248 0.891429 2.21074392 Microcoleus 44471 Bacteria Bacteria 448 2.4499999999999996e-121   NTclustered gi|1804756945|gb|MT013207.1| 2705320 g25453 i0 99.194 174.125 248 2 100 0 1 248 1893 2140 Microcoleus anatoxicus PTRS1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 43183 448 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus anatoxicus
21133731 21133731 PRJNA753704_P_NODE_617_length_1324_cov_12.866507_g426_i0 PRJNA753704 617 1324 12.866507 170.35255268 Limnospira platensis 118562 Bacteria Bacteria 1552 0   NTclustered gi|83777317|gb|DQ120927.1| 357682 g426 i0 100 10.929003021148 840 0 63 0 1 840 840 1 Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds blastn 14470 1552 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
23684140 23684140 PRJNA753704_P_NODE_2959_length_644_cov_12.119089_g2606_i0 PRJNA753704 2959 644 12.119089 78.04693316 Limnospira platensis 118562 Bacteria Bacteria 708 0   NTclustered gi|83777317|gb|DQ120927.1| 357682 g2606 i0 99.741 7.93012422360248 386 1 60 0 1 386 831 1216 Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds blastn 5107 708 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis

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