RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA680334", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Parcubacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Parcubacteria · 4 ✖

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA680334 · 4 ✖

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
29229534 29229534 PRJNA680334_S_NODE_47249_length_195_cov_3.728395_g46763_i0 PRJNA680334 47249 195 3.728395 7.27037025 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 59.3 2.53e-9   NR NCN52523.1 2762014 g46763 i0 84.8 0.507692307692308 33 5 50.8 0 97 195 1 33 NCN52523.1 50S ribosomal protein L17 [Candidatus Parcubacteria bacterium] diamond 99 59.3 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
29398909 29398909 PRJNA680334_S_NODE_75909_length_168_cov_1.881481_g75423_i0 PRJNA680334 75909 168 1.881481 3.16088808 Bacteria 2 Bacteria Bacteria 72.8 4.28e-15   NR KXJ99824.1 1617425 g75423 i0 63 1.94642857142857 54 20 96.4 0 165 4 5 58 KXJ99824.1 MAG: D-inositol-3-phosphate glycosyltransferase [Parcubacteria bacterium OLB19] diamond 327 73.2 0.994535519125683 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Parcubacteria bacterium OLB19
29987195 29987195 PRJNA680334_S_NODE_68111_length_174_cov_1.851064_g67625_i0 PRJNA680334 68111 174 1.851064 3.22085136 Parcubacteria bacterium OLB19 1617425 Bacteria Bacteria 104 2.5499999999999998e-24   NR KXK00120.1 1617425 g67625 i0 86 0.982758620689655 57 8 98.3 0 173 3 376 432 KXK00120.1 MAG: Blue copper oxidase CueO precursor [Parcubacteria bacterium OLB19] diamond 171 104 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Parcubacteria bacterium OLB19
31345997 31345997 PRJNA680334_S_NODE_102356_length_152_cov_4.168067_g101870_i0 PRJNA680334 102356 152 4.168067 6.33546184 Parcubacteria bacterium OLB19 1617425 Bacteria Bacteria 75.9 2.19e-14   NR KXK00622.1 1617425 g101870 i0 88.4 0.848684210526316 43 5 84.9 0 24 152 394 436 KXK00622.1 MAG: Histidine--tRNA ligase [Parcubacteria bacterium OLB19] diamond 129 75.9 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Parcubacteria bacterium OLB19

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);;