RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA638138" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA638138 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
2430453 2430453 PRJNA638138_P_NODE_26242_length_247_cov_0.885057_g26027_i0 PRJNA638138 26242 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 457 4.05e-124   NTclustered gi|1483583505|emb|LT631429.1| 204 g26027 i0 100 110 247 0 100 0 1 247 33152 33398 Campylobacter showae genome assembly, plasmid: V blastn 27170 457 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
19736221 19736221 PRJNA638138_P_NODE_32916_length_243_cov_0.876471_g32701_i0 PRJNA638138 32916 243 0.876471 2.12982453 Campylobacter rectus 203 Bacteria Bacteria 350 6.94e-92   NTclustered gi|1622745323|gb|CP012543.1| 203 g32701 i0 92.623 2.0082304526749 244 17 100 1 1 243 1935867 1935624 Campylobacter rectus strain ATCC 33238, complete genome blastn 488 350 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
23562121 23562121 PRJNA638138_P_NODE_34859_length_241_cov_0.916667_g34644_i0 PRJNA638138 34859 241 0.916667 2.20916747 Campylobacter jejuni 197 Bacteria Bacteria 399 6.729999999999998e-107   NTclustered gi|972488604|gb|CP010480.1| 197 g34644 i0 96.68 4.95020746887967 241 7 100 1 1 241 1653778 1653539 Campylobacter jejuni strain CJ677CC524, complete genome blastn 1193 399 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);;