RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJEB50765" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 3

tax_superkingdom 1

  • Bacteria · 22 ✖

bioproject 1

  • PRJEB50765 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
11597885 11597885 PRJEB50765_P_NODE_450_length_509_cov_2.093220_g427_i0 PRJEB50765 450 509 2.09322 10.6544898 Pseudomonadota bacterium 1977087 Bacteria Bacteria 234 3.66e-76   NR MEL6702562.1 1977087 g427 i0 68.2 5.54027504911591 157 50 92.5 0 7 477 1 157 MEL6702562.1 30S ribosomal protein S17 [Pseudomonadota bacterium] diamond 2820 234 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
11597889 11597889 PRJEB50765_P_NODE_790_length_375_cov_1.452663_g766_i0 PRJEB50765 790 375 1.452663 5.44748625 Myxococcaceae bacterium 2484252 Bacteria Bacteria 236 2.14e-74   NR RYZ13579.1 2484252 g766 i0 92.8 1 125 9 100 0 1 375 210 334 RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] diamond 375 236 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
12873051 12873051 PRJEB50765_P_NODE_2251_length_189_cov_1.513158_g2227_i0 PRJEB50765 2251 189 1.513158 2.85986862 Bacteroidota 976 Bacteria Bacteria 126 7.840000000000001e-33   NR MBU7570240.1 239 g2227 i0 90.3 30.5079365079365 62 6 98.4 0 3 188 369 430 MBU7570240.1 aldehyde dehydrogenase family protein [Flavobacterium sp.] diamond 5766 126 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
26590058 26590058 PRJEB50765_P_NODE_1661_length_230_cov_1.393782_g1637_i0 PRJEB50765 1661 230 1.393782 3.2056986 Colwellia sp. 56799 Bacteria Bacteria 42.7 0.0318   NR MCP4989313.1 56799 g1637 i0 53.8 0.508695652173913 39 18 50.9 0 1 117 325 363 MCP4989313.1 hypothetical protein [Colwellia sp.] diamond 117 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Colwelliaceae Colwellia Colwellia sp.
26931905 26931905 PRJEB50765_P_NODE_3322_length_150_cov_1.362832_g3298_i0 PRJEB50765 3322 150 1.362832 2.044248 Pseudomonadati 3379134 Bacteria Bacteria 90.1 3.44e-21   NR MBT7377214.1 2026760 g3298 i0 85.4 9.6 48 7 96 0 146 3 115 162 MBT7377214.1 F0F1 ATP synthase subunit alpha [Fidelibacterota bacterium] diamond 1440 90.9 0.991199119911991 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
27381383 27381383 PRJEB50765_P_NODE_1263_length_275_cov_1.302521_g1239_i0 PRJEB50765 1263 275 1.302521 3.58193275 Pseudomonadota bacterium 1977087 Bacteria Bacteria 144 2.9599999999999995e-42   NR MEL6702651.1 1977087 g1239 i0 75.8 0.992727272727273 91 22 99.3 0 274 2 27 117 MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium] diamond 273 144 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27753594 27753594 PRJEB50765_P_NODE_2764_length_167_cov_1.476923_g2740_i0 PRJEB50765 2764 167 1.476923 2.46646141 Bacteroidota 976 Bacteria Bacteria 48.5 1.2e-4   NR WP_348053777.1 1882438 g2740 i0 51.4 4.22155688622755 37 18 66.5 0 153 43 81 117 WP_348053777.1 ammonium transporter [Mucilaginibacter sp.] diamond 705 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Mucilaginibacter Mucilaginibacter sp.
28044268 28044268 PRJEB50765_P_NODE_2645_length_172_cov_1.140741_g2621_i0 PRJEB50765 2645 172 1.140741 1.96207452 Coriobacteriales bacterium 2478480 Bacteria Bacteria 47.8 2.47e-4   NR MDR3315660.1 2478480 g2621 i0 53.1 1.11627906976744 32 15 55.8 0 172 77 459 490 MDR3315660.1 RICIN domain-containing protein [Coriobacteriales bacterium] diamond 192 47.8 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
28454946 28454946 PRJEB50765_P_NODE_2266_length_188_cov_2.052980_g2242_i0 PRJEB50765 2266 188 2.05298 3.8596024 Pirellulaceae bacterium 2699754 Bacteria Bacteria 63.9 1.96e-10   NR MFK7736369.1 2699754 g2242 i0 58 0.797872340425532 50 20 79.8 1 150 1 21 69 MFK7736369.1 peptidylprolyl isomerase [Pirellulaceae bacterium] diamond 150 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
28517981 28517981 PRJEB50765_P_NODE_2787_length_166_cov_1.496124_g2763_i0 PRJEB50765 2787 166 1.496124 2.48356584 Candidatus Zinderia endosymbiont of Aphrophora alni 3077951 Bacteria Bacteria 90.9 8.4e-20   NR WP_339045084.1 3077951 g2763 i0 74.5 3.97590361445783 55 14 99.4 0 166 2 276 330 WP_339045084.1 elongation factor Tu [Candidatus Zinderia endosymbiont of Aphrophora alni] diamond 660 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Candidatus Zinderia Candidatus Zinderia endosymbiont of Aphrophora alni
28612648 28612648 PRJEB50765_P_NODE_2427_length_181_cov_1.354167_g2403_i0 PRJEB50765 2427 181 1.354167 2.45104227 Nitrosomonas sp. 42353 Bacteria Bacteria 84.3 3.61e-17   NR HNJ38565.1 42353 g2403 i0 68.3 0.994475138121547 60 19 99.4 0 181 2 1099 1158 HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.] diamond 180 84.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
28732236 28732236 PRJEB50765_P_NODE_1827_length_216_cov_1.296089_g1803_i0 PRJEB50765 1827 216 1.296089 2.79955224 Bacteria 2 Bacteria Bacteria 45.1 0.00423   NR WP_027086007.1 400776 g1803 i0 44.6 2.45833333333333 56 31 77.8 0 31 198 854 909 WP_027086007.1 carboxypeptidase regulatory-like domain-containing protein [Cohnella panacarvi] diamond 531 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella panacarvi
29464717 29464717 PRJEB50765_P_NODE_950_length_336_cov_0.899666_g926_i0 PRJEB50765 950 336 0.899666 3.02287776 Rhodocyclaceae bacterium 1898103 Bacteria Bacteria 44.3 0.0315   NR MCB1955432.1 1898103 g926 i0 43.5 0.616071428571429 69 36 60.7 3 88 291 207 273 MCB1955432.1 SWIM zinc finger family protein [Rhodocyclaceae bacterium] diamond 207 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Rhodocyclaceae   Rhodocyclaceae bacterium
29780818 29780818 PRJEB50765_P_NODE_1631_length_233_cov_1.142857_g1607_i0 PRJEB50765 1631 233 1.142857 2.66285681 Caenispirillum salinarum 859058 Bacteria Bacteria 67 1.12e-12   NR WP_009542739.1 859058 g1607 i0 66 2.02145922746781 53 18 68.2 0 216 58 15 67 WP_009542739.1 YqaE/Pmp3 family membrane protein [Caenispirillum salinarum] diamond 471 67 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Novispirillaceae Caenispirillum Caenispirillum salinarum
29843996 29843996 PRJEB50765_P_NODE_1031_length_317_cov_1.803571_g1007_i0 PRJEB50765 1031 317 1.803571 5.71732007 Terracidiphilus sp. 1964191 Bacteria Bacteria 48.9 5.29e-5   NR MDR3737750.1 1964191 g1007 i0 40.3 0.634069400630915 67 39 63.4 1 41 241 6 71 MDR3737750.1 hypothetical protein [Terracidiphilus sp.] diamond 201 48.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
30539048 30539048 PRJEB50765_P_NODE_1573_length_239_cov_1.717822_g1549_i0 PRJEB50765 1573 239 1.717822 4.10559458 Myxococcaceae bacterium 2484252 Bacteria Bacteria 113 7.44e-28   NR RYZ13579.1 2484252 g1549 i0 69.2 0.97907949790795 78 24 97.9 0 234 1 73 150 RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] diamond 234 113 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
31012983 31012983 PRJEB50765_P_NODE_2335_length_185_cov_1.567568_g2311_i0 PRJEB50765 2335 185 1.567568 2.9000008 Paracoccaceae bacterium 1904441 Bacteria Bacteria 73.9 1.7e-13   NR GIS52924.1 1904441 g2311 i0 95 0.648648648648649 40 2 64.9 0 120 1 1 40 GIS52924.1 MAG: chaperone protein HtpG [Paracoccaceae bacterium] diamond 120 73.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae   Paracoccaceae bacterium
31132350 31132350 PRJEB50765_P_NODE_2475_length_179_cov_1.352113_g2451_i0 PRJEB50765 2475 179 1.352113 2.42028227 Bacillota 1239 Bacteria Bacteria 93.2 9.42e-21   NR WP_328207969.1 1422 g2451 i0 81.4 57.2011173184358 59 11 98.9 0 1 177 101 159 WP_328207969.1 Hsp70 family protein, partial [Geobacillus stearothermophilus] diamond 10239 93.6 0.995726495726496 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus stearothermophilus
31170746 31170746 PRJEB50765_P_NODE_2095_length_198_cov_1.111801_g2071_i0 PRJEB50765 2095 198 1.111801 2.20136598 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 53.1 4.11e-6   NR MDR3737318.1 2052142 g2071 i0 47.7 0.984848484848485 65 33 97 1 197 6 231 295 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 195 53.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
31993337 31993337 PRJEB50765_P_NODE_3038_length_158_cov_1.256198_g3014_i0 PRJEB50765 3038 158 1.256198 1.98479284 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 80.5 2.81e-16   NR MBX9694561.1 2847862 g3014 i0 75 0.987341772151899 52 13 98.7 0 2 157 24 75 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 156 80.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32271542 32271542 PRJEB50765_P_NODE_598_length_446_cov_1.508557_g574_i0 PRJEB50765 598 446 1.508557 6.72816422 Bacteria 2 Bacteria Bacteria 78.6 1.03e-13   NR WP_188972129.1 522487 g574 i0 43.6 9.6457399103139 110 55 71.3 3 61 378 27 133 WP_188972129.1 fasciclin domain-containing protein [Deinococcus aerolatus] diamond 4302 79 0.994936708860759 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aerolatus
32745225 32745225 PRJEB50765_P_NODE_3040_length_158_cov_0.958678_g3016_i0 PRJEB50765 3040 158 0.958678 1.51471124 PVC group 1783257 Bacteria Bacteria 73.6 7.05e-14   NR MDA1175223.1 2026724 g3016 i0 64.7 9.6645569620253209 51 18 96.8 0 6 158 132 182 MDA1175223.1 aldolase/citrate lyase family protein [Chloroflexota bacterium] diamond 1527 73.9 0.995940460081191 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;