RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA559720" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA559720 · 3 ✖
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
5647328 5647328 PRJNA559720_P_NODE_12685_length_263_cov_1.231579_g12546_i0 PRJNA559720 12685 263 1.231579 3.23905277 Chroococcidiopsis thermalis 54299 Bacteria Bacteria 436 5.67e-118   NTclustered gi|428006994|gb|CP003597.1| 251229 g12546 i0 96.578 2 263 9 100 0 1 263 6072945 6072683 Chroococcidiopsis thermalis PCC 7203, complete genome blastn 526 436 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis thermalis
18395377 18395377 PRJNA559720_P_NODE_12415_length_267_cov_1.402062_g12276_i0 PRJNA559720 12415 267 1.402062 3.74350554 Trichocoleus desertorum 1481672 Bacteria Bacteria 422 1.62e-113   NTclustered gi|1373417991|gb|KY511275.1| 1382649 g12276 i0 95.131 222.164794007491 267 13 100 0 1 267 1462 1196 Trichocoleus desertorum ATA4-8-CV3 clone 10 23S ribosomal RNA gene, partial sequence; 23S-5S intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence blastn 59318 422 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Trichocoleusaceae Trichocoleus Trichocoleus desertorum
32576850 32576850 PRJNA559720_P_NODE_16559_length_228_cov_4.200000_g16420_i0 PRJNA559720 16559 228 4.2 9.576 Microcoleus sp. SU_5_3 2720482 Bacteria Bacteria 55.8 5.34e-7   NR NJK68502.1 2720482 g16420 i0 32.9 1.72368421052632 70 47 92.1 0 215 6 152 221 NJK68502.1 WD40 repeat domain-containing protein [Microcoleus sp. SU_5_3] diamond 393 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. SU_5_3

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