RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA768450 · 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
2021317 2021317 PRJNA768450_P_NODE_682_length_397_cov_2.154891_g615_i0 PRJNA768450 682 397 2.154891 8.55491727 Leptolyngbya sp. 7M 2812896 Bacteria Bacteria 385 3.299999999999999e-102   NTclustered gi|2028908486|gb|CP070897.1| 2812896 g615 i0 84.383 99.8639798488665 397 56 99 6 3 397 3679744 3680136 Leptolyngbya sp. 7M chromosome blastn 39646 385 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. 7M
10949403 10949403 PRJNA768450_P_NODE_1669_length_191_cov_4.419753_g1597_i0 PRJNA768450 1669 191 4.419753 8.44172823 Cylindrospermum sp. NIES-4074 2005457 Bacteria Bacteria 342 8.699999999999999e-90   NTclustered gi|1210208533|dbj|AP018269.1| 2005457 g1597 i0 98.953 289.120418848168 191 2 100 0 1 191 2875726 2875536 Cylindrospermum sp. NIES-4074 DNA, nearly complete genome blastn 55222 342 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Cylindrospermum Cylindrospermum sp. NIES-4074
21147895 21147895 PRJNA768450_P_NODE_857_length_340_cov_6.299035_g786_i0 PRJNA768450 857 340 6.299035 21.416719 Nostoc sphaeroides 446679 Bacteria Bacteria 484 2.6699999999999994e-132   NTclustered gi|1770420796|gb|CP045226.1| 2653204 g786 i0 93.313 221.714705882353 329 20 96 2 5 331 3000482 3000154 Nostoc sphaeroides CCNUC1 chromosome Gxm1, complete sequence blastn 75383 484 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sphaeroides
22883966 22883966 PRJNA768450_S_NODE_24058_length_161_cov_1.562500_g24009_i0 PRJNA768450 24058 161 1.5625 2.515625 root 1 Root_unresolved Root_unresolved 291 2.6e-74   NTclustered gi|148723927|gb|EF520512.1| 1211 g24009 i0 100 106.204968944099 157 0 98 0 5 161 1198 1042 Uncultured cyanobacterium clone ADK-WYh02-15 16S ribosomal RNA gene, partial sequence blastn 17099 292 0.996575342465753 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium

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