RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1123686" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1123686 · 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
280936 280936 PRJNA1123686_S_NODE_4581_length_234_cov_283582.009756_g4549_i0 PRJNA1123686 4581 234 283582.009756 663581.90282904 Campylobacter jejuni 197 Bacteria Bacteria 58.4 4.5e-4   NTclustered gi|1098450108|gb|CP017863.1| 197 g4549 i0 97.059 0.145299145299145 34 1 15 0 146 179 640628 640661 Campylobacter jejuni strain IF1100, complete genome blastn 34 58.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
1555501 1555501 PRJNA1123686_S_NODE_4582_length_234_cov_278849.848780_g4550_i0 PRJNA1123686 4582 234 278849.84878 652508.6461452 Campylobacter jejuni 197 Bacteria Bacteria 56.5 0.002   NTclustered gi|1098450108|gb|CP017863.1| 197 g4550 i0 80.899 0.38034188034188 89 2 38 8 146 234 640628 640701 Campylobacter jejuni strain IF1100, complete genome blastn 89 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
2831585 2831585 PRJNA1123686_S_NODE_4583_length_234_cov_270078.248780_g4551_i0 PRJNA1123686 4583 234 270078.24878 631983.1021452 Campylobacter jejuni 197 Bacteria Bacteria 56.5 0.002   NTclustered gi|1098450108|gb|CP017863.1| 197 g4551 i0 96.97 0.141025641025641 33 1 14 0 57 89 640660 640628 Campylobacter jejuni strain IF1100, complete genome blastn 33 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
6658758 6658758 PRJNA1123686_S_NODE_7966_length_201_cov_21397.034884_g7934_i0 PRJNA1123686 7966 201 21397.034884 43008.04011684 Campylobacter jejuni 197 Bacteria Bacteria 56.5 0.001   NTclustered gi|1098450108|gb|CP017863.1| 197 g7934 i0 96.97 0.164179104477612 33 1 16 0 24 56 640660 640628 Campylobacter jejuni strain IF1100, complete genome blastn 33 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
24506850 24506850 PRJNA1123686_S_NODE_4580_length_234_cov_284279.800000_g4548_i0 PRJNA1123686 4580 234 284279.8 665214.732 Campylobacter jejuni 197 Bacteria Bacteria 58.4 4.5e-4   NTclustered gi|1098450108|gb|CP017863.1| 197 g4548 i0 97.059 0.145299145299145 34 1 15 0 146 179 640628 640661 Campylobacter jejuni strain IF1100, complete genome blastn 34 58.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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