RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA561212 · 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
545354 545354 PRJNA561212_P_NODE_21541_length_250_cov_6.966102_g21330_i0 PRJNA561212 21541 250 6.966102 17.415255 Anatilimnocola aggregata 2528021 Bacteria Bacteria 296 9.47e-76   NTclustered gi|1712591889|gb|CP036274.1| 2528021 g21330 i0 89.655 19.424 232 24 93 0 10 241 7630835 7631066 Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome blastn 4856 296 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata
1130752 1130752 PRJNA561212_P_NODE_23241_length_247_cov_0.896552_g23030_i0 PRJNA561212 23241 247 0.896552 2.21448344 Botrimarina 2795782 Bacteria Bacteria 95.3 3.66e-15   NTclustered gi|1712768844|gb|CP036350.1| 2527962 g23030 i0 96.491 20.587044534413 57 2 34 0 10 66 4246291 4246235 Planctomycetes bacterium K2D chromosome, complete genome blastn 5085 95.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium K2D
1820964 1820964 PRJNA561212_P_NODE_14702_length_292_cov_1.977169_g14491_i0 PRJNA561212 14702 292 1.977169 5.77333348 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 329 1.12e-85   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g14491 i0 88.603 164.352739726027 272 29 92 2 8 277 7050231 7050502 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 47991 329 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
5649177 5649177 PRJNA561212_P_NODE_19045_length_261_cov_0.978723_g18834_i0 PRJNA561212 19045 261 0.978723 2.55446703 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 418 2.0399999999999995e-112   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g18834 i0 97.541 165.486590038314 244 6 93 0 9 252 2582267 2582024 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 43192 418 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
13884557 13884557 PRJNA561212_P_NODE_25031_length_244_cov_0.871345_g24820_i0 PRJNA561212 25031 244 0.871345 2.1260818 Pirellula 123 Bacteria Bacteria 102 2.15e-17   NTclustered gi|470485626|ref|NR_076710.1| 125 g24820 i0 78.659 27.2827868852459 164 28 67 4 55 217 1839 1682 Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence blastn 6657 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula staleyi
15158739 15158739 PRJNA561212_P_NODE_19632_length_256_cov_1.617486_g19421_i0 PRJNA561212 19632 256 1.617486 4.14076416 Phycisphaera 666508 Bacteria Bacteria 202 2.1799999999999998e-47   NTclustered gi|470476024|ref|NR_076315.1| 547188 g19421 i0 82.553 14.2578125 235 36 91 5 11 243 193 424 Phycisphaera mikurensis strain FYK2301M01 23S ribosomal RNA gene, complete sequence blastn 3650 202 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera mikurensis
15848323 15848323 PRJNA561212_P_NODE_24873_length_244_cov_0.912281_g24662_i0 PRJNA561212 24873 244 0.912281 2.22596564 Planctopirus ephydatiae 2528019 Bacteria Bacteria 189 1.6099999999999996e-43   NTclustered gi|1712709119|gb|CP036299.1| 2528019 g24662 i0 81.545 331.040983606557 233 40 95 3 8 239 3939188 3939418 Planctopirus ephydatiae strain spb1 chromosome, complete genome blastn 80774 189 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctopirus Planctopirus ephydatiae

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