RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Handelsmaniibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Handelsmaniibacteriota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1237347 · 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
7425198 7425198 PRJNA1237347_P_NODE_116826_length_617_cov_1.398897_g110330_i0 PRJNA1237347 116826 617 1.398897 8.63119449 Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1 2099671 Bacteria Bacteria 161 8.01e-42   NR OGG43657.1 1817868 g110330 i0 42.8 1.01134521880065 208 111 98.7 4 9 617 1089 1293 OGG43657.1 MAG: hypothetical protein A3F84_25730 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10] diamond 624 161 1 Bacteria Bacteria candidate phyla   Candidatus Handelsmaniibacteriota         Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
28828395 28828395 PRJNA1237347_P_NODE_85888_length_751_cov_1.612094_g79688_i0 PRJNA1237347 85888 751 1.612094 12.10682594 Bacteria 2 Bacteria Bacteria 142 1.88e-34   NR OGG44698.1 1817868 g79688 i0 47.3 6.07589880159787 167 86 66.3 2 241 738 677 842 OGG44698.1 MAG: hypothetical protein A3F84_28760 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10] diamond 4563 142 1 Bacteria Bacteria candidate phyla   Candidatus Handelsmaniibacteriota         Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
32064354 32064354 PRJNA1237347_P_NODE_232858_length_392_cov_1.931034_g226286_i0 PRJNA1237347 232858 392 1.931034 7.56965328 Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1 2099671 Bacteria Bacteria 94.4 1.86e-19   NR OGG55371.1 1817868 g226286 i0 43.4 0.987244897959184 129 71 98 2 2 385 958 1085 OGG55371.1 MAG: hypothetical protein A3F84_06175 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10] diamond 387 94.4 1 Bacteria Bacteria candidate phyla   Candidatus Handelsmaniibacteriota         Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10

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