RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA666695", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Magasanikiibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Magasanikiibacteriota · 3 ✖

tax_clade 1

  • Bacteria candidate phyla · 3 ✖

bioproject 1

  • PRJNA666695 · 3 ✖

analysis 1

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
632474 632474 PRJNA666695_S_NODE_42481_length_312_cov_9.335793_g41387_i0 PRJNA666695 42481 312 9.335793 29.12767416 root 1 Root_unresolved Root_unresolved 103 1.41e-25   NR HOX61061.1 2026717 g41387 i0 58.6 6.35576923076923 87 35 83.7 1 46 306 86 171 HOX61061.1 SET domain-containing protein-lysine N-methyltransferase [Candidatus Magasanikiibacteriota bacterium] diamond 1983 104 0.990384615384615 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
30745050 30745050 PRJNA666695_S_NODE_29294_length_359_cov_12.314465_g28201_i0 PRJNA666695 29294 359 12.314465 44.20892935 Candidatus Magasanikiibacteriota bacterium 2026717 Bacteria Bacteria 118 2.19e-28   NR MBP9732021.1 2026717 g28201 i0 53.3 2.90807799442897 120 54 98.6 1 356 3 368 487 MBP9732021.1 F0F1 ATP synthase subunit alpha [Candidatus Magasanikiibacteriota bacterium] diamond 1044 118 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikiibacteriota bacterium
32496639 32496639 PRJNA666695_S_NODE_52099_length_289_cov_2.024194_g51005_i0 PRJNA666695 52099 289 2.024194 5.84992066 Bacillati 1783272 Bacteria Bacteria 43.1 0.0477   NR KKR49032.1 1619047 g51005 i0 34.7 1.2560553633218 75 45 73.7 2 270 58 632 706 KKR49032.1 MAG: Tetratricopeptide TPR_2 repeat protein [Candidatus Magasanikbacteria bacterium GW2011_GWC2_40_17] diamond 363 43.5 0.990804597701149 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium GW2011_GWC2_40_17

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