RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA533623 · 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
506826 506826 PRJNA533623_P_NODE_51041_length_289_cov_17.697368_g49262_i0 PRJNA533623 51041 289 17.697368 51.14539352 Bacteria 2 Bacteria Bacteria 129 1.73e-32   NR GAA8844942.1 210 g49262 i0 78.4 8.17993079584775 88 19 91.3 0 26 289 509 596 GAA8844942.1 selenocysteine-specific translation elongation factor [Helicobacter pylori] diamond 2364 130 0.992307692307692 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
9434399 9434399 PRJNA533623_P_NODE_22828_length_485_cov_5.040094_g21074_i0 PRJNA533623 22828 485 5.040094 24.4444559 Sulfurimonas sp. 2022749 Bacteria Bacteria 107 1.9599999999999994e-23   NR WP_295007451.1 2022749 g21074 i0 80.6 0.383505154639175 62 12 38.4 0 467 282 1158 1219 WP_295007451.1 type V CRISPR-associated protein Cas12a/Cpf1 [Sulfurimonas sp.] diamond 186 107 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.
26951054 26951054 PRJNA533623_P_NODE_77002_length_202_cov_15.475177_g75221_i0 PRJNA533623 77002 202 15.475177 31.25985754 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0168   NR GAA6800385.1 210 g75221 i0 100 0.252475247524752 17 0 25.2 0 190 140 1 17 GAA6800385.1 hypothetical protein Kyoto200A_2080 [Helicobacter pylori] diamond 51 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27267406 27267406 PRJNA533623_P_NODE_52623_length_283_cov_1.171171_g50844_i0 PRJNA533623 52623 283 1.171171 3.31441393 Helicobacter pylori 210 Bacteria Bacteria 52.4 9.84e-7   NR GAA8908381.1 210 g50844 i0 69.7 0.34982332155477 33 10 35 0 248 150 5 37 GAA8908381.1 hypothetical protein Kyoto166A_1430 [Helicobacter pylori] diamond 99 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27693253 27693253 PRJNA533623_P_NODE_74204_length_208_cov_4.428571_g72423_i0 PRJNA533623 74204 208 4.428571 9.21142768 Bacteria 2 Bacteria Bacteria 43.1 0.0154   NR GAA9247141.1 210 g72423 i0 85.7 0.605769230769231 21 3 30.3 0 182 120 1 21 GAA9247141.1 hypothetical protein Kyoto199A_1050 [Helicobacter pylori] diamond 126 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27772925 27772925 PRJNA533623_P_NODE_32984_length_390_cov_10.079027_g31213_i0 PRJNA533623 32984 390 10.079027 39.3082053 Desulfurellales bacterium 2482794 Bacteria Bacteria 61.2 6.78e-8   NR TXH46962.1 2482794 g31213 i0 33.3 0.807692307692308 105 61 80.8 1 379 65 640 735 TXH46962.1 MAG: hypothetical protein E6Q97_28150 [Desulfurellales bacterium] diamond 315 61.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30077602 30077602 PRJNA533623_P_NODE_28352_length_428_cov_18.196185_g26582_i0 PRJNA533623 28352 428 18.196185 77.8796718 Campylobacterota bacterium 2026809 Bacteria Bacteria 127 4.42e-33   NR MEA1918718.1 2026809 g26582 i0 53.3 0.855140186915888 122 49 85.5 4 402 37 154 267 MEA1918718.1 aldo/keto reductase [Campylobacterota bacterium] diamond 366 127 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
31310000 31310000 PRJNA533623_P_NODE_25215_length_459_cov_2.587940_g23450_i0 PRJNA533623 25215 459 2.58794 11.8786446 Helicobacter pylori 210 Bacteria Bacteria 43.1 0.0392   NR GAA9106486.1 210 g23450 i0 97.4 0.503267973856209 77 2 50.3 0 458 228 4 80 GAA9106486.1 hypothetical protein Kyoto184A_09600 [Helicobacter pylori] diamond 231 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32322725 32322725 PRJNA533623_P_NODE_24339_length_468_cov_14.754300_g22578_i0 PRJNA533623 24339 468 14.7543 69.050124 Desulfurellales bacterium 2482794 Bacteria Bacteria 89 2.27e-19   NR TXH45790.1 2482794 g22578 i0 40.6 0.916666666666667 143 69 88.5 5 31 444 1 132 TXH45790.1 MAG: hypothetical protein E6Q97_30805 [Desulfurellales bacterium] diamond 429 89 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium

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