RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 9 ✖

bioproject 1

  • PRJEB39269 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
12810579 12810579 PRJEB39269_P_NODE_36111_length_229_cov_3.273684_g35706_i0 PRJEB39269 36111 229 3.273684 7.49673636 Pseudomonadati 3379134 Bacteria Bacteria 146 1.1199999999999999e-40   NR HVX91236.1 2053589 g35706 i0 90.8 3.9825327510917 76 7 99.6 0 229 2 181 256 HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium] diamond 912 146 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
27349675 27349675 PRJEB39269_P_NODE_65303_length_171_cov_2.446970_g64898_i0 PRJEB39269 65303 171 2.44697 4.1843187 Minisyncoccota bacterium 2053589 Bacteria Bacteria 105 2.62e-25   NR HVX91236.1 2053589 g64898 i0 86 1 57 8 100 0 1 171 119 175 HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium] diamond 171 105 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
30690180 30690180 PRJEB39269_P_NODE_86473_length_154_cov_1.060870_g86068_i0 PRJEB39269 86473 154 1.06087 1.6337398 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.61e-14   NR HYL63392.1 2032687 g86068 i0 65.3 2.84415584415584 49 17 95.5 0 152 6 366 414 HYL63392.1 serine hydrolase [Candidatus Methylomirabilis sp.] diamond 438 76.3 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota Candidatus Methylomirabilia Candidatus Methylomirabilales Candidatus Methylomirabilaceae Candidatus Methylomirabilis Candidatus Methylomirabilis sp.
30728417 30728417 PRJEB39269_P_NODE_91554_length_150_cov_1.333333_g91149_i0 PRJEB39269 91554 150 1.333333 1.9999995 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 87.8 4.88e-19   NR HTG30513.1 2072417 g91149 i0 74 3 50 13 100 0 1 150 69 118 HTG30513.1 polysaccharide deacetylase family protein [Candidatus Methylomirabilota bacterium] diamond 450 87.8 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
30918174 30918174 PRJEB39269_P_NODE_60094_length_178_cov_1.359712_g59689_i0 PRJEB39269 60094 178 1.359712 2.42028736 Candidatus Binataceae bacterium 2785449 Bacteria Bacteria 92.4 1.71e-22   NR HSR57215.1 2785449 g59689 i0 69.5 0.99438202247191 59 18 99.4 0 1 177 56 114 HSR57215.1 IS66 family insertion sequence element accessory protein TnpB [Candidatus Binataceae bacterium] diamond 177 92.4 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae   Candidatus Binataceae bacterium
31518803 31518803 PRJEB39269_P_NODE_67876_length_170_cov_1.877863_g67471_i0 PRJEB39269 67876 170 1.877863 3.1923671 Candidatus Binataceae bacterium 2785449 Bacteria Bacteria 59.7 1.27e-9   NR HVA39889.1 2785449 g67471 i0 61.5 0.917647058823529 52 20 91.8 0 158 3 24 75 HVA39889.1 hypothetical protein [Candidatus Binataceae bacterium] diamond 156 59.7 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae   Candidatus Binataceae bacterium
31582086 31582086 PRJEB39269_P_NODE_74456_length_163_cov_1.870968_g74051_i0 PRJEB39269 74456 163 1.870968 3.04967784 Candidatus Saccharimonadales bacterium 2973664 Bacteria Bacteria 73.2 1.66e-13   NR HUA68445.1 2973664 g74051 i0 69.8 4.91411042944785 53 16 97.5 0 4 162 97 149 HUA68445.1 efflux transporter outer membrane subunit [Candidatus Saccharimonadales bacterium] diamond 801 73.2 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales     Candidatus Saccharimonadales bacterium
32656839 32656839 PRJEB39269_P_NODE_87040_length_153_cov_1.798246_g86635_i0 PRJEB39269 87040 153 1.798246 2.75131638 Candidatus Bipolaricaulis sp. 2814139 Bacteria Bacteria 66.6 1.07e-11   NR MDD5453212.1 2814139 g86635 i0 60.9 0.901960784313726 46 18 90.2 0 1 138 38 83 MDD5453212.1 NYN domain-containing protein [Candidatus Bipolaricaulis sp.] diamond 138 66.6 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota Candidatus Bipolaricaulia Candidatus Bipolaricaulales Candidatus Bipolaricaulaceae Candidatus Bipolaricaulis Candidatus Bipolaricaulis sp.
32846058 32846058 PRJEB39269_P_NODE_74580_length_163_cov_1.580645_g74175_i0 PRJEB39269 74580 163 1.580645 2.57645135 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 41.2 0.0453   NR HKW50121.1 2212470 g74175 i0 45.7 0.846625766871166 46 25 84.7 0 153 16 7 52 HKW50121.1 PKD domain-containing protein [Candidatus Eiseniibacteriota bacterium] diamond 138 41.2 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota 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);;