RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1226487" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1226487 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
334937 334937 PRJNA1226487_P_NODE_46561_length_278_cov_1.502439_g46459_i0 PRJNA1226487 46561 278 1.502439 4.17678042 Tautonia plasticadhaerens 2527974 Bacteria Bacteria 78.7 4.22e-10   NTclustered gi|1712713678|gb|CP036426.1| 2527974 g46459 i0 89.062 0.589928057553957 64 6 23 1 47 109 891645 891582 Tautonia plasticadhaerens strain ElP chromosome blastn 164 78.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia plasticadhaerens
6712675 6712675 PRJNA1226487_P_NODE_39106_length_290_cov_1.419355_g39004_i0 PRJNA1226487 39106 290 1.419355 4.1161295 Tautonia plasticadhaerens 2527974 Bacteria Bacteria 228 4.1599999999999985e-55   NTclustered gi|1712713678|gb|CP036426.1| 2527974 g39004 i0 82.879 11.951724137931 257 40 88 4 36 290 5553133 5552879 Tautonia plasticadhaerens strain ElP chromosome blastn 3466 228 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia plasticadhaerens
10538922 10538922 PRJNA1226487_P_NODE_72229_length_245_cov_1.790698_g72127_i0 PRJNA1226487 72229 245 1.790698 4.3872101 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 211 3.45e-50   NTclustered gi|2874254106|emb|OY970189.1| 100233 g72127 i0 88.571 0.942857142857143 175 18 71 2 1 174 3233687 3233514 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 231 211 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
11813596 11813596 PRJNA1226487_P_NODE_47050_length_277_cov_1.509804_g46948_i0 PRJNA1226487 47050 277 1.509804 4.18215708 Aquisphaera giovannonii 406548 Bacteria Bacteria 206 1.85e-48   NTclustered gi|1730068067|gb|CP042997.1| 406548 g46948 i0 82.041 0.884476534296029 245 40 88 2 27 269 4068658 4068900 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 245 206 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
11813617 11813617 PRJNA1226487_P_NODE_51730_length_270_cov_1.563452_g51628_i0 PRJNA1226487 51730 270 1.563452 4.2213204 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 200 8.349999999999999e-47   NTclustered gi|2874254106|emb|OY970189.1| 100233 g51628 i0 87.006 61.4111111111111 177 23 66 0 1 177 2471029 2470853 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 16581 200 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
16912117 16912117 PRJNA1226487_P_NODE_62014_length_254_cov_1.701657_g61912_i0 PRJNA1226487 62014 254 1.701657 4.32220878 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 143 1.33e-29   NTclustered gi|2874254106|emb|OY970189.1| 100233 g61912 i0 90 0.874015748031496 110 11 43 0 101 210 2637241 2637350 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 222 143 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
18186553 18186553 PRJNA1226487_P_NODE_58715_length_259_cov_1.655914_g58613_i0 PRJNA1226487 58715 259 1.655914 4.28881726 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 176 1.34e-39   NTclustered gi|2874254106|emb|OY970189.1| 100233 g58613 i0 80.617 4.65250965250965 227 44 88 0 1 227 1326086 1326312 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 1205 176 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
20736383 20736383 PRJNA1226487_P_NODE_42197_length_285_cov_1.452830_g42095_i0 PRJNA1226487 42197 285 1.45283 4.1405655 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 409 1.3599999999999998e-109   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g42095 i0 92.606 52.0736842105263 284 21 99 0 1 284 5327417 5327700 Planctomyces sp. SH-PL62, complete genome blastn 14841 409 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
24561125 24561125 PRJNA1226487_P_NODE_44600_length_281_cov_1.480769_g44498_i0 PRJNA1226487 44600 281 1.480769 4.16096089 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 254 6.62e-63   NTclustered gi|2874253757|emb|OY969698.1| 100233 g44498 i0 84.291 19.1708185053381 261 39 93 2 1 260 899574 899315 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 5387 254 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae 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);;