RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB12296" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12296 · 4 ✖

analysis 1

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
10223492 10223492 PRJEB12296_P_NODE_769_length_167_cov_4.528986_g756_i0 PRJEB12296 769 167 4.528986 7.56340662 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 268 1.28e-67   NTclustered gi|2245450207|gb|CP083761.1| 155894 g756 i0 95.783 166.479041916168 166 7 99 0 2 167 795226 795391 Chroococcidiopsis sp. CCMEE 29 chromosome blastn 27802 268 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
25500658 25500658 PRJEB12296_S_NODE_14265_length_160_cov_2.104000_g14233_i0 PRJEB12296 14265 160 2.104 3.3664 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 209 7.44e-50   NTclustered gi|225696268|gb|FJ805935.1| 259957 g14233 i0 91.447 233.44375 152 13 95 0 1 152 1573 1724 Uncultured Chroococcidiopsis sp. clone NA1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 37351 209 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
25878874 25878874 PRJEB12296_S_NODE_7939_length_183_cov_3.790541_g7907_i0 PRJEB12296 7939 183 3.790541 6.93669003 root 1 Root_unresolved Root_unresolved 71.3 4.3e-8   NTclustered gi|427988066|gb|CP003592.1| 82654 g7907 i0 97.619 30.551912568306 42 0 23 1 142 183 1761539 1761499 Pseudanabaena sp. PCC 7367, complete genome blastn 5591 71.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Thalassoporaceae Thalassoporum Thalassoporum mexicanum
26423154 26423154 PRJEB12296_S_NODE_2311_length_282_cov_6.890688_g2279_i0 PRJEB12296 2311 282 6.890688 19.43174016 root 1 Root_unresolved Root_unresolved 514 2.76e-141   NTclustered gi|338192687|gb|JF788700.1| 1211 g2279 i0 99.645 161.556737588652 282 0 99 1 1 281 405 124 Uncultured cyanobacterium clone ANSCYA_H05 16S ribosomal RNA gene, partial sequence blastn 45559 516 0.996124031007752 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);;