RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Candidatus Ryaniibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Ryaniibacteriota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA340009 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_kingdom 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
27864245 27864245 PRJNA340009_P_NODE_24025_length_249_cov_13.905000_g23718_i0 PRJNA340009 24025 249 13.905 34.62345 Candidatus Ryanbacteria bacterium RIFCSPHIGHO2_ 2518621 Bacteria Bacteria 105 4.22e-25   NR OGZ46612.1 1802117 g23718 i0 67.9 0.975903614457831 81 25 96.4 1 243 4 2 82 OGZ46612.1 MAG: hypothetical protein A3J54_01075 [Candidatus Ryanbacteria bacterium RIFCSPHIGHO2_02_FULL_45_13b] diamond 243 105 1 Bacteria Bacteria candidate phyla   Candidatus Ryaniibacteriota         Candidatus Ryanbacteria bacterium RIFCSPHIGHO2_02_FULL_45_13b
29948393 29948393 PRJNA340009_P_NODE_33571_length_216_cov_9.293413_g33264_i0 PRJNA340009 33571 216 9.293413 20.07377208 Candidatus Ryanbacteria bacterium CG1 2518621 Bacteria Bacteria 116 4.8399999999999996e-32   NR PJE64726.1 1974864 g33264 i0 85.7 0.972222222222222 70 10 97.2 0 215 6 13 82 PJE64726.1 MAG: hypothetical protein COU90_00425 [Candidatus Ryanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_43_42] diamond 210 116 1 Bacteria Bacteria candidate phyla   Candidatus Ryaniibacteriota         Candidatus Ryanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_43_42
31703800 31703800 PRJNA340009_P_NODE_45397_length_190_cov_7.304965_g45090_i0 PRJNA340009 45397 190 7.304965 13.8794335 Bacillati 1783272 Bacteria Bacteria 75.5 3.25e-15   NR PJE64061.1 1974864 g45090 i0 60 1.76842105263158 55 22 86.8 0 183 19 52 106 PJE64061.1 MAG: hypothetical protein COU90_04290 [Candidatus Ryanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_43_42] diamond 336 75.9 0.994729907773386 Bacteria Bacteria candidate phyla   Candidatus Ryaniibacteriota         Candidatus Ryanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_43_42
32319684 32319684 PRJNA340009_P_NODE_26739_length_238_cov_7.238095_g26432_i0 PRJNA340009 26739 238 7.238095 17.2266661 Candidatus Ryanbacteria bacterium RIFCSPHIGHO2_ 2518621 Bacteria Bacteria 58.2 1.29e-7   NR OGZ45136.1 1802115 g26432 i0 36.4 0.970588235294118 77 49 97.1 0 238 8 88 164 OGZ45136.1 MAG: hypothetical protein A2756_03370 [Candidatus Ryanbacteria bacterium RIFCSPHIGHO2_01_FULL_48_27] diamond 231 58.2 1 Bacteria Bacteria candidate phyla   Candidatus Ryaniibacteriota         Candidatus Ryanbacteria bacterium RIFCSPHIGHO2_01_FULL_48_27
32319720 32319720 PRJNA340009_P_NODE_64199_length_166_cov_0.871795_g63892_i0 PRJNA340009 64199 166 0.871795 1.4471797 Candidatus Ryanbacteria bacterium RIFCSPLOWO2_ 2518621 Bacteria Bacteria 70.1 3.33e-14   NR OGZ52781.1 1802126 g63892 i0 77.5 0.72289156626506 40 9 72.3 0 165 46 34 73 OGZ52781.1 MAG: preprotein translocase subunit SecG [Candidatus Ryanbacteria bacterium RIFCSPLOWO2_01_FULL_48_26] diamond 120 70.1 1 Bacteria Bacteria candidate phyla   Candidatus Ryaniibacteriota         Candidatus Ryanbacteria bacterium RIFCSPLOWO2_01_FULL_48_26

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