RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA796753 · 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
780675 780675 PRJNA796753_P_NODE_3321_length_729_cov_1.612805_g3037_i0 PRJNA796753 3321 729 1.612805 11.75734845 Humisphaera borealis 2807512 Bacteria Bacteria 782 0   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g3037 i0 87.391 244.03840877915 690 75 94 11 2 684 5063735 5063051 Humisphaera borealis strain M1803 chromosome, complete genome blastn 177904 782 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
4609059 4609059 PRJNA796753_P_NODE_33284_length_269_cov_1.571429_g32972_i0 PRJNA796753 33284 269 1.571429 4.22714401 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 357 4.66e-94   NTclustered gi|2874253847|emb|OY969903.1| 904075 g32972 i0 90.741 249.271375464684 270 22 100 3 1 269 1831231 1830964 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 67054 357 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
5884096 5884096 PRJNA796753_P_NODE_11865_length_406_cov_1.246246_g11553_i0 PRJNA796753 11865 406 1.246246 5.05975876 Phycisphaerales bacterium 2052180 Bacteria Bacteria 56.5 0.003   NTclustered gi|2108090597|gb|CP070744.1| 2052180 g11553 i0 100 0.0738916256157636 30 0 7 0 296 325 3062896 3062925 MAG: Phycisphaerales bacterium isolate bin37 chromosome blastn 30 56.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
6320656 6320656 PRJNA796753_P_NODE_10225_length_433_cov_1.666667_g9913_i0 PRJNA796753 10225 433 1.666667 7.21666811 Pseudomonadati 3379134 Bacteria Bacteria 776 0   NTclustered gi|2874253974|emb|OY970299.1| 412056 g9913 i0 99.074 103.956120092379 432 4 99 0 2 433 1259025 1258594 MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 blastn 45013 776 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
8433743 8433743 PRJNA796753_P_NODE_22207_length_316_cov_0.979424_g21895_i0 PRJNA796753 22207 316 0.979424 3.09497984 Aeoliella mucimassa 2527972 Bacteria Bacteria 52.8 0.03   NTclustered gi|1712622222|gb|CP036278.1| 2527972 g21895 i0 100 0.0886075949367089 28 0 9 0 289 316 1917411 1917384 Aeoliella mucimassa strain Pan181 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Aeoliella Aeoliella mucimassa
10984751 10984751 PRJNA796753_P_NODE_44369_length_248_cov_0.880000_g44057_i0 PRJNA796753 44369 248 0.88 2.1824 Chlamydia serpentis 1967782 Bacteria Bacteria 52.8 0.022   NTclustered gi|1376449303|emb|LT993738.1| 1967782 g44057 i0 100 0.112903225806452 28 0 11 0 128 155 72844 72817 Chlamydia sp. H15-1957-10C genome assembly, chromosome: I blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia serpentis
23733506 23733506 PRJNA796753_P_NODE_38439_length_252_cov_1.290503_g38127_i0 PRJNA796753 38439 252 1.290503 3.25206756 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 309 1.23e-79   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g38127 i0 88.976 119.603174603175 254 23 100 4 1 252 2502230 2501980 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 30140 309 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae 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);;