RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1122875 · 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
277900 277900 PRJNA1122875_P_NODE_49361_length_245_cov_0.895349_g49137_i0 PRJNA1122875 49361 245 0.895349 2.19360505 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 272 1.56e-68   NTclustered gi|2874254049|emb|OY970373.1| 171953 g49137 i0 86.831 1.99591836734694 243 32 99 0 1 243 7262133 7262375 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 489 272 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9956831 9956831 PRJNA1122875_P_NODE_45488_length_249_cov_0.875000_g45264_i0 PRJNA1122875 45488 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 255 1.6e-63   NTclustered gi|2874253678|emb|OY969112.1| 171953 g45264 i0 85.317 3.81927710843373 252 31 100 6 1 249 2168107 2167859 MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 blastn 951 255 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14306552 14306552 PRJNA1122875_P_NODE_35072_length_279_cov_2.533981_g34848_i0 PRJNA1122875 35072 279 2.533981 7.06980699 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 86.1 2.53e-12   NTclustered gi|2874253709|emb|OY969474.1| 171953 g34848 i0 74.654 0.978494623655914 217 43 76 11 33 243 4784767 4784557 MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 blastn 273 86.1 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14306585 14306585 PRJNA1122875_P_NODE_37632_length_271_cov_0.833333_g37408_i0 PRJNA1122875 37632 271 0.833333 2.25833243 Alloacidobacterium dinghuense 2763107 Bacteria Bacteria 457 4.5099999999999986e-124   NTclustered gi|1895675831|gb|CP060394.1| 2763107 g37408 i0 97.048 1 271 8 100 0 1 271 538002 537732 Alloacidobacterium dinghuense strain 4Y35 chromosome, complete genome blastn 271 457 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Alloacidobacterium Alloacidobacterium dinghuense
14306765 14306765 PRJNA1122875_P_NODE_51432_length_243_cov_0.905882_g51208_i0 PRJNA1122875 51432 243 0.905882 2.20129326 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 250 7.2399999999999995e-62   NTclustered gi|2874253889|emb|OY970064.1| 194844 g51208 i0 85.246 1.72427983539095 244 34 100 2 1 243 2102271 2102029 MAG: uncultured Acidobacteriaceae bacterium isolate MFD06092.bin.c.1 genome assembly, chromosome: 1 blastn 419 250 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
19403270 19403270 PRJNA1122875_P_NODE_12516_length_471_cov_1.796482_g12293_i0 PRJNA1122875 12516 471 1.796482 8.46143022 Geothrix sp. PMB-07 3068640 Bacteria Bacteria 139 3.42e-28   NTclustered gi|2563347696|gb|CP132333.1| 3068640 g12293 i0 76.589 8.75796178343949 299 43 62 14 92 381 103848 104128 Geothrix sp. PMB-07 chromosome, complete genome blastn 4125 139 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp. PMB-07

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