RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA949785", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_phylum 1

  • Campylobacterota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA949785 · 7 ✖

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
23885531 23885531 PRJNA949785_P_NODE_11979_length_294_cov_2.090498_g11782_i0 PRJNA949785 11979 294 2.090498 6.14606412 Sulfurimonas aquatica 2672570 Bacteria Bacteria 52.8 0.027   NTclustered gi|2006624948|gb|CP046072.1| 2672570 g11782 i0 100 0.0952380952380952 28 0 10 0 262 289 1357853 1357880 Sulfurimonas aquatica strain H1576 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas aquatica
28320395 28320395 PRJNA949785_P_NODE_16626_length_248_cov_0.880000_g16429_i0 PRJNA949785 16626 248 0.88 2.1824 Sulfurovum mangrovi 2893889 Bacteria Bacteria 113 5.89e-27   NR WP_229938244.1 2893889 g16429 i0 77.5 1.71774193548387 71 15 84.7 1 3 212 556 626 WP_229938244.1 PhoX family protein [Sulfurovum mangrovi] diamond 426 113 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum mangrovi
29994064 29994064 PRJNA949785_P_NODE_15451_length_251_cov_1.730337_g15254_i0 PRJNA949785 15451 251 1.730337 4.34314587 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.0156   NR WP_172694454.1 210 g15254 i0 37.1 0.836653386454183 70 42 83.7 1 213 4 29 96 WP_172694454.1 replication initiation protein [Helicobacter pylori] diamond 210 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30499500 30499500 PRJNA949785_P_NODE_5633_length_471_cov_1.035176_g5436_i0 PRJNA949785 5633 471 1.035176 4.87567896 Sulfurimonadaceae bacterium 2771476 Bacteria Bacteria 52.4 6.19e-5   NR MDH5465436.1 2771476 g5436 i0 38.7 0.942675159235669 75 37 47.8 1 466 242 2 67 MDH5465436.1 NUDIX domain-containing protein [Sulfurimonadaceae bacterium] diamond 444 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae   Sulfurimonadaceae bacterium
30530969 30530969 PRJNA949785_P_NODE_19293_length_235_cov_2.185185_g19096_i0 PRJNA949785 19293 235 2.185185 5.13518475 Helicobacter pylori 210 Bacteria Bacteria 53.5 4.54e-7   NR GAA6795243.1 210 g19096 i0 95.7 0.293617021276596 23 1 29.4 0 234 166 3 25 GAA6795243.1 hypothetical protein Kyoto200A_0130 [Helicobacter pylori] diamond 69 53.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31162691 31162691 PRJNA949785_P_NODE_6055_length_450_cov_1.602122_g5858_i0 PRJNA949785 6055 450 1.602122 7.209549 Sulfurovum sp. FS 1969726 Bacteria Bacteria 48.1 0.00197   NR KIM08024.1 1539064 g5858 i0 35.7 0.56 84 48 52 3 269 36 52 135 KIM08024.1 MAG: hypothetical protein KU29_05555 [Sulfurovum sp. FS06-10] diamond 252 48.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp. FS06-10
31447603 31447603 PRJNA949785_P_NODE_16076_length_249_cov_1.750000_g15879_i0 PRJNA949785 16076 249 1.75 4.3575 Sulfurimonas sp. 2022749 Bacteria Bacteria 52.4 1.65e-5   NR MCF6330287.1 2022749 g15879 i0 31.3 0.807228915662651 67 45 79.5 1 51 248 1604 1670 MCF6330287.1 hypothetical protein [Sulfurimonas sp.] diamond 201 52.4 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);;