RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJEB7799 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
25616594 25616594 PRJEB7799a_S_NODE_9_length_1580_cov_7.036246_g5_i0 PRJEB7799 9 1580 7.036246 111.1726868 Staphylococcus aureus 1280 Bacteria Bacteria 505 8.019999999999999e-173   NR WP_304716840.1 1280 g5 i0 99.6 0.50126582278481 264 1 50.1 0 1580 789 193 456 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 792 505 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
25664144 25664144 PRJEB7799l_S_NODE_8186_length_181_cov_6.767123_g8157_i0 PRJEB7799 8186 181 6.767123 12.24849263 Bacillus sp. SIMBA_069 3085809 Bacteria Bacteria 99 2.16e-25   NR MFP3380993.1 3085809 g8157 i0 100 1.8232044198895 55 0 91.2 0 181 17 23 77 MFP3380993.1 hypothetical protein [Bacillus sp. SIMBA_069] diamond 330 99 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. SIMBA_069
32912670 32912670 PRJEB7799a_S_NODE_17713_length_156_cov_1.322314_g17678_i0 PRJEB7799 17713 156 1.322314 2.06280984 Clostridia bacterium 2044939 Bacteria Bacteria 57.8 5.53e-8   NR NCC83888.1 2044939 g17678 i0 55.3 0.903846153846154 47 21 90.4 0 5 145 550 596 NCC83888.1 glycosyltransferase [Clostridia bacterium] diamond 141 57.8 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32923248 32923248 PRJEB7799p_S_NODE_24985_length_153_cov_2.711864_g24962_i0 PRJEB7799 24985 153 2.711864 4.14915192 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 106 1.9e-26   NR WP_260633974.1 1280 g24962 i0 100 3.76470588235294 48 0 94.1 0 151 8 186 233 WP_260633974.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 576 106 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32940379 32940379 PRJEB7799e_S_NODE_153_length_633_cov_35.444816_g102_i0 PRJEB7799 153 633 35.444816 224.36568528 Paenibacillus 44249 Bacteria Bacteria 127 8.709999999999998e-32   NR WP_076201058.1 44249 g102 i0 44 3.7914691943128 159 76 73.9 5 607 140 148 296 WP_076201058.1 MULTISPECIES: hypothetical protein [Paenibacillus] diamond 2400 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus  
32940484 32940484 PRJEB7799p_S_NODE_24249_length_155_cov_1.833333_g24226_i0 PRJEB7799 24249 155 1.833333 2.84166615 Bacillati 1783272 Bacteria Bacteria 83.6 4.07e-17   NR WP_304716840.1 1280 g24226 i0 100 1.6258064516129 42 0 81.3 0 155 30 135 176 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 252 83.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32947132 32947132 PRJEB7799c_S_NODE_23226_length_159_cov_1.056452_g23203_i0 PRJEB7799 23226 159 1.056452 1.67975868 Paenibacillus glucanolyticus 59843 Bacteria Bacteria 60.1 7.26e-9   NR WP_376165857.1 59843 g23203 i0 59.6 1.77358490566038 47 18 86.8 1 151 14 200 246 WP_376165857.1 ATP-binding protein [Paenibacillus glucanolyticus] diamond 282 60.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus glucanolyticus
32948022 32948022 PRJEB7799p_S_NODE_14970_length_177_cov_4.661972_g14947_i0 PRJEB7799 14970 177 4.661972 8.25169044 Staphylococcus aureus 1280 Bacteria Bacteria 66.2 4.6e-12   NR WP_260633976.1 1280 g14947 i0 96.8 0.525423728813559 31 1 52.5 0 156 64 1 31 WP_260633976.1 hypothetical protein, partial [Staphylococcus aureus] diamond 93 66.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32957580 32957580 PRJEB7799d_S_NODE_10194_length_152_cov_3.735043_g10184_i0 PRJEB7799 10194 152 3.735043 5.67726536 Bacteria 2 Bacteria Bacteria 48.5 1.23e-5   NR WP_275655581.1 1313 g10184 i0 100 7.57894736842105 24 0 47.4 0 150 79 65 88 WP_275655581.1 sugar transferase, partial [Streptococcus pneumoniae] diamond 1152 48.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32981362 32981362 PRJEB7799a_S_NODE_8299_length_194_cov_6.572327_g8264_i0 PRJEB7799 8299 194 6.572327 12.75031438 Syntrophomonadaceae bacterium 2093811 Bacteria Bacteria 42.4 0.0266   NR NLB53650.1 2093811 g8264 i0 32.1 0.865979381443299 56 38 86.6 0 4 171 299 354 NLB53650.1 homoserine dehydrogenase [Syntrophomonadaceae bacterium] diamond 168 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae   Syntrophomonadaceae bacterium
33008654 33008654 PRJEB7799i_S_NODE_10731_length_154_cov_2.478992_g10701_i0 PRJEB7799 10731 154 2.478992 3.81764768 Faecousia 2840588 Bacteria Bacteria 43.5 0.00577   NR MBQ7437754.1 2485925 g10701 i0 55.6 2.76623376623377 36 16 70.1 0 152 45 367 402 MBQ7437754.1 EAL domain-containing protein [Oscillospiraceae bacterium] diamond 426 43.9 0.990888382687927 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
33016148 33016148 PRJEB7799n_S_NODE_6076_length_194_cov_2.635220_g6039_i0 PRJEB7799 6076 194 2.63522 5.1123268 Clostridia bacterium 2044939 Bacteria Bacteria 65.5 1.74e-10   NR MEI6603586.1 2044939 g6039 i0 54.2 1.82474226804124 59 26 89.7 1 16 189 282 340 MEI6603586.1 AAA family ATPase [Clostridia bacterium] diamond 354 65.5 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
33016277 33016277 PRJEB7799p_S_NODE_16612_length_173_cov_5.130435_g16589_i0 PRJEB7799 16612 173 5.130435 8.87565255 Staphylococcus aureus 1280 Bacteria Bacteria 109 1.68e-26   NR WP_304716840.1 1280 g16589 i0 100 0.988439306358382 57 0 98.8 0 173 3 6 62 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 171 109 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
33025824 33025824 PRJEB7799a_S_NODE_156_length_637_cov_8.985050_g133_i0 PRJEB7799 156 637 8.98505 57.2347685 Bacteria 2 Bacteria Bacteria 281 1.62e-92   NR WP_260633974.1 1280 g133 i0 99.3 1.99215070643642 141 1 66.4 0 3 425 130 270 WP_260633974.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 1269 281 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
33050287 33050287 PRJEB7799o_S_NODE_1829_length_194_cov_3.157233_g1821_i0 PRJEB7799 1829 194 3.157233 6.12503202 Staphylococcus aureus 1280 Bacteria Bacteria 41.2 0.0283   NR WP_178137632.1 1280 g1821 i0 63.6 0.680412371134021 44 13 66.5 2 32 160 9 50 WP_178137632.1 hypothetical protein, partial [Staphylococcus aureus] diamond 132 41.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
33059757 33059757 PRJEB7799a_S_NODE_10717_length_180_cov_8.951724_g10682_i0 PRJEB7799 10717 180 8.951724 16.1131032 Bacteria 2 Bacteria Bacteria 117 5.489999999999999e-32   NR WP_311050769.1 1351 g10682 i0 100 1.86666666666667 56 0 93.3 0 2 169 36 91 WP_311050769.1 TonB-dependent receptor domain-containing protein, partial [Enterococcus faecalis] diamond 336 117 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
33076785 33076785 PRJEB7799a_S_NODE_10341_length_182_cov_3.204082_g10306_i0 PRJEB7799 10341 182 3.204082 5.83142924 Bacteria 2 Bacteria Bacteria 103 8.73e-27   NR WP_214977742.1 74706 g10306 i0 100 2.32417582417582 47 0 77.5 0 180 40 18 64 WP_214977742.1 hypothetical protein, partial [Staphylococcus coagulans] diamond 423 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus coagulans
33083627 33083627 PRJEB7799c_S_NODE_38126_length_151_cov_1.275862_g38103_i0 PRJEB7799 38126 151 1.275862 1.92655162 Dendrosporobacter quercicolus 146817 Bacteria Bacteria 42 0.0205   NR WP_092068988.1 146817 g38103 i0 42 4.90728476821192 50 29 99.3 0 2 151 5746 5795 WP_092068988.1 PfaD family polyunsaturated fatty acid/polyketide biosynthesis protein [Dendrosporobacter quercicolus] diamond 741 42 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Dendrosporobacter Dendrosporobacter quercicolus
33101516 33101516 PRJEB7799p_S_NODE_16694_length_173_cov_2.065217_g16671_i0 PRJEB7799 16694 173 2.065217 3.57282541 Staphylococcus aureus 1280 Bacteria Bacteria 95.1 3.72e-21   NR WP_304716840.1 1280 g16671 i0 100 0.901734104046243 52 0 90.2 0 172 17 61 112 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 156 95.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
33117776 33117776 PRJEB7799d_S_NODE_5911_length_169_cov_1.641791_g5901_i0 PRJEB7799 5911 169 1.641791 2.77462679 Thomasclavelia ramosa 1547 Bacteria Bacteria 95.1 4.079999999999999e-24   NR MCB5532046.1 1547 g5901 i0 93.9 0.869822485207101 49 3 87 0 3 149 9 57 MCB5532046.1 hypothetical protein [Thomasclavelia ramosa] diamond 147 95.1 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Thomasclavelia Thomasclavelia ramosa
33135660 33135660 PRJEB7799p_S_NODE_13367_length_181_cov_1.438356_g13344_i0 PRJEB7799 13367 181 1.438356 2.60342436 Staphylococcus aureus 1280 Bacteria Bacteria 100 6.429999999999999e-23   NR WP_304716840.1 1280 g13344 i0 100 0.812154696132597 49 0 81.2 0 2 148 336 384 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 147 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
33145260 33145260 PRJEB7799n_S_NODE_2959_length_256_cov_11.760181_g2922_i0 PRJEB7799 2959 256 11.760181 30.10606336 Bacteria 2 Bacteria Bacteria 79 3.09e-15   NR WP_268569832.1 1464 g2922 i0 51.4 2.6015625 74 30 86.7 1 1 222 168 235 WP_268569832.1 ATP-binding protein [Paenibacillus larvae] diamond 666 79.3 0.996216897856242 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus larvae
33152791 33152791 PRJEB7799p_S_NODE_24968_length_153_cov_2.796610_g24945_i0 PRJEB7799 24968 153 2.79661 4.2788133 Staphylococcus aureus 1280 Bacteria Bacteria 87 2.35e-18   NR WP_304716840.1 1280 g24945 i0 100 0.862745098039216 44 0 86.3 0 1 132 233 276 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 132 87 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
33162114 33162114 PRJEB7799a_S_NODE_7856_length_197_cov_3.524691_g7821_i0 PRJEB7799 7856 197 3.524691 6.94364127 Bacteria 2 Bacteria Bacteria 54.3 9.55e-8   NR WP_333727354.1 1639 g7821 i0 96.8 0.944162436548223 31 1 47.2 0 94 2 1 31 WP_333727354.1 hypothetical protein, partial [Listeria monocytogenes] diamond 186 54.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes

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