RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA784298 · 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
765351 765351 PRJNA784298_P_NODE_20321_length_273_cov_3.735000_g20120_i0 PRJNA784298 20321 273 3.735 10.19655 uncultured Arcobacter sp. 165434 Bacteria Bacteria 191 5.09e-44   NTclustered gi|2907625741|emb|OZ223301.1| 165434 g20120 i0 80.392 99.1501831501832 255 46 93 4 17 269 179805 180057 MAG: uncultured Arcobacter sp. isolate 7fb66f34-7b41-4cab-a2d2-b84adad47d9e genome assembly, chromosome: 2 blastn 27068 191 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
17343594 17343594 PRJNA784298_P_NODE_22734_length_257_cov_1.255435_g22533_i0 PRJNA784298 22734 257 1.255435 3.22646795 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 89.8 1.78e-13   NTclustered gi|2581878167|gb|CP134854.1| 2933791 g22533 i0 88.312 0.898832684824903 77 6 29 2 177 250 2037824 2037748 Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 52 chromosome, complete genome blastn 231 89.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
22890820 22890820 PRJNA784298_P_NODE_14158_length_331_cov_4.670543_g13957_i0 PRJNA784298 14158 331 4.670543 15.45949733 Aliarcobacter 2321111 Bacteria Bacteria 606 5.299999999999998e-169   NTclustered gi|1817415496|gb|CP026656.1| 28198 g13957 i0 99.698 385.447129909366 331 1 100 0 1 331 56796 57126 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 127583 606 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus

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