RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA395690 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_clade 0

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
27991479 27991479 PRJNA395690_P_NODE_30825_length_165_cov_0.879310_g30673_i0 PRJNA395690 30825 165 0.87931 1.4508615 Armatimonadota bacterium 2033014 Bacteria Bacteria 75.5 1.53e-14   NR MES2462291.1 2033014 g30673 i0 74.5 0.927272727272727 51 13 92.7 0 9 161 167 217 MES2462291.1 pirin family protein [Armatimonadota bacterium] diamond 153 75.5 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
28149313 28149313 PRJNA395690_P_NODE_17425_length_194_cov_1.662069_g17273_i0 PRJNA395690 17425 194 1.662069 3.22441386 Armatimonadota bacterium 2033014 Bacteria Bacteria 78.2 4.53e-16   NR MER3462571.1 2033014 g17273 i0 54 0.974226804123711 63 29 97.4 0 4 192 22 84 MER3462571.1 hypothetical protein [Armatimonadota bacterium] diamond 189 78.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
28149327 28149327 PRJNA395690_P_NODE_35525_length_161_cov_1.366071_g35373_i0 PRJNA395690 35525 161 1.366071 2.19937431 Armatimonadota bacterium 2033014 Bacteria Bacteria 59.3 5.37e-9   NR MER3462571.1 2033014 g35373 i0 66.7 2.21739130434783 39 13 72.7 0 16 132 142 180 MER3462571.1 hypothetical protein [Armatimonadota bacterium] diamond 357 59.3 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
29885970 29885970 PRJNA395690_P_NODE_2491_length_495_cov_2.013453_g2343_i0 PRJNA395690 2491 495 2.013453 9.96659235 Armatimonadota bacterium 2033014 Bacteria Bacteria 117 1.81e-29   NR MBI3945553.1 2033014 g2343 i0 41.4 0.951515151515152 157 92 95.2 0 475 5 41 197 MBI3945553.1 hypothetical protein [Armatimonadota bacterium] diamond 471 117 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31149180 31149180 PRJNA395690_P_NODE_5175_length_350_cov_1.342193_g5026_i0 PRJNA395690 5175 350 1.342193 4.6976755 Armatimonadota bacterium 2033014 Bacteria Bacteria 46.6 0.00519   NR MCH8979472.1 2033014 g5026 i0 39.7 0.625714285714286 73 34 54 1 242 54 80 152 MCH8979472.1 NADH-quinone oxidoreductase subunit H [Armatimonadota bacterium] diamond 219 46.6 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31275981 31275981 PRJNA395690_P_NODE_13695_length_220_cov_1.192982_g13543_i0 PRJNA395690 13695 220 1.192982 2.6245604 Capsulimonas corticalis 2219043 Bacteria Bacteria 74.3 1.6e-13   NR WP_119322789.1 2219043 g13543 i0 65.5 4.8 58 19 77.7 1 2 172 300 357 WP_119322789.1 WGR domain-containing protein [Capsulimonas corticalis] diamond 1056 74.3 1 Bacteria   Bacillati Armatimonadota Armatimonadia Capsulimonadales Capsulimonadaceae Capsulimonas Capsulimonas corticalis

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