RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB80557 · 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
6099716 6099716 PRJEB80557_S_NODE_31105_length_174_cov_1.232000_g30709_i0 PRJEB80557 31105 174 1.232 2.14368 root 1 Root_unresolved Root_unresolved 278 2.22e-70   NTclustered gi|1226876681|gb|CP022559.1| 197 g30709 i0 98.113 88.9022988505747 159 3 91 0 1 159 698336 698178 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 15469 279 0.996415770609319 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
7374123 7374123 PRJEB80557_S_NODE_34126_length_167_cov_1.296610_g33730_i0 PRJEB80557 34126 167 1.29661 2.1653387 Campylobacter 194 Bacteria Bacteria 309 7.53e-80   NTclustered gi|1207769205|gb|MF351718.1| 199 g33730 i0 100 234.011976047904 167 0 100 0 1 167 841 1007 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 39080 309 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
25222761 25222761 PRJEB80557_S_NODE_8840_length_305_cov_1.414062_g8444_i0 PRJEB80557 8840 305 1.414062 4.3128891 root 1 Root_unresolved Root_unresolved 486 6.579999999999998e-133   NTclustered gi|1377039872|gb|MF037584.1| 195 g8444 i0 97.544 40.0918032786885 285 6 93 1 1 285 1043 1326 Campylobacter coli strain SHP40 cfrC gene cluster, complete sequence blastn 12228 486 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli

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