RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 11 ✖

bioproject 1

  • PRJNA788929 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
5873125 5873125 PRJNA788929_P_NODE_44485_length_231_cov_25.430380_g43824_i0 PRJNA788929 44485 231 25.43038 58.7441778 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 1619070 Bacteria Bacteria 276 1.13e-69   NTclustered gi|837350690|gb|CP011211.1| 1619070 g43824 i0 90.821 94.987012987013 207 17 89 2 24 229 849846 850051 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome blastn 21942 276 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
7148021 7148021 PRJNA788929_P_NODE_41286_length_243_cov_32.947059_g40625_i0 PRJNA788929 41286 243 32.947059 80.06135337 Candidatus Mycosynbacter amalyticus 2665156 Bacteria Bacteria 291 4.26e-74   NTclustered gi|1799615131|gb|CP045921.1| 2665156 g40625 i0 90.498 137.024691358025 221 19 91 2 1 220 220113 219894 Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome blastn 33297 291 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota       Candidatus Mycosynbacter Candidatus Mycosynbacter amalyticus
7592469 7592469 PRJNA788929_P_NODE_44686_length_230_cov_16.401274_g44025_i0 PRJNA788929 44686 230 16.401274 37.7229302 Bacteria 2 Bacteria Bacteria 318 1.8299999999999998e-82   NTclustered gi|2258875662|gb|CP060232.1| 2052152 g44025 i0 94.231 77.4695652173913 208 12 90 0 23 230 964848 964641 MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome blastn 17818 318 1 Bacteria Bacteria candidate phyla   Candidatus Nomuraibacteriota         Candidatus Nomurabacteria bacterium
8422792 8422792 PRJNA788929_P_NODE_48907_length_205_cov_8.242424_g48246_i0 PRJNA788929 48907 205 8.242424 16.8969692 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 298 2.08e-76   NTclustered gi|1950821269|gb|CP066696.1| 2026720 g48246 i0 96.154 72.4731707317073 182 7 89 0 3 184 798269 798450 Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome blastn 14857 298 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
9697876 9697876 PRJNA788929_P_NODE_42728_length_240_cov_146.502994_g42067_i0 PRJNA788929 42728 240 146.502994 351.6071856 Candidatus Mycosynbacter amalyticus 2665156 Bacteria Bacteria 327 3.199999999999999e-85   NTclustered gi|1799615131|gb|CP045921.1| 2665156 g42067 i0 94.009 82.9541666666667 217 12 90 1 1 217 220109 219894 Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome blastn 19909 327 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota       Candidatus Mycosynbacter Candidatus Mycosynbacter amalyticus
13968026 13968026 PRJNA788929_P_NODE_12151_length_498_cov_37.054118_g11494_i0 PRJNA788929 12151 498 37.054118 184.52950764 Bacteria 2 Bacteria Bacteria 595 1.7899999999999994e-165   NTclustered gi|1769783243|gb|CP042461.1| 1862133 g11494 i0 89.518 110.034136546185 477 41 95 7 27 498 1251553 1251081 Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome blastn 54797 601 0.990016638935108 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Gracilibacteria bacterium 28_42_T64
16072072 16072072 PRJNA788929_P_NODE_44093_length_233_cov_16.737500_g43432_i0 PRJNA788929 44093 233 16.7375 38.998375 uncultured Candidatus Saccharibacteria bacterium 179883 Bacteria Bacteria 274 4.09e-69   NTclustered gi|2874254031|emb|OY970356.1| 179883 g43432 i0 90.821 86.4721030042918 207 16 88 3 24 229 599567 599363 MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1 blastn 20148 274 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         uncultured Candidatus Saccharibacteria bacterium
16072123 16072123 PRJNA788929_P_NODE_48033_length_210_cov_12.000000_g47372_i0 PRJNA788929 48033 210 12 25.2 Minisyncoccota bacterium 2053589 Bacteria Bacteria 152 1.77e-32   NTclustered gi|2556886971|gb|CP129473.1| 2053589 g47372 i0 82.011 190.033333333333 189 25 87 7 5 187 444594 444779 MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome blastn 39907 152 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
17347735 17347735 PRJNA788929_P_NODE_36614_length_255_cov_28.137363_g35953_i0 PRJNA788929 36614 255 28.137363 71.75027565 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 276 1.26e-69   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g35953 i0 89.815 69.678431372549 216 20 84 2 1 215 668127 668341 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 17768 276 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
18620534 18620534 PRJNA788929_P_NODE_10315_length_554_cov_51.309771_g9662_i0 PRJNA788929 10315 554 51.309771 284.25613134 Patescibacteria group bacterium 2052139 Bacteria Bacteria 394 7.87e-105   NTclustered gi|2621785934|emb|OY782392.1| 2052139 g9662 i0 80.871 35.7653429602888 528 78 94 21 37 554 429588 429074 MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1 blastn 19814 394 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
24996079 24996079 PRJNA788929_P_NODE_43360_length_237_cov_15.890244_g42699_i0 PRJNA788929 43360 237 15.890244 37.65987828 Candidatus Mycosynbacter amalyticus 2665156 Bacteria Bacteria 329 8.78e-86   NTclustered gi|1799615131|gb|CP045921.1| 2665156 g42699 i0 94.393 119.645569620253 214 12 90 0 1 214 220107 219894 Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome blastn 28356 329 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota       Candidatus Mycosynbacter Candidatus Mycosynbacter amalyticus

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