RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA485080", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 12 ✖

tax_phylum 1

  • Campylobacterota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA485080 · 12 ✖

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
21499246 21499246 PRJNA485080_P_NODE_35757_length_245_cov_0.895349_g35663_i0 PRJNA485080 35757 245 0.895349 2.19360505 Aliarcobacter 2321111 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1898123824|gb|CP060693.1| 28198 g35663 i0 100 92.7020408163265 245 0 100 0 1 245 744400 744156 Aliarcobacter cryaerophilus strain 16CS1285-4 chromosome, complete genome blastn 22712 453 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
26743823 26743823 PRJNA485080_P_NODE_41381_length_242_cov_0.911243_g41287_i0 PRJNA485080 41381 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 50.8 6.04e-6   NR GAA6912895.1 210 g41287 i0 51.7 2.23140495867769 60 27 71.9 1 185 12 7 66 GAA6912895.1 hypothetical protein Kyoto207A_3080 [Helicobacter pylori] diamond 540 50.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27297559 27297559 PRJNA485080_P_NODE_30563_length_247_cov_0.885057_g30469_i0 PRJNA485080 30563 247 0.885057 2.18609079 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.0115   NR GAA9138561.1 210 g30469 i0 41.7 2.23481781376518 72 31 75.3 3 203 18 39 109 GAA9138561.1 hypothetical protein Kyoto190A_2920 [Helicobacter pylori] diamond 552 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27661195 27661195 PRJNA485080_P_NODE_27684_length_248_cov_1.320000_g27590_i0 PRJNA485080 27684 248 1.32 3.2736 root 1 Root_unresolved Root_unresolved 48.5 1.89e-4   NR GAA9039287.1 210 g27590 i0 40 4.62096774193548 65 38 77.4 1 7 198 74 138 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 1146 48.9 0.991820040899796 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27756026 27756026 PRJNA485080_P_NODE_28484_length_248_cov_0.880000_g28390_i0 PRJNA485080 28484 248 0.88 2.1824 root 1 Root_unresolved Root_unresolved 47.8 4.07e-5   NR GAA8809467.1 210 g28390 i0 60 1.93548387096774 40 13 44.8 1 208 98 2 41 GAA8809467.1 hypothetical protein Kyoto149A_2970 [Helicobacter pylori] diamond 480 48.1 0.993762993762994 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28008535 28008535 PRJNA485080_P_NODE_15385_length_290_cov_1.064516_g15291_i0 PRJNA485080 15385 290 1.064516 3.0870964 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00563   NR GAA8949042.1 210 g15291 i0 53.5 2.68965517241379 43 18 42.4 1 208 86 46 88 GAA8949042.1 hypothetical protein Kyoto181A_0860 [Helicobacter pylori] diamond 780 45.4 0.993392070484582 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29444463 29444463 PRJNA485080_P_NODE_25210_length_250_cov_0.870056_g25116_i0 PRJNA485080 25210 250 0.870056 2.17514 Helicobacter pylori 210 Bacteria Bacteria 42 0.0201   NR GAA8687625.1 210 g25116 i0 47.8 0.552 46 24 55.2 0 146 9 53 98 GAA8687625.1 hypothetical protein Kyoto145A_1710 [Helicobacter pylori] diamond 138 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29665336 29665336 PRJNA485080_P_NODE_3530_length_496_cov_0.964539_g3436_i0 PRJNA485080 3530 496 0.964539 4.78411344 Helicobacter pylori 210 Bacteria Bacteria 48.9 1.1e-4   NR GAA8856488.1 210 g3436 i0 65.5 0.175403225806452 29 10 17.5 0 336 250 1 29 GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori] diamond 87 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30440097 30440097 PRJNA485080_P_NODE_25653_length_249_cov_1.011364_g25559_i0 PRJNA485080 25653 249 1.011364 2.51829636 root 1 Root_unresolved Root_unresolved 70.9 1.92e-12   NR GAA6795622.1 210 g25559 i0 70.7 2.80722891566265 41 12 49.4 0 37 159 88 128 GAA6795622.1 hypothetical protein Kyoto200A_0460 [Helicobacter pylori] diamond 699 71.2 0.995786516853933 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31213329 31213329 PRJNA485080_P_NODE_31415_length_247_cov_0.885057_g31321_i0 PRJNA485080 31415 247 0.885057 2.18609079 Aliarcobacter butzleri 28197 Bacteria Bacteria 42.7 0.00403   NR WP_305863257.1 28197 g31321 i0 59.5 0.449392712550607 37 15 44.9 0 112 2 18 54 WP_305863257.1 DUF1725 domain-containing protein, partial [Aliarcobacter butzleri] diamond 111 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
32131294 32131294 PRJNA485080_P_NODE_22138_length_251_cov_0.865169_g22044_i0 PRJNA485080 22138 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 43.1 0.00281   NR GAA6991793.1 210 g22044 i0 44.7 0.561752988047809 47 26 56.2 0 221 81 9 55 GAA6991793.1 hypothetical protein Kyoto211A_4670 [Helicobacter pylori] diamond 141 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32273942 32273942 PRJNA485080_P_NODE_14678_length_295_cov_1.387387_g14584_i0 PRJNA485080 14678 295 1.387387 4.09279165 root 1 Root_unresolved Root_unresolved 65.1 1.03e-10   NR GAA9246096.1 210 g14584 i0 54.1 5.28813559322034 61 28 62 0 40 222 37 97 GAA9246096.1 hypothetical protein Kyoto199A_0190 [Helicobacter pylori] diamond 1560 65.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);;