RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA884104", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 4 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA884104 · 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
28886970 28886970 PRJNA884104_S_NODE_73368_length_248_cov_1.320000_g72625_i0 PRJNA884104 73368 248 1.32 3.2736 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 70.1 6.14e-12   NR MDA3798896.1 2212473 g72625 i0 55.9 2.33467741935484 59 23 71.4 1 2 178 98 153 MDA3798896.1 sensor domain-containing diguanylate cyclase [Kiritimatiellia bacterium] diamond 579 70.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31359053 31359053 PRJNA884104_S_NODE_55436_length_281_cov_1.120192_g54693_i0 PRJNA884104 55436 281 1.120192 3.14773952 PVC group 1783257 Bacteria Bacteria 67.4 1.23e-10   NR HPK70123.1 2212473 g54693 i0 40.6 3.01067615658363 96 48 99.3 4 279 1 393 482 HPK70123.1 alpha-amylase family glycosyl hydrolase [Kiritimatiellia bacterium] diamond 846 67.8 0.994100294985251 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31951920 31951920 PRJNA884104_S_NODE_57777_length_275_cov_1.524752_g57034_i0 PRJNA884104 57777 275 1.524752 4.193068 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 52.8 1.55e-5   NR MCS6770642.1 2212473 g57034 i0 41.7 3.12 96 43 99.3 3 1 273 68 155 MCS6770642.1 molecular chaperone DnaJ [Kiritimatiellia bacterium] diamond 858 52.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32268560 32268560 PRJNA884104_S_NODE_30098_length_372_cov_1.030100_g29355_i0 PRJNA884104 30098 372 1.0301 3.831972 Kiritimatiellales bacterium 2202731 Bacteria Bacteria 47 0.00515   NR MEI7850403.1 2202731 g29355 i0 48 0.403225806451613 50 25 40.3 1 23 172 772 820 MEI7850403.1 DUF2723 domain-containing protein [Kiritimatiellales bacterium] diamond 150 47 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales     Kiritimatiellales 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);;