RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA937226" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA937226 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
27088311 27088311 PRJNA937226_S_NODE_11742_length_229_cov_2.600000_g11615_i0 PRJNA937226 11742 229 2.6 5.954 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 70.5 5.35e-13   NR MBE6136892.1 2049044 g11615 i0 62 0.655021834061135 50 19 65.5 0 3 152 21 70 MBE6136892.1 hypothetical protein [Erysipelotrichaceae bacterium] diamond 150 70.5 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
27214451 27214451 PRJNA937226_S_NODE_15842_length_204_cov_2.012903_g15715_i0 PRJNA937226 15842 204 2.012903 4.10632212 Clostridia bacterium 2044939 Bacteria Bacteria 120 7.06e-30   NR MBQ7860716.1 2044939 g15715 i0 88.2 1 68 8 100 0 1 204 657 724 MBQ7860716.1 hypothetical protein [Clostridia bacterium] diamond 204 120 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27537632 27537632 PRJNA937226_S_NODE_7963_length_263_cov_1.528037_g7836_i0 PRJNA937226 7963 263 1.528037 4.01873731 Lachnospiraceae 186803 Bacteria Bacteria 167 2.01e-48   NR WP_087174882.1 1965547 g7836 i0 96.6 2.97718631178707 87 3 99.2 0 261 1 231 317 WP_087174882.1 redox-regulated ATPase YchF [Lachnoclostridium sp. An118] diamond 783 167 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnoclostridium Lachnoclostridium sp. An118
27909140 27909140 PRJNA937226_S_NODE_11305_length_232_cov_6.612022_g11178_i0 PRJNA937226 11305 232 6.612022 15.33989104 Clostridiales bacterium 1898207 Bacteria Bacteria 111 4.09e-27   NR MBR2597059.1 1898207 g11178 i0 96.5 1.47413793103448 57 2 73.7 0 231 61 316 372 MBR2597059.1 phage major capsid protein [Clostridiales bacterium] diamond 342 111 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28319864 28319864 PRJNA937226_S_NODE_25166_length_169_cov_1.300000_g25039_i0 PRJNA937226 25166 169 1.3 2.197 Eubacteriales bacterium 2831996 Bacteria Bacteria 41.6 0.033   NR MBS7304082.1 2831996 g25039 i0 37.5 0.85207100591716 48 30 85.2 0 2 145 4 51 MBS7304082.1 response regulator transcription factor [Eubacteriales bacterium] diamond 144 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
28642826 28642826 PRJNA937226_S_NODE_6467_length_282_cov_3.832618_g6340_i0 PRJNA937226 6467 282 3.832618 10.80798276 Lactobacillaceae 33958 Bacteria Bacteria 61.2 1.88e-8   NR WP_014565393.1 1584 g6340 i0 42.7 5.6063829787234 75 39 78.7 2 231 10 406 477 WP_014565393.1 Z1 domain-containing protein [Lactobacillus delbrueckii] diamond 1581 61.6 0.993506493506494 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus delbrueckii
28951596 28951596 PRJNA937226_S_NODE_27868_length_163_cov_1.824561_g27741_i0 PRJNA937226 27868 163 1.824561 2.97403443 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 41.2 0.00749   NR MBR2716263.1 2485925 g27741 i0 42.1 0.699386503067485 38 22 69.9 0 24 137 16 53 MBR2716263.1 hypothetical protein [Oscillospiraceae bacterium] diamond 114 41.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29242600 29242600 PRJNA937226_S_NODE_8309_length_259_cov_2.476190_g8182_i0 PRJNA937226 8309 259 2.47619 6.4133321 Bacillaceae 186817 Bacteria Bacteria 155 1.69e-44   NR WP_078429665.1 427920 g8182 i0 91.8 2.93050193050193 85 7 98.5 0 3 257 104 188 WP_078429665.1 phosphate acetyltransferase [Alkalihalobacterium alkalinitrilicum] diamond 759 156 0.993589743589744 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalihalobacterium Alkalihalobacterium alkalinitrilicum
30151111 30151111 PRJNA937226_S_NODE_17312_length_197_cov_1.689189_g17185_i0 PRJNA937226 17312 197 1.689189 3.32770233 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 133 2.05e-38   NR MBQ7001489.1 2485925 g17185 i0 96.9 0.974619289340102 64 2 97.5 0 197 6 46 109 MBQ7001489.1 Holliday junction resolvase RuvX [Oscillospiraceae bacterium] diamond 192 133 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
31130538 31130538 PRJNA937226_S_NODE_21875_length_179_cov_1.200000_g21748_i0 PRJNA937226 21875 179 1.2 2.148 Bacillales bacterium 1904864 Bacteria Bacteria 83.6 6.36e-17   NR MDD7735446.1 1904864 g21748 i0 69.5 0.988826815642458 59 17 98.9 1 177 1 83 140 MDD7735446.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Bacillales bacterium] diamond 177 83.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales     Bacillales bacterium
32016391 32016391 PRJNA937226_S_NODE_11358_length_232_cov_2.333333_g11231_i0 PRJNA937226 11358 232 2.333333 5.41333256 Halalkalibacter krulwichiae 199441 Bacteria Bacteria 122 1.05e-31   NR WP_066151133.1 199441 g11231 i0 77.9 0.995689655172414 77 17 99.6 0 231 1 142 218 WP_066151133.1 LacI family DNA-binding transcriptional regulator [Halalkalibacter krulwichiae] diamond 231 122 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Halalkalibacter Halalkalibacter krulwichiae
32174843 32174843 PRJNA937226_S_NODE_9078_length_251_cov_3.415842_g8951_i0 PRJNA937226 9078 251 3.415842 8.57376342 Streptococcus suis 1307 Bacteria Bacteria 42 0.0108   NR WP_319443985.1 1307 g8951 i0 67.9 0.334661354581673 28 9 33.5 0 251 168 24 51 WP_319443985.1 hypothetical protein, partial [Streptococcus suis] diamond 84 42 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
32333210 32333210 PRJNA937226_S_NODE_2079_length_423_cov_4.192513_g1952_i0 PRJNA937226 2079 423 4.192513 17.73432999 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 125 5.700000000000001e-34   NR POH17992.1 1625 g1952 i0 71.6 0.773049645390071 109 31 77.3 0 392 66 1 109 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 327 125 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis

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