RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA631796 · 4 ✖

analysis 1

  • diamond · 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
603332 603332 PRJNA631796_P_NODE_13201_length_201_cov_0.914286_g12923_i0 PRJNA631796 13201 201 0.914286 1.83771486 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 97.1 1.0899999999999999e-23   NR WP_250123675.1 155894 g12923 i0 96.2 1.55223880597015 52 2 77.6 0 1 156 104 155 WP_250123675.1 SsrA-binding protein SmpB [Chroococcidiopsis sp. CCMEE 29] diamond 312 97.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
3154225 3154225 PRJNA631796_P_NODE_11223_length_208_cov_1.700680_g10945_i0 PRJNA631796 11223 208 1.70068 3.5374144 Nostocales 1161 Bacteria Bacteria 134 9.77e-36   NR WP_015131394.1 99598 g10945 i0 94.1 23.5384615384615 68 4 98.1 0 3 206 230 297 WP_015131394.1 30S ribosomal protein S12 methylthiotransferase RimO [Calothrix sp. PCC 7507] diamond 4896 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 7507
27681473 27681473 PRJNA631796_P_NODE_11564_length_207_cov_0.876712_g11286_i0 PRJNA631796 11564 207 0.876712 1.81479384 unclassified Leptolyngbya 2650499 Bacteria Bacteria 87 3.22e-18   NR WP_347273178.1 2650499 g11286 i0 93.2 0.63768115942029 44 3 63.8 0 76 207 1 44 WP_347273178.1 MULTISPECIES: SUMF1/EgtB/PvdO family nonheme iron enzyme [unclassified Leptolyngbya] diamond 132 87 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya  
28028567 28028567 PRJNA631796_P_NODE_11525_length_207_cov_0.876712_g11247_i0 PRJNA631796 11525 207 0.876712 1.81479384 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 133 2.4099999999999993e-34   NR WP_106368697.1 2107693 g11247 i0 94.1 3.94202898550725 68 4 98.6 0 206 3 270 337 WP_106368697.1 DNA helicase PcrA [Chlorogloea sp. CCALA 695] diamond 816 133 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695

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