RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1028258", 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 · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA1028258 · 6 ✖

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
26877095 26877095 PRJNA1028258_P_NODE_110401_length_252_cov_1.420765_g109838_i0 PRJNA1028258 110401 252 1.420765 3.5803278 Lentisphaeria bacterium 2053569 Bacteria Bacteria 44.7 0.0089   NR HQL08285.1 2053569 g109838 i0 46.5 2.41666666666667 43 23 51.2 0 188 60 1224 1266 HQL08285.1 FG-GAP-like repeat-containing protein [Lentisphaeria bacterium] diamond 609 44.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
26971631 26971631 PRJNA1028258_P_NODE_122302_length_242_cov_1.641618_g121739_i0 PRJNA1028258 122302 242 1.641618 3.97271556 Lentisphaeria bacterium 2053569 Bacteria Bacteria 42.4 0.0465   NR MBQ6598788.1 2053569 g121739 i0 39 0.731404958677686 59 29 73.1 1 236 60 181 232 MBQ6598788.1 helix-turn-helix domain-containing protein [Lentisphaeria bacterium] diamond 177 42.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
28487989 28487989 PRJNA1028258_P_NODE_98587_length_262_cov_1.471503_g98024_i0 PRJNA1028258 98587 262 1.471503 3.85533786 Lentisphaeria bacterium 2053569 Bacteria Bacteria 74.3 8.65e-14   NR HQL10028.1 2053569 g98024 i0 42.9 0.961832061068702 84 48 96.2 0 7 258 7 90 HQL10028.1 NUMOD3 domain-containing DNA-binding protein [Lentisphaeria bacterium] diamond 252 74.3 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
29521830 29521830 PRJNA1028258_P_NODE_47390_length_368_cov_1.561873_g46827_i0 PRJNA1028258 47390 368 1.561873 5.74769264 Pseudomonadati 3379134 Bacteria Bacteria 44.3 0.0381   NR MEI8247789.1 1932692 g46827 i0 41.7 1.03532608695652 60 32 48.9 1 6 185 156 212 MEI8247789.1 S41 family peptidase [Lentisphaerota bacterium] diamond 381 44.7 0.991051454138702 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
30501101 30501101 PRJNA1028258_P_NODE_162493_length_228_cov_0.893082_g161930_i0 PRJNA1028258 162493 228 0.893082 2.03622696 Pseudomonadati 3379134 Bacteria Bacteria 43.9 0.0119   NR NLC80463.1 1932692 g161930 i0 42.1 2.25 57 26 65.8 1 23 172 622 678 NLC80463.1 hypothetical protein [Lentisphaerota bacterium] diamond 513 43.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
31892034 31892034 PRJNA1028258_P_NODE_142777_length_233_cov_0.865854_g142214_i0 PRJNA1028258 142777 233 0.865854 2.01743982 Bacteria 2 Bacteria Bacteria 53.5 1e-6   NR HCN07844.1 2053569 g142214 i0 65.6 1.24892703862661 32 11 41.2 0 5 100 3 34 HCN07844.1 hypothetical protein [Lentisphaeria bacterium] diamond 291 53.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria 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);;