RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1249042" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1249042 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

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
5457781 5457781 PRJNA1249042_S_NODE_2905_length_531_cov_5.008197_g2706_i0 PRJNA1249042 2905 531 5.008197 26.59352607 Acidobacteriota bacterium 1978231 Bacteria Bacteria 575 2.499999999999999e-159   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g2706 i0 87.205 294.905838041431 508 61 95 4 26 531 3298163 3298668 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 156595 575 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
6732172 6732172 PRJNA1249042_S_NODE_34166_length_233_cov_4.094737_g33952_i0 PRJNA1249042 34166 233 4.094737 9.54073721 Chloracidobacterium validum 2821543 Bacteria Bacteria 100 7.34e-17   NTclustered gi|2033659757|gb|CP072648.1| 2821543 g33952 i0 93.939 1.27896995708155 66 4 28 0 168 233 105590 105655 Chloracidobacterium validum strain BV2-C chromosome 1, complete sequence blastn 298 100 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium validum
8007565 8007565 PRJNA1249042_S_NODE_110027_length_154_cov_2.207207_g109813_i0 PRJNA1249042 110027 154 2.207207 3.39909878 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 122 9.499999999999999e-24   NTclustered gi|217038899|gb|EU810989.1| 171953 g109813 i0 98.551 55.9545454545455 69 1 45 0 86 154 428 360 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 8617 122 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
10558406 10558406 PRJNA1249042_S_NODE_18669_length_268_cov_3.035556_g18455_i0 PRJNA1249042 18669 268 3.035556 8.13529008 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 339 1.6799999999999998e-88   NTclustered gi|2874254027|emb|OY970352.1| 171953 g18455 i0 89.811 107.55223880597 265 25 99 2 5 268 2366969 2367232 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 28824 339 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14383346 14383346 PRJNA1249042_S_NODE_11852_length_296_cov_4.747036_g11638_i0 PRJNA1249042 11852 296 4.747036 14.05122656 Acidobacteriota bacterium 1978231 Bacteria Bacteria 372 1.86e-98   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g11638 i0 90.426 111.148648648649 282 27 95 0 1 282 3298617 3298336 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 32900 372 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
14383597 14383597 PRJNA1249042_S_NODE_42952_length_219_cov_4.301136_g42738_i0 PRJNA1249042 42952 219 4.301136 9.41948784 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 233 6.45e-57   NTclustered gi|217038907|gb|EU810998.1| 171953 g42738 i0 86.239 131.570776255708 218 26 99 4 1 216 293 78 Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence blastn 28814 233 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
22031145 22031145 PRJNA1249042_S_NODE_32278_length_237_cov_1.814433_g32064_i0 PRJNA1249042 32278 237 1.814433 4.30020621 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 261 3.25e-65   NTclustered gi|217038907|gb|EU810998.1| 171953 g32064 i0 86.667 306.029535864979 240 27 100 4 1 237 29 266 Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence blastn 72529 261 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;