RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA812715 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
2088174 2088174 PRJNA812715_P_NODE_17642_length_840_cov_4.661017_g16105_i0 PRJNA812715 17642 840 4.661017 39.1525428 Fimbriiglobus ruber 1908690 Bacteria Bacteria 1197 0   NTclustered gi|1227086021|ref|NR_148575.1| 1908690 g16105 i0 92.738 98.7916666666667 840 39 99 12 4 840 3 823 Fimbriiglobus ruber strain SP5 16S ribosomal RNA, partial sequence blastn 82985 1197 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Fimbriiglobus Fimbriiglobus ruber
2090593 2090593 PRJNA812715_P_NODE_95882_length_259_cov_2.048387_g94081_i0 PRJNA812715 95882 259 2.048387 5.30532233 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 307 4.5600000000000005e-79   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g94081 i0 88.031 17.1698841698842 259 31 100 0 1 259 2869578 2869320 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 4447 307 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
3364376 3364376 PRJNA812715_P_NODE_47623_length_395_cov_2.465839_g45826_i0 PRJNA812715 47623 395 2.465839 9.74006405 Urbifossiella limnaea 2528023 Bacteria Bacteria 220 9.79e-53   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g45826 i0 87.179 64.8329113924051 195 23 49 2 200 393 2018929 2018736 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 25609 220 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
8465312 8465312 PRJNA812715_P_NODE_125267_length_201_cov_4.359375_g123466_i0 PRJNA812715 125267 201 4.359375 8.76234375 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 206 1.27e-48   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g123466 i0 85.714 488.393034825871 196 26 97 2 7 201 2001910 2001716 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 98167 206 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
8467195 8467195 PRJNA812715_P_NODE_71247_length_303_cov_1.339130_g69447_i0 PRJNA812715 71247 303 1.33913 4.0575639 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 431 3.099999999999999e-116   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g69447 i0 92.208 57.026402640264 308 18 100 5 1 303 1156353 1156659 Planctomyces sp. SH-PL62, complete genome blastn 17279 431 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
9742294 9742294 PRJNA812715_P_NODE_72008_length_301_cov_1.013158_g70208_i0 PRJNA812715 72008 301 1.013158 3.04960558 Urbifossiella limnaea 2528023 Bacteria Bacteria 309 1.5100000000000002e-79   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g70208 i0 85.294 159.744186046512 306 37 100 6 1 301 2017966 2018268 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 48083 309 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
12293734 12293734 PRJNA812715_P_NODE_80190_length_284_cov_1.459716_g78390_i0 PRJNA812715 80190 284 1.459716 4.14559344 Paludisphaera borealis 1387353 Bacteria Bacteria 466 7.899999999999999e-127   NTclustered gi|1133581311|gb|CP019082.1| 1387353 g78390 i0 96.479 257.785211267606 284 7 99 3 2 284 122615 122334 Paludisphaera borealis strain PX4 chromosome, complete genome blastn 73211 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Paludisphaera Paludisphaera borealis
16527523 16527523 PRJNA812715_P_NODE_120133_length_241_cov_2.470238_g118332_i0 PRJNA812715 120133 241 2.470238 5.95327358 Gimesia 1649453 Bacteria Bacteria 261 3.31e-65   NTclustered gi|1712496122|gb|CP036269.1| 2527973 g118332 i0 87.124 132.551867219917 233 27 96 3 10 241 2395485 2395715 Gimesia alba strain Pan241w chromosome blastn 31945 261 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia alba
17391651 17391651 PRJNA812715_P_NODE_41214_length_437_cov_2.700549_g39419_i0 PRJNA812715 41214 437 2.700549 11.80139913 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 466 1.27e-126   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g39419 i0 87.407 4.92677345537757 405 51 93 0 21 425 698721 699125 Planctomyces sp. SH-PL62, complete genome blastn 2153 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
19938591 19938591 PRJNA812715_P_NODE_111256_length_246_cov_0.890173_g109455_i0 PRJNA812715 111256 246 0.890173 2.18982558 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 200 7.5e-47   NTclustered gi|2874253847|emb|OY969903.1| 904075 g109455 i0 85.128 3.8130081300813 195 29 79 0 52 246 532754 532560 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 938 200 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
21214122 21214122 PRJNA812715_P_NODE_112377_length_246_cov_0.878613_g110576_i0 PRJNA812715 112377 246 0.878613 2.16138798 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 344 3.27e-90   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g110576 i0 91.903 145.117886178862 247 18 100 2 1 246 2002640 2002395 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 35699 344 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
21214290 21214290 PRJNA812715_P_NODE_118557_length_242_cov_1.491124_g116756_i0 PRJNA812715 118557 242 1.491124 3.60852008 Aquisphaera giovannonii 406548 Bacteria Bacteria 435 1.85e-117   NTclustered gi|1730068067|gb|CP042997.1| 406548 g116756 i0 99.58 101.595041322314 238 1 98 0 1 238 5176340 5176577 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 24586 435 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
22489064 22489064 PRJNA812715_P_NODE_122958_length_235_cov_2.549383_g121157_i0 PRJNA812715 122958 235 2.549383 5.99105005 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 243 1.16e-59   NTclustered gi|2874253847|emb|OY969903.1| 904075 g121157 i0 85.654 34.1702127659574 237 27 99 7 3 235 1830793 1830560 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 8030 243 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
25038683 25038683 PRJNA812715_P_NODE_124800_length_219_cov_4.691781_g122999_i0 PRJNA812715 124800 219 4.691781 10.27500039 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 342 1.03e-89   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g122999 i0 94.977 169.200913242009 219 10 99 1 2 219 7051130 7050912 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 37055 342 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae 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);;