RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA473824" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA473824 · 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
4274157 4274157 PRJNA473824_P_NODE_63604_length_173_cov_4.441176_g62966_i0 PRJNA473824 63604 173 4.441176 7.68323448 Campylobacter showae 204 Bacteria Bacteria 141 3.01e-29   NTclustered gi|1483583503|emb|LT631427.1| 204 g62966 i0 100 4.5202312138728296 76 0 87 0 1 76 16905 16980 Campylobacter showae genome assembly, plasmid: III blastn 782 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
8749601 8749601 PRJNA473824_P_NODE_70287_length_173_cov_3.904412_g69649_i0 PRJNA473824 70287 173 3.904412 6.75463276 Campylobacter 194 Bacteria Bacteria 141 3.01e-29   NTclustered gi|1938724023|gb|CP060707.1| 199 g69649 i0 100 14.4393063583815 76 0 88 0 98 173 51890 51965 Campylobacter concisus strain P1CDO2 chromosome, complete genome blastn 2498 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
9375175 9375175 PRJNA473824_P_NODE_93928_length_173_cov_2.889706_g93290_i0 PRJNA473824 93928 173 2.889706 4.99919138 Campylobacter concisus 199 Bacteria Bacteria 141 3.01e-29   NTclustered gi|1938715890|gb|CP049263.1| 199 g93290 i0 100 4.65895953757225 76 0 44 0 1 76 1783145 1783070 Campylobacter concisus strain H16O-S1 chromosome, complete genome blastn 806 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
10024772 10024772 PRJNA473824_P_NODE_37308_length_198_cov_1.142857_g36670_i0 PRJNA473824 37308 198 1.142857 2.26285686 Campylobacter 194 Bacteria Bacteria 366 5.4e-97   NTclustered gi|1122816700|gb|KX096290.1| 204 g36670 i0 100 107.484848484848 198 0 100 0 1 198 254 57 Campylobacter showae culture KCOM:2587 16S ribosomal RNA gene, partial sequence blastn 21282 366 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
13849945 13849945 PRJNA473824_P_NODE_165171_length_150_cov_4.530973_g164533_i0 PRJNA473824 165171 150 4.530973 6.7964595 root 1 Root_unresolved Root_unresolved 143 7.049999999999998e-30   NTclustered gi|2323232558|gb|CP109813.1| 195 g164533 i0 100 116.286666666667 77 0 100 0 1 77 315908 315832 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 17443 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
16399339 16399339 PRJNA473824_P_NODE_98273_length_173_cov_2.808824_g97635_i0 PRJNA473824 98273 173 2.808824 4.85926552 Campylobacter 194 Bacteria Bacteria 141 3.01e-29   NTclustered gi|1483583497|emb|LT631421.1| 204 g97635 i0 100 2.19653179190751 76 0 44 0 98 173 54477 54552 Campylobacter showae genome assembly, chromosome: I blastn 380 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
21498292 21498292 PRJNA473824_P_NODE_31877_length_212_cov_0.840000_g31239_i0 PRJNA473824 31877 212 0.84 1.7808 Campylobacter 194 Bacteria Bacteria 390 3.48e-104   NTclustered gi|1935888393|gb|CP049239.1| 199 g31239 i0 100 227.88679245283 211 0 99 0 1 211 1032358 1032148 Campylobacter concisus strain P3UCO1 chromosome, complete genome blastn 48312 390 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus

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