RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA393181 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
6788099 6788099 PRJNA393181_S_NODE_24486_length_233_cov_1.969388_g24380_i0 PRJNA393181 24486 233 1.969388 4.58867404 Virgibacillus litoralis 578221 Bacteria Bacteria 59.7 2.79e-8   NR WP_209482258.1 578221 g24380 i0 40.3 0.991416309012876 77 41 99.1 2 1 231 36 107 WP_209482258.1 arginase [Virgibacillus litoralis] diamond 231 59.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Virgibacillus Virgibacillus litoralis
13164465 13164465 PRJNA393181_S_NODE_36991_length_178_cov_2.319149_g36885_i0 PRJNA393181 36991 178 2.319149 4.12808522 Staphylococcus aureus 1280 Bacteria Bacteria 109 1.93e-29   NR WP_160401609.1 1280 g36885 i0 89.8 0.99438202247191 59 6 99.4 0 178 2 23 81 WP_160401609.1 ABC transporter substrate-binding protein, partial [Staphylococcus aureus] diamond 177 109 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
26902454 26902454 PRJNA393181_S_NODE_44981_length_156_cov_2.294118_g44875_i0 PRJNA393181 44981 156 2.294118 3.57882408 Paenibacillus 44249 Bacteria Bacteria 58.9 1.42e-8   NR WP_175491797.1 1333845 g44875 i0 61.5 2 52 20 100 0 1 156 25 76 WP_175491797.1 ABC transporter permease [Paenibacillus sophorae] diamond 312 58.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sophorae
27517715 27517715 PRJNA393181_S_NODE_43403_length_160_cov_1.780488_g43297_i0 PRJNA393181 43403 160 1.780488 2.8487808 Firmicutes bacterium 13_1_4 1879010 Bacteria Bacteria 92 1.56e-20   NR OLD06924.1 1805156 g43297 i0 80.8 0.975 52 10 97.5 0 159 4 213 264 OLD06924.1 MAG: hypothetical protein AUJ09_01770 [Firmicutes bacterium 13_1_40CM_3_65_11] diamond 156 92 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium 13_1_40CM_3_65_11
27770492 27770492 PRJNA393181_S_NODE_30564_length_202_cov_2.490909_g30458_i0 PRJNA393181 30564 202 2.490909 5.03163618 Lactobacillus crispatus 47770 Bacteria Bacteria 50.4 2.52e-5   NR WP_133534204.1 47770 g30458 i0 38.4 1.08415841584158 73 37 99.5 2 1 201 66 136 WP_133534204.1 hypothetical protein, partial [Lactobacillus crispatus] diamond 219 50.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
28528222 28528222 PRJNA393181_S_NODE_17367_length_286_cov_1.594378_g17261_i0 PRJNA393181 17367 286 1.594378 4.55992108 Firmicutes bacterium 13_1_4 1879010 Bacteria Bacteria 78.2 1.2e-14   NR OLD06924.1 1805156 g17261 i0 57.1 0.734265734265734 70 30 73.4 0 4 213 262 331 OLD06924.1 MAG: hypothetical protein AUJ09_01770 [Firmicutes bacterium 13_1_40CM_3_65_11] diamond 210 78.2 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium 13_1_40CM_3_65_11
28622906 28622906 PRJNA393181_S_NODE_18227_length_278_cov_2.547718_g18121_i0 PRJNA393181 18227 278 2.547718 7.08265604 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 82.4 5.66e-16   NR MBQ9413227.1 2485925 g18121 i0 63.5 3.09712230215827 74 26 79.9 1 56 277 1 73 MBQ9413227.1 MBOAT family protein [Oscillospiraceae bacterium] diamond 861 82.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28780466 28780466 PRJNA393181_S_NODE_20147_length_262_cov_2.475556_g20041_i0 PRJNA393181 20147 262 2.475556 6.48595672 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 56.2 7.85e-7   NR MBQ6319266.1 1898203 g20041 i0 39.5 1.84351145038168 81 47 90.5 1 21 257 341 421 MBQ6319266.1 serine/threonine protein kinase [Lachnospiraceae bacterium] diamond 483 56.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29033464 29033464 PRJNA393181_S_NODE_30328_length_203_cov_2.397590_g30222_i0 PRJNA393181 30328 203 2.39759 4.8671077 Veillonellaceae bacterium 2049049 Bacteria Bacteria 97.8 9.63e-23   NR NMC31201.1 2049049 g30222 i0 68.2 1.96551724137931 66 21 97.5 0 4 201 87 152 NMC31201.1 proline iminopeptidase-family hydrolase [Veillonellaceae bacterium] diamond 399 97.8 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae   Veillonellaceae bacterium
29208087 29208087 PRJNA393181_S_NODE_38629_length_173_cov_2.000000_g38523_i0 PRJNA393181 38629 173 2 3.46 Bacteria 2 Bacteria Bacteria 115 2.8399999999999997e-31   NR WP_213397906.1 1423 g38523 i0 96.5 2.96531791907514 57 2 98.8 0 1 171 62 118 WP_213397906.1 cytochrome P450, partial [Bacillus subtilis] diamond 513 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
29664321 29664321 PRJNA393181_S_NODE_25510_length_227_cov_1.621053_g25404_i0 PRJNA393181 25510 227 1.621053 3.67979031 Bacillus sp. SIMBA_161 3080866 Bacteria Bacteria 54.7 7.76e-8   NR MFP3422661.1 3080866 g25404 i0 49 2.51101321585903 51 26 67.4 0 166 14 2 52 MFP3422661.1 hypothetical protein [Bacillus sp. SIMBA_161] diamond 570 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. SIMBA_161
30218394 30218394 PRJNA393181_S_NODE_15952_length_300_cov_2.178707_g15846_i0 PRJNA393181 15952 300 2.178707 6.536121 Bacteria 2 Bacteria Bacteria 53.9 8.57e-6   NR WP_066330782.1 152268 g15846 i0 72.5 1.83 40 11 40 0 181 300 18 57 WP_066330782.1 MDR family MFS transporter [Metabacillus litoralis] diamond 549 53.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus litoralis
30486090 30486090 PRJNA393181_S_NODE_22233_length_247_cov_2.776190_g22127_i0 PRJNA393181 22233 247 2.77619 6.8571893 Bacillota bacterium 1879010 Bacteria Bacteria 57 9.59e-9   NR MDI9504832.1 1879010 g22127 i0 65 0.48582995951417 40 14 48.6 0 3 122 12 51 MDI9504832.1 sel1 repeat family protein [Bacillota bacterium] diamond 120 57 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31339186 31339186 PRJNA393181_S_NODE_32196_length_195_cov_3.183544_g32090_i0 PRJNA393181 32196 195 3.183544 6.2079108 Paenibacillus sp. SYP-B4298 2996034 Bacteria Bacteria 92.8 3.8e-20   NR WP_270166955.1 2996034 g32090 i0 65.6 2.95384615384615 64 22 98.5 0 3 194 365 428 WP_270166955.1 hypothetical protein [Paenibacillus sp. SYP-B4298] diamond 576 92.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. SYP-B4298
31893769 31893769 PRJNA393181_S_NODE_33597_length_190_cov_1.921569_g33491_i0 PRJNA393181 33597 190 1.921569 3.6509811 root 1 Root_unresolved Root_unresolved 44.3 0.0038   NR MBS5016378.1 41978 g33491 i0 44.1 3.77368421052632 59 32 91.6 1 184 11 81 139 MBS5016378.1 sel1 repeat family protein [Ruminococcus sp.] diamond 717 44.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
31940079 31940079 PRJNA393181_S_NODE_23077_length_241_cov_3.465686_g22971_i0 PRJNA393181 23077 241 3.465686 8.35230326 Paenibacillus rhizophilus 1850366 Bacteria Bacteria 48.1 4.19e-4   NR WP_124697366.1 1850366 g22971 i0 49.1 0.70954356846473 57 29 71 0 71 241 22 78 WP_124697366.1 ABC transporter permease [Paenibacillus rhizophilus] diamond 171 48.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus rhizophilus
31971822 31971822 PRJNA393181_S_NODE_13478_length_328_cov_3.216495_g13372_i0 PRJNA393181 13478 328 3.216495 10.5501036 Firmicutes bacterium 13_1_4 1879010 Bacteria Bacteria 169 2.57e-49   NR OLD06924.1 1805156 g13372 i0 71.3 0.98780487804878 108 31 98.8 0 326 3 99 206 OLD06924.1 MAG: hypothetical protein AUJ09_01770 [Firmicutes bacterium 13_1_40CM_3_65_11] diamond 324 169 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium 13_1_40CM_3_65_11

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