RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB65099 · 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
9057201 9057201 PRJEB65099_P_NODE_1028_length_625_cov_5.400362_g924_i0 PRJEB65099 1028 625 5.400362 33.7522625 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 734 0   NTclustered gi|2874253948|emb|OY970273.1| 100233 g924 i0 88.226 120.8656 620 65 99 8 1 617 2623595 2622981 MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1 blastn 75541 734 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
11608455 11608455 PRJEB65099_P_NODE_2750_length_348_cov_1.134545_g2645_i0 PRJEB65099 2750 348 1.134545 3.9482166 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 521 2.089999999999999e-143   NTclustered gi|523452411|gb|KF182831.1| 120965 g2645 i0 93.696 100.896551724138 349 20 100 2 1 348 17 364 Uncultured planctomycete clone S1-090 16S ribosomal RNA gene, partial sequence blastn 35112 521 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
12883554 12883554 PRJEB65099_P_NODE_5511_length_250_cov_0.881356_g5406_i0 PRJEB65099 5511 250 0.881356 2.20339 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 100 7.97e-17   NTclustered gi|2874253903|emb|OY970228.1| 100233 g5406 i0 74.803 20.596 254 49 97 14 5 246 2664206 2663956 MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1 blastn 5149 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
17981512 17981512 PRJEB65099_P_NODE_6935_length_242_cov_0.923077_g6830_i0 PRJEB65099 6935 242 0.923077 2.23384634 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 370 5.3e-98   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g6830 i0 94.215 104.652892561983 242 14 100 0 1 242 1230266 1230507 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 25326 370 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
23081885 23081885 PRJEB65099_P_NODE_6719_length_243_cov_0.917647_g6614_i0 PRJEB65099 6719 243 0.917647 2.22988221 Singulisphaera sp. Ch08 3120278 Bacteria Bacteria 433 6.69e-117   NTclustered gi|2732846650|gb|CP155447.1| 3120278 g6614 i0 98.765 319.954732510288 243 3 100 0 1 243 3412709 3412951 Singulisphaera sp. Ch08 chromosome, complete genome blastn 77749 433 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. Ch08

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