RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA438111", tax_clade = "Bacteria candidate phyla" 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

  • Bacteria candidate phyla · 5 ✖

bioproject 1

  • PRJNA438111 · 5 ✖

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
27771145 27771145 PRJNA438111_P_NODE_75104_length_161_cov_3.189394_g74479_i0 PRJNA438111 75104 161 3.189394 5.13492434 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 86.7 3.14e-18   NR HWC03303.1 2072417 g74479 i0 83 0.987577639751553 53 9 98.8 0 3 161 358 410 HWC03303.1 TRAP transporter large permease [Candidatus Methylomirabilota bacterium] diamond 159 86.7 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
29902863 29902863 PRJNA438111_P_NODE_65651_length_167_cov_3.869565_g65026_i0 PRJNA438111 65651 167 3.869565 6.46217355 Bacteria 2 Bacteria Bacteria 104 3.85e-25   NR HXG48521.1 2072417 g65026 i0 89.1 4.94011976047904 55 6 98.8 0 167 3 90 144 HXG48521.1 PA0069 family radical SAM protein [Candidatus Methylomirabilota bacterium] diamond 825 104 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
31750952 31750952 PRJNA438111_P_NODE_40437_length_193_cov_5.109756_g39812_i0 PRJNA438111 40437 193 5.109756 9.86182908 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 68.2 8.25e-12   NR HET9491634.1 2072417 g39812 i0 57.6 1.78756476683938 59 25 91.7 0 185 9 110 168 HET9491634.1 HAD family hydrolase [Candidatus Methylomirabilota bacterium] diamond 345 68.2 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
31957152 31957152 PRJNA438111_P_NODE_40657_length_193_cov_3.908537_g40032_i0 PRJNA438111 40657 193 3.908537 7.54347641 Bacteria 2 Bacteria Bacteria 114 2.12e-28   NR HEY7364913.1 2072417 g40032 i0 90.5 20.5647668393782 63 6 97.9 0 3 191 237 299 HEY7364913.1 Mrp/NBP35 family ATP-binding protein [Candidatus Methylomirabilota bacterium] diamond 3969 115 0.991304347826087 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
32130949 32130949 PRJNA438111_P_NODE_56498_length_175_cov_1.739726_g55873_i0 PRJNA438111 56498 175 1.739726 3.0445205 Candidatus Methylomirabilales bacterium 3159508 Bacteria Bacteria 53.9 3.6e-7   NR MFI5339513.1 3159508 g55873 i0 41.2 0.874285714285714 51 30 87.4 0 170 18 51 101 MFI5339513.1 tetratricopeptide repeat protein [Candidatus Methylomirabilales bacterium] diamond 153 53.9 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota Candidatus Methylomirabilia Candidatus Methylomirabilales     Candidatus Methylomirabilales 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);;