RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1200128 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
2878050 2878050 PRJNA1200128_S_NODE_7943_length_272_cov_1.231441_g7834_i0 PRJNA1200128 7943 272 1.231441 3.34951952 root 1 Root_unresolved Root_unresolved 109 1.2e-27   NR GAA8948808.1 210 g7834 i0 68.8 3.51838235294118 77 24 84.9 0 41 271 11 87 GAA8948808.1 hypothetical protein Kyoto181A_0780 [Helicobacter pylori] diamond 957 110 0.990909090909091 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
6704817 6704817 PRJNA1200128_S_NODE_21266_length_200_cov_1.496815_g21157_i0 PRJNA1200128 21266 200 1.496815 2.99363 Helicobacter pylori 210 Bacteria Bacteria 57.4 2.52e-8   NR GAA8684133.1 210 g21157 i0 55.6 0.81 54 24 81 0 199 38 82 135 GAA8684133.1 hypothetical protein Kyoto145A_0980 [Helicobacter pylori] diamond 162 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
19453218 19453218 PRJNA1200128_S_NODE_4856_length_319_cov_3.626812_g4747_i0 PRJNA1200128 4856 319 3.626812 11.56953028 Helicobacter pylori 210 Bacteria Bacteria 122 1.22e-33   NR WP_322538256.1 210 g4747 i0 95.1 0.573667711598746 61 3 57.4 0 27 209 47 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 183 122 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27230586 27230586 PRJNA1200128_S_NODE_46263_length_154_cov_0.891892_g46154_i0 PRJNA1200128 46263 154 0.891892 1.37351368 Helicobacter pylori 210 Bacteria Bacteria 38.9 0.0475   NR GAA8997529.1 210 g46154 i0 40 0.974025974025974 50 19 79.9 2 32 154 7 54 GAA8997529.1 hypothetical protein Kyoto181A_6350 [Helicobacter pylori] diamond 150 38.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27502445 27502445 PRJNA1200128_S_NODE_17843_length_211_cov_1.250000_g17734_i0 PRJNA1200128 17843 211 1.25 2.6375 root 1 Root_unresolved Root_unresolved 63.9 2.75e-11   NR WP_240373706.1 195 g17734 i0 64.4 24.9383886255924 45 15 62.6 1 193 62 49 93 WP_240373706.1 hypothetical protein, partial [Campylobacter coli] diamond 5262 64.3 0.993779160186625 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
27502446 27502446 PRJNA1200128_S_NODE_24243_length_192_cov_0.946309_g24134_i0 PRJNA1200128 24243 192 0.946309 1.81691328 Bacteria 2 Bacteria Bacteria 46.6 7.63e-5   NR WP_240373355.1 197 g24134 i0 80 0.84375 25 5 39.1 0 77 3 31 55 WP_240373355.1 hypothetical protein, partial [Campylobacter jejuni] diamond 162 47 0.991489361702128 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
28272527 28272527 PRJNA1200128_S_NODE_11146_length_244_cov_2.104478_g11037_i0 PRJNA1200128 11146 244 2.104478 5.13492632 Campylobacter coli 195 Bacteria Bacteria 64.7 1.13e-11   NR RJF75347.1 195 g11037 i0 54.1 0.75 61 28 75 0 203 21 2 62 RJF75347.1 hypothetical protein D4Z77_08730, partial [Campylobacter coli] diamond 183 64.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
28557033 28557033 PRJNA1200128_S_NODE_50207_length_150_cov_0.878505_g50098_i0 PRJNA1200128 50207 150 0.878505 1.3177575 Sulfurovum sp. 1969726 Bacteria Bacteria 53.9 1.2e-6   NR MCB4762252.1 1969726 g50098 i0 52 3.04 50 23 98 1 150 4 308 357 MCB4762252.1 hypothetical protein [Sulfurovum sp.] diamond 456 54.3 0.992633517495396 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
28840944 28840944 PRJNA1200128_S_NODE_12588_length_235_cov_1.104167_g12479_i0 PRJNA1200128 12588 235 1.104167 2.59479245 Campylobacter lari 201 Bacteria Bacteria 65.5 5.9e-12   NR WP_240388843.1 201 g12479 i0 64.4 0.574468085106383 45 16 57.4 0 135 1 28 72 WP_240388843.1 hypothetical protein, partial [Campylobacter lari] diamond 135 65.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
28872547 28872547 PRJNA1200128_S_NODE_44408_length_156_cov_1.247788_g44299_i0 PRJNA1200128 44408 156 1.247788 1.94654928 Helicobacter pylori 210 Bacteria Bacteria 89.4 1.72e-21   NR WP_322538256.1 210 g44299 i0 95.8 0.923076923076923 48 2 92.3 0 13 156 1 48 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 144 89.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29251306 29251306 PRJNA1200128_S_NODE_42929_length_158_cov_1.226087_g42820_i0 PRJNA1200128 42929 158 1.226087 1.93721746 Helicobacter pylori 210 Bacteria Bacteria 47.8 1.18e-5   NR GAA9255098.1 210 g42820 i0 46.3 0.778481012658228 41 22 77.8 0 153 31 1 41 GAA9255098.1 hypothetical protein Kyoto199A_3180 [Helicobacter pylori] diamond 123 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29680529 29680529 PRJNA1200128_S_NODE_7550_length_276_cov_2.849785_g7441_i0 PRJNA1200128 7550 276 2.849785 7.8654066 root 1 Root_unresolved Root_unresolved 45.4 0.00551   NR GAA8853825.1 210 g7441 i0 60.6 1.27173913043478 33 13 35.9 0 188 90 34 66 GAA8853825.1 hypothetical protein Kyoto154A_0760 [Helicobacter pylori] diamond 351 45.8 0.991266375545852 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29883213 29883213 PRJNA1200128_S_NODE_28011_length_183_cov_1.007143_g27902_i0 PRJNA1200128 28011 183 1.007143 1.84307169 Helicobacter pylori 210 Bacteria Bacteria 50.1 2.27e-5   NR GAA9039287.1 210 g27902 i0 54.5 2.88524590163934 44 19 70.5 1 129 1 23 66 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 528 50.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29946302 29946302 PRJNA1200128_S_NODE_24851_length_190_cov_1.918367_g24742_i0 PRJNA1200128 24851 190 1.918367 3.6448973 Helicobacter pylori 210 Bacteria Bacteria 39.3 0.0431   NR GAA6862807.1 210 g24742 i0 41.3 0.726315789473684 46 26 71.1 1 5 139 9 54 GAA6862807.1 hypothetical protein Kyoto206A_1910 [Helicobacter pylori] diamond 138 39.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30691707 30691707 PRJNA1200128_S_NODE_5033_length_315_cov_2.500000_g4924_i0 PRJNA1200128 5033 315 2.5 7.875 Bacteria 2 Bacteria Bacteria 95.9 4.4e-23   NR WP_322538264.1 210 g4924 i0 47.5 1.88571428571429 99 52 94.3 0 9 305 4 102 WP_322538264.1 hypothetical protein, partial [Helicobacter pylori] diamond 594 95.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30894225 30894225 PRJNA1200128_S_NODE_25454_length_189_cov_0.883562_g25345_i0 PRJNA1200128 25454 189 0.883562 1.66993218 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0123   NR GAA8895910.1 210 g25345 i0 66.7 0.476190476190476 30 9 47.6 1 98 187 63 91 GAA8895910.1 hypothetical protein BTM182_16150 [Helicobacter pylori] diamond 90 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31178145 31178145 PRJNA1200128_S_NODE_40695_length_161_cov_1.194915_g40586_i0 PRJNA1200128 40695 161 1.194915 1.92381315 Campylobacterales bacterium 2268180 Bacteria Bacteria 100 1.84e-24   NR MBE0495799.1 2268180 g40586 i0 88.7 1.97515527950311 53 6 98.8 0 3 161 114 166 MBE0495799.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Campylobacterales bacterium] diamond 318 100 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
31779209 31779209 PRJNA1200128_S_NODE_45357_length_155_cov_1.258929_g45248_i0 PRJNA1200128 45357 155 1.258929 1.95133995 Helicobacter pylori 210 Bacteria Bacteria 39.3 0.0278   NR GAA8883080.1 210 g45248 i0 42.9 0.948387096774194 49 27 94.8 1 8 154 5 52 GAA8883080.1 hypothetical protein Kyoto154A_4660 [Helicobacter pylori] diamond 147 39.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32304746 32304746 PRJNA1200128_S_NODE_38959_length_163_cov_2.350000_g38850_i0 PRJNA1200128 38959 163 2.35 3.8305 root 1 Root_unresolved Root_unresolved 42 0.00713   NR GAA6860864.1 210 g38850 i0 66.7 0.993865030674847 27 9 49.7 0 162 82 77 103 GAA6860864.1 hypothetical protein Kyoto206A_1490 [Helicobacter pylori] diamond 162 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32727826 32727826 PRJNA1200128_S_NODE_34280_length_171_cov_1.101562_g34171_i0 PRJNA1200128 34280 171 1.101562 1.88367102 Helicobacter pylori 210 Bacteria Bacteria 50.8 3.38e-6   NR GAA8954509.1 210 g34171 i0 52.9 0.894736842105263 51 20 82.5 2 154 14 42 92 GAA8954509.1 hypothetical protein Kyoto181A_2710 [Helicobacter pylori] diamond 153 50.8 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);;