RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA454503 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
19568269 19568269 PRJNA454503_P_NODE_43996_length_222_cov_1.614907_g43667_i0 PRJNA454503 43996 222 1.614907 3.58509354 uncultured Helicobacter sp. 175537 Bacteria Bacteria 137 8.98e-36   NR WP_299327541.1 175537 g43667 i0 90.5 1 74 7 100 0 1 222 88 161 WP_299327541.1 OmpP1/FadL family transporter [uncultured Helicobacter sp.] diamond 222 137 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
28529060 28529060 PRJNA454503_P_NODE_59767_length_210_cov_0.872483_g59438_i0 PRJNA454503 59767 210 0.872483 1.8322143 Campylobacterota bacterium 2026809 Bacteria Bacteria 92 1.04e-19   NR NPA59219.1 2026809 g59438 i0 62.3 1.97142857142857 69 26 98.6 0 3 209 654 722 NPA59219.1 glycosyltransferase [Campylobacterota bacterium] diamond 414 92 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
29791666 29791666 PRJNA454503_P_NODE_79391_length_204_cov_0.909091_g79062_i0 PRJNA454503 79391 204 0.909091 1.85454564 unclassified Sulfurospirillum 2618290 Bacteria Bacteria 117 3.95e-30   NR WP_037959241.1 2618290 g79062 i0 77.3 0.970588235294118 66 15 97.1 0 203 6 109 174 WP_037959241.1 MULTISPECIES: NAD-dependent epimerase/dehydratase family protein [unclassified Sulfurospirillum] diamond 198 117 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum  
30329435 30329435 PRJNA454503_P_NODE_30692_length_238_cov_1.988701_g30363_i0 PRJNA454503 30692 238 1.988701 4.73310838 Helicobacter pylori 210 Bacteria Bacteria 48.1 4.65e-5   NR GAA8948737.1 210 g30363 i0 50 0.957983193277311 54 17 55.5 1 193 62 3 56 GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori] diamond 228 48.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30960919 30960919 PRJNA454503_P_NODE_30274_length_239_cov_1.460674_g29945_i0 PRJNA454503 30274 239 1.460674 3.49101086 Helicobacter pylori 210 Bacteria Bacteria 87.8 1.28e-19   NR WP_322377330.1 210 g29945 i0 97.6 0.514644351464435 41 1 51.5 0 123 1 1 41 WP_322377330.1 KilA-N domain-containing protein [Helicobacter pylori] diamond 123 87.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31371916 31371916 PRJNA454503_P_NODE_68016_length_207_cov_0.890411_g67687_i0 PRJNA454503 68016 207 0.890411 1.84315077 Campylobacter coli 195 Bacteria Bacteria 120 9.149999999999999e-34   NR WP_289858361.1 195 g67687 i0 82.6 1 69 12 100 0 1 207 2 70 WP_289858361.1 DUF6950 family protein, partial [Campylobacter coli] diamond 207 120 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
31403523 31403523 PRJNA454503_P_NODE_37296_length_230_cov_1.538462_g36967_i0 PRJNA454503 37296 230 1.538462 3.5384626 Campylobacter sp. 2 205 Bacteria Bacteria 85.5 4.73e-19   NR WP_214120692.1 2836735 g36967 i0 64.9 0.965217391304348 74 23 95.2 2 12 230 63 134 WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01] diamond 222 85.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. 2018MI01
32004422 32004422 PRJNA454503_P_NODE_78978_length_204_cov_0.909091_g78649_i0 PRJNA454503 78978 204 0.909091 1.85454564 Helicobacter pylori 210 Bacteria Bacteria 42 0.00395   NR GAA9140559.1 210 g78649 i0 61 0.602941176470588 41 16 60.3 0 123 1 4 44 GAA9140559.1 hypothetical protein Kyoto190A_3310 [Helicobacter pylori] diamond 123 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32415850 32415850 PRJNA454503_P_NODE_86979_length_200_cov_2.719424_g86650_i0 PRJNA454503 86979 200 2.719424 5.438848 Helicobacter pylori 210 Bacteria Bacteria 73.9 7.77e-16   NR GAA8692375.1 210 g86650 i0 73.3 0.675 45 12 67.5 0 136 2 1 45 GAA8692375.1 hypothetical protein Kyoto145A_2350 [Helicobacter pylori] diamond 135 73.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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