RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1240805" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240805 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5452939 5452939 PRJNA1240805_P_NODE_5285_length_198_cov_7.624161_g5236_i0 PRJNA1240805 5285 198 7.624161 15.09583878 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 202 1.61e-47   NTclustered gi|217038899|gb|EU810989.1| 171953 g5236 i0 94.615 78.459595959596 130 7 66 0 69 198 1 130 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 15535 202 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9978593 9978593 PRJNA1240805_P_NODE_8228_length_162_cov_1.805310_g8179_i0 PRJNA1240805 8228 162 1.80531 2.9246022 Pseudomonadati 3379134 Bacteria Bacteria 71.3 3.72e-8   NTclustered gi|2874253836|emb|OY969886.1| 171953 g8179 i0 95.455 1.6358024691358 44 2 27 0 110 153 888373 888330 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 265 71.3 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
15652422 15652422 PRJNA1240805_P_NODE_3573_length_244_cov_13.179487_g3524_i0 PRJNA1240805 3573 244 13.179487 32.15794828 Acidobacteriota bacterium 1978231 Bacteria Bacteria 296 9.21e-76   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g3524 i0 90.95 96.8196721311475 221 19 91 1 1 221 4648915 4648696 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 23624 296 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
19475504 19475504 PRJNA1240805_P_NODE_6036_length_186_cov_3.204380_g5987_i0 PRJNA1240805 6036 186 3.20438 5.9601468 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 207 3.21e-49   NTclustered gi|2874253692|emb|OY969418.1| 171953 g5987 i0 90 110.123655913978 160 16 86 0 1 160 4233763 4233922 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 20483 207 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20751021 20751021 PRJNA1240805_P_NODE_8957_length_154_cov_3.266667_g8908_i0 PRJNA1240805 8957 154 3.266667 5.03066718 Acidobacteriota bacterium 1978231 Bacteria Bacteria 243 6.99e-60   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g8908 i0 95.395 244.253246753247 152 7 99 0 1 152 4649311 4649462 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 37615 243 1 Bacteria   Pseudomonadati Acidobacteriota         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);;