RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1145574 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
2839544 2839544 PRJNA1145574_P_NODE_803_length_930_cov_1.409568_g653_i0 PRJNA1145574 803 930 1.409568 13.1089824 Enterococcus faecalis 1351 Bacteria Bacteria 409 3.44e-139   NR WP_015974302.1 1351 g653 i0 75.6 0.832258064516129 258 63 83.2 0 150 923 5 262 WP_015974302.1 phage portal protein [Enterococcus faecalis] diamond 774 409 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
21435223 21435223 PRJNA1145574_P_NODE_8317_length_299_cov_1.035398_g8133_i0 PRJNA1145574 8317 299 1.035398 3.09584002 Enterococcus faecalis 1351 Bacteria Bacteria 161 2.22e-46   NR WP_411430886.1 1351 g8133 i0 78.8 2.97993311036789 99 21 99.3 0 1 297 69 167 WP_411430886.1 DNA polymerase, partial [Enterococcus faecalis] diamond 891 161 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
21965530 21965530 PRJNA1145574_P_NODE_7918_length_307_cov_1.333333_g7734_i0 PRJNA1145574 7918 307 1.333333 4.09333231 Lactobacillus johnsonii 33959 Bacteria Bacteria 194 4.96e-62   NR WP_260317301.1 33959 g7734 i0 100 0.986970684039088 101 0 98.7 0 3 305 26 126 WP_260317301.1 hypothetical protein [Lactobacillus johnsonii] diamond 303 194 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus johnsonii
24514561 24514561 PRJNA1145574_P_NODE_3760_length_425_cov_1.028409_g3576_i0 PRJNA1145574 3760 425 1.028409 4.37073825 root 1 Root_unresolved Root_unresolved 240 2.32e-77   NR WP_411399578.1 1351 g3576 i0 80.9 7.94823529411765 141 27 99.5 0 2 424 85 225 WP_411399578.1 hypothetical protein, partial [Enterococcus faecalis] diamond 3378 242 0.991735537190083 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
26627379 26627379 PRJNA1145574_P_NODE_9801_length_273_cov_1.170000_g9617_i0 PRJNA1145574 9801 273 1.17 3.1941 Lactobacillus mulieris 2508708 Bacteria Bacteria 178 2.849999999999999e-55   NR WP_265666319.1 2508708 g9617 i0 98.9 0.989010989010989 90 1 98.9 0 271 2 54 143 WP_265666319.1 siphovirus Gp157 family protein [Lactobacillus mulieris] diamond 270 178 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus mulieris
26679406 26679406 PRJNA1145574_P_NODE_9401_length_280_cov_1.130435_g9217_i0 PRJNA1145574 9401 280 1.130435 3.165218 root 1 Root_unresolved Root_unresolved 47 6.07e-4   NR WP_411429939.1 1351 g9217 i0 88.5 1.67142857142857 26 3 27.9 0 8 85 112 137 WP_411429939.1 hypothetical protein, partial [Enterococcus faecalis] diamond 468 47 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
27312560 27312560 PRJNA1145574_P_NODE_6063_length_347_cov_1.518248_g5879_i0 PRJNA1145574 6063 347 1.518248 5.26832056 root 1 Root_unresolved Root_unresolved 135 1.24e-38   NR WP_411429961.1 1351 g5879 i0 77.1 3.64841498559078 83 19 71.8 0 98 346 18 100 WP_411429961.1 hypothetical protein, partial [Enterococcus faecalis] diamond 1266 136 0.992647058823529 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
27512986 27512986 PRJNA1145574_P_NODE_723_length_976_cov_1.699889_g581_i0 PRJNA1145574 723 976 1.699889 16.59091664 Enterococcus faecalis 1351 Bacteria Bacteria 182 1.77e-53   NR WP_015974334.1 1351 g581 i0 73.7 0.421106557377049 137 33 41.5 2 832 428 1 136 WP_015974334.1 hypothetical protein [Enterococcus faecalis] diamond 411 182 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
28164962 28164962 PRJNA1145574_P_NODE_8225_length_301_cov_1.026316_g8041_i0 PRJNA1145574 8225 301 1.026316 3.08921116 root 1 Root_unresolved Root_unresolved 171 1.15e-47   NR WP_411401443.1 1351 g8041 i0 80 8.97009966777409 100 20 99.7 0 1 300 279 378 WP_411401443.1 ribonucleoside-diphosphate reductase subunit alpha, partial [Enterococcus faecalis] diamond 2700 171 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
28385900 28385900 PRJNA1145574_P_NODE_9886_length_271_cov_1.944444_g9702_i0 PRJNA1145574 9886 271 1.944444 5.26944324 root 1 Root_unresolved Root_unresolved 136 2.68e-38   NR WP_411399584.1 1351 g9702 i0 76.1 7.02952029520295 92 19 98.5 1 271 5 42 133 WP_411399584.1 hypothetical protein, partial [Enterococcus faecalis] diamond 1905 136 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
29533673 29533673 PRJNA1145574_P_NODE_12470_length_249_cov_0.886364_g12286_i0 PRJNA1145574 12470 249 0.886364 2.20704636 Acetatifactor aquisgranensis 2941233 Bacteria Bacteria 80.1 2.91e-15   NR WP_251207212.1 2941233 g12286 i0 45.3 1.03614457831325 86 44 100 1 1 249 395 480 WP_251207212.1 YidC/Oxa1 family membrane protein insertase [Acetatifactor aquisgranensis] diamond 258 80.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Acetatifactor Acetatifactor aquisgranensis
29786150 29786150 PRJNA1145574_P_NODE_6511_length_337_cov_0.886364_g6327_i0 PRJNA1145574 6511 337 0.886364 2.98704668 Lactobacillus jensenii 109790 Bacteria Bacteria 198 3.6699999999999995e-56   NR WP_234975732.1 109790 g6327 i0 98.2 0.997032640949555 112 2 99.7 0 337 2 997 1108 WP_234975732.1 tape measure protein [Lactobacillus jensenii] diamond 336 198 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus jensenii
30122552 30122552 PRJNA1145574_P_NODE_1352_length_712_cov_2.075117_g1180_i0 PRJNA1145574 1352 712 2.075117 14.77483304 root 1 Root_unresolved Root_unresolved 300 2.07e-100   NR WP_411429948.1 1351 g1180 i0 86.9 4.04494382022472 160 21 67.4 0 710 231 32 191 WP_411429948.1 hypothetical protein, partial [Enterococcus faecalis] diamond 2880 301 0.996677740863787 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
30260379 30260379 PRJNA1145574_P_NODE_10332_length_263_cov_1.636842_g10148_i0 PRJNA1145574 10332 263 1.636842 4.30489446 Enterococcus faecalis 1351 Bacteria Bacteria 124 2.3e-34   NR WP_411399543.1 1351 g10148 i0 67.5 3.77566539923954 83 27 94.7 0 10 258 21 103 WP_411399543.1 hypothetical protein, partial [Enterococcus faecalis] diamond 993 124 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
30407380 30407380 PRJNA1145574_P_NODE_4833_length_382_cov_1.514563_g4649_i0 PRJNA1145574 4833 382 1.514563 5.78563066 root 1 Root_unresolved Root_unresolved 209 6.08e-66   NR WP_411416295.1 1351 g4649 i0 77 3.95811518324607 126 29 99 0 380 3 33 158 WP_411416295.1 hypothetical protein, partial [Enterococcus faecalis] diamond 1512 209 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
30564659 30564659 PRJNA1145574_P_NODE_13193_length_247_cov_0.896552_g13009_i0 PRJNA1145574 13193 247 0.896552 2.21448344 root 1 Root_unresolved Root_unresolved 130 2.03e-37   NR MFP9058802.1 1351 g13009 i0 87 13.0080971659919 77 10 93.5 0 241 11 24 100 MFP9058802.1 hypothetical protein [Enterococcus faecalis] diamond 3213 131 0.99236641221374 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
30923871 30923871 PRJNA1145574_P_NODE_7174_length_322_cov_1.879518_g6990_i0 PRJNA1145574 7174 322 1.879518 6.05204796 Enterococcus faecalis 1351 Bacteria Bacteria 164 2.86e-48   NR WP_411401185.1 1351 g6990 i0 73.3 5.8695652173913 105 28 97.8 0 321 7 33 137 WP_411401185.1 hypothetical protein, partial [Enterococcus faecalis] diamond 1890 164 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
30986947 30986947 PRJNA1145574_P_NODE_4474_length_395_cov_1.409938_g4290_i0 PRJNA1145574 4474 395 1.409938 5.5692551 Lactobacillus 1578 Bacteria Bacteria 223 7.21e-73   NR WP_234975733.1 1578 g4290 i0 100 0.865822784810127 114 0 86.6 0 365 24 1 114 WP_234975733.1 MULTISPECIES: hypothetical protein [Lactobacillus] diamond 342 223 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus  
31671283 31671283 PRJNA1145574_P_NODE_2837_length_485_cov_1.135922_g2654_i0 PRJNA1145574 2837 485 1.135922 5.5092217 root 1 Root_unresolved Root_unresolved 139 1.6499999999999998e-35   NR WP_411430849.1 1351 g2654 i0 58.5 4.36082474226804 118 48 73 1 1 354 362 478 WP_411430849.1 hypothetical protein [Enterococcus faecalis] diamond 2115 139 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
31671284 31671284 PRJNA1145574_P_NODE_6197_length_344_cov_1.151292_g6013_i0 PRJNA1145574 6197 344 1.151292 3.96044448 root 1 Root_unresolved Root_unresolved 132 6.32e-35   NR WP_411430838.1 1351 g6013 i0 69.9 2.17151162790698 83 25 72.4 0 251 3 1 83 WP_411430838.1 metallophosphoesterase [Enterococcus faecalis] diamond 747 132 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
31714082 31714082 PRJNA1145574_P_NODE_6317_length_341_cov_1.164179_g6133_i0 PRJNA1145574 6317 341 1.164179 3.96985039 Enterococcus faecalis 1351 Bacteria Bacteria 43.1 0.0143   NR WP_411429977.1 1351 g6133 i0 30.5 3.30791788856305 82 55 71.3 2 8 250 11 91 WP_411429977.1 hypothetical protein, partial [Enterococcus faecalis] diamond 1128 43.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
32788553 32788553 PRJNA1145574_P_NODE_2420_length_526_cov_1.637969_g2238_i0 PRJNA1145574 2420 526 1.637969 8.61571694 Enterococcus faecalis 1351 Bacteria Bacteria 165 4.099999999999999e-48   NR WP_015974362.1 1351 g2238 i0 55.6 1.95057034220532 171 76 97.5 0 514 2 35 205 WP_015974362.1 hypothetical protein [Enterococcus faecalis] diamond 1026 165 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis

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