RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1175041" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_clade 2

tax_superkingdom 1

  • Bacteria · 24 ✖

bioproject 1

  • PRJNA1175041 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
16893501 16893501 PRJNA1175041_P_NODE_101494_length_245_cov_0.883721_g98626_i0 PRJNA1175041 101494 245 0.883721 2.16511645 Angelakisella sp. 1935177 Bacteria Bacteria 139 2.56e-36   NR MCI9667402.1 1935177 g98626 i0 96.2 1.91020408163265 79 3 96.7 0 238 2 1 79 MCI9667402.1 hypothetical protein [Angelakisella sp.] diamond 468 139 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Angelakisella Angelakisella sp.
21993920 21993920 PRJNA1175041_P_NODE_78038_length_300_cov_1.202643_g75170_i0 PRJNA1175041 78038 300 1.202643 3.607929 Geopseudomonas aromaticivorans 2849492 Bacteria Bacteria 171 9.6e-52   NR WP_217682444.1 2849492 g75170 i0 94.6 0.92 92 5 92 0 280 5 105 196 WP_217682444.1 hypothetical protein [Geopseudomonas aromaticivorans] diamond 276 171 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Geopseudomonas Geopseudomonas aromaticivorans
26964737 26964737 PRJNA1175041_P_NODE_99382_length_247_cov_0.873563_g96514_i0 PRJNA1175041 99382 247 0.873563 2.15770061 Bacillati 1783272 Bacteria Bacteria 105 1.13e-25   NR WP_261197916.1 1423 g96514 i0 71.3 16.0931174089069 80 23 97.2 0 242 3 19 98 WP_261197916.1 hypothetical protein [Bacillus subtilis] diamond 3975 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
27008778 27008778 PRJNA1175041_P_NODE_106022_length_241_cov_0.904762_g103154_i0 PRJNA1175041 106022 241 0.904762 2.18047642 Cystobacterineae bacterium 1934914 Bacteria Bacteria 45.4 0.00399   NR MCL2012724.1 1934914 g103154 i0 38.1 0.784232365145228 63 38 77.2 1 188 3 346 408 MCL2012724.1 FAD-dependent oxidoreductase [Cystobacterineae bacterium] diamond 189 45.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Cystobacterineae bacterium
27103675 27103675 PRJNA1175041_P_NODE_99982_length_246_cov_0.878613_g97114_i0 PRJNA1175041 99982 246 0.878613 2.16138798 uncultured Dubosiella sp. 1937011 Bacteria Bacteria 168 1.63e-49   NR WP_289197645.1 1937011 g97114 i0 98.8 1 82 1 100 0 246 1 120 201 WP_289197645.1 PolC-type DNA polymerase III [uncultured Dubosiella sp.] diamond 246 168 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Dubosiella uncultured Dubosiella sp.
27514595 27514595 PRJNA1175041_P_NODE_82003_length_288_cov_1.093023_g79135_i0 PRJNA1175041 82003 288 1.093023 3.14790624 Eubacterium sp. 142586 Bacteria Bacteria 202 9.95e-63   NR MCI9209700.1 142586 g79135 i0 100 1 96 0 100 0 1 288 214 309 MCI9209700.1 alpha/beta hydrolase [Eubacterium sp.] diamond 288 202 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
27577714 27577714 PRJNA1175041_P_NODE_107804_length_239_cov_0.915663_g104936_i0 PRJNA1175041 107804 239 0.915663 2.18843457 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 157 8.44e-44   NR MDY2789824.1 1898203 g104936 i0 94.9 6.94142259414226 79 4 99.2 0 2 238 285 363 MDY2789824.1 amidophosphoribosyltransferase [Lachnospiraceae bacterium] diamond 1659 157 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27798906 27798906 PRJNA1175041_P_NODE_107224_length_240_cov_0.886228_g104356_i0 PRJNA1175041 107224 240 0.886228 2.1269472 Eubacterium sp. 142586 Bacteria Bacteria 89.4 3.27e-19   NR MCI9412796.1 142586 g104356 i0 73.1 0.65 52 14 65 0 3 158 250 301 MCI9412796.1 restriction endonuclease [Eubacterium sp.] diamond 156 89.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
27956666 27956666 PRJNA1175041_P_NODE_91945_length_260_cov_2.213904_g89077_i0 PRJNA1175041 91945 260 2.213904 5.7561504 Oceanicella sp. SM1341 1548889 Bacteria Bacteria 43.9 0.0182   NR WP_118138491.1 1548889 g89077 i0 38.6 0.807692307692308 70 32 78.5 3 6 209 606 666 WP_118138491.1 cytochrome c oxidase subunit I [Oceanicella sp. SM1341] diamond 210 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Oceanicella Oceanicella sp. SM1341
28619849 28619849 PRJNA1175041_P_NODE_102187_length_244_cov_0.888889_g99319_i0 PRJNA1175041 102187 244 0.888889 2.16888916 unclassified Turicibacter 2638206 Bacteria Bacteria 67.8 1.6e-12   NR WP_262953588.1 2638206 g99319 i0 67.3 0.602459016393443 49 16 60.2 0 178 32 55 103 WP_262953588.1 MULTISPECIES: helix-turn-helix domain-containing protein [unclassified Turicibacter] diamond 147 67.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Turicibacteraceae Turicibacter  
29945925 29945925 PRJNA1175041_P_NODE_89111_length_268_cov_1.482051_g86243_i0 PRJNA1175041 89111 268 1.482051 3.97189668 Opitutaceae bacterium 2006848 Bacteria Bacteria 43.5 0.0272   NR HEY3756961.1 2006848 g86243 i0 31 0.649253731343284 58 40 64.9 0 34 207 31 88 HEY3756961.1 mechanosensitive ion channel family protein [Opitutaceae bacterium] diamond 174 43.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30420088 30420088 PRJNA1175041_P_NODE_96513_length_249_cov_0.863636_g93645_i0 PRJNA1175041 96513 249 0.863636 2.15045364 Lachnospiraceae bacterium 1 1898203 Bacteria Bacteria 120 1.15e-31   NR EOS78106.1 1235800 g93645 i0 77.5 0.963855421686747 80 18 96.4 0 9 248 6 85 EOS78106.1 hypothetical protein C819_00417 [Lachnospiraceae bacterium 10-1] diamond 240 120 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium 10-1
30628254 30628254 PRJNA1175041_P_NODE_83373_length_284_cov_1.218009_g80505_i0 PRJNA1175041 83373 284 1.218009 3.45914556 Actinomycetes 1760 Bacteria Bacteria 43.9 0.0232   NR WP_281860861.1 120377 g80505 i0 32.2 1.26760563380282 59 40 62.3 0 7 183 370 428 WP_281860861.1 ATP-binding protein [Salana multivorans] diamond 360 44.3 0.99097065462754 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Beutenbergiaceae Salana Salana multivorans
30862062 30862062 PRJNA1175041_P_NODE_96934_length_249_cov_0.863636_g94066_i0 PRJNA1175041 96934 249 0.863636 2.15045364 Acetatifactor sp. 1872090 Bacteria Bacteria 166 1.92e-48   NR MFG6356014.1 1872090 g94066 i0 100 0.987951807228916 82 0 98.8 0 248 3 152 233 MFG6356014.1 Rpn family recombination-promoting nuclease/putative transposase [Acetatifactor sp.] diamond 246 166 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Acetatifactor Acetatifactor sp.
31336035 31336035 PRJNA1175041_P_NODE_78416_length_299_cov_1.039823_g75548_i0 PRJNA1175041 78416 299 1.039823 3.10907077 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 91.3 3.82e-21   NR POH17992.1 1625 g75548 i0 84.1 0.632107023411371 63 10 63.2 0 1 189 69 131 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 189 91.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
31367999 31367999 PRJNA1175041_P_NODE_70896_length_325_cov_1.250000_g68028_i0 PRJNA1175041 70896 325 1.25 4.0625 Escherichia coli 562 Bacteria Bacteria 87.8 1.63e-19   NR HAI4532814.1 562 g68028 i0 71.6 3.23076923076923 74 21 68.3 0 325 104 69 142 HAI4532814.1 hypothetical protein [Escherichia coli] diamond 1050 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31589377 31589377 PRJNA1175041_P_NODE_92596_length_259_cov_1.091398_g89728_i0 PRJNA1175041 92596 259 1.091398 2.82672082 Stenotrophomonas sp. ZAC14A_NAIMI4_1 2072412 Bacteria Bacteria 42.7 0.0444   NR WP_159095046.1 2072412 g89728 i0 46.2 0.602316602316602 52 26 57.9 1 212 63 13 64 WP_159095046.1 hypothetical protein [Stenotrophomonas sp. ZAC14A_NAIMI4_1] diamond 156 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp. ZAC14A_NAIMI4_1
31589379 31589379 PRJNA1175041_P_NODE_99036_length_247_cov_0.873563_g96168_i0 PRJNA1175041 99036 247 0.873563 2.15770061 Muribaculaceae bacterium 2498093 Bacteria Bacteria 97.4 1.88e-22   NR MDE6796223.1 2498093 g96168 i0 65.4 0.947368421052632 78 23 93.5 2 9 239 1 75 MDE6796223.1 tetratricopeptide repeat protein [Muribaculaceae bacterium] diamond 234 97.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Muribaculaceae   Muribaculaceae bacterium
31810618 31810618 PRJNA1175041_P_NODE_90017_length_266_cov_1.139896_g87149_i0 PRJNA1175041 90017 266 1.139896 3.03212336 Haliangiales bacterium 3069304 Bacteria Bacteria 42.7 0.0433   NR HYT61386.1 3069304 g87149 i0 33.8 0.800751879699248 71 32 72.2 3 44 235 104 166 HYT61386.1 prolyl oligopeptidase family serine peptidase [Haliangiales bacterium] diamond 213 42.7 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales     Haliangiales bacterium
32063615 32063615 PRJNA1175041_P_NODE_88138_length_271_cov_1.090909_g85270_i0 PRJNA1175041 88138 271 1.090909 2.95636339 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.7 0.0107   NR MEM7198959.1 2026780 g85270 i0 36.5 0.697416974169742 63 39 69.7 1 6 194 29 90 MEM7198959.1 S46 family peptidase [Planctomycetota bacterium] diamond 189 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32285540 32285540 PRJNA1175041_P_NODE_85659_length_278_cov_0.887805_g82791_i0 PRJNA1175041 85659 278 0.887805 2.4680979 uncultured Massilia sp. 169973 Bacteria Bacteria 43.1 0.00992   NR WP_296952003.1 169973 g82791 i0 50 0.517985611510791 48 23 50.7 1 21 161 10 57 WP_296952003.1 hypothetical protein [uncultured Massilia sp.] diamond 144 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia uncultured Massilia sp.
32664249 32664249 PRJNA1175041_P_NODE_106680_length_240_cov_0.910180_g103812_i0 PRJNA1175041 106680 240 0.91018 2.184432 Dorea sp. 2040332 Bacteria Bacteria 148 4.56e-41   NR MCI8321910.1 2040332 g103812 i0 100 1 80 0 100 0 1 240 15 94 MCI8321910.1 hypothetical protein [Dorea sp.] diamond 240 148 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Dorea Dorea sp.
32695802 32695802 PRJNA1175041_P_NODE_104380_length_242_cov_0.917160_g101512_i0 PRJNA1175041 104380 242 0.91716 2.2195272 bacterium 1869227 Bacteria Bacteria 42.7 0.0352   NR NBO38053.1 1869227 g101512 i0 37.5 0.59504132231405 48 30 59.5 0 167 24 234 281 NBO38053.1 hypothetical protein [bacterium] diamond 144 42.7 1 Bacteria               bacterium
32884693 32884693 PRJNA1175041_P_NODE_94120_length_255_cov_1.049451_g91252_i0 PRJNA1175041 94120 255 1.049451 2.67610005 Trabulsiella odontotermitis 379893 Bacteria Bacteria 46.2 0.00254   NR WP_080993459.1 379893 g91252 i0 30.9 2.85882352941176 81 52 90.6 2 254 24 343 423 WP_080993459.1 type VI secretion system tip protein VgrG [Trabulsiella odontotermitis] diamond 729 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Trabulsiella Trabulsiella odontotermitis

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