RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1068513 · 3 ✖

analysis 1

  • diamond · 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
28172638 28172638 PRJNA1068513_S_NODE_346_length_913_cov_11.223810_g321_i0 PRJNA1068513 346 913 11.22381 102.4733853 Campylobacter cuniculorum 374106 Bacteria Bacteria 111 9.2e-26   NR WP_027306189.1 374106 g321 i0 42 1.01204819277108 174 91 55.5 5 650 144 6 174 WP_027306189.1 thermonuclease family protein [Campylobacter cuniculorum] diamond 924 111 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter cuniculorum
31900604 31900604 PRJNA1068513_S_NODE_13017_length_245_cov_1.104651_g12971_i0 PRJNA1068513 13017 245 1.104651 2.70639495 Campylobacter hyointestinalis 198 Bacteria Bacteria 43.1 0.0268   NR WP_111949755.1 198 g12971 i0 39.2 0.624489795918367 51 31 62.4 0 192 40 10 60 WP_111949755.1 hypothetical protein [Campylobacter hyointestinalis] diamond 153 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter hyointestinalis
32185467 32185467 PRJNA1068513_S_NODE_4778_length_414_cov_2.865103_g4733_i0 PRJNA1068513 4778 414 2.865103 11.86152642 Sulfurimonas sp. 2022749 Bacteria Bacteria 46.2 0.0139   NR WP_373070441.1 2022749 g4733 i0 28.3 0.920289855072464 127 70 76.8 4 391 74 290 416 WP_373070441.1 DUF748 domain-containing protein [Sulfurimonas sp.] diamond 381 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.

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