RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJDB12578" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 14 ✖

bioproject 1

  • PRJDB12578 · 14 ✖
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
2149 2149 PRJDB12578_S_NODE_148421_length_205_cov_0.987179_g125363_i0 PRJDB12578 148421 205 0.987179 2.02371695 Stanieria cyanosphaera 102116 Bacteria Bacteria 52.8 0.018   NTclustered gi|428267688|gb|CP003653.1| 111780 g125363 i0 100 0.136585365853659 28 0 14 0 127 154 1621004 1620977 Stanieria cyanosphaera PCC 7437, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
2554333 2554333 PRJDB12578_S_NODE_211923_length_163_cov_0.868421_g188865_i0 PRJDB12578 211923 163 0.868421 1.41552623 Oculatella lusitanica 2928764 Bacteria Bacteria 207 2.74e-49   NTclustered gi|1793889078|gb|MN061918.1| 2692086 g188865 i0 90.184 145.773006134969 163 11 98 4 1 160 2726 2566 Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 23761 207 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Oculatella Oculatella lusitanica
3830575 3830575 PRJDB12578_S_NODE_210544_length_163_cov_1.061404_g187486_i0 PRJDB12578 210544 163 1.061404 1.73008852 Leptolyngbya sp. NIES-3755 1752064 Bacteria Bacteria 302 1.22e-77   NTclustered gi|965629957|dbj|AP017308.1| 1752064 g187486 i0 100 130.159509202454 163 0 100 0 1 163 1243730 1243892 Leptolyngbya sp. NIES-3755 DNA, complete genome blastn 21216 302 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755
6381463 6381463 PRJDB12578_S_NODE_174346_length_182_cov_1.293233_g151288_i0 PRJDB12578 174346 182 1.293233 2.35368406 uncultured cyanobacterium 1211 Bacteria Bacteria 337 3.82e-88   NTclustered gi|386685926|gb|JQ612142.1| 1211 g151288 i0 100 101.521978021978 182 0 100 0 1 182 336 517 Uncultured cyanobacterium clone MSmat.3.13 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 18477 337 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
8634025 8634025 PRJDB12578_S_NODE_75507_length_434_cov_1.132468_g52457_i0 PRJDB12578 75507 434 1.132468 4.91491112 Calotrichaceae 2661849 Bacteria Bacteria 752 0   NTclustered gi|283766156|gb|GQ980023.1| 232991 g52457 i0 97.926 180.08064516129 434 9 100 0 1 434 2 435 Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence blastn 78155 758 0.992084432717678 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Dulcicalothrix Dulcicalothrix desertica
8928780 8928780 PRJDB12578_S_NODE_137848_length_216_cov_1.940120_g114790_i0 PRJDB12578 137848 216 1.94012 4.1906592 Leptolyngbya sp. BL-A-14 3104317 Bacteria Bacteria 287 4.799999999999999e-73   NTclustered gi|2804745243|gb|CP166621.1| 3104317 g114790 i0 91.08 139.069444444444 213 17 99 2 1 213 1777806 1778016 MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome blastn 30039 287 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. BL-A-14
12754736 12754736 PRJDB12578_S_NODE_122871_length_238_cov_1.523810_g99813_i0 PRJDB12578 122871 238 1.52381 3.6266678 Prochlorococcus sp. MIT 9314 3082534 Bacteria Bacteria 54.7 0.006   NTclustered gi|2895585218|gb|CP138950.1| 3082534 g99813 i0 100 0.121848739495798 29 0 12 0 61 89 1554072 1554100 Prochlorococcus sp. MIT 9314 chromosome, complete genome blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus sp. MIT 9314
15305617 15305617 PRJDB12578_S_NODE_184513_length_175_cov_0.809524_g161455_i0 PRJDB12578 184513 175 0.809524 1.416667 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 259 8.09e-65   NTclustered gi|225696249|gb|FJ805916.1| 259957 g161455 i0 93.678 103.851428571429 174 10 99 1 2 175 3085 2913 Uncultured Chroococcidiopsis sp. clone A1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 18174 259 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
16584830 16584830 PRJDB12578_S_NODE_87614_length_344_cov_1.633898_g64556_i0 PRJDB12578 87614 344 1.633898 5.62060912 Brasilonema sennae 1397703 Bacteria Bacteria 492 1.62e-134   NTclustered gi|1702166658|gb|CP030118.1| 415709 g64556 i0 92.69 154.049418604651 342 24 99 1 1 341 1167010 1167351 Brasilonema sennae CENA114 chromosome blastn 52993 492 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Brasilonema Brasilonema sennae
19126033 19126033 PRJDB12578_S_NODE_105656_length_275_cov_1.137168_g82598_i0 PRJDB12578 105656 275 1.137168 3.127212 Prochlorococcus sp. MIT 0604 1501268 Bacteria Bacteria 52.8 0.025   NTclustered gi|689266968|gb|CP007753.1| 1501268 g82598 i0 100 0.101818181818182 28 0 10 0 89 116 1272073 1272046 Prochlorococcus sp. MIT 0604, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus sp. MIT 0604
19133891 19133891 PRJDB12578_S_NODE_95976_length_306_cov_1.424125_g72918_i0 PRJDB12578 95976 306 1.424125 4.3578225 Woronichinia naegeliana 283820 Bacteria Bacteria 488 1.8399999999999996e-133   NTclustered gi|2307062866|gb|CP073041.1| 2824559 g72918 i0 95.724 156.359477124183 304 11 100 2 1 303 3381033 3381335 MAG: Woronichinia naegeliana WA131 chromosome, complete genome blastn 47846 488 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Coelosphaeriaceae Woronichinia Woronichinia naegeliana
21382994 21382994 PRJDB12578_S_NODE_212297_length_162_cov_2.106195_g189239_i0 PRJDB12578 212297 162 2.106195 3.4120359 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 54.7 0.004   NTclustered gi|413968727|gb|CP003284.1| 46234 g189239 i0 100 0.574074074074074 29 0 18 0 76 104 1735823 1735795 Anabaena sp. 90 chromosome chANA01, complete sequence blastn 93 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. 90
26715435 26715435 PRJDB12578_S_NODE_141681_length_212_cov_1.245399_g118623_i0 PRJDB12578 141681 212 1.245399 2.64024588 Pseudanabaena sp. 1153 Bacteria Bacteria 42 0.0465   NR MFN6068992.1 1153 g118623 i0 36 0.707547169811321 50 30 67.9 1 24 167 342 391 MFN6068992.1 leucine--tRNA ligase [Pseudanabaena sp.] diamond 150 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp.
32366248 32366248 PRJDB12578_S_NODE_119039_length_245_cov_1.479592_g95981_i0 PRJDB12578 119039 245 1.479592 3.6250004 Nostoc 1177 Bacteria Bacteria 42.4 0.0484   NR WP_190589176.1 1162 g95981 i0 43.9 1.00408163265306 41 23 50.2 0 83 205 186 226 WP_190589176.1 MULTISPECIES: Rpn family recombination-promoting nuclease/putative transposase [Nostocaceae] diamond 246 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae    

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