RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312107 · 7 ✖

analysis 1

  • diamond · 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
5481079 5481079 PRJNA312107_P_NODE_22025_length_166_cov_0.888889_g21859_i0 PRJNA312107 22025 166 0.888889 1.47555574 Campylobacter ureolyticus 827 Bacteria Bacteria 101 1.9599999999999994e-23   NR WP_269499316.1 827 g21859 i0 100 0.975903614457831 54 0 97.6 0 164 3 126 179 WP_269499316.1 anaerobic C4-dicarboxylate transporter [Campylobacter ureolyticus] diamond 162 101 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
27674707 27674707 PRJNA312107_P_NODE_23604_length_164_cov_0.904348_g23438_i0 PRJNA312107 23604 164 0.904348 1.48313072 Desulfurellales bacterium 2482794 Bacteria Bacteria 96.7 1.3399999999999999e-24   NR TXH56862.1 2482794 g23438 i0 91.8 0.896341463414634 49 4 89.6 0 16 162 18 66 TXH56862.1 MAG: hypothetical protein E6Q97_05560, partial [Desulfurellales bacterium] diamond 147 96.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29870685 29870685 PRJNA312107_P_NODE_23151_length_165_cov_0.896552_g22985_i0 PRJNA312107 23151 165 0.896552 1.4793108 Bacteria 2 Bacteria Bacteria 68.6 9.96e-12   NR TXH47520.1 2482794 g22985 i0 55.8 8.49090909090909 52 23 94.5 0 157 2 576 627 TXH47520.1 MAG: ATP-dependent DNA helicase [Desulfurellales bacterium] diamond 1401 68.6 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30706038 30706038 PRJNA312107_P_NODE_23814_length_164_cov_0.904348_g23648_i0 PRJNA312107 23814 164 0.904348 1.48313072 Desulfurellales bacterium 2482794 Bacteria Bacteria 65.9 8.77e-11   NR TXH54718.1 2482794 g23648 i0 52.8 0.969512195121951 53 25 97 0 162 4 281 333 TXH54718.1 MAG: hypothetical protein E6Q97_10270 [Desulfurellales bacterium] diamond 159 65.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31116654 31116654 PRJNA312107_P_NODE_25175_length_163_cov_0.912281_g25009_i0 PRJNA312107 25175 163 0.912281 1.48701803 Desulfurellales bacterium 2482794 Bacteria Bacteria 51.2 9.26e-6   NR TXH43037.1 2482794 g25009 i0 64.4 0.828220858895706 45 16 82.8 0 23 157 83 127 TXH43037.1 MAG: hypothetical protein E6Q97_34840 [Desulfurellales bacterium] diamond 135 51.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32273410 32273410 PRJNA312107_P_NODE_26758_length_152_cov_2.330097_g26592_i0 PRJNA312107 26758 152 2.330097 3.54174744 Pseudomonadati 3379134 Bacteria Bacteria 61.2 2.15e-10   NR GAA9176272.1 210 g26592 i0 100 1.53947368421053 26 0 51.3 0 4 81 1 26 GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori] diamond 234 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32540621 32540621 PRJNA312107_P_NODE_19019_length_169_cov_0.866667_g18853_i0 PRJNA312107 19019 169 0.866667 1.46466723 Desulfurellales bacterium 2482794 Bacteria Bacteria 62.4 2.52e-10   NR TXH50016.1 2482794 g18853 i0 48.2 0.994082840236686 56 29 99.4 0 168 1 62 117 TXH50016.1 MAG: hypothetical protein E6Q97_21245 [Desulfurellales bacterium] diamond 168 62.4 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);;