RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA631119 · 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
3154036 3154036 PRJNA631119_P_NODE_15163_length_328_cov_3.470588_g15045_i0 PRJNA631119 15163 328 3.470588 11.38352864 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 309 1.66e-79   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g15045 i0 84.591 43.280487804878 318 41 95 6 3 312 7050823 7050506 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 14196 309 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
8256382 8256382 PRJNA631119_P_NODE_28047_length_261_cov_1.228723_g27929_i0 PRJNA631119 28047 261 1.228723 3.20696703 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 364 2.689999999999999e-96   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g27929 i0 91.985 90.0727969348659 262 17 100 2 1 261 1600509 1600251 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 23509 364 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
15905978 15905978 PRJNA631119_P_NODE_14393_length_334_cov_3.084291_g14275_i0 PRJNA631119 14393 334 3.084291 10.30153194 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 547 3.2899999999999986e-151   NTclustered gi|317120536|gb|HQ010214.1| 120965 g14275 i0 96.933 98.1047904191617 326 10 98 0 4 329 613 938 Uncultured planctomycete clone soil31_C7 16S ribosomal RNA gene, partial sequence blastn 32767 547 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
15906015 15906015 PRJNA631119_P_NODE_22153_length_286_cov_1.446009_g22035_i0 PRJNA631119 22153 286 1.446009 4.13558574 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 350 8.369999999999999e-92   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g22035 i0 88.889 80.9510489510489 288 26 99 6 3 286 7052547 7052262 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 23152 350 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24829549 24829549 PRJNA631119_P_NODE_36680_length_244_cov_0.900585_g36562_i0 PRJNA631119 36680 244 0.900585 2.1974274 Mariniblastus fucicola 980251 Bacteria Bacteria 52.8 0.022   NTclustered gi|1730062935|gb|CP042912.1| 980251 g36562 i0 100 0.114754098360656 28 0 11 0 188 215 5198891 5198918 Mariniblastus fucicola strain FC18 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Mariniblastus Mariniblastus fucicola

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