RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA934332", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA934332 · 4 ✖

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
27436038 27436038 PRJNA934332_P_NODE_11403_length_241_cov_0.886905_g11316_i0 PRJNA934332 11403 241 0.886905 2.13744105 Candidatus Babelota bacterium 2030827 Bacteria Bacteria 107 4.48e-27   NR MCA9770713.1 2030827 g11316 i0 74.6 0.83402489626556 67 17 83.4 0 203 3 1 67 MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium] diamond 201 107 1 Bacteria Bacteria candidate phyla             Candidatus Babelota bacterium
29835392 29835392 PRJNA934332_P_NODE_6211_length_273_cov_1.650000_g6124_i0 PRJNA934332 6211 273 1.65 4.5045 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 96.7 2.15e-22   NR MDB5180732.1 2026720 g6124 i0 76.4 0.791208791208791 72 17 79.1 0 216 1 50 121 MDB5180732.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 216 96.7 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
29930393 29930393 PRJNA934332_P_NODE_6271_length_272_cov_2.321608_g6184_i0 PRJNA934332 6271 272 2.321608 6.31477376 Candidatus Gracilibacteria bacterium HOT-871 1540872 Bacteria Bacteria 44.7 0.0114   NR ATU04913.1 1540872 g6184 i0 33.8 0.716911764705882 65 43 71.7 0 229 35 11 75 ATU04913.1 phage tail tape measure protein [Candidatus Gracilibacteria bacterium HOT-871] diamond 195 44.7 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Gracilibacteria bacterium HOT-871
31794725 31794725 PRJNA934332_P_NODE_9777_length_245_cov_0.895349_g9690_i0 PRJNA934332 9777 245 0.895349 2.19360505 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 48.9 2.53e-4   NR HEV8310476.1 2072417 g9690 i0 37.8 0.906122448979592 74 41 85.7 2 13 222 151 223 HEV8310476.1 glycosyltransferase family 39 protein [Candidatus Methylomirabilota bacterium] diamond 222 48.9 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);;