RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1061474" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1061474 · 18 ✖

analysis 1

  • diamond · 18 ✖

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