RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1101946" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1101946 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
2761992 2761992 PRJNA1101946_S_NODE_743_length_526_cov_8.236897_g652_i0 PRJNA1101946 743 526 8.236897 43.32607822 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 125 1.96e-33   NR POH17992.1 1625 g652 i0 68.7 0.564638783269962 99 30 55.9 1 525 232 4 102 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 297 125 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
27153354 27153354 PRJNA1101946_S_NODE_26662_length_155_cov_11.641509_g26563_i0 PRJNA1101946 26662 155 11.641509 18.04433895 root 1 Root_unresolved Root_unresolved 58.9 2.09e-8   NR ACV20892.1 1396 g26563 i0 75.5 3.79354838709677 49 12 94.8 0 154 8 146 194 ACV20892.1 enhanced green fluorescent protein [Bacillus cereus] diamond 588 58.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
27627828 27627828 PRJNA1101946_S_NODE_13224_length_220_cov_21.964912_g13125_i0 PRJNA1101946 13224 220 21.964912000000002 48.3228064 root 1 Root_unresolved Root_unresolved 118 6.69e-30   NR ACV20892.1 1396 g13125 i0 87.1 2.86363636363636 70 9 95.5 0 220 11 108 177 ACV20892.1 enhanced green fluorescent protein [Bacillus cereus] diamond 630 118 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
28101135 28101135 PRJNA1101946_S_NODE_14465_length_211_cov_29.555556_g14366_i0 PRJNA1101946 14465 211 29.555556 62.36222316 root 1 Root_unresolved Root_unresolved 110 6.95e-27   NR ACV20892.1 1396 g14366 i0 85.3 2.90047393364929 68 10 96.7 0 1 204 108 175 ACV20892.1 enhanced green fluorescent protein [Bacillus cereus] diamond 612 110 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
28732806 28732806 PRJNA1101946_S_NODE_13627_length_217_cov_41.970238_g13528_i0 PRJNA1101946 13627 217 41.970238 91.07541646 root 1 Root_unresolved Root_unresolved 92.4 3.37e-20   NR ACV20892.1 1396 g13528 i0 75.7 3.87096774193548 70 17 96.8 0 4 213 77 146 ACV20892.1 enhanced green fluorescent protein [Bacillus cereus] diamond 840 92.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
28795682 28795682 PRJNA1101946_S_NODE_15907_length_201_cov_88.868421_g15808_i0 PRJNA1101946 15907 201 88.868421 178.62552621 Vescimonas 2892396 Bacteria Bacteria 42.4 0.0297   NR MFR7534603.1 2485925 g15808 i0 38.3 1.7910447761194 60 35 86.6 1 7 180 11 70 MFR7534603.1 Mur ligase family protein [Oscillospiraceae bacterium] diamond 360 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28836071 28836071 PRJNA1101946_S_NODE_1748_length_411_cov_11.558011_g1649_i0 PRJNA1101946 1748 411 11.558011 47.50342521 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 114 1.27e-29   NR POH17992.1 1625 g1649 i0 75.6 0.569343065693431 78 19 56.9 0 276 43 48 125 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 234 114 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
29057273 29057273 PRJNA1101946_S_NODE_22528_length_169_cov_9.733333_g22429_i0 PRJNA1101946 22528 169 9.733333 16.44933277 Ruminococcus flavefaciens 1265 Bacteria Bacteria 41.6 0.0352   NR WP_303820261.1 1265 g22429 i0 37.7 0.940828402366864 53 26 81.7 1 162 25 153 205 WP_303820261.1 CPBP family intramembrane glutamic endopeptidase [Ruminococcus flavefaciens] diamond 159 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus flavefaciens
29080138 29080138 PRJNA1101946_S_NODE_17808_length_191_cov_2.154930_g17709_i0 PRJNA1101946 17808 191 2.15493 4.1159163 Bacteria 2 Bacteria Bacteria 71.6 2.17e-13   NR MBQ2827153.1 2044939 g17709 i0 100 1.03664921465969 33 0 51.8 0 99 1 169 201 MBQ2827153.1 SIS domain-containing protein [Clostridia bacterium] diamond 198 71.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29215253 29215253 PRJNA1101946_S_NODE_5709_length_299_cov_10.504000_g5610_i0 PRJNA1101946 5709 299 10.504 31.40696 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 80.1 9.24e-17   NR POH17992.1 1625 g5610 i0 66.7 0.632107023411371 63 21 63.2 0 297 109 69 131 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 189 80.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
30352562 30352562 PRJNA1101946_S_NODE_10592_length_242_cov_2.378238_g10493_i0 PRJNA1101946 10592 242 2.378238 5.75533596 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 92.4 3.52e-22   NR MCI1956429.1 2485925 g10493 i0 94.2 0.644628099173554 52 3 64.5 0 1 156 14 65 MCI1956429.1 phage holin family protein [Oscillospiraceae bacterium] diamond 156 92.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
30415547 30415547 PRJNA1101946_S_NODE_17553_length_192_cov_4.636364_g17454_i0 PRJNA1101946 17553 192 4.636364 8.90181888 Ructibacterium gallinarum 2779355 Bacteria Bacteria 42 0.0367   NR WP_226393139.1 2779355 g17454 i0 41 0.609375 39 23 60.9 0 40 156 291 329 WP_226393139.1 recombinase family protein [Ructibacterium gallinarum] diamond 117 42 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ructibacterium Ructibacterium gallinarum
30415548 30415548 PRJNA1101946_S_NODE_23633_length_165_cov_27.931034_g23534_i0 PRJNA1101946 23633 165 27.931034 46.0862061 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 39.7 0.0439   NR MBS1310036.1 2485925 g23534 i0 34 0.963636363636364 53 35 96.4 0 2 160 16 68 MBS1310036.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Oscillospiraceae bacterium] diamond 159 39.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
30762846 30762846 PRJNA1101946_S_NODE_13974_length_215_cov_2.849398_g13875_i0 PRJNA1101946 13974 215 2.849398 6.1262057 Candidatus Choladocola sp. 3048844 Bacteria Bacteria 42.4 0.036   NR MDY3248899.1 3048844 g13875 i0 39 0.572093023255814 41 25 57.2 0 144 22 199 239 MDY3248899.1 YfhO family protein [Candidatus Choladocola sp.] diamond 123 42.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Choladocola Candidatus Choladocola sp.
30817266 30817266 PRJNA1101946_S_NODE_10514_length_242_cov_21.461140_g10415_i0 PRJNA1101946 10514 242 21.46114 51.9359588 root 1 Root_unresolved Root_unresolved 110 5.36e-27   NR ACV20892.1 1396 g10415 i0 81.7 352.512396694215 71 13 88 0 28 240 80 150 ACV20892.1 enhanced green fluorescent protein [Bacillus cereus] diamond 85308 110 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
30920935 30920935 PRJNA1101946_S_NODE_3134_length_352_cov_1.580858_g3035_i0 PRJNA1101946 3134 352 1.580858 5.56462016 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 90.5 1.67e-19   NR MBQ6635704.1 1898203 g3035 i0 82.5 0.971590909090909 57 10 48.6 0 158 328 1 57 MBQ6635704.1 hypothetical protein [Lachnospiraceae bacterium] diamond 342 90.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
31047407 31047407 PRJNA1101946_S_NODE_9935_length_248_cov_5.015075_g9836_i0 PRJNA1101946 9935 248 5.015075 12.437386 Butyrivibrio sp. XBB1 28121 Bacteria Bacteria 44.7 0.00813   NR WP_081671254.1 1280682 g9836 i0 53.1 0.387096774193548 32 15 38.7 0 149 244 333 364 WP_081671254.1 MBOAT family O-acyltransferase [Butyrivibrio sp. XBB1001] diamond 96 44.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Butyrivibrio Butyrivibrio sp. XBB1001
31331545 31331545 PRJNA1101946_S_NODE_10876_length_239_cov_2.315789_g10777_i0 PRJNA1101946 10876 239 2.315789 5.53473571 Clostridia bacterium 2044939 Bacteria Bacteria 142 6.17e-39   NR MBP3703983.1 2044939 g10777 i0 87.3 0.99163179916318 79 10 99.2 0 1 237 298 376 MBP3703983.1 hypothetical protein [Clostridia bacterium] diamond 237 142 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32027570 32027570 PRJNA1101946_S_NODE_20758_length_176_cov_69.236220_g20659_i0 PRJNA1101946 20758 176 69.23622 121.8557472 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 40.4 0.0383   NR MEE1401839.1 2485925 g20659 i0 34.5 1.875 55 36 93.8 0 175 11 16 70 MEE1401839.1 Mur ligase domain-containing protein [Oscillospiraceae bacterium] diamond 330 40.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32280869 32280869 PRJNA1101946_S_NODE_22119_length_171_cov_3.426230_g22020_i0 PRJNA1101946 22119 171 3.42623 5.8588533 Bacillota bacterium 1879010 Bacteria Bacteria 82.4 1.81e-17   NR MBR1445379.1 1879010 g22020 i0 74.5 0.964912280701754 55 14 96.5 0 6 170 32 86 MBR1445379.1 DUF3800 domain-containing protein [Bacillota bacterium] diamond 165 82.4 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32659621 32659621 PRJNA1101946_S_NODE_18440_length_187_cov_98.166667_g18341_i0 PRJNA1101946 18440 187 98.166667 183.57166729 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 41.2 0.0225   NR MEE1401839.1 2485925 g18341 i0 34.5 1.76470588235294 55 36 88.2 0 2 166 16 70 MEE1401839.1 Mur ligase domain-containing protein [Oscillospiraceae bacterium] diamond 330 41.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae 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);;