RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1073183" 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 · 5 ✖

bioproject 1

  • PRJNA1073183 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
10390308 10390308 PRJNA1073183_P_NODE_10889_length_389_cov_2.066456_g10794_i0 PRJNA1073183 10889 389 2.066456 8.03851384 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 496 1.43e-135   NTclustered gi|226525339|gb|FJ872375.1| 156588 g10794 i0 91.831 155.804627249357 355 29 91 0 1 355 27824 27470 Uncultured Verrucomicrobia bacterium clone 286 genomic sequence blastn 60608 496 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
11665886 11665886 PRJNA1073183_P_NODE_24590_length_262_cov_2.005291_g24495_i0 PRJNA1073183 24590 262 2.005291 5.25386242 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 451 2.02e-122   NTclustered gi|389547028|gb|JQ401956.1| 100233 g24495 i0 97.71 98.2328244274809 262 6 100 0 1 262 39 300 Uncultured Planctomycetaceae bacterium clone CNY_02197 16S ribosomal RNA gene, partial sequence blastn 25737 451 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
12941003 12941003 PRJNA1073183_P_NODE_25491_length_256_cov_3.234973_g25396_i0 PRJNA1073183 25491 256 3.234973 8.28153088 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 215 2.8e-51   NTclustered gi|2874254106|emb|OY970189.1| 100233 g25396 i0 85.922 113.05078125 206 23 79 6 9 211 4317291 4317089 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 28941 215 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
15489960 15489960 PRJNA1073183_P_NODE_30873_length_245_cov_1.901163_g30778_i0 PRJNA1073183 30873 245 1.901163 4.65784935 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 353 5.41e-93   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g30778 i0 92.653 194.951020408163 245 18 100 0 1 245 2002870 2002626 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 47763 353 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
17593823 17593823 PRJNA1073183_P_NODE_19314_length_297_cov_1.736607_g19219_i0 PRJNA1073183 19314 297 1.736607 5.15772279 Singulisphaera 466152 Bacteria Bacteria 387 6.66e-103   NTclustered gi|485099129|ref|NR_102524.1| 466153 g19219 i0 90.301 118.043771043771 299 24 99 5 2 297 299 3 Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence blastn 35059 387 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera acidiphila

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