RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA706190" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA706190 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
26671692 26671692 PRJNA706190_P_NODE_14401_length_221_cov_0.906977_g14265_i0 PRJNA706190 14401 221 0.906977 2.00441917 Helicobacter pylori 210 Bacteria Bacteria 43.5 0.00214   NR GAA6820949.1 210 g14265 i0 44.2 0.583710407239819 43 19 58.4 1 34 162 1 38 GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori] diamond 129 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26734921 26734921 PRJNA706190_P_NODE_24241_length_199_cov_1.060000_g24105_i0 PRJNA706190 24241 199 1.06 2.1094 Helicobacter pylori 210 Bacteria Bacteria 69.7 4.04e-14   NR GAA6967877.1 210 g24105 i0 77.3 0.663316582914573 44 10 66.3 0 59 190 5 48 GAA6967877.1 hypothetical protein Kyoto211A_2790 [Helicobacter pylori] diamond 132 69.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27684071 27684071 PRJNA706190_P_NODE_21124_length_205_cov_1.000000_g20988_i0 PRJNA706190 21124 205 1 2.05 Helicobacter pylori 210 Bacteria Bacteria 50.4 1.23e-5   NR GAA9253219.1 210 g20988 i0 95 0.292682926829268 20 1 29.3 0 11 70 40 59 GAA9253219.1 hypothetical protein Kyoto199A_2630 [Helicobacter pylori] diamond 60 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27684072 27684072 PRJNA706190_P_NODE_47704_length_169_cov_0.866667_g47568_i0 PRJNA706190 47704 169 0.866667 1.46466723 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.00157   NR GAA9019328.1 210 g47568 i0 61.5 0.923076923076923 26 10 46.2 0 168 91 12 37 GAA9019328.1 hypothetical protein Kyoto181A_7610 [Helicobacter pylori] diamond 156 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28073127 28073127 PRJNA706190_P_NODE_59145_length_168_cov_0.865546_g59009_i0 PRJNA706190 59145 168 0.865546 1.45411728 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.00103   NR GAA8854026.1 210 g59009 i0 53.3 5.73214285714286 45 21 80.4 0 150 16 150 194 GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori] diamond 963 46.2 0.991341991341991 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29388867 29388867 PRJNA706190_P_NODE_45609_length_171_cov_0.819672_g45473_i0 PRJNA706190 45609 171 0.819672 1.40163912 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0254   NR GAA6861401.1 210 g45473 i0 52 0.87719298245614 50 22 84.2 1 170 27 9 58 GAA6861401.1 hypothetical protein Kyoto206A_1640 [Helicobacter pylori] diamond 150 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29420132 29420132 PRJNA706190_P_NODE_4829_length_280_cov_0.887446_g4693_i0 PRJNA706190 4829 280 0.887446 2.4848488 Helicobacter pylori 210 Bacteria Bacteria 79.7 1.08e-17   NR GAA8688365.1 210 g4693 i0 85.7 0.45 42 6 45 0 109 234 1 42 GAA8688365.1 hypothetical protein Kyoto145A_1840 [Helicobacter pylori] diamond 126 79.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29925670 29925670 PRJNA706190_P_NODE_66671_length_166_cov_0.888889_g66535_i0 PRJNA706190 66671 166 0.888889 1.47555574 Helicobacter pylori 210 Bacteria Bacteria 56.2 9.18e-9   NR GAA8854446.1 210 g66535 i0 77.3 1.57228915662651 44 7 77.7 2 130 2 22 63 GAA8854446.1 hypothetical protein Kyoto154A_1380 [Helicobacter pylori] diamond 261 56.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30020465 30020465 PRJNA706190_P_NODE_91831_length_162_cov_0.920354_g91695_i0 PRJNA706190 91831 162 0.920354 1.49097348 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00238   NR GAA9217696.1 210 g91695 i0 66.7 0.5 27 9 50 0 77 157 13 39 GAA9217696.1 hypothetical protein Kyoto198A_3200 [Helicobacter pylori] diamond 81 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30062339 30062339 PRJNA706190_P_NODE_74511_length_165_cov_0.896552_g74375_i0 PRJNA706190 74511 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 42.7 0.00253   NR GAA9181004.1 210 g74375 i0 60 3.63636363636364 40 16 72.7 0 3 122 3 42 GAA9181004.1 hypothetical protein Kyoto193A_2430 [Helicobacter pylori] diamond 600 43.1 0.990719257540603 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30273373 30273373 PRJNA706190_P_NODE_71832_length_165_cov_1.344828_g71696_i0 PRJNA706190 71832 165 1.344828 2.2189662 Helicobacter pylori 210 Bacteria Bacteria 43.1 0.00136   NR GAA9043165.1 210 g71696 i0 60 0.545454545454545 30 12 54.5 0 68 157 40 69 GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori] diamond 90 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30936692 30936692 PRJNA706190_P_NODE_77694_length_164_cov_1.121739_g77558_i0 PRJNA706190 77694 164 1.121739 1.83965196 Helicobacter pylori 210 Bacteria Bacteria 45.8 2.21e-4   NR GAA9085486.1 210 g77558 i0 52.3 0.804878048780488 44 20 78.7 1 25 153 3 46 GAA9085486.1 hypothetical protein Kyoto184A_07860 [Helicobacter pylori] diamond 132 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31442327 31442327 PRJNA706190_P_NODE_79456_length_164_cov_0.904348_g79320_i0 PRJNA706190 79456 164 0.904348 1.48313072 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0033   NR GAA8722279.1 210 g79320 i0 66.7 0.439024390243902 24 8 43.9 0 164 93 11 34 GAA8722279.1 hypothetical protein Kyoto145A_4750 [Helicobacter pylori] diamond 72 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31758609 31758609 PRJNA706190_P_NODE_70337_length_166_cov_0.888889_g70201_i0 PRJNA706190 70337 166 0.888889 1.47555574 Helicobacter pylori 210 Bacteria Bacteria 52 1.95e-6   NR GAA8908272.1 210 g70201 i0 82.8 0.524096385542169 29 5 52.4 0 98 12 1 29 GAA8908272.1 hypothetical protein Kyoto166A_1320 [Helicobacter pylori] diamond 87 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32233501 32233501 PRJNA706190_P_NODE_88158_length_162_cov_2.681416_g88022_i0 PRJNA706190 88158 162 2.681416 4.34389392 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0328   NR GAA6820949.1 210 g88022 i0 80 0.37037037037037 20 4 37 0 30 89 20 39 GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori] diamond 60 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32549881 32549881 PRJNA706190_P_NODE_92819_length_162_cov_0.920354_g92683_i0 PRJNA706190 92819 162 0.920354 1.49097348 Helicobacter pylori 210 Bacteria Bacteria 43.1 6.65e-4   NR GAA6845155.1 210 g92683 i0 56.8 0.685185185185185 37 14 68.5 1 134 24 2 36 GAA6845155.1 hypothetical protein Kyoto200A_5200 [Helicobacter pylori] diamond 111 43.1 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);;