RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1068513", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 14 ✖

tax_phylum 1

  • Campylobacterota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068513 · 14 ✖

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
1013619 1013619 PRJNA1068513_S_NODE_10341_length_277_cov_8.617647_g10295_i0 PRJNA1068513 10341 277 8.617647 23.87088219 root 1 Root_unresolved Root_unresolved 63.9 1.18e-5   NTclustered gi|2222028449|gb|CP094103.1| 210 g10295 i0 100 13.321299638989201 34 0 12 0 1 34 1292685 1292718 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 3690 63.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
3564162 3564162 PRJNA1068513_S_NODE_683_length_761_cov_28.340116_g649_i0 PRJNA1068513 683 761 28.340116 215.66828276 root 1 Root_unresolved Root_unresolved 67.6 2.73e-6   NTclustered gi|2222028449|gb|CP094103.1| 210 g649 i0 93.478 10.8961892247043 46 1 12 2 1 45 1292674 1292718 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 8292 67.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
4841654 4841654 PRJNA1068513_S_NODE_4584_length_422_cov_1.366762_g4539_i0 PRJNA1068513 4584 422 1.366762 5.76773564 root 1 Root_unresolved Root_unresolved 62.1 6.75e-5   NTclustered gi|2222028449|gb|CP094103.1| 210 g4539 i0 97.222 9.07345971563981 36 1 9 0 382 417 1292718 1292683 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 3829 62.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
6116792 6116792 PRJNA1068513_S_NODE_3685_length_462_cov_4.897172_g3640_i0 PRJNA1068513 3685 462 4.897172 22.62493464 root 1 Root_unresolved Root_unresolved 80.5 2.06e-10   NTclustered gi|2222028449|gb|CP094103.1| 210 g3640 i0 94.34 11.0952380952381 53 1 11 2 411 462 1292718 1292667 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 5126 80.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
12492455 12492455 PRJNA1068513_S_NODE_11270_length_263_cov_7.015789_g11224_i0 PRJNA1068513 11270 263 7.015789 18.45152507 root 1 Root_unresolved Root_unresolved 82.4 3.06e-11   NTclustered gi|2222028449|gb|CP094103.1| 210 g11224 i0 94.444 37.425855513308 54 1 33 2 1 53 1292667 1292719 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 9843 82.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
17591422 17591422 PRJNA1068513_S_NODE_714_length_753_cov_24.614706_g678_i0 PRJNA1068513 714 753 24.614706 185.34873618 root 1 Root_unresolved Root_unresolved 67.6 2.7e-6   NTclustered gi|2222028449|gb|CP094103.1| 210 g678 i0 93.478 5.50597609561753 46 1 6 2 709 753 1292718 1292674 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 4146 67.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
18033634 18033634 PRJNA1068513_S_NODE_6795_length_350_cov_2.577617_g6749_i0 PRJNA1068513 6795 350 2.577617 9.0216595 Helicobacter pylori 210 Bacteria Bacteria 93.5 1.95e-14   NTclustered gi|2222028449|gb|CP094103.1| 210 g6749 i0 95 19.6714285714286 60 1 17 2 1 59 1292662 1292720 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 6885 93.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
18865148 18865148 PRJNA1068513_S_NODE_1455_length_622_cov_5.590164_g1414_i0 PRJNA1068513 1455 622 5.590164 34.77082008 root 1 Root_unresolved Root_unresolved 84.2 2.19e-11   NTclustered gi|2222028449|gb|CP094103.1| 210 g1414 i0 94.545 10 55 1 9 2 1 54 1292665 1292718 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 6220 84.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
18865158 18865158 PRJNA1068513_S_NODE_3535_length_469_cov_7.674242_g3490_i0 PRJNA1068513 3535 469 7.674242 35.99219498 root 1 Root_unresolved Root_unresolved 69.4 4.53e-7   NTclustered gi|2222028449|gb|CP094103.1| 210 g3490 i0 97.5 9.3773987206823 40 1 9 0 417 456 1292721 1292682 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 4398 69.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
20140068 20140068 PRJNA1068513_S_NODE_956_length_701_cov_117.291401_g917_i0 PRJNA1068513 956 701 117.291401 822.21272101 root 1 Root_unresolved Root_unresolved 99 8.87e-16   NTclustered gi|2222028449|gb|CP094103.1| 210 g917 i0 93.846 10.6875891583452 65 4 9 0 1 65 1292654 1292718 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 7492 99 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
24407801 24407801 PRJNA1068513_S_NODE_7840_length_324_cov_3.505976_g7794_i0 PRJNA1068513 7840 324 3.505976 11.35936224 Helicobacter pylori 210 Bacteria Bacteria 99 3.85e-16   NTclustered gi|2222028449|gb|CP094103.1| 210 g7794 i0 91.781 22.0524691358025 73 2 22 4 1 71 1292656 1292726 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 7145 99 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28172638 28172638 PRJNA1068513_S_NODE_346_length_913_cov_11.223810_g321_i0 PRJNA1068513 346 913 11.22381 102.4733853 Campylobacter cuniculorum 374106 Bacteria Bacteria 111 9.2e-26   NR WP_027306189.1 374106 g321 i0 42 1.01204819277108 174 91 55.5 5 650 144 6 174 WP_027306189.1 thermonuclease family protein [Campylobacter cuniculorum] diamond 924 111 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter cuniculorum
31900604 31900604 PRJNA1068513_S_NODE_13017_length_245_cov_1.104651_g12971_i0 PRJNA1068513 13017 245 1.104651 2.70639495 Campylobacter hyointestinalis 198 Bacteria Bacteria 43.1 0.0268   NR WP_111949755.1 198 g12971 i0 39.2 0.624489795918367 51 31 62.4 0 192 40 10 60 WP_111949755.1 hypothetical protein [Campylobacter hyointestinalis] diamond 153 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter hyointestinalis
32185467 32185467 PRJNA1068513_S_NODE_4778_length_414_cov_2.865103_g4733_i0 PRJNA1068513 4778 414 2.865103 11.86152642 Sulfurimonas sp. 2022749 Bacteria Bacteria 46.2 0.0139   NR WP_373070441.1 2022749 g4733 i0 28.3 0.920289855072464 127 70 76.8 4 391 74 290 416 WP_373070441.1 DUF748 domain-containing protein [Sulfurimonas sp.] diamond 381 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.

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