RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA474426" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474426 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1096952 1096952 PRJNA474426_P_NODE_32661_length_167_cov_1.186441_g32456_i0 PRJNA474426 32661 167 1.186441 1.98135647 Aliarcobacter 2321111 Bacteria Bacteria 283 4.56e-72   NTclustered gi|1817415496|gb|CP026656.1| 28198 g32456 i0 100 355.646706586826 153 0 92 0 2 154 56985 56833 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 59393 283 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
13201163 13201163 PRJNA474426_P_NODE_32711_length_167_cov_0.881356_g32506_i0 PRJNA474426 32711 167 0.881356 1.47186452 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 167 4.79e-37   NTclustered gi|2317587505|gb|CP099556.1| 28198 g32506 i0 97.917 32.6167664670659 96 2 92 0 59 154 163445 163350 Aliarcobacter cryaerophilus strain ICDCAC48 chromosome, complete genome blastn 5447 167 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
13850585 13850585 PRJNA474426_P_NODE_33251_length_166_cov_1.487179_g33046_i0 PRJNA474426 33251 166 1.487179 2.46871714 Aliarcobacter 2321111 Bacteria Bacteria 246 5.94e-61   NTclustered gi|1896712910|gb|CP060264.1| 28198 g33046 i0 99.265 60.8614457831325 136 1 82 0 29 164 507587 507452 Aliarcobacter cryaerophilus strain 16CS0369-1-AR-4 chromosome, complete genome blastn 10103 246 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
17674607 17674607 PRJNA474426_P_NODE_37054_length_159_cov_3.481818_g36849_i0 PRJNA474426 37054 159 3.481818 5.53609062 Arcobacteraceae 2808963 Bacteria Bacteria 272 9.28e-69   NTclustered gi|1474790806|gb|CP032100.1| 663365 g36849 i0 99.333 357.440251572327 150 1 94 0 10 159 1733885 1733736 Arcobacter suis CECT 7833 chromosome, complete genome blastn 56833 272 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis

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