RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA929940" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA929940 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
26746725 26746725 PRJNA929940_S_NODE_54061_length_155_cov_5.398305_g53826_i0 PRJNA929940 54061 155 5.398305 8.36737275 root 1 Root_unresolved Root_unresolved 100 4.45e-26   NR WP_407812873.1 1280 g53826 i0 96.1 130.296774193548 51 2 98.7 0 1 153 21 71 WP_407812873.1 hypothetical protein, partial [Staphylococcus aureus] diamond 20196 101 0.99009900990099 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
26993039 26993039 PRJNA929940_S_NODE_7742_length_327_cov_2.120690_g7507_i0 PRJNA929940 7742 327 2.12069 6.9346563 Staphylococcus aureus 1280 Bacteria Bacteria 67 3.77e-12   NR MDN8753916.1 1280 g7507 i0 78.9 0.348623853211009 38 8 34.9 0 162 275 15 52 MDN8753916.1 hypothetical protein [Staphylococcus aureus] diamond 114 67 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27056627 27056627 PRJNA929940_S_NODE_17082_length_243_cov_56.266990_g16847_i0 PRJNA929940 17082 243 56.26699 136.7287857 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 85.1 1.85e-19   NR WP_305021979.1 1590 g16847 i0 100 2.81481481481481 38 0 46.9 0 242 129 58 95 WP_305021979.1 nucleoside-diphosphate kinase, partial [Lactiplantibacillus plantarum] diamond 684 85.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
27150923 27150923 PRJNA929940_S_NODE_45122_length_167_cov_1.484615_g44887_i0 PRJNA929940 45122 167 1.484615 2.47930705 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 43.1 0.00946   NR MBQ9393311.1 2485925 g44887 i0 39.2 2.74850299401198 51 29 91.6 1 3 155 77 125 MBQ9393311.1 amino acid ABC transporter substrate-binding protein [Oscillospiraceae bacterium] diamond 459 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
27214410 27214410 PRJNA929940_S_NODE_3362_length_438_cov_92.039900_g3129_i0 PRJNA929940 3362 438 92.0399 403.134762 Bacillus cereus 1396 Bacteria Bacteria 258 2.0500000000000006e-86   NR WP_233724406.1 1396 g3129 i0 97.1 0.931506849315068 136 2 91.8 1 436 35 6 141 WP_233724406.1 hypothetical protein [Bacillus cereus] diamond 408 258 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
27530485 27530485 PRJNA929940_S_NODE_5243_length_375_cov_4.547337_g5008_i0 PRJNA929940 5243 375 4.547337 17.05251375 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 104 9.36e-27   NR WP_252130154.1 1590 g5008 i0 100 0.344 43 0 34.4 0 374 246 31 73 WP_252130154.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 129 104 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
27561838 27561838 PRJNA929940_S_NODE_6964_length_339_cov_4.006623_g6729_i0 PRJNA929940 6964 339 4.006623 13.58245197 Leuconostoc mesenteroides 1245 Bacteria Bacteria 43.9 0.0391   NR WP_061399561.1 1245 g6729 i0 30.9 1.80530973451327 68 46 60.2 1 50 253 186 252 WP_061399561.1 acyltransferase [Leuconostoc mesenteroides] diamond 612 43.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Leuconostoc Leuconostoc mesenteroides
28035774 28035774 PRJNA929940_S_NODE_42385_length_171_cov_1.440299_g42150_i0 PRJNA929940 42385 171 1.440299 2.46291129 Staphylococcus aureus 1280 Bacteria Bacteria 47.8 2.17e-5   NR MDN8753916.1 1280 g42150 i0 69 0.508771929824561 29 9 50.9 0 88 2 15 43 MDN8753916.1 hypothetical protein [Staphylococcus aureus] diamond 87 47.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28193351 28193351 PRJNA929940_S_NODE_7606_length_328_cov_15.261168_g7371_i0 PRJNA929940 7606 328 15.261168 50.05663104 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 78.6 1.86e-16   NR WP_252130094.1 1590 g7371 i0 87 0.420731707317073 46 6 42.1 0 272 135 1 46 WP_252130094.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 138 78.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28382969 28382969 PRJNA929940_S_NODE_49786_length_160_cov_15.983740_g49551_i0 PRJNA929940 49786 160 15.98374 25.573984 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 54.7 7.56e-8   NR WP_252130024.1 1590 g49551 i0 100 6.3 28 0 52.5 0 2 85 47 74 WP_252130024.1 60S acidic ribosomal protein P2, partial [Lactiplantibacillus plantarum] diamond 1008 54.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28446283 28446283 PRJNA929940_S_NODE_5746_length_363_cov_2.196319_g5511_i0 PRJNA929940 5746 363 2.196319 7.97263797 Staphylococcus aureus 1280 Bacteria Bacteria 49.7 3.24e-5   NR MDN8753916.1 1280 g5511 i0 46.9 0.528925619834711 64 26 46.3 1 146 313 8 71 MDN8753916.1 hypothetical protein [Staphylococcus aureus] diamond 192 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28667315 28667315 PRJNA929940_S_NODE_32047_length_191_cov_1.422078_g31812_i0 PRJNA929940 32047 191 1.422078 2.71616898 Streptococcus pneumoniae 1313 Bacteria Bacteria 47 4.11e-5   NR MFR7015324.1 1313 g31812 i0 46.9 1.53926701570681 49 26 77 0 44 190 1 49 MFR7015324.1 hypothetical protein [Streptococcus pneumoniae] diamond 294 47 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28730339 28730339 PRJNA929940_S_NODE_8627_length_314_cov_10.981949_g8392_i0 PRJNA929940 8627 314 10.981949 34.48331986 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 50.1 2.33e-5   NR WP_252130094.1 1590 g8392 i0 81.3 0.305732484076433 32 5 30.6 1 54 149 1 31 WP_252130094.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 96 50.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28888098 28888098 PRJNA929940_S_NODE_10948_length_288_cov_2.071713_g10713_i0 PRJNA929940 10948 288 2.071713 5.96653344 Blautia sp. 1955243 Bacteria Bacteria 43.5 0.0119   NR WP_291816360.1 1955243 g10713 i0 42.2 0.46875 45 26 46.9 0 165 31 47 91 WP_291816360.1 transposase family protein [Blautia sp.] diamond 135 43.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia sp.
29393483 29393483 PRJNA929940_S_NODE_38449_length_177_cov_42.935714_g38214_i0 PRJNA929940 38449 177 42.935714 75.99621378 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 123 1.3399999999999996e-34   NR WP_252130042.1 1590 g38214 i0 100 14.5084745762712 57 0 96.6 0 176 6 48 104 WP_252130042.1 nucleoside-diphosphate kinase, partial [Lactiplantibacillus plantarum] diamond 2568 123 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29456183 29456183 PRJNA929940_S_NODE_4030_length_411_cov_5.943850_g3796_i0 PRJNA929940 4030 411 5.94385 24.4292235 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 157 3.269999999999999e-47   NR WP_252130168.1 1590 g3796 i0 98.7 0.562043795620438 77 1 56.2 0 23 253 1 77 WP_252130168.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 231 157 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29708707 29708707 PRJNA929940_S_NODE_52390_length_157_cov_3.200000_g52155_i0 PRJNA929940 52390 157 3.2 5.024 Tumebacillus avium 1903704 Bacteria Bacteria 40 0.0326   NR WP_087458473.1 1903704 g52155 i0 46.5 0.821656050955414 43 20 82.2 1 136 8 14 53 WP_087458473.1 tetratricopeptide repeat protein [Tumebacillus avium] diamond 129 40 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Tumebacillus Tumebacillus avium
29835353 29835353 PRJNA929940_S_NODE_9011_length_309_cov_14.496324_g8776_i0 PRJNA929940 9011 309 14.496324 44.79364116 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 186 2.2300000000000003e-58   NR WP_252130021.1 1590 g8776 i0 95.8 1.92233009708738 96 4 93.2 0 21 308 1 96 WP_252130021.1 M14 family zinc carboxypeptidase, partial [Lactiplantibacillus plantarum] diamond 594 187 0.994652406417112 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30025124 30025124 PRJNA929940_S_NODE_13331_length_267_cov_4.569565_g13096_i0 PRJNA929940 13331 267 4.569565 12.20073855 Lactiplantibacillus sp. E932 2952565 Bacteria Bacteria 66.2 5.76e-12   NR MCM8651792.1 2952565 g13096 i0 100 0.674157303370786 30 0 33.7 0 3 92 59 88 MCM8651792.1 thioredoxin family protein [Lactiplantibacillus sp. E932] diamond 180 66.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus sp. E932
30372894 30372894 PRJNA929940_S_NODE_3272_length_441_cov_29.039604_g3039_i0 PRJNA929940 3272 441 29.039604 128.06465364 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 170 3.2e-52   NR WP_252130203.1 1590 g3039 i0 100 0.605442176870748 89 0 60.5 0 284 18 1 89 WP_252130203.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 267 170 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30600608 30600608 PRJNA929940_S_NODE_41573_length_172_cov_2.118519_g41338_i0 PRJNA929940 41573 172 2.118519 3.64385268 root 1 Root_unresolved Root_unresolved 125 3.5999999999999997e-36   NR WP_407819303.1 1280 g41338 i0 100 611.441860465116 56 0 97.7 0 170 3 11 66 WP_407819303.1 hypothetical protein, partial [Staphylococcus aureus] diamond 105168 125 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30909748 30909748 PRJNA929940_S_NODE_1834_length_542_cov_65.075248_g1617_i0 PRJNA929940 1834 542 65.075248 352.70784416 Bacillus cereus 1396 Bacteria Bacteria 154 1.39e-44   NR WP_233724406.1 1396 g1617 i0 89.2 0.514760147601476 93 7 50.4 2 3 275 6 97 WP_233724406.1 hypothetical protein [Bacillus cereus] diamond 279 154 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
31510420 31510420 PRJNA929940_S_NODE_4156_length_407_cov_4.635135_g3922_i0 PRJNA929940 4156 407 4.635135 18.86499945 Enterococcus faecium 1352 Bacteria Bacteria 101 1.2e-25   NR PWS22576.1 1352 g3922 i0 97.8 40.6879606879607 46 1 33.9 0 407 270 3 48 PWS22576.1 hypothetical protein DKP78_17665 [Enterococcus faecium] diamond 16560 102 0.990196078431373 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
31549228 31549228 PRJNA929940_S_NODE_10976_length_287_cov_14.892000_g10741_i0 PRJNA929940 10976 287 14.892 42.74004 root 1 Root_unresolved Root_unresolved 158 4.639999999999999e-47   NR QHG80041.1 1280 g10741 i0 98.7 54.0104529616725 76 1 79.4 0 2 229 112 187 QHG80041.1 30S ribosomal protein S13 [Staphylococcus aureus] diamond 15501 159 0.993710691823899 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32118497 32118497 PRJNA929940_S_NODE_21718_length_221_cov_76.630435_g21483_i0 PRJNA929940 21718 221 76.630435 169.35326135 root 1 Root_unresolved Root_unresolved 73.6 3.82e-15   NR WP_252130105.1 1590 g21483 i0 97.2 3.71945701357466 36 1 48.9 0 219 112 49 84 WP_252130105.1 50S ribosomal protein L37Ae, partial [Lactiplantibacillus plantarum] diamond 822 74.3 0.990578734858681 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
32143010 32143010 PRJNA929940_S_NODE_11198_length_286_cov_1.815261_g10963_i0 PRJNA929940 11198 286 1.815261 5.19164646 Dehalobacterium sp. 2022806 Bacteria Bacteria 42 0.0112   NR MEL7564728.1 2022806 g10963 i0 40.4 0.493006993006993 47 28 49.3 0 90 230 11 57 MEL7564728.1 hypothetical protein [Dehalobacterium sp.] diamond 141 42 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae Dehalobacterium Dehalobacterium sp.
32396174 32396174 PRJNA929940_S_NODE_23019_length_217_cov_1.461111_g22784_i0 PRJNA929940 23019 217 1.461111 3.17061087 Clostridiales bacterium 1898207 Bacteria Bacteria 41.6 0.0498   NR HCC04177.1 1898207 g22784 i0 35.7 0.580645161290323 42 27 58.1 0 145 20 75 116 HCC04177.1 hypothetical protein [Clostridiales bacterium] diamond 126 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales 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);;