RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1011833 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
1430235 1430235 PRJNA1011833_S_NODE_41722_length_180_cov_1.255474_g41302_i0 PRJNA1011833 41722 180 1.255474 2.2598532 Microcystis aeruginosa 1126 Bacteria Bacteria 52.8 0.015   NTclustered gi|2924414|emb|AJ224715.1| 267867 g41302 i0 100 0.155555555555556 28 0 16 0 93 120 508 535 Microcystis aeruginosa gene encoding peptide synthetase, strain PCC7820, partial blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis aeruginosa
12909150 12909150 PRJNA1011833_S_NODE_47031_length_169_cov_1.142857_g46611_i0 PRJNA1011833 47031 169 1.142857 1.93142833 Calothrix sp. PCC 7716 2853227 Bacteria Bacteria 302 1.27e-77   NTclustered gi|2083844586|dbj|AP025018.1| 2853227 g46611 i0 98.817 290.940828402367 169 2 100 0 1 169 1857378 1857210 Calothrix sp. PCC 7716 DNA, complete genome blastn 49169 302 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 7716

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