RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA641707 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
22289925 22289925 PRJNA641707_P_NODE_192138_length_198_cov_11.221477_g189475_i0 PRJNA641707 192138 198 11.221477 22.21852446 Lentisphaerota bacterium 1932692 Bacteria Bacteria 80.5 1.01e-15   NR NLF16927.1 1932692 g189475 i0 51.2 1.3030303030303 86 17 92.4 1 12 194 90 175 NLF16927.1 DEAD/DEAH box helicase family protein [Lentisphaerota bacterium] diamond 258 80.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
26796261 26796261 PRJNA641707_P_NODE_112581_length_246_cov_2.507614_g109918_i0 PRJNA641707 112581 246 2.507614 6.16873044 Lentisphaerota bacterium 1932692 Bacteria Bacteria 95.9 7.6e-21   NR MEI6055088.1 1932692 g109918 i0 57 1.92682926829268 79 26 96.3 1 9 245 185 255 MEI6055088.1 TIM-barrel domain-containing protein [Lentisphaerota bacterium] diamond 474 95.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
27143988 27143988 PRJNA641707_P_NODE_52042_length_298_cov_5.971888_g49384_i0 PRJNA641707 52042 298 5.971888 17.79622624 Victivallales bacterium 2212475 Bacteria Bacteria 57.4 5.23e-7   NR HJO91876.1 2212475 g49384 i0 29.1 1.59060402684564 158 46 92.6 1 295 20 232 389 HJO91876.1 hypothetical protein [Victivallales bacterium] diamond 474 57.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
27428955 27428955 PRJNA641707_P_NODE_12943_length_601_cov_4.619565_g10740_i0 PRJNA641707 12943 601 4.619565 27.76358565 Victivallales bacterium 2212475 Bacteria Bacteria 57.4 9.23e-6   NR HJO91876.1 2212475 g10740 i0 34.8 0.444259567387687 89 53 44.4 2 317 583 19 102 HJO91876.1 hypothetical protein [Victivallales bacterium] diamond 267 57.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
27681690 27681690 PRJNA641707_P_NODE_231524_length_189_cov_11.385714_g228861_i0 PRJNA641707 231524 189 11.385714 21.51899946 Lentisphaerota bacterium 1932692 Bacteria Bacteria 119 3.36e-30   NR MBE6362191.1 1932692 g228861 i0 88.7 3.93650793650794 62 7 98.4 0 186 1 186 247 MBE6362191.1 trigger factor [Lentisphaerota bacterium] diamond 744 119 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
27725693 27725693 PRJNA641707_P_NODE_187684_length_199_cov_5.866667_g185021_i0 PRJNA641707 187684 199 5.866667 11.67466733 PVC group 1783257 Bacteria Bacteria 72 9.92e-13   NR MBT3379166.1 1932692 g185021 i0 50 31.7185929648241 72 27 95 1 190 2 271 342 MBT3379166.1 F0F1 ATP synthase subunit alpha [Lentisphaerota bacterium] diamond 6312 72.4 0.994475138121547 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
28628818 28628818 PRJNA641707_P_NODE_26727_length_420_cov_5.495957_g24135_i0 PRJNA641707 26727 420 5.495957 23.0830194 Victivallales bacterium 2212475 Bacteria Bacteria 57.4 2.02e-6   NR HJO91876.1 2212475 g24135 i0 34.8 0.635714285714286 89 53 63.6 2 285 19 19 102 HJO91876.1 hypothetical protein [Victivallales bacterium] diamond 267 57.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
29070758 29070758 PRJNA641707_P_NODE_147348_length_239_cov_7.615789_g144685_i0 PRJNA641707 147348 239 7.615789 18.20173571 Victivallales bacterium 2212475 Bacteria Bacteria 47.8 6.12e-4   NR HJO91876.1 2212475 g144685 i0 38.4 0.916317991631799 73 41 87.9 2 5 214 143 214 HJO91876.1 hypothetical protein [Victivallales bacterium] diamond 219 47.8 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
29638643 29638643 PRJNA641707_P_NODE_285750_length_168_cov_5.394958_g283087_i0 PRJNA641707 285750 168 5.394958 9.06352944 Lentisphaerota bacterium 1932692 Bacteria Bacteria 60.1 9.43e-9   NR NQT94315.1 1932692 g283087 i0 60.4 0.857142857142857 48 19 85.7 0 149 6 220 267 NQT94315.1 sulfatase-like hydrolase/transferase [Lentisphaerota bacterium] diamond 144 60.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
29796703 29796703 PRJNA641707_P_NODE_255431_length_180_cov_3.244275_g252768_i0 PRJNA641707 255431 180 3.244275 5.839695 Victivallales bacterium 2212475 Bacteria Bacteria 47 5.3e-4   NR HJO91876.1 2212475 g252768 i0 46.9 0.816666666666667 49 21 73.3 2 7 138 232 280 HJO91876.1 hypothetical protein [Victivallales bacterium] diamond 147 47 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
31218202 31218202 PRJNA641707_P_NODE_252935_length_181_cov_3.810606_g250272_i0 PRJNA641707 252935 181 3.810606 6.89719686 Lentisphaeria bacterium 2053569 Bacteria Bacteria 63.9 5.4e-10   NR MCJ8331776.1 2053569 g250272 i0 49.2 2.93370165745856 59 30 97.8 0 177 1 52 110 MCJ8331776.1 protein kinase [Lentisphaeria bacterium] diamond 531 63.9 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);;