RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA681861" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA681861 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
15199972 15199972 PRJNA681861_P_NODE_32312_length_203_cov_44.839080_g30212_i0 PRJNA681861 32312 203 44.83908 91.0233324 Phyllobacterium sp. OV277 1882772 Bacteria Bacteria 72.4 8.61e-15   NR SDP92290.1 1882772 g30212 i0 64.6 0.70935960591133 48 17 70.9 0 144 1 12 59 SDP92290.1 hypothetical protein SAMN05443582_1226 [Phyllobacterium sp. OV277] diamond 144 72.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Phyllobacterium Phyllobacterium sp. OV277
19784490 19784490 PRJNA681861_P_NODE_13256_length_461_cov_2.949074_g11223_i0 PRJNA681861 13256 461 2.949074 13.59523114 Roseateles sp. 1971397 Bacteria Bacteria 224 1.8999999999999998e-68   NR WP_348011092.1 1971397 g11223 i0 94.1 0.767895878524946 118 7 76.8 0 1 354 239 356 WP_348011092.1 IS5 family transposase [Roseateles sp.] diamond 354 224 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
26607007 26607007 PRJNA681861_P_NODE_32721_length_202_cov_1.421965_g30621_i0 PRJNA681861 32721 202 1.421965 2.8723693 Methylobacterium 407 Bacteria Bacteria 54.3 7.01e-7   NR WP_055958895.1 407 g30621 i0 100 0.415841584158416 28 0 41.6 0 202 119 150 177 WP_055958895.1 MULTISPECIES: hypothetical protein [Methylobacterium] diamond 84 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium  
26986989 26986989 PRJNA681861_P_NODE_34182_length_195_cov_4.801205_g32082_i0 PRJNA681861 34182 195 4.801205 9.36234975 Pseudomonadota bacterium 1977087 Bacteria Bacteria 95.1 4.94e-24   NR MES2500853.1 1977087 g32082 i0 85.1 0.723076923076923 47 7 72.3 0 143 3 1 47 MES2500853.1 CsbD family protein [Pseudomonadota bacterium] diamond 141 95.1 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27346803 27346803 PRJNA681861_P_NODE_44283_length_165_cov_2.485294_g42183_i0 PRJNA681861 44283 165 2.485294 4.1007351 Pseudomonas 286 Bacteria Bacteria 62 2.04e-9   NR MES2602038.1 1977087 g42183 i0 76.3 2.65454545454545 38 9 69.1 0 51 164 4322 4359 MES2602038.1 DUF5801 repeats-in-toxin domain-containing protein [Pseudomonadota bacterium] diamond 438 62 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27378474 27378474 PRJNA681861_P_NODE_15503_length_401_cov_5.416667_g13420_i0 PRJNA681861 15503 401 5.416667 21.72083467 Methylotenera 359407 Bacteria Bacteria 67.4 5.09e-12   NR WP_047540061.1 1055487 g13420 i0 76 0.748129675810474 50 11 36.7 1 320 174 1 50 WP_047540061.1 hypothetical protein [Methylotenera versatilis] diamond 300 67.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera versatilis
28503217 28503217 PRJNA681861_P_NODE_42507_length_175_cov_3.308219_g40407_i0 PRJNA681861 42507 175 3.308219 5.78938325 Methylophilus sp. 29541 Bacteria Bacteria 85.1 4.64e-20   NR MDO8961622.1 29541 g40407 i0 62.7 1.28571428571429 75 4 87.4 1 22 174 1 75 MDO8961622.1 DUF2171 domain-containing protein [Methylophilus sp.] diamond 225 85.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylophilus Methylophilus sp.
28755762 28755762 PRJNA681861_P_NODE_32107_length_204_cov_7.742857_g30007_i0 PRJNA681861 32107 204 7.742857 15.79542828 Pseudomonadota bacterium 1977087 Bacteria Bacteria 86.7 7.3e-21   NR MES2546963.1 1977087 g30007 i0 97.7 0.647058823529412 44 1 64.7 0 51 182 1 44 MES2546963.1 entericidin A/B family lipoprotein [Pseudomonadota bacterium] diamond 132 86.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28767423 28767423 PRJNA681861_P_NODE_28487_length_227_cov_1.878788_g26387_i0 PRJNA681861 28487 227 1.878788 4.26484876 Faucicola 1604696 Bacteria Bacteria 103 6.23e-25   NR WP_342769631.1 34059 g26387 i0 58.7 2.97356828193833 75 30 97.8 1 6 227 103 177 WP_342769631.1 replication initiation protein [Moraxella atlantae] diamond 675 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Faucicola Faucicola atlantae
28913407 28913407 PRJNA681861_P_NODE_19148_length_330_cov_2.495017_g17050_i0 PRJNA681861 19148 330 2.495017 8.2335561 Roseateles sp. 1971397 Bacteria Bacteria 216 8.67e-66   NR WP_348011092.1 1971397 g17050 i0 90.8 0.990909090909091 109 10 99.1 0 2 328 17 125 WP_348011092.1 IS5 family transposase [Roseateles sp.] diamond 327 216 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
28945501 28945501 PRJNA681861_P_NODE_32708_length_202_cov_1.526012_g30608_i0 PRJNA681861 32708 202 1.526012 3.08254424 Methylibium sp. Root1272 1736441 Bacteria Bacteria 72.8 4.2e-14   NR WP_056314824.1 1736441 g30608 i0 50.8 0.965346534653465 65 32 96.5 0 197 3 51 115 WP_056314824.1 hypothetical protein [Methylibium sp. Root1272] diamond 195 72.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Methylibium Methylibium sp. Root1272
28957192 28957192 PRJNA681861_P_NODE_46368_length_154_cov_2.112000_g44268_i0 PRJNA681861 46368 154 2.112 3.25248 Methylotenera 359407 Bacteria Bacteria 106 7.51e-27   NR MES2547805.1 1977087 g44268 i0 94.1 2.98051948051948 51 3 99.4 0 1 153 37 87 MES2547805.1 cation diffusion facilitator family transporter [Pseudomonadota bacterium] diamond 459 107 0.990654205607477 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29355806 29355806 PRJNA681861_P_NODE_17709_length_356_cov_2.914373_g15611_i0 PRJNA681861 17709 356 2.914373 10.37516788 Pseudomonadota bacterium 1977087 Bacteria Bacteria 83.6 1e-18   NR MES2579017.1 1977087 g15611 i0 89.8 0.825842696629214 49 5 41.3 0 35 181 1 49 MES2579017.1 DUF1328 domain-containing protein [Pseudomonadota bacterium] diamond 294 83.6 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29398922 29398922 PRJNA681861_P_NODE_18109_length_348_cov_6.028213_g16011_i0 PRJNA681861 18109 348 6.028213 20.97818124 Methylotenera 359407 Bacteria Bacteria 68.2 1.49e-12   NR WP_047540061.1 1055487 g16011 i0 76 0.862068965517241 50 11 42.2 1 82 228 1 50 WP_047540061.1 hypothetical protein [Methylotenera versatilis] diamond 300 68.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera versatilis
29671077 29671077 PRJNA681861_P_NODE_45830_length_157_cov_1.718750_g43730_i0 PRJNA681861 45830 157 1.71875 2.6984375 Roseateles sp. 1971397 Bacteria Bacteria 82 1.58e-16   NR MBV8380698.1 1971397 g43730 i0 78.4 1.94904458598726 51 11 97.5 0 3 155 597 647 MBV8380698.1 efflux RND transporter permease subunit [Roseateles sp.] diamond 306 82 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
29797603 29797603 PRJNA681861_P_NODE_28391_length_227_cov_3.095960_g26291_i0 PRJNA681861 28391 227 3.09596 7.0278292 Roseateles sp. 1971397 Bacteria Bacteria 54.7 1.82e-6   NR WP_348011092.1 1971397 g26291 i0 77.1 0.462555066079295 35 8 46.3 0 225 121 450 484 WP_348011092.1 IS5 family transposase [Roseateles sp.] diamond 105 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
29841049 29841049 PRJNA681861_P_NODE_47271_length_150_cov_1.743802_g45171_i0 PRJNA681861 47271 150 1.743802 2.615703 Pseudomonadota 1224 Bacteria Bacteria 85.5 2.11e-20   NR WP_146714530.1 562 g45171 i0 87.8 2.94 49 6 98 0 148 2 10 58 WP_146714530.1 PH domain-containing protein, partial [Escherichia coli] diamond 441 85.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29999111 29999111 PRJNA681861_P_NODE_31551_length_207_cov_5.280899_g29451_i0 PRJNA681861 31551 207 5.280899 10.93146093 Pseudomonadati 3379134 Bacteria Bacteria 53.1 2.31e-7   NR PPD56059.1 2051956 g29451 i0 91.7 3.69565217391304 24 2 34.8 0 155 84 1 24 PPD56059.1 MAG: general stress protein CsbD [Methylotenera sp.] diamond 765 53.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera sp.
30176728 30176728 PRJNA681861_P_NODE_45932_length_156_cov_2.598425_g43832_i0 PRJNA681861 45932 156 2.598425 4.053543 Pseudomonadota bacterium 1977087 Bacteria Bacteria 75.5 1.01e-15   NR MES2547334.1 1977087 g43832 i0 86.7 0.865384615384615 45 6 86.5 0 137 3 1 45 MES2547334.1 hypothetical protein [Pseudomonadota bacterium] diamond 135 75.5 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30935212 30935212 PRJNA681861_P_NODE_13254_length_461_cov_3.069444_g11221_i0 PRJNA681861 13254 461 3.069444 14.15013684 Proteobacteria bacterium ST_bin12 1978760 Bacteria Bacteria 86.7 4.45e-18   NR OQW69634.1 1978760 g11221 i0 70.5 0.396963123644252 61 18 39.7 0 189 371 47 107 OQW69634.1 MAG: hypothetical protein BVN34_04835 [Proteobacteria bacterium ST_bin12] diamond 183 86.7 1 Bacteria   Pseudomonadati Pseudomonadota         Proteobacteria bacterium ST_bin12
31030153 31030153 PRJNA681861_P_NODE_19675_length_321_cov_7.198630_g17575_i0 PRJNA681861 19675 321 7.19863 23.1076023 Pseudomonadota bacterium 1977087 Bacteria Bacteria 80.9 1.08e-17   NR MES2578974.1 1977087 g17575 i0 72.1 0.635514018691589 68 15 62.6 2 240 40 1 65 MES2578974.1 hypothetical protein [Pseudomonadota bacterium] diamond 204 80.9 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31061778 31061778 PRJNA681861_P_NODE_13915_length_442_cov_4.631961_g11863_i0 PRJNA681861 13915 442 4.631961 20.47326762 Methylotenera sp. 2051956 Bacteria Bacteria 71.2 2.79e-13   NR PPD56412.1 2051956 g11863 i0 88.6 0.298642533936652 44 5 29.9 0 377 246 1 44 PPD56412.1 MAG: osmotically-inducible lipoprotein B [Methylotenera sp.] diamond 132 71.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera sp.
31673904 31673904 PRJNA681861_P_NODE_20737_length_306_cov_6.895307_g18637_i0 PRJNA681861 20737 306 6.895307 21.09963942 Methylotenera 359407 Bacteria Bacteria 141 3.41e-41   NR WP_020167710.1 359407 g18637 i0 87.9 4.52941176470588 91 11 89.2 0 34 306 1 91 WP_020167710.1 MULTISPECIES: BON domain-containing protein [Methylotenera] diamond 1386 142 0.992957746478873 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera  
31946819 31946819 PRJNA681861_P_NODE_45377_length_159_cov_2.630769_g43277_i0 PRJNA681861 45377 159 2.630769 4.18292271 Methylotenera sp. 2051956 Bacteria Bacteria 69.7 1.34e-12   NR PPD56095.1 2051956 g43277 i0 66.7 2.16981132075472 57 3 77.4 1 124 2 9 65 PPD56095.1 MAG: Crp/Fnr family transcriptional regulator [Methylotenera sp.] diamond 345 69.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera sp.
32421646 32421646 PRJNA681861_P_NODE_36479_length_186_cov_2.159236_g34379_i0 PRJNA681861 36479 186 2.159236 4.01617896 Methylotenera sp. 2051956 Bacteria Bacteria 79.3 7.46e-17   NR MBX9676283.1 2051956 g34379 i0 82.2 0.725806451612903 45 8 72.6 0 1 135 79 123 MBX9676283.1 hypothetical protein [Methylotenera sp.] diamond 135 79.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera sp.
32831650 32831650 PRJNA681861_P_NODE_42180_length_177_cov_2.810811_g40080_i0 PRJNA681861 42180 177 2.810811 4.97513547 Methylotenera versatilis 1055487 Bacteria Bacteria 120 8.58e-34   NR WP_047537628.1 1055487 g40080 i0 98.3 0.983050847457627 58 1 98.3 0 176 3 7 64 WP_047537628.1 putative quinol monooxygenase [Methylotenera versatilis] diamond 174 120 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera versatilis

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