RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA508758 · 3 ✖

analysis 1

  • diamond · 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
28024782 28024782 PRJNA508758_P_NODE_78645_length_248_cov_0.880000_g77597_i0 PRJNA508758 78645 248 0.88 2.1824 Leptolyngbya boryana 1184 Bacteria Bacteria 147 4.3499999999999997e-39   NR WP_316427949.1 1184 g77597 i0 90.2 1.98387096774194 82 8 99.2 0 248 3 328 409 WP_316427949.1 SLBB domain-containing protein [Leptolyngbya boryana] diamond 492 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya boryana
28466886 28466886 PRJNA508758_P_NODE_82906_length_245_cov_0.895349_g81858_i0 PRJNA508758 82906 245 0.895349 2.19360505 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 147 8.24e-41   NR WP_009634148.1 927677 g81858 i0 91.4 0.991836734693878 81 7 99.2 0 2 244 151 231 WP_009634148.1 glycosyltransferase family 4 protein [Synechocystis sp. PCC 7509] diamond 243 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
31150936 31150936 PRJNA508758_P_NODE_26415_length_392_cov_1.153605_g25367_i0 PRJNA508758 26415 392 1.153605 4.5221316 Desmonostoc geniculatum 1874532 Bacteria Bacteria 216 1.02e-62   NR MBW4677809.1 1874567 g25367 i0 80 0.994897959183674 130 26 99.5 0 3 392 158 287 MBW4677809.1 DDE-type integrase/transposase/recombinase [Desmonostoc geniculatum HA4340-LM1] diamond 390 216 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Desmonostoc Desmonostoc geniculatum

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