RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1255065 · 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
360510 360510 PRJNA1255065_P_NODE_75461_length_208_cov_2.698113_g73233_i0 PRJNA1255065 75461 208 2.698113 5.61207504 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 344 2.6799999999999993e-90   NTclustered gi|2874253692|emb|OY969418.1| 171953 g73233 i0 97.059 117.173076923077 204 6 98 0 5 208 4231896 4231693 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 24372 344 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
360605 360605 PRJNA1255065_P_NODE_87661_length_189_cov_1.478571_g85433_i0 PRJNA1255065 87661 189 1.478571 2.79449919 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 316 5.21e-82   NTclustered gi|2874253678|emb|OY969112.1| 171953 g85433 i0 96.842 187.693121693122 190 5 100 1 1 189 4731756 4731945 MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 blastn 35474 316 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
1635206 1635206 PRJNA1255065_P_NODE_57142_length_257_cov_1.509615_g54914_i0 PRJNA1255065 57142 257 1.509615 3.87971055 Acidobacteriota bacterium 1978231 Bacteria Bacteria 320 5.8e-83   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g54914 i0 89.189 110.801556420233 259 25 100 3 1 257 317243 317500 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 28476 320 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
2911165 2911165 PRJNA1255065_P_NODE_58843_length_251_cov_1.054455_g56615_i0 PRJNA1255065 58843 251 1.054455 2.64668205 Terriglobus roseus 392734 Bacteria Bacteria 453 5.34e-123   NTclustered gi|390410848|gb|CP003379.1| 926566 g56615 i0 99.203 103.358565737052 251 2 100 0 1 251 2077736 2077486 Terriglobus roseus DSM 18391, complete genome blastn 25943 453 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus roseus
6738025 6738025 PRJNA1255065_P_NODE_18146_length_659_cov_3.055738_g16120_i0 PRJNA1255065 18146 659 3.055738 20.13731342 Acidobacteriota bacterium 1978231 Bacteria Bacteria 935 0   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g16120 i0 92.273 104.817905918058 660 49 99 1 1 658 317753 318412 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 69075 935 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
12531620 12531620 PRJNA1255065_P_NODE_110250_length_168_cov_1.344538_g108022_i0 PRJNA1255065 110250 168 1.344538 2.25882384 Bacteria 2 Bacteria Bacteria 267 4.63e-67   NTclustered gi|2874253692|emb|OY969418.1| 171953 g108022 i0 98.039 109.89880952381 153 3 91 0 16 168 4231863 4232015 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 18463 267 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
22037146 22037146 PRJNA1255065_P_NODE_60598_length_245_cov_1.056122_g58370_i0 PRJNA1255065 60598 245 1.056122 2.5874989 Acidobacteriota bacterium 1978231 Bacteria Bacteria 342 1.17e-89   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g58370 i0 91.837 151.183673469388 245 20 100 0 1 245 4648684 4648928 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 37040 342 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);;