RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Beckwithiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Beckwithiibacteriota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1148190 · 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
29502050 29502050 PRJNA1148190_P_NODE_126610_length_468_cov_3.000000_g115447_i0 PRJNA1148190 126610 468 3 14.04 Candidatus Beckwithbacteria bacterium 2053519 Bacteria Bacteria 87 3.69e-17   NR NMC36624.1 2053519 g115447 i0 53.1 0.519230769230769 81 38 51.9 0 3 245 203 283 NMC36624.1 glycosyltransferase family 2 protein [Candidatus Beckwithbacteria bacterium] diamond 243 87 1 Bacteria Bacteria candidate phyla   Candidatus Beckwithiibacteriota         Candidatus Beckwithbacteria bacterium
29534904 29534904 PRJNA1148190_P_NODE_7630_length_4057_cov_4.899096_g3333_i1 PRJNA1148190 7630 4057 4.899096 198.75632472 Candidatus Beckwithbacteria bacterium CG1 2053519 Bacteria Bacteria 80.5 4.21e-11   NR PIS09646.1 1974495 g3333 i1 42.2 0.255854079368992 147 72 10.3 8 3617 3201 114 255 PIS09646.1 MAG: hypothetical protein COT75_00405 [Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10] diamond 1038 80.5 1 Bacteria Bacteria candidate phyla   Candidatus Beckwithiibacteriota         Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10
29850418 29850418 PRJNA1148190_P_NODE_588171_length_251_cov_0.865169_g576998_i0 PRJNA1148190 588171 251 0.865169 2.17157419 Candidatus Beckwithbacteria bacterium 2053519 Bacteria Bacteria 103 1.3299999999999999e-24   NR NMB56414.1 2053519 g576998 i0 59.5 1.00398406374502 84 33 99.2 1 3 251 24 107 NMB56414.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] diamond 252 103 1 Bacteria Bacteria candidate phyla   Candidatus Beckwithiibacteriota         Candidatus Beckwithbacteria bacterium
30766287 30766287 PRJNA1148190_P_NODE_421134_length_282_cov_1.368421_g409961_i0 PRJNA1148190 421134 282 1.368421 3.85894722 Candidatus Beckwithbacteria bacterium CG23_combo_of_CG 2053519 Bacteria Bacteria 110 5.9000000000000005e-27   NR PIP51780.1 1974498 g409961 i0 60.2 0.936170212765957 88 34 92.6 1 282 22 161 248 PIP51780.1 MAG: hypothetical protein COX09_05225 [Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_47_9] diamond 264 110 1 Bacteria Bacteria candidate phyla   Candidatus Beckwithiibacteriota         Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_47_9
32094078 32094078 PRJNA1148190_P_NODE_302178_length_319_cov_1.170732_g291005_i0 PRJNA1148190 302178 319 1.170732 3.73463508 Candidatus Beckwithbacteria bacterium 2053519 Bacteria Bacteria 72.8 2.57e-12   NR NMC36625.1 2053519 g291005 i0 42 0.940438871473354 100 57 93.1 1 305 9 339 438 NMC36625.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] diamond 300 72.8 1 Bacteria Bacteria candidate phyla   Candidatus Beckwithiibacteriota         Candidatus Beckwithbacteria 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);;