RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA849646 · 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
3388958 3388958 PRJNA849646_P_NODE_28403_length_252_cov_2.346369_g28285_i0 PRJNA849646 28403 252 2.346369 5.91284988 Campylobacter armoricus 2505970 Bacteria Bacteria 65.8 2.94e-6   NTclustered gi|1861371805|gb|CP053825.1| 2505970 g28285 i0 84.286 4.83333333333333 70 8 27 3 175 241 217887 217956 Campylobacter armoricus strain CCUG 73571 chromosome, complete genome blastn 1218 65.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter armoricus
19964513 19964513 PRJNA849646_P_NODE_14476_length_279_cov_1.495146_g14358_i0 PRJNA849646 14476 279 1.495146 4.17145734 Campylobacter concisus 199 Bacteria Bacteria 477 3.5799999999999985e-130   NTclustered gi|1938719709|gb|CP049264.1| 199 g14358 i0 97.491 16.4086021505376 279 7 100 0 1 279 698304 698582 Campylobacter concisus strain P11CDO-S1 chromosome, complete genome blastn 4578 477 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
21240069 21240069 PRJNA849646_P_NODE_10237_length_287_cov_2.079439_g10119_i0 PRJNA849646 10237 287 2.079439 5.96798993 Campylobacter gracilis 824 Bacteria Bacteria 459 1.3399999999999999e-124   NTclustered gi|909717139|gb|CP012196.1| 824 g10119 i0 95.238 2.04878048780488 294 6 99 5 1 286 1532380 1532087 Campylobacter gracilis strain ATCC 33236, complete genome blastn 588 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter gracilis

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