RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA414036" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA414036 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28623161 28623161 PRJNA414036_P_NODE_46327_length_231_cov_2.954082_g44588_i0 PRJNA414036 46327 231 2.954082 6.82392942 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42.4 0.046   NR MDQ6786359.1 1978231 g44588 i0 95.5 0.285714285714286 22 1 28.6 0 10 75 104 125 MDQ6786359.1 TonB-dependent receptor [Acidobacteriota bacterium] diamond 66 42.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31356299 31356299 PRJNA414036_P_NODE_47156_length_231_cov_2.770408_g45417_i0 PRJNA414036 47156 231 2.770408 6.39964248 Pseudomonadati 3379134 Bacteria Bacteria 48.1 2.67e-4   NR WP_125485429.1 570835 g45417 i0 95 1.5974025974026 20 1 26 0 9 68 36 55 WP_125485429.1 YdeI/OmpD-associated family protein [Edaphobacter aggregans] diamond 369 48.5 0.991752577319588 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter aggregans
31672384 31672384 PRJNA414036_P_NODE_87237_length_152_cov_5.290598_g85498_i0 PRJNA414036 87237 152 5.290598 8.04170896 Pseudomonadati 3379134 Bacteria Bacteria 45.4 1.3e-4   NR ADI18656.1 710731 g85498 i0 64.7 2.78289473684211 34 12 67.1 0 106 5 31 64 ADI18656.1 hypothetical protein [uncultured Acidobacteria bacterium HF4000_26D02] diamond 423 45.8 0.991266375545852 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteria bacterium HF4000_26D02
31877047 31877047 PRJNA414036_P_NODE_51837_length_231_cov_1.897959_g50098_i0 PRJNA414036 51837 231 1.897959 4.38428529 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 45.1 0.0049   NR MFN0100876.1 2212468 g50098 i0 68.2 0.558441558441558 22 7 28.6 0 222 157 407 428 MFN0100876.1 hypothetical protein [Bryobacteraceae bacterium] diamond 129 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium

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