RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA473799" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA473799 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
26633029 26633029 PRJNA473799_P_NODE_5581_length_513_cov_1.527273_g5314_i0 PRJNA473799 5581 513 1.527273 7.83491049 Helicobacter pylori 210 Bacteria Bacteria 55.8 1.32e-6   NR GAA6899797.1 210 g5314 i0 49.2 0.35672514619883 61 31 35.7 0 179 361 54 114 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 183 55.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27282080 27282080 PRJNA473799_P_NODE_36723_length_250_cov_0.870056_g36449_i0 PRJNA473799 36723 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 50.4 6.36e-6   NR GAA8684589.1 210 g36449 i0 55.8 4.272 52 21 61.2 2 240 88 1 51 GAA8684589.1 hypothetical protein Kyoto145A_1090 [Helicobacter pylori] diamond 1068 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28023837 28023837 PRJNA473799_P_NODE_35365_length_251_cov_0.865169_g35091_i0 PRJNA473799 35365 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 57.4 1.29e-8   NR GAA8860838.1 210 g35091 i0 53.2 0.561752988047809 47 22 56.2 0 217 77 12 58 GAA8860838.1 hypothetical protein Kyoto154A_2730 [Helicobacter pylori] diamond 141 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28023839 28023839 PRJNA473799_P_NODE_40545_length_248_cov_0.880000_g40271_i0 PRJNA473799 40545 248 0.88 2.1824 Helicobacter pylori 210 Bacteria Bacteria 58.2 1.14e-7   NR GAA6899356.1 210 g40271 i0 63.4 1.51209677419355 41 15 49.6 0 240 118 219 259 GAA6899356.1 hypothetical protein Kyoto207A_1070 [Helicobacter pylori] diamond 375 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28812765 28812765 PRJNA473799_P_NODE_43968_length_246_cov_0.890173_g43694_i0 PRJNA473799 43968 246 0.890173 2.18982558 Helicobacter pylori 210 Bacteria Bacteria 44.3 0.00201   NR GAA8955309.1 210 g43694 i0 48.9 0.548780487804878 45 21 52.4 1 15 143 27 71 GAA8955309.1 hypothetical protein Kyoto181A_2860 [Helicobacter pylori] diamond 135 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29744643 29744643 PRJNA473799_P_NODE_7970_length_383_cov_1.848387_g7696_i0 PRJNA473799 7970 383 1.848387 7.07932221 Pseudomonadati 3379134 Bacteria Bacteria 43.5 0.00555   NR GAA6864469.1 210 g7696 i0 46.2 0.618798955613577 39 21 30.5 0 267 151 5 43 GAA6864469.1 hypothetical protein Kyoto206A_2160 [Helicobacter pylori] diamond 237 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30138993 30138993 PRJNA473799_P_NODE_10692_length_322_cov_1.590361_g10418_i0 PRJNA473799 10692 322 1.590361 5.12096242 Helicobacter pylori 210 Bacteria Bacteria 73.6 4.96e-15   NR GAA8838853.1 210 g10418 i0 79.1 0.400621118012422 43 9 40.1 0 47 175 1 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 129 73.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30424139 30424139 PRJNA473799_P_NODE_12553_length_307_cov_1.123932_g12279_i0 PRJNA473799 12553 307 1.123932 3.45047124 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.0318   NR GAA9005118.1 210 g12279 i0 54.8 0.41042345276873 42 19 41 0 248 123 12 53 GAA9005118.1 hypothetical protein Kyoto181A_6770 [Helicobacter pylori] diamond 126 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30487033 30487033 PRJNA473799_P_NODE_22073_length_274_cov_1.487562_g21799_i0 PRJNA473799 22073 274 1.487562 4.07591988 Helicobacter pylori 210 Bacteria Bacteria 66.6 3.8e-12   NR GAA8798126.1 210 g21799 i0 87.5 1.02919708029197 32 4 35 0 247 152 1 32 GAA8798126.1 hypothetical protein Kyoto149A_1450 [Helicobacter pylori] diamond 282 66.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30518519 30518519 PRJNA473799_P_NODE_40733_length_248_cov_0.880000_g40459_i0 PRJNA473799 40733 248 0.88 2.1824 Helicobacter pylori 210 Bacteria Bacteria 43.9 9.92e-4   NR GAA9117035.1 210 g40459 i0 61.5 0.314516129032258 26 10 31.5 0 169 246 4 29 GAA9117035.1 hypothetical protein Kyoto184A_10210 [Helicobacter pylori] diamond 78 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31656251 31656251 PRJNA473799_P_NODE_36757_length_250_cov_0.870056_g36483_i0 PRJNA473799 36757 250 0.870056 2.17514 Helicobacter pylori 210 Bacteria Bacteria 46.6 7.56e-4   NR GAA9246114.1 210 g36483 i0 54.8 0.504 42 19 50.4 0 150 25 110 151 GAA9246114.1 hypothetical protein Kyoto199A_0250 [Helicobacter pylori] diamond 126 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31672545 31672545 PRJNA473799_P_NODE_8937_length_356_cov_1.307420_g8663_i0 PRJNA473799 8937 356 1.30742 4.6544152 Bacteria 2 Bacteria Bacteria 50.8 2.99e-5   NR GAA6899797.1 210 g8663 i0 51 0.851123595505618 51 25 43 0 162 10 54 104 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 303 50.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32036046 32036046 PRJNA473799_P_NODE_32178_length_255_cov_1.379121_g31904_i0 PRJNA473799 32178 255 1.379121 3.51675855 Helicobacter pylori 210 Bacteria Bacteria 54.3 2.2e-7   NR GAA8992044.1 210 g31904 i0 75 0.8 32 8 37.6 0 61 156 1 32 GAA8992044.1 hypothetical protein Kyoto181A_6080 [Helicobacter pylori] diamond 204 54.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32479247 32479247 PRJNA473799_P_NODE_48939_length_244_cov_0.883041_g48665_i0 PRJNA473799 48939 244 0.883041 2.15462004 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0208   NR GAA9192930.1 210 g48665 i0 72 0.307377049180328 25 7 30.7 0 152 226 20 44 GAA9192930.1 hypothetical protein Kyoto193A_3770 [Helicobacter pylori] diamond 75 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32511015 32511015 PRJNA473799_P_NODE_25399_length_267_cov_2.597938_g25125_i0 PRJNA473799 25399 267 2.597938 6.93649446 Helicobacter pylori 210 Bacteria Bacteria 76.3 1.39e-15   NR GAA6899797.1 210 g25125 i0 67.8 1.40449438202247 59 19 66.3 0 263 87 59 117 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 375 76.3 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);;