RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA193544" and tax_phylum = "Candidatus Peregrinibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Peregrinibacteriota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA193544 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_kingdom 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
5469258 5469258 PRJNA193544_S_NODE_965_length_254_cov_21.026667_g950_i0 PRJNA193544 965 254 21.026667 53.40773418 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 285 2.09e-72   NTclustered gi|2225492643|gb|CP082927.1| 2053688 g950 i0 88.608 59.3858267716535 237 24 93 3 18 252 195433 195198 MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome blastn 15084 285 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
6743540 6743540 PRJNA193544_S_NODE_1246_length_229_cov_7.290000_g1231_i0 PRJNA193544 1246 229 7.29 16.6941 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 329 8.43e-86   NTclustered gi|2225492643|gb|CP082927.1| 2053688 g1231 i0 93.274 66.3144104803494 223 15 97 0 1 223 195100 194878 MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome blastn 15186 329 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
8019281 8019281 PRJNA193544_S_NODE_507_length_315_cov_13459.835664_g492_i0 PRJNA193544 507 315 13459.835664 42398.4823416 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 219 2.7499999999999993e-52   NTclustered gi|2225492643|gb|CP082927.1| 2053688 g492 i0 82.642 152.663492063492 265 28 81 14 34 289 192749 192494 MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome blastn 48089 219 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
13119649 13119649 PRJNA193544_S_NODE_1351_length_222_cov_4.150259_g1336_i0 PRJNA193544 1351 222 4.150259 9.21357498 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 278 2.98e-70   NTclustered gi|2225492643|gb|CP082927.1| 2053688 g1336 i0 89.189 4.18468468468468 222 24 100 0 1 222 193276 193055 MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome blastn 929 278 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria 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);;