RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB50332 · 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
119456 119456 PRJEB50332_P_NODE_17421_length_203_cov_0.915493_g17339_i0 PRJEB50332 17421 203 0.915493 1.85845079 Nostoc sp. C052 2576902 Bacteria Bacteria 276 9.64e-70   NTclustered gi|1866639087|gb|CP040272.1| 2576902 g17339 i0 91.133 33.8472906403941 203 18 100 0 1 203 1211147 1210945 Nostoc sp. C052 chromosome, complete genome blastn 6871 276 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. C052
2266527 2266527 PRJEB50332_P_NODE_1822_length_416_cov_1.163380_g1741_i0 PRJEB50332 1822 416 1.16338 4.8396608 Synechococcales 1890424 Bacteria Bacteria 680 0   NTclustered gi|146740641|emb|AM709628.1| 115743 g1741 i0 96.386 191.745192307692 415 11 99 2 2 416 4374 3964 Synechococcus sp. PCC 7009 partial ribosomal RNA operon, strain PCC 7009 blastn 79766 686 0.991253644314869 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. PCC 7009
4819181 4819181 PRJEB50332_P_NODE_1324_length_477_cov_1.560096_g1243_i0 PRJEB50332 1324 477 1.560096 7.44165792 Cyanobium 167375 Bacteria Bacteria 870 0   NTclustered gi|146740641|emb|AM709628.1| 115743 g1243 i0 99.582 176.40251572327 478 1 100 1 1 477 2953 2476 Synechococcus sp. PCC 7009 partial ribosomal RNA operon, strain PCC 7009 blastn 84144 876 0.993150684931507 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. PCC 7009
10322400 10322400 PRJEB50332_P_NODE_3709_length_305_cov_2.065574_g3627_i0 PRJEB50332 3709 305 2.065574 6.3000007 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 327 4.219999999999999e-85   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g3627 i0 86.532 482.780327868852 297 40 97 0 9 305 3680247 3680543 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 147248 327 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
13744670 13744670 PRJEB50332_P_NODE_1371_length_467_cov_2.435961_g1290_i0 PRJEB50332 1371 467 2.435961 11.37593787 Tolypothrichaceae 119859 Bacteria Bacteria 813 0   NTclustered gi|521763816|gb|KC463682.1| 1211 g1290 i0 98.081 104.443254817987 469 5 100 3 1 467 342 808 Uncultured cyanobacterium clone BkfYyy_700 16S ribosomal RNA gene, partial sequence blastn 48775 813 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
21393375 21393375 PRJEB50332_P_NODE_2997_length_333_cov_1.536765_g2915_i0 PRJEB50332 2997 333 1.536765 5.11742745 root 1 Root_unresolved Root_unresolved 616 8.87e-172   NTclustered gi|213389485|gb|FJ024312.1| 1211 g2915 i0 100 100 333 0 100 0 1 333 736 404 Uncultured cyanobacterium clone 3 16S ribosomal RNA gene, partial sequence blastn 33300 616 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
23071549 23071549 PRJEB50332_P_NODE_9319_length_228_cov_1.556886_g9237_i0 PRJEB50332 9319 228 1.556886 3.54970008 Nostocales cyanobacterium HT-58-2 1940762 Bacteria Bacteria 165 2.4999999999999997e-36   NTclustered gi|1199827411|gb|CP019636.1| 1940762 g9237 i0 81.373 1.75438596491228 204 36 89 2 1 203 3129433 3129231 Nostocales cyanobacterium HT-58-2 chromosome, complete genome blastn 400 165 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales     Nostocales cyanobacterium HT-58-2

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