RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA743294", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA743294 · 6 ✖
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
2473734 2473734 PRJNA743294_P_NODE_41102_length_266_cov_1.005181_g40646_i0 PRJNA743294 41102 266 1.005181 2.67378146 Bacteria 2 Bacteria Bacteria 183 8.27e-42   NTclustered gi|1995790976|gb|CP071032.1| 1932692 g40646 i0 82.775 131.086466165414 209 33 78 3 2 209 1584723 1584517 Lentisphaerae bacterium strain zth2 chromosome, complete genome blastn 34869 183 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
27937155 27937155 PRJNA743294_P_NODE_5145_length_674_cov_2.497504_g4703_i0 PRJNA743294 5145 674 2.497504 16.83317696 Victivallales bacterium 2212475 Bacteria Bacteria 84.3 8.04e-15   NR MCF7792232.1 2212475 g4703 i0 26.4 0.859050445103858 193 139 85.9 1 625 47 2 191 MCF7792232.1 glycosyltransferase family 4 protein [Victivallales bacterium] diamond 579 84.3 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
27968575 27968575 PRJNA743294_P_NODE_26145_length_323_cov_1.248000_g25689_i0 PRJNA743294 26145 323 1.248 4.03104 Lentisphaerota bacterium 1932692 Bacteria Bacteria 140 3.35e-36   NR MEI6055088.1 1932692 g25689 i0 69.6 1.70897832817337 92 28 85.4 0 319 44 441 532 MEI6055088.1 TIM-barrel domain-containing protein [Lentisphaerota bacterium] diamond 552 140 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
29768251 29768251 PRJNA743294_P_NODE_59151_length_229_cov_2.467949_g58695_i0 PRJNA743294 59151 229 2.467949 5.65160321 Victivallales bacterium 2212475 Bacteria Bacteria 78.2 1.04e-14   NR HJO91876.1 2212475 g58695 i0 59.3 0.707423580786026 54 21 70.7 1 163 2 858 910 HJO91876.1 hypothetical protein [Victivallales bacterium] diamond 162 78.2 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
32582098 32582098 PRJNA743294_P_NODE_53759_length_245_cov_0.906977_g53303_i0 PRJNA743294 53759 245 0.906977 2.22209365 Oligosphaeraceae bacterium 2699751 Bacteria Bacteria 57.4 2.29e-7   NR NMA42592.1 2699751 g53303 i0 41 1.01632653061224 83 46 99.2 3 244 2 184 265 NMA42592.1 hypothetical protein [Oligosphaeraceae bacterium] diamond 249 57.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Oligosphaeria Oligosphaerales Oligosphaeraceae   Oligosphaeraceae bacterium
32770756 32770756 PRJNA743294_P_NODE_52900_length_246_cov_0.872832_g52444_i0 PRJNA743294 52900 246 0.872832 2.14716672 Victivallales bacterium 2212475 Bacteria Bacteria 41.6 0.0384   NR MCF7792234.1 2212475 g52444 i0 76.2 0.51219512195122 21 5 25.6 0 169 107 76 96 MCF7792234.1 RidA family protein [Victivallales bacterium] diamond 126 41.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales 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);;