RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA561138" 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 · 6 ✖

bioproject 1

  • PRJNA561138 · 6 ✖
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
3096078 3096078 PRJNA561138_P_NODE_26543_length_248_cov_0.880000_g26348_i0 PRJNA561138 26543 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 140 5.27e-38   NR WP_023069674.1 118322 g26348 i0 80.5 33.6653225806452 82 16 99.2 0 3 248 125 206 WP_023069674.1 alkene reductase [Lyngbya aestuarii] diamond 8349 141 0.99290780141844 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Lyngbya Lyngbya aestuarii
10749450 10749450 PRJNA561138_P_NODE_27609_length_246_cov_0.890173_g27414_i0 PRJNA561138 27609 246 0.890173 2.18982558 cyanobacterium NIES-36 2510787 Bacteria Bacteria 268 2.03e-67   NTclustered gi|1566846291|dbj|LC455671.1| 2510787 g27414 i0 86.64 176.788617886179 247 28 99 3 1 245 1426 1669 Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence blastn 43490 268 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium NIES-36
13299284 13299284 PRJNA561138_P_NODE_9191_length_417_cov_1.325581_g8996_i0 PRJNA561138 9191 417 1.325581 5.52767277 Anabaena sp. YBS01 2490939 Bacteria Bacteria 638 2.4199999999999997e-178   NTclustered gi|1772285456|gb|CP034058.1| 2490939 g8996 i0 94.853 69.6882494004796 408 21 98 0 10 417 5562080 5561673 Anabaena sp. YBS01 chromosome, complete genome blastn 29060 638 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. YBS01
14574017 14574017 PRJNA561138_P_NODE_20992_length_281_cov_1.384615_g20797_i0 PRJNA561138 20992 281 1.384615 3.89076815 Anabaena sp. YBS01 2490939 Bacteria Bacteria 435 2.1999999999999994e-117   NTclustered gi|1772285456|gb|CP034058.1| 2490939 g20797 i0 94.662 1.43060498220641 281 14 100 1 1 281 5565217 5564938 Anabaena sp. YBS01 chromosome, complete genome blastn 402 435 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. YBS01
15847946 15847946 PRJNA561138_P_NODE_25053_length_250_cov_0.870056_g24858_i0 PRJNA561138 25053 250 0.870056 2.17514 Anabaena sp. YBS01 2490939 Bacteria Bacteria 379 9.139999999999998e-101   NTclustered gi|1772285456|gb|CP034058.1| 2490939 g24858 i0 94 1 250 15 100 0 1 250 5561718 5561469 Anabaena sp. YBS01 chromosome, complete genome blastn 250 379 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. YBS01
31027112 31027112 PRJNA561138_P_NODE_25435_length_250_cov_0.864407_g25240_i0 PRJNA561138 25435 250 0.864407 2.1610175 Leptolyngbya sp. 47254 Bacteria Bacteria 43.5 0.0222   NR MEB3269333.1 47254 g25240 i0 40.7 0.648 54 30 64.8 1 222 61 169 220 MEB3269333.1 glycosyltransferase family 39 protein [Leptolyngbya sp.] diamond 162 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp.

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