RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1022392 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
3989034 3989034 PRJNA1022392_P_NODE_68024_length_167_cov_2.050000_g67355_i0 PRJNA1022392 68024 167 2.05 3.4235 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 302 1.2600000000000001e-77   NTclustered gi|225696175|gb|FJ805842.1| 259957 g67355 i0 99.398 120.502994011976 166 1 99 0 2 167 2392 2227 Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 20124 302 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
3989129 3989129 PRJNA1022392_P_NODE_76264_length_160_cov_1.557522_g75595_i0 PRJNA1022392 76264 160 1.557522 2.4920352 Microcoleus vaginatus 119532 Bacteria Bacteria 189 9.69e-44   NTclustered gi|2212798032|gb|CP031740.1| 669365 g75595 i0 88.889 2.86875 153 17 96 0 1 153 2541873 2541721 Microcoleus vaginatus PCC 9802 chromosome, complete genome blastn 459 189 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus vaginatus
7814734 7814734 PRJNA1022392_P_NODE_41987_length_195_cov_3.932432_g41318_i0 PRJNA1022392 41987 195 3.932432 7.6682424 Stanieria sp. NIES-3757 1807358 Bacteria Bacteria 128 2.72e-25   NTclustered gi|1003382826|dbj|AP017375.1| 1807358 g41318 i0 89.899 1.33846153846154 99 10 51 0 96 194 293656 293558 Stanieria sp. NIES-3757 DNA, complete genome blastn 261 128 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria sp. NIES-3757
9932083 9932083 PRJNA1022392_P_NODE_73428_length_162_cov_2.113043_g72759_i0 PRJNA1022392 73428 162 2.113043 3.42312966 Nostocales 1161 Bacteria Bacteria 180 5.93e-41   NTclustered gi|1210177014|dbj|AP018248.1| 231146 g72759 i0 88.966 10.5308641975309 145 16 93 0 13 157 6272229 6272373 Tolypothrix tenuis PCC 7101 DNA, nearly complete genome blastn 1706 180 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Tolypothrichaceae Tolypothrix Tolypothrix tenuis

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