RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1249535" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1249535 · 4 ✖

analysis 1

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
28115864 28115864 PRJNA1249535_S_NODE_195005_length_309_cov_2.313559_g191622_i0 PRJNA1249535 195005 309 2.313559 7.14889731 Lentisphaerales bacterium 2448604 Bacteria Bacteria 43.5 0.0448   NR MCH2206870.1 2448604 g191622 i0 32.3 0.631067961165049 65 36 55.3 1 55 225 194 258 MCH2206870.1 PQQ-binding-like beta-propeller repeat protein [Lentisphaerales bacterium] diamond 195 43.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales     Lentisphaerales bacterium
28937095 28937095 PRJNA1249535_S_NODE_89408_length_387_cov_6.770701_g86026_i0 PRJNA1249535 89408 387 6.770701 26.20261287 Lentisphaeria bacterium 2053569 Bacteria Bacteria 45.8 0.0127   NR MCR5382205.1 2053569 g86026 i0 27.2 0.713178294573643 92 50 69 2 45 311 198 275 MCR5382205.1 HIRAN domain-containing protein [Lentisphaeria bacterium] diamond 276 45.8 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
29978951 29978951 PRJNA1249535_S_NODE_245351_length_282_cov_3.727273_g241968_i0 PRJNA1249535 245351 282 3.727273 10.51090986 Lentisphaerota bacterium 1932692 Bacteria Bacteria 43.1 0.0393   NR MBE6390152.1 1932692 g241968 i0 66.7 0.25531914893617 24 8 25.5 0 92 21 76 99 MBE6390152.1 D-hexose-6-phosphate mutarotase [Lentisphaerota bacterium] diamond 72 43.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
30136597 30136597 PRJNA1249535_S_NODE_78132_length_404_cov_5.842900_g74751_i0 PRJNA1249535 78132 404 5.8429 23.605316 Lentisphaerota bacterium 1932692 Bacteria Bacteria 45.1 0.0302   NR MBM4148142.1 1932692 g74751 i0 27.8 0.801980198019802 108 71 78.7 2 57 374 71 173 MBM4148142.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Lentisphaerota bacterium] diamond 324 45.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota 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);;