RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1102048 · 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
1486474 1486474 PRJNA1102048_P_NODE_9262_length_287_cov_1.271028_g9158_i0 PRJNA1102048 9262 287 1.271028 3.64785036 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 418 2.2699999999999993e-112   NTclustered gi|2874253948|emb|OY970273.1| 100233 g9158 i0 93.286 99.1951219512195 283 19 99 0 1 283 2622374 2622092 MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1 blastn 28469 418 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
16788856 16788856 PRJNA1102048_P_NODE_17154_length_242_cov_0.911243_g17050_i0 PRJNA1102048 17154 242 0.911243 2.20520806 Phycisphaerae bacterium 2026778 Bacteria Bacteria 303 5.45e-78   NTclustered gi|2621780281|emb|OY776568.1| 2026778 g17050 i0 89.256 194.363636363636 242 26 100 0 1 242 4346581 4346822 MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1 blastn 47036 303 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
18063437 18063437 PRJNA1102048_P_NODE_15835_length_245_cov_0.895349_g15731_i0 PRJNA1102048 15835 245 0.895349 2.19360505 Aquisphaera giovannonii 406548 Bacteria Bacteria 207 4.46e-49   NTclustered gi|1730068067|gb|CP042997.1| 406548 g15731 i0 82.305 17.2204081632653 243 39 98 4 3 243 6164177 6163937 Aquisphaera giovannonii strain OJF2 chromosome, complete genome blastn 4219 207 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
18063441 18063441 PRJNA1102048_P_NODE_16055_length_244_cov_0.900585_g15951_i0 PRJNA1102048 16055 244 0.900585 2.1974274 Rohdeia mirabilis 2528008 Bacteria Bacteria 187 5.7799999999999984e-43   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g15951 i0 80.658 151.385245901639 243 45 99 2 1 242 3894478 3894719 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 36938 187 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
21888612 21888612 PRJNA1102048_P_NODE_6158_length_348_cov_0.905455_g6054_i0 PRJNA1102048 6158 348 0.905455 3.1509834 Lignipirellula cremea 2528010 Bacteria Bacteria 514 3.4999999999999997e-141   NTclustered gi|1712668320|gb|CP036433.1| 2528010 g6054 i0 93.41 168.462643678161 349 20 100 3 1 348 1144448 1144794 Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome blastn 58625 514 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Lignipirellula Lignipirellula cremea

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