RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA826497" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA826497 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
9748698 9748698 PRJNA826497_S_NODE_7208_length_205_cov_10.313953_g7168_i0 PRJNA826497 7208 205 10.313953 21.14360365 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 322 1.24e-83   NTclustered gi|76574288|gb|DQ139436.1| 171953 g7168 i0 95.522 23.0780487804878 201 9 98 0 1 201 243 43 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 4731 322 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19947170 19947170 PRJNA826497_S_NODE_10816_length_182_cov_20.382550_g10776_i0 PRJNA826497 10816 182 20.38255 37.096241 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 206 1.12e-48   NTclustered gi|76574288|gb|DQ139436.1| 171953 g10776 i0 87.931 24.5769230769231 174 21 96 0 1 174 196 23 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 4473 206 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
21222709 21222709 PRJNA826497_S_NODE_6817_length_209_cov_3.551136_g6777_i0 PRJNA826497 6817 209 3.551136 7.42187424 Acidobacteriota bacterium 1978231 Bacteria Bacteria 375 9.57e-100   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g6777 i0 99.043 121.985645933014 209 2 100 0 1 209 3298946 3298738 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 25495 375 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
23773046 23773046 PRJNA826497_S_NODE_15159_length_164_cov_9.580153_g15119_i0 PRJNA826497 15159 164 9.580153 15.71145092 Geothrix sp. 1962974 Bacteria Bacteria 67.6 4.89e-7   NTclustered gi|2515262989|gb|CP126625.1| 1962974 g15119 i0 93.333 4.71951219512195 45 3 27 0 63 107 117074 117118 MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome blastn 774 67.6 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.

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