RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA674048 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1165866 1165866 PRJNA674048_P_NODE_14801_length_233_cov_2.211957_g14598_i0 PRJNA674048 14801 233 2.211957 5.15385981 Bacteria 2 Bacteria Bacteria 326 1.11e-84   NTclustered gi|2874253677|emb|OY969111.1| 171953 g14598 i0 91.736 98.6051502145923 242 9 100 7 1 233 715700 715461 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 blastn 22975 326 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
5746663 5746663 PRJNA674048_P_NODE_34025_length_153_cov_2.509615_g33822_i0 PRJNA674048 34025 153 2.509615 3.83971095 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 237 3.22e-58   NTclustered gi|2874254091|emb|OY970174.1| 171953 g33822 i0 94.737 138.790849673203 152 8 99 0 1 152 4357740 4357891 MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 blastn 21235 237 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
7021808 7021808 PRJNA674048_P_NODE_33146_length_160_cov_3.423423_g32943_i0 PRJNA674048 33146 160 3.423423 5.4774768 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 171 3.51e-38   NTclustered gi|2874254108|emb|OY970193.1| 171953 g32943 i0 91.87 141.86875 123 8 76 2 19 140 1690546 1690667 MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 blastn 22699 171 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
18495436 18495436 PRJNA674048_P_NODE_18735_length_204_cov_2.064516_g18532_i0 PRJNA674048 18735 204 2.064516 4.21161264 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 270 4.5099999999999985e-68   NTclustered gi|112980873|gb|DQ829677.1| 171953 g18532 i0 90.777 412 206 13 100 6 1 204 1814 1613 Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence blastn 84048 270 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19769958 19769958 PRJNA674048_P_NODE_22676_length_184_cov_4.059259_g22473_i0 PRJNA674048 22676 184 4.059259 7.46903656 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 220 4.06e-53   NTclustered gi|2874254159|emb|OY970389.1| 2283092 g22473 i0 90 73.4565217391304 170 17 92 0 1 170 2618324 2618155 MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1 blastn 13516 220 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
24117965 24117965 PRJNA674048_P_NODE_27339_length_169_cov_0.866667_g27136_i0 PRJNA674048 27339 169 0.866667 1.46466723 Pseudomonadati 3379134 Bacteria Bacteria 143 8.139999999999998e-30   NTclustered gi|1886125103|gb|CP046444.1| 1617967 g27136 i0 85.926 82.3550295857988 135 17 79 2 31 164 2543462 2543595 Granulicella sp. 5B5 chromosome, complete genome blastn 13918 143 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella sp. 5B5

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