RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_phylum = "Candidatus Methylomirabilota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Methylomirabilota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA312107 · 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
27010886 27010886 PRJNA312107_P_NODE_23682_length_164_cov_0.904348_g23516_i0 PRJNA312107 23682 164 0.904348 1.48313072 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 111 1.8e-27   NR HEV8143487.1 2072417 g23516 i0 100 1.97560975609756 54 0 98.8 0 162 1 266 319 HEV8143487.1 extracellular solute-binding protein [Candidatus Methylomirabilota bacterium] diamond 324 111 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
27895419 27895419 PRJNA312107_P_NODE_22245_length_166_cov_0.888889_g22079_i0 PRJNA312107 22245 166 0.888889 1.47555574 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 77.8 5.81e-15   NR MBM2836732.1 2072417 g22079 i0 63.6 2.98192771084337 55 20 99.4 0 1 165 633 687 MBM2836732.1 hypothetical protein [Candidatus Methylomirabilota bacterium] diamond 495 77.8 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
29379482 29379482 PRJNA312107_P_NODE_25629_length_162_cov_0.920354_g25463_i0 PRJNA312107 25629 162 0.920354 1.49097348 Candidatus Methylomirabilis sp. 2032687 Bacteria Bacteria 55.8 1.77e-7   NR HWT79516.1 2032687 g25463 i0 48.1 1.77777777777778 52 27 96.3 0 160 5 82 133 HWT79516.1 hypothetical protein [Candidatus Methylomirabilis sp.] diamond 288 55.8 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota Candidatus Methylomirabilia Candidatus Methylomirabilales Candidatus Methylomirabilaceae Candidatus Methylomirabilis Candidatus Methylomirabilis sp.
30091637 30091637 PRJNA312107_P_NODE_21152_length_167_cov_0.881356_g20986_i0 PRJNA312107 21152 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 72.4 4.34e-13   NR HXG49249.1 2072417 g20986 i0 67.3 1.97604790419162 55 18 98.8 0 1 165 334 388 HXG49249.1 hypothetical protein [Candidatus Methylomirabilota bacterium] diamond 330 72.4 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
30264132 30264132 PRJNA312107_P_NODE_24232_length_164_cov_0.895652_g24066_i0 PRJNA312107 24232 164 0.895652 1.46886928 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 86.3 4.56e-18   NR HMH30972.1 2072417 g24066 i0 63 0.98780487804878 54 20 98.8 0 1 162 38 91 HMH30972.1 Mur ligase domain-containing protein [Candidatus Methylomirabilota bacterium] diamond 162 86.3 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota 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);;