RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA630877 · 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
15180141 15180141 PRJNA630877_S_NODE_109312_length_207_cov_2.222892_g90175_i0 PRJNA630877 109312 207 2.222892 4.60138644 root 1 Root_unresolved Root_unresolved 383 5.65e-102   NTclustered gi|192337804|gb|EU751413.1| 1211 g90175 i0 100 99.6811594202899 207 0 100 0 1 207 690 484 Uncultured cyanobacterium clone SD-G09 16S ribosomal RNA gene, partial sequence blastn 20634 383 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
22829185 22829185 PRJNA630877_S_NODE_136038_length_171_cov_1.323077_g116901_i0 PRJNA630877 136038 171 1.323077 2.26246167 Bacteria 2 Bacteria Bacteria 311 2.14e-80   NTclustered gi|238544006|emb|FN298071.1| 1211 g116901 i0 99.415 100.076023391813 171 1 100 0 1 171 487 657 Uncultured cyanobacterium partial 16S rRNA gene, clone CAR-K11c-B8 blastn 17113 311 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
25378151 25378151 PRJNA630877_S_NODE_93200_length_245_cov_2.044118_g74063_i0 PRJNA630877 93200 245 2.044118 5.0080891 root 1 Root_unresolved Root_unresolved 340 4.209999999999999e-89   NTclustered gi|328835073|gb|JF508312.1| 1211 g74063 i0 98.953 96.3469387755102 191 1 78 1 54 244 12 201 Uncultured cyanobacterium clone AlertD10 16S ribosomal RNA gene, partial sequence blastn 23605 342 0.994152046783626 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);;