RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA971593 · 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
11470165 11470165 PRJNA971593_P_NODE_7189_length_453_cov_1.918421_g7040_i0 PRJNA971593 7189 453 1.918421 8.69044713 Leptolyngbya 47251 Bacteria Bacteria 760 0   NTclustered gi|757114186|dbj|AP014638.1| 411966 g7040 i0 96.909 257.9293598234 453 14 100 0 1 453 247928 247476 Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101 blastn 116842 760 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya boryana
20070885 20070885 PRJNA971593_P_NODE_19236_length_271_cov_1.757576_g19087_i0 PRJNA971593 19236 271 1.757576 4.76303096 Geminocystis sp. NIES-3709 1617448 Bacteria Bacteria 52.8 0.025   NTclustered gi|770470343|dbj|AP014821.1| 1617448 g19087 i0 96.774 0.114391143911439 31 1 11 0 88 118 3342870 3342900 Geminocystis sp. NIES-3709 DNA, complete genome blastn 31 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Geminocystis Geminocystis sp. NIES-3709
20070924 20070924 PRJNA971593_P_NODE_22236_length_251_cov_0.865169_g22087_i0 PRJNA971593 22236 251 0.865169 2.17157419 Leptolyngbya sp. NIES-3755 1752064 Bacteria Bacteria 442 1.1599999999999995e-119   NTclustered gi|965629957|dbj|AP017308.1| 1752064 g22087 i0 98.413 177.669322709163 252 3 100 1 1 251 1243927 1243676 Leptolyngbya sp. NIES-3755 DNA, complete genome blastn 44595 442 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755

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