RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA662254" 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

  • PRJNA662254 · 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
28893493 28893493 PRJNA662254_P_NODE_63848_length_242_cov_0.911243_g63197_i0 PRJNA662254 63848 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 95.9 1.1200000000000001e-22   NR HWS95847.1 2032687 g63197 i0 52.5 1.98347107438017 80 38 99.2 0 241 2 92 171 HWS95847.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Methylomirabilis sp.] diamond 480 95.9 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota Candidatus Methylomirabilia Candidatus Methylomirabilales Candidatus Methylomirabilaceae Candidatus Methylomirabilis Candidatus Methylomirabilis sp.
29197387 29197387 PRJNA662254_P_NODE_62849_length_242_cov_0.911243_g62198_i0 PRJNA662254 62849 242 0.911243 2.20520806 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 146 8.68e-39   NR HWN95602.1 2072417 g62198 i0 85 0.991735537190083 80 12 99.2 0 3 242 245 324 HWN95602.1 DEAD/DEAH box helicase family protein [Candidatus Methylomirabilota bacterium] diamond 240 146 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
30662303 30662303 PRJNA662254_P_NODE_51453_length_248_cov_0.880000_g50802_i0 PRJNA662254 51453 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 154 1.75e-41   NR HWN95708.1 2072417 g50802 i0 93.9 2.9758064516129 82 5 99.2 0 248 3 409 490 HWN95708.1 aminomethyl-transferring glycine dehydrogenase [Candidatus Methylomirabilota bacterium] diamond 738 154 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
31515990 31515990 PRJNA662254_P_NODE_61936_length_243_cov_0.905882_g61285_i0 PRJNA662254 61936 243 0.905882 2.20129326 Pseudomonadati 3379134 Bacteria Bacteria 100 2.3499999999999994e-23   NR HYB61709.1 2072417 g61285 i0 92.5 6 53 4 65.4 0 81 239 1 53 HYB61709.1 malate dehydrogenase [Candidatus Methylomirabilota bacterium] diamond 1458 101 0.99009900990099 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
32041364 32041364 PRJNA662254_P_NODE_55978_length_246_cov_0.890173_g55327_i0 PRJNA662254 55978 246 0.890173 2.18982558 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 94.4 9.92e-21   NR HXG47374.1 2072417 g55327 i0 55.6 2.96341463414634 81 36 98.8 0 244 2 104 184 HXG47374.1 phosphate signaling complex protein PhoU [Candidatus Methylomirabilota bacterium] diamond 729 94.4 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);;