RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA382357" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA382357 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
5505990 5505990 PRJNA382357_P_NODE_10185_length_653_cov_6.217905_g9484_i0 PRJNA382357 10185 653 6.217905 40.60291965 Pseudomonadati 3379134 Bacteria Bacteria 180 1.58e-49   NR MDD3500783.1 1969726 g9484 i0 100 1.17151607963247 85 0 39.1 0 2 256 14 98 MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.] diamond 765 180 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
18255167 18255167 PRJNA382357_P_NODE_2935_length_1088_cov_2.644596_g2417_i0 PRJNA382357 2935 1088 2.644596 28.77320448 Poseidonibacter antarcticus 2478538 Bacteria Bacteria 156 7.339999999999998e-42   NR WP_162984614.1 2478538 g2417 i0 77.6 0.573529411764706 98 22 27 0 1086 793 4 101 WP_162984614.1 GAG-pre-integrase domain-containing protein, partial [Poseidonibacter antarcticus] diamond 624 156 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter antarcticus
26631904 26631904 PRJNA382357_P_NODE_160541_length_194_cov_3.330827_g159802_i0 PRJNA382357 160541 194 3.330827 6.46180438 Helicobacter pylori 210 Bacteria Bacteria 66.6 6.19e-13   NR WP_316480680.1 210 g159802 i0 100 0.417525773195876 27 0 41.8 0 82 2 1 27 WP_316480680.1 hypothetical protein [Helicobacter pylori] diamond 81 66.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27517444 27517444 PRJNA382357_P_NODE_152003_length_203_cov_2.669014_g151264_i0 PRJNA382357 152003 203 2.669014 5.41809842 Helicobacter pylori 210 Bacteria Bacteria 65.5 3.94e-12   NR GAA9246723.1 210 g151264 i0 61.2 2.33497536945813 49 12 72.4 1 190 44 3 44 GAA9246723.1 hypothetical protein Kyoto199A_0690 [Helicobacter pylori] diamond 474 65.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27580483 27580483 PRJNA382357_P_NODE_103884_length_238_cov_1.457627_g103145_i0 PRJNA382357 103884 238 1.457627 3.46915226 Campylobacterota bacterium 2026809 Bacteria Bacteria 57.8 3.59e-8   NR RLA81297.1 2026809 g103145 i0 43.5 0.869747899159664 69 37 85.7 2 33 236 74 141 RLA81297.1 MAG: hypothetical protein DRG78_09390 [Campylobacterota bacterium] diamond 207 57.8 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28464795 28464795 PRJNA382357_P_NODE_159746_length_195_cov_16.313433_g159007_i0 PRJNA382357 159746 195 16.313433 31.81119435 Arcobacter nitrofigilis 28199 Bacteria Bacteria 42.4 0.0099   NR WP_013135010.1 28199 g159007 i0 41.5 0.630769230769231 41 24 63.1 0 8 130 80 120 WP_013135010.1 DUF6463 family protein [Arcobacter nitrofigilis] diamond 123 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter nitrofigilis
28496342 28496342 PRJNA382357_P_NODE_104847_length_237_cov_1.477273_g104108_i0 PRJNA382357 104847 237 1.477273 3.50113701 Aliarcobacter sp. 2321116 Bacteria Bacteria 62.8 3.01e-9   NR MFA9197616.1 2321116 g104108 i0 59.4 0.810126582278481 64 26 81 0 18 209 129 192 MFA9197616.1 beta strand repeat-containing protein [Aliarcobacter sp.] diamond 192 62.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter sp.
28528023 28528023 PRJNA382357_P_NODE_157267_length_200_cov_4.244604_g156528_i0 PRJNA382357 157267 200 4.244604 8.489208 Desulfurellales bacterium 2482794 Bacteria Bacteria 58.2 7.8e-8   NR TXH51787.1 2482794 g156528 i0 65.1 0.645 43 15 64.5 0 24 152 586 628 TXH51787.1 MAG: hypothetical protein E6Q97_17690, partial [Desulfurellales bacterium] diamond 129 58.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29649455 29649455 PRJNA382357_P_NODE_157090_length_200_cov_14.187050_g156351_i0 PRJNA382357 157090 200 14.18705 28.3741 Pseudomonadati 3379134 Bacteria Bacteria 73.2 3.33e-13   NR WP_046552098.1 206403 g156351 i0 84.2 8.55 38 6 57 0 115 2 219 256 WP_046552098.1 NAD(P)/FAD-dependent oxidoreductase [Sulfurovum lithotrophicum] diamond 1710 73.6 0.994565217391304 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum lithotrophicum
29664089 29664089 PRJNA382357_P_NODE_141470_length_208_cov_0.884354_g140731_i0 PRJNA382357 141470 208 0.884354 1.83945632 Desulfurellales bacterium 2482794 Bacteria Bacteria 48.9 3.94e-5   NR TXH55011.1 2482794 g140731 i0 49 0.735576923076923 51 20 73.6 1 11 163 82 126 TXH55011.1 MAG: hypothetical protein E6Q97_09675 [Desulfurellales bacterium] diamond 153 48.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29980340 29980340 PRJNA382357_P_NODE_53091_length_319_cov_19.922481_g52352_i0 PRJNA382357 53091 319 19.922481 63.55271439 Desulfurellales bacterium 2482794 Bacteria Bacteria 132 9.15e-37   NR TXH58408.1 2482794 g52352 i0 80.2 0.761755485893417 81 16 76.2 0 37 279 77 157 TXH58408.1 MAG: hypothetical protein E6Q97_02280 [Desulfurellales bacterium] diamond 243 132 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30137901 30137901 PRJNA382357_P_NODE_23712_length_458_cov_1.108312_g22975_i0 PRJNA382357 23712 458 1.108312 5.07606896 Campylobacterota bacterium 2026809 Bacteria Bacteria 150 3.1299999999999996e-42   NR MBM17588.1 2026809 g22975 i0 62.5 0.786026200873362 120 45 78.6 0 364 5 57 176 MBM17588.1 hypothetical protein [Campylobacterota bacterium] diamond 360 150 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
32034922 32034922 PRJNA382357_P_NODE_130338_length_214_cov_1.555556_g129599_i0 PRJNA382357 130338 214 1.555556 3.32888984 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 86.7 5.45e-18   NR WP_342836526.1 28198 g129599 i0 58.7 0.883177570093458 63 26 88.3 0 22 210 91 153 WP_342836526.1 glycosyltransferase [Aliarcobacter cryaerophilus] diamond 189 86.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
32035007 32035007 PRJNA382357_P_NODE_91698_length_251_cov_43.915789_g90959_i0 PRJNA382357 91698 251 43.915789 110.22863039 Desulfurellales bacterium 2482794 Bacteria Bacteria 52.8 1.22e-5   NR TXH41845.1 2482794 g90959 i0 49.1 0.657370517928287 55 28 65.7 0 86 250 392 446 TXH41845.1 MAG: hypothetical protein E6Q97_36780 [Desulfurellales bacterium] diamond 165 52.8 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32083548 32083548 PRJNA382357_P_NODE_98278_length_244_cov_1.420765_g97539_i0 PRJNA382357 98278 244 1.420765 3.4666666 Aliarcobacter 2321111 Bacteria Bacteria 87.4 3.65e-18   NR WP_187472577.1 28198 g97539 i0 68.6 2.50819672131148 51 16 62.7 0 153 1 294 344 WP_187472577.1 GmrSD restriction endonuclease domain-containing protein [Aliarcobacter cryaerophilus] diamond 612 87.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus

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