RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA565778" 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

  • PRJNA565778 · 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
4963829 4963829 PRJNA565778_S_NODE_19864_length_248_cov_113.345972_g19568_i0 PRJNA565778 19864 248 113.345972 281.09801056 Arcobacter 28196 Bacteria Bacteria 313 9.32e-81   NTclustered gi|1847331607|gb|CP053835.1| 873191 g19568 i0 93.365 15.241935483871 211 14 85 0 38 248 2146608 2146398 Arcobacter defluvii strain LMG 25694 chromosome, complete genome blastn 3780 313 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter defluvii
4963925 4963925 PRJNA565778_S_NODE_40364_length_163_cov_2.309524_g40068_i0 PRJNA565778 40364 163 2.309524 3.76452412 Campylobacter 194 Bacteria Bacteria 302 1.22e-77   NTclustered gi|470482328|ref|NR_076526.1| 76517 g40068 i0 100 239.901840490798 163 0 100 0 1 163 116 278 Campylobacter hominis strain CH001A 23S ribosomal RNA gene, complete sequence blastn 39104 302 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter hominis
10064346 10064346 PRJNA565778_S_NODE_4748_length_473_cov_3.167431_g4518_i0 PRJNA565778 4748 473 3.167431 14.98194863 Bacteria 2 Bacteria Bacteria 857 0   NTclustered gi|1829985141|gb|CP050963.1| 827 g4518 i0 99.366 45.9090909090909 473 3 100 0 1 473 1544339 1544811 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 21715 857 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
20960548 20960548 PRJNA565778_S_NODE_34857_length_184_cov_237.517007_g34561_i0 PRJNA565778 34857 184 237.517007 437.03129288 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 255 1.11e-63   NTclustered gi|1817415496|gb|CP026656.1| 28198 g34561 i0 97.959 0.967391304347826 147 3 80 0 1 147 1398342 1398488 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 178 255 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
22235135 22235135 PRJNA565778_S_NODE_11378_length_324_cov_4.216028_g11082_i0 PRJNA565778 11378 324 4.216028 13.65993072 Aliarcobacter trophiarum 708186 Bacteria Bacteria 52.8 0.03   NTclustered gi|1442793352|gb|CP031367.1| 1032241 g11082 i0 100 0.0864197530864197 28 0 9 0 286 313 1484222 1484249 Aliarcobacter trophiarum LMG 25534 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter trophiarum

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