RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA278119 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
14400169 14400169 PRJNA278119_P_NODE_22832_length_207_cov_1.031646_g22583_i0 PRJNA278119 22832 207 1.031646 2.13550722 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 230 7.7999999999999985e-56   NTclustered gi|2874253779|emb|OY969763.1| 412056 g22583 i0 89.247 92.9420289855072 186 16 90 2 5 190 3832565 3832384 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 19239 230 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
14400251 14400251 PRJNA278119_P_NODE_28872_length_184_cov_1.540741_g28623_i0 PRJNA278119 28872 184 1.540741 2.83496344 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 244 2.41e-60   NTclustered gi|2874254040|emb|OY970364.1| 412056 g28623 i0 91.16 105.66847826087 181 14 98 2 1 180 989080 989259 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 blastn 19443 244 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16948788 16948788 PRJNA278119_P_NODE_3754_length_623_cov_1.768293_g3516_i0 PRJNA278119 3754 623 1.768293 11.01646539 Nibricoccus aquaticus 2576891 Bacteria Bacteria 1016 0   NTclustered gi|1243404978|gb|CP023344.1| 2576891 g3516 i0 96.429 106.157303370787 616 22 99 0 6 621 2497075 2497690 Nibricoccus aquaticus strain HZ-65 chromosome, complete genome blastn 66136 1016 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus aquaticus
18223109 18223109 PRJNA278119_P_NODE_39395_length_166_cov_1.333333_g39146_i0 PRJNA278119 39395 166 1.333333 2.21333278 Actomonas aquatica 2866162 Bacteria Bacteria 75 2.97e-9   NTclustered gi|2647674565|gb|CP139781.1| 2866162 g39146 i0 97.674 0.259036144578313 43 1 26 0 10 52 1672679 1672637 Actomonas aquatica strain WL0086 chromosome, complete genome blastn 43 75 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Actomonas Actomonas aquatica
20772953 20772953 PRJNA278119_P_NODE_45637_length_163_cov_0.912281_g45388_i0 PRJNA278119 45637 163 0.912281 1.48701803 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 176 7.73e-40   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g45388 i0 86.709 4.82822085889571 158 21 97 0 1 158 3216485 3216328 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 787 176 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
21460463 21460463 PRJNA278119_P_NODE_1517_length_993_cov_4.096398_g1334_i0 PRJNA278119 1517 993 4.096398 40.67723214 Nibricoccus 2576890 Bacteria Bacteria 1171 0   NTclustered gi|807238858|gb|CP011265.1| 1637999 g1334 i0 91.924 200.229607250755 842 61 84 7 1 838 1902491 1901653 Verrucomicrobia bacterium IMCC26134, complete genome blastn 198828 1182 0.990693739424704 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium IMCC26134
22047651 22047651 PRJNA278119_P_NODE_21338_length_215_cov_1.391566_g21089_i0 PRJNA278119 21338 215 1.391566 2.9918669 Chthoniobacteraceae bacterium 2811408 Bacteria Bacteria 93.5 1.12e-14   NTclustered gi|2813917447|gb|CP170506.1| 2811408 g21089 i0 93.651 0.423255813953488 63 3 29 1 81 143 4278816 4278755 MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome blastn 91 93.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae   Chthoniobacteraceae 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);;