RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB25583" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJEB25583 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
5125396 5125396 PRJEB25583_P_NODE_4705_length_189_cov_1.309211_g4528_i0 PRJEB25583 4705 189 1.309211 2.47440879 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 294 2.44e-75   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g4528 i0 94.709 164.486772486772 189 10 100 0 1 189 2502446 2502634 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 31088 294 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
8949966 8949966 PRJEB25583_P_NODE_1348_length_380_cov_2.763848_g1172_i0 PRJEB25583 1348 380 2.763848 10.5026224 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 571 2.2499999999999996e-158   NTclustered gi|2874253779|emb|OY969763.1| 412056 g1172 i0 93.75 156.302631578947 384 18 100 6 1 380 3832398 3832779 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 59395 571 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10225773 10225773 PRJEB25583_P_NODE_7629_length_155_cov_1.669492_g7452_i0 PRJEB25583 7629 155 1.669492 2.5877126 Poriferisphaera corsica 2528020 Bacteria Bacteria 165 1.57e-36   NTclustered gi|1712598971|gb|CP036425.1| 2528020 g7452 i0 90.476 38.7612903225806 126 10 81 2 2 126 3163771 3163895 Poriferisphaera corsica strain KS4 chromosome, complete genome blastn 6008 165 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Poriferisphaera Poriferisphaera corsica
11189793 11189793 PRJEB25583_P_NODE_7389_length_157_cov_1.291667_g7212_i0 PRJEB25583 7389 157 1.291667 2.02791719 Isosphaera 127 Bacteria Bacteria 163 5.74e-36   NTclustered gi|470487262|ref|NR_076810.1| 128 g7212 i0 85.987 13.6687898089172 157 17 100 4 1 157 1242 1091 Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence blastn 2146 163 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera pallida

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