RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax_phylum = "Ignavibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ignavibacteriota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA669701 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27378387 27378387 PRJNA669701_P_NODE_87803_length_273_cov_1.045000_g87408_i0 PRJNA669701 87803 273 1.045 2.85285 FCB group 1783270 Bacteria Bacteria 45.1 0.00792   NR MBM2815029.1 2053306 g87408 i0 34.7 5.48351648351648 72 43 74.7 1 250 47 324 395 MBM2815029.1 helicase [Ignavibacteria bacterium] diamond 1497 45.4 0.993392070484582 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
28439790 28439790 PRJNA669701_P_NODE_77246_length_285_cov_1.783019_g76851_i0 PRJNA669701 77246 285 1.783019 5.08160415 Ignavibacteriales bacterium 2049428 Bacteria Bacteria 44.7 0.0129   NR MBI1933887.1 2049428 g76851 i0 29.3 2.75789473684211 92 64 95.8 1 280 8 282 373 MBI1933887.1 VCBS repeat-containing protein [Ignavibacteriales bacterium] diamond 786 44.7 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales     Ignavibacteriales bacterium
29387006 29387006 PRJNA669701_P_NODE_130369_length_244_cov_1.362573_g129974_i0 PRJNA669701 130369 244 1.362573 3.32467812 Ignavibacteria bacterium 2053306 Bacteria Bacteria 55.1 8.86e-8   NR HRE41040.1 2053306 g129974 i0 45.6 3.15983606557377 57 31 70.1 0 71 241 6 62 HRE41040.1 DUF2442 domain-containing protein [Ignavibacteria bacterium] diamond 771 55.1 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
29607474 29607474 PRJNA669701_P_NODE_122410_length_247_cov_0.885057_g122015_i0 PRJNA669701 122410 247 0.885057 2.18609079 Ignavibacteriales bacterium 2049428 Bacteria Bacteria 136 3.76e-35   NR HEX2866131.1 2049428 g122015 i0 78 0.995951417004049 82 18 99.6 0 2 247 556 637 HEX2866131.1 DNA methyltransferase [Ignavibacteriales bacterium] diamond 246 136 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales     Ignavibacteriales bacterium
31440389 31440389 PRJNA669701_P_NODE_144736_length_236_cov_2.171779_g144341_i0 PRJNA669701 144736 236 2.171779 5.12539844 Ignavibacteriaceae bacterium 2651163 Bacteria Bacteria 55.1 2.9e-7   NR MDR3666087.1 2651163 g144341 i0 35.1 1.90677966101695 74 44 89 1 212 3 1 74 MDR3666087.1 hypothetical protein [Ignavibacteriaceae bacterium] diamond 450 55.1 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae   Ignavibacteriaceae 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);;