RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA688736 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
8830250 8830250 PRJNA688736_P_NODE_22827_length_330_cov_1.214008_g22542_i0 PRJNA688736 22827 330 1.214008 4.0062264 Gemmata 113 Bacteria Bacteria 494 4.29e-135   NTclustered gi|12583965|gb|AF245369.1|AF245369 114 g22542 i0 93.675 141.193939393939 332 17 100 4 1 330 687 1016 Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence blastn 46594 494 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
10872274 10872274 PRJNA688736_P_NODE_50229_length_242_cov_1.485207_g49944_i0 PRJNA688736 50229 242 1.485207 3.59420094 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 285 1.97e-72   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g49944 i0 90.045 0.913223140495868 221 21 91 1 22 242 4824011 4824230 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 221 285 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
17245714 17245714 PRJNA688736_P_NODE_34014_length_275_cov_1.351485_g33729_i0 PRJNA688736 34014 275 1.351485 3.71658375 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 326 1.35e-84   NTclustered gi|2874253847|emb|OY969903.1| 904075 g33729 i0 89.354 92.0909090909091 263 23 94 4 1 258 1830995 1831257 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 25325 326 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
22344857 22344857 PRJNA688736_P_NODE_21358_length_339_cov_4.424812_g21073_i0 PRJNA688736 21358 339 4.424812 15.00011268 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 532 9.38e-147   NTclustered gi|2874254106|emb|OY970189.1| 100233 g21073 i0 95.015 156.666666666667 341 13 100 4 1 339 5934820 5935158 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 53110 532 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
22855188 22855188 PRJNA688736_P_NODE_45598_length_247_cov_0.896552_g45313_i0 PRJNA688736 45598 247 0.896552 2.21448344 Gemmataceae 1914233 Bacteria Bacteria 327 3.31e-85   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g45313 i0 92.544 196.97975708502 228 17 92 0 1 228 2018466 2018693 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 48654 327 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
23620884 23620884 PRJNA688736_P_NODE_41599_length_251_cov_1.314607_g41314_i0 PRJNA688736 41599 251 1.314607 3.29966357 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 381 2.549999999999999e-101   NTclustered gi|2874253847|emb|OY969903.1| 904075 g41314 i0 94.071 56.3147410358566 253 11 100 4 1 251 1830841 1830591 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 14135 381 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales 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);;