RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA615175 · 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
9523367 9523367 PRJNA615175_P_NODE_23788_length_280_cov_2.318841_g23620_i0 PRJNA615175 23788 280 2.318841 6.4927548 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 364 2.919999999999999e-96   NTclustered gi|2874253948|emb|OY970273.1| 100233 g23620 i0 89.831 139.864285714286 295 15 100 7 1 280 2621967 2621673 MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1 blastn 39162 364 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
10799034 10799034 PRJNA615175_P_NODE_14049_length_379_cov_3.179739_g13881_i0 PRJNA615175 14049 379 3.179739 12.05121081 Anatilimnocola aggregata 2528021 Bacteria Bacteria 549 1.0499999999999996e-151   NTclustered gi|1712591889|gb|CP036274.1| 2528021 g13881 i0 92.857 86.4300791556728 378 27 99 0 1 378 7629890 7629513 Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome blastn 32757 549 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata
13349040 13349040 PRJNA615175_P_NODE_20251_length_308_cov_2.400000_g20083_i0 PRJNA615175 20251 308 2.4 7.392 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 257 5.68e-64   NTclustered gi|2874253847|emb|OY969903.1| 904075 g20083 i0 82.623 50.7857142857143 305 40 97 12 9 307 1831543 1831246 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 15642 257 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
16452560 16452560 PRJNA615175_P_NODE_17813_length_331_cov_4.410853_g17645_i0 PRJNA615175 17813 331 4.410853 14.59992343 Gemmata 113 Bacteria Bacteria 584 2.4899999999999985e-162   NTclustered gi|1727537522|gb|CP042911.1| 114 g17645 i0 98.489 111.111782477341 331 5 100 0 1 331 2941848 2942178 Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome blastn 36778 584 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
24821051 24821051 PRJNA615175_P_NODE_17420_length_335_cov_4.354962_g17252_i0 PRJNA615175 17420 335 4.3549620000000004 14.5891227 Anatilimnocola aggregata 2528021 Bacteria Bacteria 442 1.5999999999999994e-119   NTclustered gi|1712591889|gb|CP036274.1| 2528021 g17252 i0 90.504 202.382089552239 337 29 100 2 1 335 7629543 7629208 Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome blastn 67798 442 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata

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