RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 23 ✖

bioproject 1

  • PRJNA1192965 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
1042364 1042364 PRJNA1192965_P_NODE_1_length_3180_cov_34.790795_g0_i0 PRJNA1192965 1 3180 34.790795 1106.347281 Ruminococcus sp. XPD3 41978 Bacteria Bacteria 1895 0   NR WP_075424065.1 1452269 g0 i0 100 0.911320754716981 966 0 91.1 0 2997 100 2 967 WP_075424065.1 type VI-D CRISPR-associated RNA-guided ribonuclease Cas13d [Ruminococcus sp. XPD3002] diamond 2898 1895 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp. XPD3002
2871277 2871277 PRJNA1192965_P_NODE_1523_length_332_cov_1.420849_g1504_i0 PRJNA1192965 1523 332 1.420849 4.71721868 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 204 3.97e-65   NR MBX9724270.1 2364082 g1504 i0 90.9 0.993975903614458 110 10 99.4 0 331 2 57 166 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 330 204 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
13074111 13074111 PRJNA1192965_P_NODE_4191_length_246_cov_0.890173_g4172_i0 PRJNA1192965 4191 246 0.890173 2.18982558 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 111 1.3500000000000002e-26   NR MEA2126612.1 2586742 g4172 i0 76.3 1.96341463414634 80 19 97.6 0 242 3 29 108 MEA2126612.1 phospholipid/cholesterol/gamma-HCH transport system substrate-binding protein [Solirubrobacteraceae bacterium] diamond 483 111 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
16897632 16897632 PRJNA1192965_P_NODE_3774_length_249_cov_0.875000_g3755_i0 PRJNA1192965 3774 249 0.875 2.17875 Humibacter sp. 1940291 Bacteria Bacteria 79 7.14e-15   NR HWU47516.1 1940291 g3755 i0 87.8 0.493975903614458 41 5 49.4 0 126 248 685 725 HWU47516.1 ATP-dependent DNA helicase [Humibacter sp.] diamond 123 79 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Humibacter Humibacter sp.
26629176 26629176 PRJNA1192965_P_NODE_2941_length_261_cov_1.638298_g2922_i0 PRJNA1192965 2941 261 1.638298 4.27595778 Streptomyces akebiae 2865673 Bacteria Bacteria 41.6 0.0458   NR WP_220644572.1 2865673 g2922 i0 35.8 0.609195402298851 53 30 56.3 1 38 184 55 107 WP_220644572.1 hypothetical protein [Streptomyces akebiae] diamond 159 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces akebiae
26945699 26945699 PRJNA1192965_P_NODE_4742_length_243_cov_0.905882_g4723_i0 PRJNA1192965 4742 243 0.905882 2.20129326 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 99.4 1.71e-25   NR MBA4076561.1 2067979 g4723 i0 75.4 0.703703703703704 57 14 70.4 0 6 176 5 61 MBA4076561.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 171 99.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
27072330 27072330 PRJNA1192965_P_NODE_3842_length_248_cov_0.880000_g3823_i0 PRJNA1192965 3842 248 0.88 2.1824 Chloroflexota bacterium 2026724 Bacteria Bacteria 48.9 2.54e-4   NR RMG70180.1 2026724 g3823 i0 43.4 0.641129032258065 53 25 58.1 1 104 247 7 59 RMG70180.1 MAG: hypothetical protein D6711_18025 [Chloroflexota bacterium] diamond 159 48.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27533756 27533756 PRJNA1192965_P_NODE_2243_length_288_cov_1.237209_g2224_i0 PRJNA1192965 2243 288 1.237209 3.56316192 Chloroflexota 200795 Bacteria Bacteria 57.8 2.17e-7   NR MCZ2111889.1 2026734 g2224 i0 42.4 1.91666666666667 92 40 95.8 3 286 11 138 216 MCZ2111889.1 biotin--[acetyl-CoA-carboxylase] ligase [Dehalococcoidia bacterium] diamond 552 57.8 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
27641222 27641222 PRJNA1192965_P_NODE_4864_length_242_cov_1.792899_g4845_i0 PRJNA1192965 4864 242 1.792899 4.33881558 Thermoflexales bacterium 2497639 Bacteria Bacteria 92.4 1.16e-19   NR MBP7687209.1 2497639 g4845 i0 50.6 1.00413223140496 81 39 99.2 1 1 240 268 348 MBP7687209.1 substrate-binding domain-containing protein [Thermoflexales bacterium] diamond 243 92.4 1 Bacteria   Bacillati Chloroflexota Thermoflexia Thermoflexales     Thermoflexales bacterium
28683156 28683156 PRJNA1192965_P_NODE_4687_length_243_cov_1.811765_g4668_i0 PRJNA1192965 4687 243 1.811765 4.40258895 Cyanobacteria bacterium UBA12227 2055765 Bacteria Bacteria 48.5 3.17e-4   NR HAG82264.1 2055765 g4668 i0 42.9 1.5679012345679 56 32 69.1 0 239 72 215 270 HAG82264.1 PEP-CTERM sorting domain-containing protein [Cyanobacteria bacterium UBA12227] diamond 381 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA12227
28903772 28903772 PRJNA1192965_P_NODE_5128_length_241_cov_0.916667_g5109_i0 PRJNA1192965 5128 241 0.916667 2.20916747 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 49.3 1.68e-4   NR MEO8688348.1 2586742 g5109 i0 55.1 3.23651452282158 49 21 61 1 241 95 110 157 MEO8688348.1 universal stress protein [Solirubrobacteraceae bacterium] diamond 780 49.3 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
29314479 29314479 PRJNA1192965_P_NODE_4749_length_243_cov_0.905882_g4730_i0 PRJNA1192965 4749 243 0.905882 2.20129326 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 130 6.069999999999998e-35   NR MBX9694561.1 2847862 g4730 i0 77.9 0.950617283950617 77 17 95.1 0 233 3 244 320 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 231 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29724643 29724643 PRJNA1192965_P_NODE_5090_length_241_cov_0.916667_g5071_i0 PRJNA1192965 5090 241 0.916667 2.20916747 Trueperella pyogenes 1661 Bacteria Bacteria 142 1.53e-40   NR WP_048712052.1 1661 g5071 i0 97.4 1.91701244813278 77 2 95.9 0 10 240 1 77 WP_048712052.1 metal-dependent transcriptional regulator [Trueperella pyogenes] diamond 462 142 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Trueperella Trueperella pyogenes
30546296 30546296 PRJNA1192965_P_NODE_3793_length_248_cov_1.468571_g3774_i0 PRJNA1192965 3793 248 1.468571 3.64205608 Clostridia bacterium 2044939 Bacteria Bacteria 72.4 1.25e-12   NR MBR0463171.1 2044939 g3774 i0 52.6 4.65725806451613 76 30 85.9 3 36 248 222 296 MBR0463171.1 glycoside hydrolase family 125 protein [Clostridia bacterium] diamond 1155 72.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31052099 31052099 PRJNA1192965_P_NODE_3655_length_249_cov_0.875000_g3636_i0 PRJNA1192965 3655 249 0.875 2.17875 Micromonosporaceae bacterium 1873464 Bacteria Bacteria 44.3 0.0115   NR MBX6748373.1 1873464 g3636 i0 44.2 0.518072289156627 43 24 51.8 0 23 151 127 169 MBX6748373.1 ABC transporter permease [Micromonosporaceae bacterium] diamond 129 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae   Micromonosporaceae bacterium
31620919 31620919 PRJNA1192965_P_NODE_2916_length_262_cov_1.629630_g2897_i0 PRJNA1192965 2916 262 1.62963 4.2696306 unclassified Oceanobacillus 2630292 Bacteria Bacteria 42.7 0.0453   NR WP_156858045.1 2630292 g2897 i0 30.6 0.709923664122137 62 43 71 0 234 49 149 210 WP_156858045.1 MULTISPECIES: ribosome biogenesis GTPase YqeH [unclassified Oceanobacillus] diamond 186 42.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Oceanobacillus  
31652423 31652423 PRJNA1192965_P_NODE_4057_length_247_cov_0.885057_g4038_i0 PRJNA1192965 4057 247 0.885057 2.18609079 Bacilli bacterium 1903720 Bacteria Bacteria 42 0.0235   NR GHU29446.1 1903720 g4038 i0 37.5 0.777327935222672 64 32 71.7 4 198 22 4 64 GHU29446.1 hypothetical protein FACS1894152_7770 [Bacilli bacterium] diamond 192 42 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31779030 31779030 PRJNA1192965_P_NODE_1157_length_369_cov_4.905405_g1138_i0 PRJNA1192965 1157 369 4.905405 18.10094445 Brevibacillus fulvus 1125967 Bacteria Bacteria 137 3.71e-39   NR WP_204516782.1 1125967 g1138 i0 61.7 0.869918699186992 107 41 87 0 41 361 2 108 WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] diamond 321 137 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
31873985 31873985 PRJNA1192965_P_NODE_2997_length_259_cov_1.956989_g2978_i0 PRJNA1192965 2997 259 1.956989 5.06860151 Bacilli bacterium 1903720 Bacteria Bacteria 120 7.2e-30   NR MBP3799570.1 1903720 g2978 i0 66.3 1.93436293436293 83 28 96.1 0 6 254 102 184 MBP3799570.1 dynamin family protein [Bacilli bacterium] diamond 501 120 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
32063787 32063787 PRJNA1192965_P_NODE_1278_length_356_cov_1.088339_g1259_i0 PRJNA1192965 1278 356 1.088339 3.87448684 Symbiobacteriaceae bacterium 2602712 Bacteria Bacteria 109 4.07e-26   NR MDF2629472.1 2602712 g1259 i0 44.4 0.985955056179775 117 62 98.6 2 352 2 38 151 MDF2629472.1 zinc-binding dehydrogenase [Symbiobacteriaceae bacterium] diamond 351 109 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae   Symbiobacteriaceae bacterium
32127365 32127365 PRJNA1192965_P_NODE_5198_length_241_cov_0.916667_g5179_i0 PRJNA1192965 5198 241 0.916667 2.20916747 Chloroflexota bacterium 2026724 Bacteria Bacteria 156 1.59e-42   NR MCA0455724.1 2026724 g5179 i0 97.5 0.983402489626556 79 2 98.3 0 239 3 288 366 MCA0455724.1 toll/interleukin-1 receptor domain-containing protein [Chloroflexota bacterium] diamond 237 156 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32317321 32317321 PRJNA1192965_P_NODE_1759_length_315_cov_1.037190_g1740_i0 PRJNA1192965 1759 315 1.03719 3.2671485 Mycolicibacterium austroafricanum 39687 Bacteria Bacteria 43.9 0.0319   NR WP_222879370.1 39687 g1740 i0 41 0.580952380952381 61 36 58.1 0 279 97 187 247 WP_222879370.1 YgfZ/GcvT domain-containing protein [Mycolicibacterium austroafricanum] diamond 183 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium austroafricanum
32348885 32348885 PRJNA1192965_P_NODE_4319_length_245_cov_0.895349_g4300_i0 PRJNA1192965 4319 245 0.895349 2.19360505 Prescottella equi 43767 Bacteria Bacteria 50.4 4.08e-5   NR WP_084869264.1 43767 g4300 i0 55 0.489795918367347 40 17 49 1 2 121 157 195 WP_084869264.1 head-tail connector protein [Prescottella equi] diamond 120 50.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Prescottella Prescottella equi

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