RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA222400 · 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
27597416 27597416 PRJNA222400_P_NODE_8084_length_166_cov_0.888889_g8051_i0 PRJNA222400 8084 166 0.888889 1.47555574 PVC group 1783257 Bacteria Bacteria 63.2 7.02e-10   NR WP_129077981.1 1548597 g8051 i0 50.9 3.90361445783133 55 27 99.4 0 165 1 73 127 WP_129077981.1 6-bladed beta-propeller [Anaerobacillus alkaliphilus] diamond 648 63.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Anaerobacillus Anaerobacillus alkaliphilus
27944634 27944634 PRJNA222400_P_NODE_525_length_707_cov_1.655015_g496_i0 PRJNA222400 525 707 1.655015 11.70095605 Bacillati 1783272 Bacteria Bacteria 163 1.3e-44   NR WP_188647295.1 1571185 g496 i0 46 21.5516265912306 189 78 80.2 4 29 595 199 363 WP_188647295.1 4-hydroxyphenylpyruvate dioxygenase [Marinithermofilum abyssi] diamond 15237 164 0.99390243902439 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Marinithermofilum Marinithermofilum abyssi
28291726 28291726 PRJNA222400_P_NODE_4406_length_211_cov_1.925926_g4373_i0 PRJNA222400 4406 211 1.925926 4.06370386 Bacillales 1385 Bacteria Bacteria 95.9 1.36e-23   NR WP_056469398.1 1712029 g4373 i0 64.8 8.70142180094787 71 24 99.5 1 2 211 1 71 WP_056469398.1 group I truncated hemoglobin [Bacillus sp. FJAT-25509] diamond 1836 96.3 0.995846313603323 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. FJAT-25509
28653045 28653045 PRJNA222400_P_NODE_1967_length_360_cov_2.758842_g1934_i0 PRJNA222400 1967 360 2.758842 9.9318312 Blautia sp. MSK.2 1955243 Bacteria Bacteria 43.1 0.0213   NR WP_174088999.1 2709718 g1934 i0 33.7 0.766666666666667 92 59 75.8 2 84 356 11 101 WP_174088999.1 prealbumin-like fold domain-containing protein, partial [Blautia sp. MSK.20.85] diamond 276 43.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia sp. MSK.20.85
28905358 28905358 PRJNA222400_P_NODE_2668_length_294_cov_2.000000_g2635_i0 PRJNA222400 2668 294 2 5.88 Bacillus weihaiensis 1547283 Bacteria Bacteria 108 1.25e-26   NR WP_083584509.1 1547283 g2635 i0 55.7 2.95918367346939 97 43 99 0 3 293 27 123 WP_083584509.1 nucleoside phosphorylase [Bacillus weihaiensis] diamond 870 108 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus weihaiensis
28937285 28937285 PRJNA222400_P_NODE_5908_length_185_cov_1.088235_g5875_i0 PRJNA222400 5908 185 1.088235 2.01323475 Niameybacter massiliensis 1658108 Bacteria Bacteria 56.2 2.97e-7   NR WP_053984370.1 1658108 g5875 i0 51.9 4.32972972972973 52 25 84.3 0 158 3 329 380 WP_053984370.1 ABC transporter ATP-binding protein [Niameybacter massiliensis] diamond 801 56.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Niameybacter Niameybacter massiliensis
29221541 29221541 PRJNA222400_P_NODE_1929_length_364_cov_1.679365_g1896_i0 PRJNA222400 1929 364 1.679365 6.1128886 Priestia megaterium 1404 Bacteria Bacteria 99.8 5.31e-23   NR WP_114896361.1 1404 g1896 i0 44.7 0.93956043956044 114 59 94 2 19 360 2 111 WP_114896361.1 SDR family oxidoreductase [Priestia megaterium] diamond 342 99.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia megaterium
29333852 29333852 PRJNA222400_P_NODE_1089_length_495_cov_1.405830_g1056_i0 PRJNA222400 1089 495 1.40583 6.9588585 root 1 Root_unresolved Root_unresolved 88.2 8.37e-20   NR WP_369599335.1 1590 g1056 i0 90.7 51.8606060606061 43 4 26.1 0 495 367 17 59 WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 25671 89 0.991011235955056 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29933957 29933957 PRJNA222400_P_NODE_1691_length_391_cov_1.666667_g1658_i0 PRJNA222400 1691 391 1.666667 6.51666797 PVC group 1783257 Bacteria Bacteria 62.4 2.65e-8   NR MBR5302381.1 2044939 g1658 i0 46.6 4.12020460358056 73 34 53.7 2 68 277 363 433 MBR5302381.1 cation-translocating P-type ATPase [Clostridia bacterium] diamond 1611 62.8 0.993630573248408 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30249960 30249960 PRJNA222400_P_NODE_2932_length_276_cov_1.647577_g2899_i0 PRJNA222400 2932 276 1.647577 4.54731252 PVC group 1783257 Bacteria Bacteria 51.2 2.66e-5   NR WP_126810078.1 180344 g2899 i0 41.8 13.5760869565217 79 43 82.6 1 6 233 105 183 WP_126810078.1 ribosome recycling factor [Vagococcus elongatus] diamond 3747 51.6 0.992248062015504 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Vagococcus Vagococcus elongatus
30390363 30390363 PRJNA222400_P_NODE_1153_length_479_cov_2.290698_g1120_i0 PRJNA222400 1153 479 2.290698 10.97244342 Clostridia bacterium 2044939 Bacteria Bacteria 54.3 3.5e-5   NR MBQ8739326.1 2044939 g1120 i0 48.8 0.782881002087683 43 22 26.9 0 17 145 156 198 MBQ8739326.1 hypothetical protein [Clostridia bacterium] diamond 375 54.3 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30800570 30800570 PRJNA222400_P_NODE_674_length_633_cov_2.642123_g644_i0 PRJNA222400 674 633 2.6421230000000002 16.72463859 Pontibacillus sp. HMF3514 2692425 Bacteria Bacteria 147 2.35e-41   NR WP_160098424.1 2692425 g644 i0 47.9 1.96208530805687 140 73 66.4 0 502 83 5 144 WP_160098424.1 OsmC family protein [Pontibacillus sp. HMF3514] diamond 1242 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Pontibacillus Pontibacillus sp. HMF3514
30895620 30895620 PRJNA222400_P_NODE_6374_length_178_cov_0.953488_g6341_i0 PRJNA222400 6374 178 0.953488 1.69720864 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 46.6 6.81e-4   NR MBR2801936.1 2049044 g6341 i0 41.2 0.859550561797753 51 30 86 0 2 154 333 383 MBR2801936.1 glucosyltransferase [Erysipelotrichaceae bacterium] diamond 153 46.6 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
31292367 31292367 PRJNA222400_P_NODE_7695_length_167_cov_1.169492_g7662_i0 PRJNA222400 7695 167 1.169492 1.95305164 PVC group 1783257 Bacteria Bacteria 111 3.3e-27   NR WP_093227905.1 46223 g7662 i0 92.7 78.0538922155689 55 4 98.8 0 3 167 99 153 WP_093227905.1 NADP-dependent isocitrate dehydrogenase [Thermoflavimicrobium dichotomicum] diamond 13035 112 0.991071428571429 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Thermoflavimicrobium Thermoflavimicrobium dichotomicum
32904203 32904203 PRJNA222400_P_NODE_2440_length_315_cov_1.139098_g2407_i0 PRJNA222400 2440 315 1.139098 3.5881587 Bacteria 2 Bacteria Bacteria 136 1.85e-35   NR WP_322158004.1 1406 g2407 i0 56.9 8.72380952380952 116 39 100 2 1 315 38 153 WP_322158004.1 GH39 family glycosyl hydrolase [Paenibacillus polymyxa] diamond 2748 136 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus polymyxa

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