RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA796639" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 18 ✖

bioproject 1

  • PRJNA796639 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
26705406 26705406 PRJNA796639_P_NODE_6141_length_249_cov_0.875000_g6016_i0 PRJNA796639 6141 249 0.875 2.17875 Streptomyces 1883 Bacteria Bacteria 44.3 0.0102   NR WP_126915786.1 1883 g6016 i0 40 0.602409638554217 50 28 60.2 2 97 246 35 82 WP_126915786.1 MULTISPECIES: prepilin peptidase [Streptomyces] diamond 150 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
26958720 26958720 PRJNA796639_P_NODE_6062_length_249_cov_0.875000_g5937_i0 PRJNA796639 6062 249 0.875 2.17875 Jiangellaceae bacterium 2768363 Bacteria Bacteria 45.4 0.00437   NR HSI94084.1 2768363 g5937 i0 35.2 1.09638554216867 91 47 95.2 2 1 237 7 97 HSI94084.1 chorismate-binding protein [Jiangellaceae bacterium] diamond 273 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jiangellales Jiangellaceae   Jiangellaceae bacterium
27022245 27022245 PRJNA796639_P_NODE_2822_length_335_cov_1.011450_g2697_i0 PRJNA796639 2822 335 1.01145 3.3883575 Cryptosporangium aurantiacum 134849 Bacteria Bacteria 43.5 0.0449   NR WP_073258352.1 134849 g2697 i0 37.5 0.501492537313433 56 31 46.6 1 170 325 34 89 WP_073258352.1 TIGR03089 family protein [Cryptosporangium aurantiacum] diamond 168 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Cryptosporangiales Cryptosporangiaceae Cryptosporangium Cryptosporangium aurantiacum
27085518 27085518 PRJNA796639_P_NODE_6402_length_247_cov_1.724138_g6277_i0 PRJNA796639 6402 247 1.724138 4.25862086 Clostridia bacterium 2044939 Bacteria Bacteria 85.9 8.3e-18   NR HML69499.1 2044939 g6277 i0 51.9 0.983805668016194 81 38 98.4 1 5 247 53 132 HML69499.1 nucleoside hydrolase [Clostridia bacterium] diamond 243 85.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27780531 27780531 PRJNA796639_P_NODE_5384_length_254_cov_1.386740_g5259_i0 PRJNA796639 5384 254 1.38674 3.5223196 Pseudonocardia nematodicida 1206997 Bacteria Bacteria 43.5 0.0221   NR WP_349300394.1 1206997 g5259 i0 33 1.14566929133858 97 50 96.9 2 252 7 210 306 WP_349300394.1 CynX/NimT family MFS transporter [Pseudonocardia nematodicida] diamond 291 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia nematodicida
28096114 28096114 PRJNA796639_P_NODE_4865_length_267_cov_1.319588_g4740_i0 PRJNA796639 4865 267 1.319588 3.52329996 Synechococcus sp. Nb3U1 1914529 Bacteria Bacteria 43.9 0.0159   NR WP_235278608.1 1914529 g4740 i0 39.7 0.820224719101124 73 36 73 3 55 249 67 139 WP_235278608.1 hypothetical protein [Synechococcus sp. Nb3U1] diamond 219 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. Nb3U1
28222259 28222259 PRJNA796639_P_NODE_7306_length_243_cov_0.905882_g7181_i0 PRJNA796639 7306 243 0.905882 2.20129326 Clostridium sp. 1506 Bacteria Bacteria 41.6 0.0371   NR MDR0964144.1 1506 g7181 i0 44.4 0.333333333333333 27 15 33.3 0 53 133 4 30 MDR0964144.1 hypothetical protein [Clostridium sp.] diamond 81 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
28380264 28380264 PRJNA796639_P_NODE_6166_length_248_cov_2.514286_g6041_i0 PRJNA796639 6166 248 2.514286 6.23542928 Candidatus Dormiibacterota bacterium 2052315 Bacteria Bacteria 45.4 0.00441   NR HKA49911.1 2052315 g6041 i0 47.1 0.616935483870968 51 25 59.3 1 182 36 63 113 HKA49911.1 hypothetical protein [Candidatus Dormiibacterota bacterium] diamond 153 45.4 1 Bacteria   Bacillati Candidatus Dormiibacterota         Candidatus Dormiibacterota bacterium
28506613 28506613 PRJNA796639_P_NODE_6607_length_247_cov_0.879310_g6482_i0 PRJNA796639 6607 247 0.87931 2.1718957 Nonomuraea helvata 37484 Bacteria Bacteria 47 4.26e-4   NR WP_344984142.1 37484 g6482 i0 40.9 0.801619433198381 66 38 80.2 1 45 242 38 102 WP_344984142.1 hypothetical protein [Nonomuraea helvata] diamond 198 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea helvata
28664529 28664529 PRJNA796639_P_NODE_5507_length_251_cov_0.887640_g5382_i0 PRJNA796639 5507 251 0.88764 2.2279764 Leifsonia sp. TF 1870902 Bacteria Bacteria 44.7 0.00829   NR WP_208040632.1 2815212 g5382 i0 45.6 0.681274900398406 57 26 66.9 2 218 51 115 167 WP_208040632.1 sensor histidine kinase [Leifsonia sp. TF02-11] diamond 171 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. TF02-11
30622403 30622403 PRJNA796639_P_NODE_3873_length_289_cov_1.120370_g3748_i0 PRJNA796639 3873 289 1.12037 3.2378693 Bifidobacteriaceae bacterium 2291324 Bacteria Bacteria 43.1 0.042   NR MDR1153033.1 2291324 g3748 i0 39.4 0.737024221453287 71 41 71.6 1 21 227 94 164 MDR1153033.1 hypothetical protein [Bifidobacteriaceae bacterium] diamond 213 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae   Bifidobacteriaceae bacterium
31222673 31222673 PRJNA796639_P_NODE_6455_length_247_cov_0.885057_g6330_i0 PRJNA796639 6455 247 0.885057 2.18609079 Mycobacterium bohemicum 56425 Bacteria Bacteria 171 4.81e-49   NR ORV00101.1 56425 g6330 i0 98.8 1.96761133603239 81 1 98.4 0 246 4 55 135 ORV00101.1 hypothetical protein AWB93_09720 [Mycobacterium bohemicum] diamond 486 171 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium bohemicum
31539312 31539312 PRJNA796639_P_NODE_2356_length_365_cov_1.054795_g2231_i0 PRJNA796639 2356 365 1.054795 3.85000175 Sphaerisporangium album 509200 Bacteria Bacteria 78.2 3.7e-14   NR WP_114033542.1 509200 g2231 i0 38.3 3.81369863013699 120 62 94.5 3 346 2 30 142 WP_114033542.1 cellulose binding domain-containing protein [Sphaerisporangium album] diamond 1392 78.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Sphaerisporangium Sphaerisporangium album
31823718 31823718 PRJNA796639_P_NODE_4297_length_280_cov_1.246377_g4172_i0 PRJNA796639 4297 280 1.246377 3.4898556 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 43.9 0.0197   NR MFQ5933018.1 2026734 g4172 i0 34.7 0.771428571428571 72 40 77.1 2 249 34 69 133 MFQ5933018.1 phosphatase PAP2 family protein [Dehalococcoidia bacterium] diamond 216 43.9 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
31855413 31855413 PRJNA796639_P_NODE_5517_length_251_cov_0.865169_g5392_i0 PRJNA796639 5517 251 0.865169 2.17157419 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 159 1.97e-43   NR MBQ3252338.1 2485925 g5392 i0 94 6.94422310756972 83 5 99.2 0 2 250 131 213 MBQ3252338.1 glutamine synthetase III [Oscillospiraceae bacterium] diamond 1743 159 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32425069 32425069 PRJNA796639_P_NODE_7279_length_243_cov_1.500000_g7154_i0 PRJNA796639 7279 243 1.5 3.645 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 44.7 0.0072   NR MFN6337432.1 2847862 g7154 i0 41.5 0.506172839506173 41 23 49.4 1 5 124 92 132 MFN6337432.1 4a-hydroxytetrahydrobiopterin dehydratase [Cyanobacteriota bacterium] diamond 123 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32456841 32456841 PRJNA796639_P_NODE_6459_length_247_cov_0.885057_g6334_i0 PRJNA796639 6459 247 0.885057 2.18609079 Caldilinea sp. 2293560 Bacteria Bacteria 43.5 0.0177   NR MFO7631691.1 2293560 g6334 i0 42.4 0.801619433198381 66 34 80.2 2 227 30 5 66 MFO7631691.1 A24 family peptidase [Caldilinea sp.] diamond 198 43.5 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae Caldilinea Caldilinea sp.
32456842 32456842 PRJNA796639_P_NODE_7519_length_242_cov_0.911243_g7394_i0 PRJNA796639 7519 242 0.911243 2.20520806 Dermatophilaceae bacterium 2728912 Bacteria Bacteria 43.9 0.0147   NR HEY5179339.1 2728912 g7394 i0 45.8 0.731404958677686 59 24 70.7 2 32 202 1129 1181 HEY5179339.1 MobF family relaxase [Dermatophilaceae bacterium] diamond 177 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae   Dermatophilaceae 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);;