RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1112809", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 3 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA1112809 · 3 ✖

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
28457689 28457689 PRJNA1112809_P_NODE_74506_length_402_cov_1.744681_g71231_i0 PRJNA1112809 74506 402 1.744681 7.01361762 Victivallales bacterium 2212475 Bacteria Bacteria 53.5 2.02e-5   NR MBQ7178625.1 2212475 g71231 i0 73.3 0.223880597014925 30 8 22.4 0 23 112 5 34 MBQ7178625.1 sel1 repeat family protein [Victivallales bacterium] diamond 90 53.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
28647048 28647048 PRJNA1112809_P_NODE_157727_length_256_cov_1.956284_g154452_i0 PRJNA1112809 157727 256 1.956284 5.00808704 Lentisphaerota bacterium 1932692 Bacteria Bacteria 43.5 0.0235   NR RMD74234.1 1932692 g154452 i0 38.3 0.703125 60 36 70.3 1 187 8 181 239 RMD74234.1 MAG: hypothetical protein D6820_17130 [Lentisphaerota bacterium] diamond 180 43.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
29720168 29720168 PRJNA1112809_P_NODE_129530_length_285_cov_1.424528_g126255_i0 PRJNA1112809 129530 285 1.424528 4.0599048 Lentisphaerota bacterium 1932692 Bacteria Bacteria 99.8 5.53e-22   NR NQT94346.1 1932692 g126255 i0 54.5 2.65263157894737 88 40 92.6 0 283 20 197 284 NQT94346.1 GNAT family N-acetyltransferase [Lentisphaerota bacterium] diamond 756 99.8 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);;