RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1137393 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1032102 1032102 PRJNA1137393_P_NODE_55601_length_166_cov_0.888889_g55085_i0 PRJNA1137393 55601 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 307 2.69e-79   NTclustered gi|1145145120|gb|KX686749.1| 195 g55085 i0 100 101 166 0 100 0 1 166 46619 46454 Campylobacter coli strain Tx40 plasmid unnamed, complete sequence blastn 16766 307 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
7937672 7937672 PRJNA1137393_P_NODE_11247_length_248_cov_1.432161_g10731_i0 PRJNA1137393 11247 248 1.432161 3.55175928 Arcobacter acticola 1849015 Bacteria Bacteria 374 4.2099999999999995e-99   NTclustered gi|1845963640|gb|CP042652.1| 1849015 g10731 i0 94.979 322.116935483871 239 10 96 1 12 248 1064019 1063781 Arcobacter acticola strain KCTC 52212 chromosome, complete genome blastn 79885 374 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter acticola
8685154 8685154 PRJNA1137393_P_NODE_4147_length_449_cov_3.827500_g3634_i0 PRJNA1137393 4147 449 3.8275 17.185475 Arcobacteraceae 2808963 Bacteria Bacteria 824 0   NTclustered gi|1847339566|gb|CP053833.1| 1054034 g3634 i0 99.777 390.425389755011 449 1 100 0 1 449 919187 919635 Arcobacter cloacae strain LMG 26153 chromosome, complete genome blastn 175301 830 0.992771084337349 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter cloacae
11763314 11763314 PRJNA1137393_P_NODE_20250_length_201_cov_1.730263_g19734_i0 PRJNA1137393 20250 201 1.730263 3.47782863 uncultured Arcobacter sp. 165434 Bacteria Bacteria 261 2.67e-65   NTclustered gi|682122801|gb|KJ739652.1| 165434 g19734 i0 90.816 254.562189054726 196 17 98 1 6 201 39 233 Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence blastn 51167 261 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
13785457 13785457 PRJNA1137393_P_NODE_48451_length_167_cov_0.881356_g47935_i0 PRJNA1137393 48451 167 0.881356 1.47186452 Campylobacter 194 Bacteria Bacteria 259 7.69e-65   NTclustered gi|2700477995|gb|CP147775.1| 199 g47935 i0 94.611 13.0059880239521 167 9 100 0 1 167 488411 488245 Campylobacter concisus strain RMIT-O23 chromosome blastn 2172 259 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
19410575 19410575 PRJNA1137393_P_NODE_10736_length_253_cov_3.671569_g10220_i0 PRJNA1137393 10736 253 3.671569 9.28906957 uncultured Aliarcobacter sp. 2321118 Bacteria Bacteria 462 8.95e-126   NTclustered gi|2621785459|emb|OY781917.1| 2321118 g10220 i0 99.605 384.411067193676 253 1 100 0 1 253 1466110 1466362 MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2 blastn 97256 462 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter uncultured Aliarcobacter sp.

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