RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA1061474", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 27 ✖

tax_kingdom 1

  • Bacillati · 27 ✖

bioproject 1

  • PRJNA1061474 · 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
3562303 3562303 PRJNA1061474_P_NODE_15583_length_512_cov_1.715262_g15337_i0 PRJNA1061474 15583 512 1.715262 8.78214144 root 1 Root_unresolved Root_unresolved 209 3.47e-63   NR QHG77622.1 1280 g15337 i0 67.6 150.181640625 145 47 85 0 435 1 104 248 QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus] diamond 76893 210 0.995238095238095 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
3562368 3562368 PRJNA1061474_P_NODE_55623_length_243_cov_0.905882_g55377_i0 PRJNA1061474 55623 243 0.905882 2.20129326 Bacillota bacterium 1879010 Bacteria Bacteria 144 1.3e-41   NR HWI55799.1 1879010 g55377 i0 94.9 4.81481481481481 78 4 96.3 0 235 2 1 78 HWI55799.1 50S ribosomal protein L9 [Bacillota bacterium] diamond 1170 144 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
4005440 4005440 PRJNA1061474_P_NODE_53184_length_245_cov_0.895349_g52938_i0 PRJNA1061474 53184 245 0.895349 2.19360505 Paenibacillus polymyxa 1406 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2451066805|gb|CP097766.3| 1406 g52938 i0 100 2 245 0 100 0 1 245 4213878 4213634 Paenibacillus polymyxa strain R 6.14 chromosome, complete genome blastn 490 453 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus polymyxa
6556843 6556843 PRJNA1061474_P_NODE_49766_length_248_cov_0.880000_g49520_i0 PRJNA1061474 49766 248 0.88 2.1824 Desulfofundulus kuznetsovii 58135 Bacteria Bacteria 156 1.66e-33   NTclustered gi|333820987|gb|CP002770.1| 760568 g49520 i0 81.967 0.919354838709677 183 33 74 0 66 248 524682 524500 Desulfotomaculum kuznetsovii DSM 6115, complete genome blastn 228 156 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae Desulfofundulus Desulfofundulus kuznetsovii
9939788 9939788 PRJNA1061474_P_NODE_26508_length_367_cov_1.666667_g26262_i0 PRJNA1061474 26508 367 1.666667 6.11666789 Aerococcus 1375 Bacteria Bacteria 678 0   NTclustered gi|984726517|gb|CP014164.1| 1377 g26262 i0 100 447.558583106267 367 0 100 0 1 367 18734 18368 Aerococcus viridans strain CCUG4311, complete genome blastn 164254 678 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus viridans
9939863 9939863 PRJNA1061474_P_NODE_52588_length_245_cov_0.895349_g52342_i0 PRJNA1061474 52588 245 0.895349 2.19360505 Lysinibacillus 400634 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1333950533|gb|CP026007.1| 2072025 g52342 i0 100 72.2040816326531 245 0 100 0 1 245 111999 111755 Lysinibacillus sp. YS11 chromosome, complete genome blastn 17690 453 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus sp. YS11
11657309 11657309 PRJNA1061474_P_NODE_44770_length_253_cov_1.777778_g44524_i0 PRJNA1061474 44770 253 1.777778 4.49777834 Staphylococcus epidermidis 1282 Bacteria Bacteria 429 9.079999999999999e-116   NTclustered gi|2866855000|gb|CP064560.1| 1282 g44524 i0 99.574 440.324110671937 235 1 93 0 1 235 2354517 2354283 Staphylococcus epidermidis strain UMCG361 chromosome, complete genome blastn 111402 429 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
13765074 13765074 PRJNA1061474_P_NODE_51651_length_246_cov_0.890173_g51405_i0 PRJNA1061474 51651 246 0.890173 2.18982558 Agathobacter 1766253 Bacteria Bacteria 420 5.29e-113   NTclustered gi|2669501798|gb|CP143947.1| 39491 g51405 i0 100 421.170731707317 227 0 92 0 20 246 1392798 1392572 Agathobacter rectalis strain DFI.5.28 chromosome, complete genome blastn 103608 420 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Agathobacter Agathobacter rectalis
18030661 18030661 PRJNA1061474_P_NODE_52335_length_245_cov_0.976744_g52089_i0 PRJNA1061474 52335 245 0.976744 2.3930228 Lachnospiraceae bacterium GAM79 2109691 Bacteria Bacteria 383 6.899999999999998e-102   NTclustered gi|2127625274|gb|CP085928.1| 2109691 g52089 i0 97.748 443.191836734694 222 5 91 0 19 240 819956 819735 Lachnospiraceae bacterium GAM79 strain FDAARGOS_1585 chromosome, complete genome blastn 108582 383 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium GAM79
18863250 18863250 PRJNA1061474_P_NODE_56335_length_242_cov_0.911243_g56089_i0 PRJNA1061474 56335 242 0.911243 2.20520806 Staphylococcus 1279 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|1176884116|gb|CP020463.1| 1282 g56089 i0 100 100 242 0 100 0 1 242 704035 704276 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 24200 448 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
21855790 21855790 PRJNA1061474_P_NODE_51118_length_246_cov_0.890173_g50872_i0 PRJNA1061474 51118 246 0.890173 2.18982558 Sporomusaceae 1843490 Bacteria Bacteria 160 4.29e-44   NR WP_145093510.1 943346 g50872 i0 90.1 2.98780487804878 81 8 98.8 0 243 1 384 464 WP_145093510.1 NADH-quinone oxidoreductase subunit NuoF [Sporomusa sp. KB1] diamond 735 161 0.993788819875776 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Sporomusa Sporomusa sp. KB1
21855879 21855879 PRJNA1061474_P_NODE_54598_length_243_cov_2.264706_g54352_i0 PRJNA1061474 54598 243 2.264706 5.50323558 Aerococcus urinaeequi 51665 Bacteria Bacteria 418 1.8699999999999998e-112   NTclustered gi|1919119126|gb|CP063065.1| 51665 g54352 i0 99.563 482.679012345679 229 1 94 0 15 243 254735 254963 Aerococcus urinaeequi strain T43 chromosome, complete genome blastn 117291 418 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus urinaeequi
26869233 26869233 PRJNA1061474_P_NODE_30401_length_337_cov_0.981061_g30155_i0 PRJNA1061474 30401 337 0.981061 3.30617557 Bacteria 2 Bacteria Bacteria 47.8 0.00185   NR WP_013077039.1 33943 g30155 i0 32.4 7.43323442136499 108 52 91.7 4 29 337 243 334 WP_013077039.1 S-layer homology domain-containing protein [Kyrpidia tusciae] diamond 2505 47.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Kyrpidia Kyrpidia tusciae
26877521 26877521 PRJNA1061474_P_NODE_56741_length_242_cov_0.911243_g56495_i0 PRJNA1061474 56741 242 0.911243 2.20520806 Candidatus Fermentithermobacillaceae bacterium 3085339 Bacteria Bacteria 53.1 5e-7   NR HHW26098.1 3085339 g56495 i0 54.2 0.59504132231405 48 21 59.5 1 221 78 28 74 HHW26098.1 helix-turn-helix domain-containing protein [Candidatus Fermentithermobacillaceae bacterium] diamond 144 53.1 1 Bacteria   Bacillati Bacillota Candidatus Fermentithermobacillia Candidatus Fermentithermobacillales Candidatus Fermentithermobacillaceae   Candidatus Fermentithermobacillaceae bacterium
27035446 27035446 PRJNA1061474_P_NODE_47982_length_249_cov_0.875000_g47736_i0 PRJNA1061474 47982 249 0.875 2.17875 Longicatena sp. 1918617 Bacteria Bacteria 42 0.0431   NR MEE0831737.1 1918617 g47736 i0 36.5 0.759036144578313 63 38 75.9 2 244 56 56 116 MEE0831737.1 hypothetical protein [Longicatena sp.] diamond 189 42 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Longicatena Longicatena sp.
27951564 27951564 PRJNA1061474_P_NODE_47965_length_249_cov_0.875000_g47719_i0 PRJNA1061474 47965 249 0.875 2.17875 Clostridium malenominatum 1539 Bacteria Bacteria 57 3.73e-7   NR WP_343766983.1 1539 g47719 i0 74.3 0.421686746987952 35 9 42.2 0 245 141 656 690 WP_343766983.1 AIPR family protein [Clostridium malenominatum] diamond 105 57 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium malenominatum
29616358 29616358 PRJNA1061474_P_NODE_14010_length_548_cov_1.378947_g13768_i0 PRJNA1061474 14010 548 1.378947 7.55662956 root 1 Root_unresolved Root_unresolved 87 3.89e-19   NR WP_369599335.1 1590 g13768 i0 100 47.293795620438 40 0 21.9 0 2 121 20 59 WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 25917 87 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29972295 29972295 PRJNA1061474_P_NODE_50631_length_247_cov_0.885057_g50385_i0 PRJNA1061474 50631 247 0.885057 2.18609079 Bacillaceae 186817 Bacteria Bacteria 144 1.2999999999999998e-38   NR WP_066102485.1 186817 g50385 i0 92.7 0.995951417004049 82 6 99.6 0 246 1 343 424 WP_066102485.1 MULTISPECIES: DEAD/DEAH box helicase [Bacillaceae] diamond 246 144 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae    
30540978 30540978 PRJNA1061474_P_NODE_52253_length_245_cov_1.343023_g52007_i0 PRJNA1061474 52253 245 1.343023 3.29040635 uncultured Blautia sp. 765821 Bacteria Bacteria 42.7 0.0377   NR WP_317366054.1 765821 g52007 i0 32.2 0.722448979591837 59 40 72.2 0 223 47 59 117 WP_317366054.1 polysaccharide biosynthesis protein [uncultured Blautia sp.] diamond 177 42.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia uncultured Blautia sp.
31172601 31172601 PRJNA1061474_P_NODE_50275_length_247_cov_0.885057_g50029_i0 PRJNA1061474 50275 247 0.885057 2.18609079 Bacillus pinisoli 2901866 Bacteria Bacteria 93.2 2.61e-20   NR WP_246944254.1 2901866 g50029 i0 50.6 1.0080971659919 83 39 98.4 1 4 246 265 347 WP_246944254.1 hypothetical protein [Bacillus pinisoli] diamond 249 93.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus pinisoli
31195894 31195894 PRJNA1061474_P_NODE_54515_length_244_cov_0.900585_g54269_i0 PRJNA1061474 54515 244 0.900585 2.1974274 Bacillati 1783272 Bacteria Bacteria 63.9 8.17e-11   NR WP_186893483.1 52692 g54269 i0 67.5 4.97950819672131 40 13 49.2 0 125 244 2 41 WP_186893483.1 HsmA family protein [Acetobacterium malicum] diamond 1215 64.3 0.993779160186625 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Acetobacterium Acetobacterium malicum
31394457 31394457 PRJNA1061474_P_NODE_54316_length_244_cov_0.900585_g54070_i0 PRJNA1061474 54316 244 0.900585 2.1974274 Clostridia bacterium 2044939 Bacteria Bacteria 122 2.77e-33   NR HYG34118.1 2044939 g54070 i0 72.5 0.983606557377049 80 22 98.4 0 242 3 48 127 HYG34118.1 hypothetical protein [Clostridia bacterium] diamond 240 122 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31773751 31773751 PRJNA1061474_P_NODE_49597_length_248_cov_0.880000_g49351_i0 PRJNA1061474 49597 248 0.88 2.1824 Bacillus sp. (in: firmicutes) 1409 Bacteria Bacteria 101 4.39e-23   NR HVH96762.1 1409 g49351 i0 54.3 0.979838709677419 81 37 98 0 4 246 223 303 HVH96762.1 reverse transcriptase domain-containing protein [Bacillus sp. (in: firmicutes)] diamond 243 101 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. (in: firmicutes)
32216874 32216874 PRJNA1061474_P_NODE_57318_length_241_cov_0.916667_g57072_i0 PRJNA1061474 57318 241 0.916667 2.20916747 Limnochorda pilosa 1555112 Bacteria Bacteria 62.8 3.14e-9   NR WP_068137019.1 1555112 g57072 i0 40.2 1.0207468879668 82 47 99.6 2 240 1 105 186 WP_068137019.1 hypothetical protein [Limnochorda pilosa] diamond 246 62.8 1 Bacteria   Bacillati Bacillota Limnochordia Limnochordales Limnochordaceae Limnochorda Limnochorda pilosa
32375092 32375092 PRJNA1061474_P_NODE_47299_length_250_cov_0.870056_g47053_i0 PRJNA1061474 47299 250 0.870056 2.17514 Pseudobutyrivibrio sp. 2014367 Bacteria Bacteria 80.9 1.91e-16   NR MCR4695170.1 2014367 g47053 i0 73.5 2.868 49 13 58.8 0 235 89 173 221 MCR4695170.1 uracil-DNA glycosylase [Pseudobutyrivibrio sp.] diamond 717 80.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Pseudobutyrivibrio Pseudobutyrivibrio sp.
32375097 32375097 PRJNA1061474_P_NODE_51299_length_246_cov_0.890173_g51053_i0 PRJNA1061474 51299 246 0.890173 2.18982558 Bacillota bacterium 1879010 Bacteria Bacteria 56.6 3.56e-7   NR MCY0885261.1 1879010 g51053 i0 59.3 0.719512195121951 59 24 72 0 63 239 187 245 MCY0885261.1 acyltransferase [Bacillota bacterium] diamond 177 56.6 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32879662 32879662 PRJNA1061474_P_NODE_52620_length_245_cov_0.895349_g52374_i0 PRJNA1061474 52620 245 0.895349 2.19360505 Acetivibrio clariflavus 288965 Bacteria Bacteria 58.2 8.59e-8   NR WP_257194544.1 288965 g52374 i0 63.6 1.07755102040816 44 16 53.9 0 243 112 199 242 WP_257194544.1 trypsin-like peptidase domain-containing protein [Acetivibrio clariflavus] diamond 264 58.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Acetivibrio Acetivibrio clariflavus

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