RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA217180" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA217180 · 10 ✖

analysis 1

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
27105387 27105387 PRJNA217180_P_NODE_14802_length_162_cov_0.902655_g14702_i0 PRJNA217180 14802 162 0.902655 1.4623011 Desulfurellales bacterium 2482794 Bacteria Bacteria 45.8 0.00105   NR TXH46783.1 2482794 g14702 i0 38.5 0.962962962962963 52 32 96.3 0 7 162 571 622 TXH46783.1 MAG: hypothetical protein E6Q97_28800 [Desulfurellales bacterium] diamond 156 45.8 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
27136756 27136756 PRJNA217180_P_NODE_9962_length_187_cov_1.137681_g9862_i0 PRJNA217180 9962 187 1.137681 2.12746347 Desulfurellales bacterium 2482794 Bacteria Bacteria 78.6 9.3e-16   NR TXH44753.1 2482794 g9862 i0 75.5 0.850267379679144 53 13 85 0 161 3 1 53 TXH44753.1 MAG: hypothetical protein E6Q97_32255 [Desulfurellales bacterium] diamond 159 78.6 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
27642842 27642842 PRJNA217180_P_NODE_13124_length_166_cov_0.871795_g13024_i0 PRJNA217180 13124 166 0.871795 1.4471797 Desulfurellales bacterium 2482794 Bacteria Bacteria 87 2.88e-18   NR TXH57896.1 2482794 g13024 i0 76.4 0.993975903614458 55 13 99.4 0 166 2 324 378 TXH57896.1 MAG: hypothetical protein E6Q97_03420 [Desulfurellales bacterium] diamond 165 87 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
27706176 27706176 PRJNA217180_P_NODE_10584_length_182_cov_1.496241_g10484_i0 PRJNA217180 10584 182 1.496241 2.72315862 Desulfurellales bacterium 2482794 Bacteria Bacteria 60.8 6.66e-9   NR TXH57450.1 2482794 g10484 i0 51 0.840659340659341 51 25 84.1 0 156 4 200 250 TXH57450.1 MAG: hypothetical protein E6Q97_04415, partial [Desulfurellales bacterium] diamond 153 60.8 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
27863569 27863569 PRJNA217180_P_NODE_14785_length_162_cov_0.902655_g14685_i0 PRJNA217180 14785 162 0.902655 1.4623011 Desulfurellales bacterium 2482794 Bacteria Bacteria 50.4 2.31e-5   NR TXH56018.1 2482794 g14685 i0 48.1 0.962962962962963 52 27 96.3 0 158 3 83 134 TXH56018.1 MAG: hypothetical protein E6Q97_07395 [Desulfurellales bacterium] diamond 156 50.4 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29221537 29221537 PRJNA217180_P_NODE_13809_length_164_cov_0.886957_g13709_i0 PRJNA217180 13809 164 0.886957 1.45460948 Desulfurellales bacterium 2482794 Bacteria Bacteria 73.9 1.25e-13   NR TXH46698.1 2482794 g13709 i0 71.7 0.969512195121951 53 15 97 0 160 2 83 135 TXH46698.1 MAG: hypothetical protein E6Q97_28965 [Desulfurellales bacterium] diamond 159 73.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29979191 29979191 PRJNA217180_P_NODE_15371_length_161_cov_0.910714_g15271_i0 PRJNA217180 15371 161 0.910714 1.46624954 Helicobacter pylori 210 Bacteria Bacteria 47 3.7e-5   NR WP_316479291.1 210 g15271 i0 42.6 0.875776397515528 47 27 87.6 0 19 159 17 63 WP_316479291.1 hypothetical protein, partial [Helicobacter pylori] diamond 141 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31938774 31938774 PRJNA217180_P_NODE_13457_length_165_cov_0.879310_g13357_i0 PRJNA217180 13457 165 0.87931 1.4508615 Desulfurellales bacterium 2482794 Bacteria Bacteria 53.1 2.67e-6   NR TXH53536.1 2482794 g13357 i0 42.6 1.85454545454545 54 31 98.2 0 3 164 284 337 TXH53536.1 MAG: DUF3987 domain-containing protein [Desulfurellales bacterium] diamond 306 53.1 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32445407 32445407 PRJNA217180_P_NODE_12919_length_166_cov_0.871795_g12819_i0 PRJNA217180 12919 166 0.871795 1.4471797 Desulfurellales bacterium 2482794 Bacteria Bacteria 111 9.91e-27   NR TXH46783.1 2482794 g12819 i0 90.9 0.993975903614458 55 5 99.4 0 165 1 333 387 TXH46783.1 MAG: hypothetical protein E6Q97_28800 [Desulfurellales bacterium] diamond 165 111 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32652094 32652094 PRJNA217180_P_NODE_13080_length_166_cov_0.871795_g12980_i0 PRJNA217180 13080 166 0.871795 1.4471797 root 1 Root_unresolved Root_unresolved 56.6 1.57e-7   NR TXH46046.1 2482794 g12980 i0 50.9 3.70481927710843 53 26 95.8 0 8 166 11 63 TXH46046.1 MAG: hypothetical protein E6Q97_30385 [Desulfurellales bacterium] diamond 615 56.6 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);;