RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA781196 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
2486731 2486731 PRJNA781196_P_NODE_41422_length_278_cov_1.575610_g41045_i0 PRJNA781196 41422 278 1.57561 4.3801958 Planctomycetia 203683 Bacteria Bacteria 377 3.72e-100   NTclustered gi|12583967|gb|AF245371.1|AF245371 149588 g41045 i0 91.336 97.276978417266207 277 23 99 1 1 277 1454 1179 Planctomycete str. 139 23S ribosomal RNA gene, partial sequence blastn 27043 377 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 139
3310179 3310179 PRJNA781196_P_NODE_15283_length_422_cov_1.315186_g14906_i0 PRJNA781196 15283 422 1.315186 5.55008492 Urbifossiella limnaea 2528023 Bacteria Bacteria 483 1.22e-131   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g14906 i0 88.557 167.5663507109 402 41 95 5 23 422 4212047 4212445 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 70713 483 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
4587379 4587379 PRJNA781196_P_NODE_2564_length_921_cov_2.520047_g2282_i0 PRJNA781196 2564 921 2.520047 23.20963287 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 1212 0   NTclustered gi|2874254106|emb|OY970189.1| 100233 g2282 i0 90.635 366.972855591748 929 63 99 15 1 912 5935886 5936807 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 337982 1212 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
8412048 8412048 PRJNA781196_P_NODE_11527_length_477_cov_1.351485_g11151_i0 PRJNA781196 11527 477 1.351485 6.44658345 planctomycete str. 139 149588 Bacteria Bacteria 664 0   NTclustered gi|12583967|gb|AF245371.1|AF245371 149588 g11151 i0 91.824 147.176100628931 477 36 99 3 3 477 10 485 Planctomycete str. 139 23S ribosomal RNA gene, partial sequence blastn 70203 664 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 139
9687630 9687630 PRJNA781196_P_NODE_29408_length_323_cov_1.136000_g29031_i0 PRJNA781196 29408 323 1.136 3.66928 Urbifossiella limnaea 2528023 Bacteria Bacteria 403 7.27e-108   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g29031 i0 89.873 100.452012383901 316 28 98 4 4 317 2019862 2019549 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 32446 403 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
13513593 13513593 PRJNA781196_P_NODE_6671_length_603_cov_3.562264_g6297_i0 PRJNA781196 6671 603 3.562264 21.48045192 Urbifossiella limnaea 2528023 Bacteria Bacteria 667 0   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g6297 i0 86.601 192.860696517413 612 72 100 4 1 603 2018886 2018276 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 116295 667 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
18611049 18611049 PRJNA781196_P_NODE_48235_length_257_cov_1.695652_g47858_i0 PRJNA781196 48235 257 1.695652 4.35782564 Planctomycetales bacterium ZRK34 2723666 Bacteria Bacteria 126 1.36e-24   NTclustered gi|1898316769|gb|CP050848.1| 2723666 g47858 i0 92.135 2.91828793774319 89 7 35 0 6 94 3919915 3919827 Planctomycetales bacterium ZRK34 chromosome, complete genome blastn 750 126 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium ZRK34
19062925 19062925 PRJNA781196_P_NODE_28135_length_329_cov_1.046875_g27758_i0 PRJNA781196 28135 329 1.046875 3.44421875 Gemmataceae 1914233 Bacteria Bacteria 303 7.74e-78   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g27758 i0 83.582 119.334346504559 335 43 100 10 1 329 2017989 2017661 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 39261 303 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
22437074 22437074 PRJNA781196_P_NODE_66998_length_242_cov_0.923077_g66621_i0 PRJNA781196 66998 242 0.923077 2.23384634 Tautonia plasticadhaerens 2527974 Bacteria Bacteria 442 1.1099999999999995e-119   NTclustered gi|1712713678|gb|CP036426.1| 2527974 g66621 i0 99.587 47.3140495867769 242 1 100 0 1 242 265463 265704 Tautonia plasticadhaerens strain ElP chromosome blastn 11450 442 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia plasticadhaerens
24985968 24985968 PRJNA781196_P_NODE_4960_length_690_cov_2.439222_g4599_i0 PRJNA781196 4960 690 2.439222 16.8306318 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 804 0   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g4599 i0 87.767 116.408695652174 703 67 100 14 1 690 1599860 1599164 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 80322 804 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
24986064 24986064 PRJNA781196_P_NODE_5560_length_655_cov_1.625430_g5194_i0 PRJNA781196 5560 655 1.62543 10.6465665 planctomycete str. 139 149588 Bacteria Bacteria 835 0   NTclustered gi|12583967|gb|AF245371.1|AF245371 149588 g5194 i0 89.802 157.317557251908 657 59 99 7 2 655 2850 2199 Planctomycete str. 139 23S ribosomal RNA gene, partial sequence blastn 103043 835 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 139

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