RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA939415", 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

  • PRJNA939415 · 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
2531905 2531905 PRJNA939415_P_NODE_105562_length_226_cov_2.882353_g105140_i0 PRJNA939415 105562 226 2.882353 6.51411778 Lentisphaeraceae bacterium 2461380 Bacteria Bacteria 67 3.55e-11   NR NQZ57860.1 2461380 g105140 i0 82.4 3.15929203539823 34 6 45.1 0 104 3 1 34 NQZ57860.1 Fe-S cluster assembly ATPase SufC [Lentisphaeraceae bacterium] diamond 714 67 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae   Lentisphaeraceae bacterium
6360588 6360588 PRJNA939415_P_NODE_52045_length_281_cov_4.687500_g51623_i0 PRJNA939415 52045 281 4.6875 13.171875 Lentisphaeria bacterium 2053569 Bacteria Bacteria 90.5 2.37e-19   NR MBQ6353320.1 2053569 g51623 i0 97.6 0.437722419928826 41 1 43.8 0 157 279 1 41 MBQ6353320.1 rod shape-determining protein MreC [Lentisphaeria bacterium] diamond 123 90.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
28477869 28477869 PRJNA939415_P_NODE_22106_length_331_cov_2.341085_g21685_i0 PRJNA939415 22106 331 2.341085 7.74899135 Victivallales bacterium 2212475 Bacteria Bacteria 49.7 3.86e-4   NR MBR0459350.1 2212475 g21685 i0 32 0.879154078549849 97 56 78.9 2 6 266 1023 1119 MBR0459350.1 RHS repeat-associated core domain-containing protein [Victivallales bacterium] diamond 291 49.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
29677331 29677331 PRJNA939415_P_NODE_64290_length_269_cov_3.642857_g63868_i0 PRJNA939415 64290 269 3.642857 9.79928533 Lentisphaeria bacterium 2053569 Bacteria Bacteria 115 1.2399999999999999e-28   NR MFA5205433.1 2053569 g63868 i0 65.2 0.992565055762082 89 31 99.3 0 3 269 161 249 MFA5205433.1 ABC transporter permease [Lentisphaeria bacterium] diamond 267 115 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
31510604 31510604 PRJNA939415_P_NODE_68056_length_265_cov_5.932292_g67634_i0 PRJNA939415 68056 265 5.932292 15.7205738 Lentisphaerota bacterium 1932692 Bacteria Bacteria 52.8 1.41e-5   NR NLF85917.1 1932692 g67634 i0 43 0.973584905660377 86 49 97.4 0 258 1 312 397 NLF85917.1 TolC family protein [Lentisphaerota bacterium] diamond 258 52.8 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
32175007 32175007 PRJNA939415_P_NODE_95538_length_241_cov_1.505952_g95116_i0 PRJNA939415 95538 241 1.505952 3.62934432 Lentisphaerota bacterium 1932692 Bacteria Bacteria 144 9.67e-38   NR MBE6385219.1 1932692 g95116 i0 82.5 0.995850622406639 80 14 99.6 0 1 240 661 740 MBE6385219.1 hypothetical protein [Lentisphaerota bacterium] diamond 240 144 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);;