RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA835051 · 3 ✖

analysis 1

  • blastn · 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
2101627 2101627 PRJNA835051_S_NODE_48882_length_218_cov_2.171429_g48586_i0 PRJNA835051 48882 218 2.171429 4.73371522 uncultured Rivularia sp. 447564 Bacteria Bacteria 52.8 0.019   NTclustered gi|2621703013|emb|OY762007.1| 447564 g48586 i0 100 0.128440366972477 28 0 13 0 2 29 8263514 8263541 MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia uncultured Rivularia sp.
7607346 7607346 PRJNA835051_S_NODE_115646_length_159_cov_1.620690_g115350_i0 PRJNA835051 115646 159 1.62069 2.5768971 Oscillatoriales 1150 Bacteria Bacteria 294 1.98e-75   NTclustered gi|1566846289|dbj|LC455669.1| 118562 g115350 i0 100 171.22641509434 159 0 100 0 1 159 32 190 Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence blastn 27225 294 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
12305770 12305770 PRJNA835051_S_NODE_85350_length_180_cov_2.065693_g85054_i0 PRJNA835051 85350 180 2.065693 3.7182474 uncultured Rivularia sp. 447564 Bacteria Bacteria 69.4 1.52e-7   NTclustered gi|2621703013|emb|OY762007.1| 447564 g85054 i0 95.455 66.3611111111111 44 1 24 1 137 180 8260939 8260897 MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1 blastn 11945 69.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia uncultured Rivularia sp.

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