contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA397065" and tax_phylum = "Pseudomonadota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9340250 | 9340250 | PRJNA397065_S_NODE_7168_length_338_cov_2.983819_g6918_i0 | PRJNA397065 | 7168 | 338 | 2.983819 | 10.08530822 | Propionivibrio sp. | 2212460 | Bacteria | Bacteria | 214 | 2.4699999999999996e-66 | NR | WP_305073382.1 | 2212460 | g6918 | i0 | 97.3 | 0.994082840236686 | 112 | 3 | 99.4 | 0 | 1 | 336 | 23 | 134 | WP_305073382.1 IS5 family transposase [Propionivibrio sp.] | diamond | 336 | 214 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Rhodocyclales | Rhodocyclaceae | Propionivibrio | Propionivibrio sp. | ||
| 13165758 | 13165758 | PRJNA397065_S_NODE_16911_length_171_cov_1.323944_g16661_i0 | PRJNA397065 | 16911 | 171 | 1.323944 | 2.26394424 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 111 | 7.56e-27 | NR | WP_018315012.1 | 1080187 | g16661 | i0 | 94.6 | 0.982456140350877 | 56 | 3 | 98.2 | 0 | 169 | 2 | 418 | 473 | WP_018315012.1 hypothetical protein [Cupriavidus sp. UYPR2.512] | diamond | 168 | 111 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 26632220 | 26632220 | PRJNA397065_S_NODE_16401_length_175_cov_1.609589_g16151_i0 | PRJNA397065 | 16401 | 175 | 1.609589 | 2.81678075 | Trinickia fusca | 2419777 | Bacteria | Bacteria | 97.8 | 3e-24 | NR | WP_121275632.1 | 2419777 | g16151 | i0 | 77.6 | 2.98285714285714 | 58 | 13 | 99.4 | 0 | 1 | 174 | 73 | 130 | WP_121275632.1 DUF29 domain-containing protein [Trinickia fusca] | diamond | 522 | 97.8 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Trinickia | Trinickia fusca | ||
| 26854104 | 26854104 | PRJNA397065_S_NODE_14601_length_191_cov_4.055556_g14351_i0 | PRJNA397065 | 14601 | 191 | 4.055556 | 7.74611196 | Burkholderiaceae | 119060 | Bacteria | Bacteria | 117 | 5.69e-33 | NR | WP_029308548.1 | 119060 | g14351 | i0 | 100 | 0.910994764397906 | 58 | 0 | 91.1 | 0 | 189 | 16 | 17 | 74 | WP_029308548.1 MULTISPECIES: hypothetical protein [Burkholderiaceae] | diamond | 174 | 117 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | ||||
| 27043761 | 27043761 | PRJNA397065_S_NODE_18842_length_157_cov_1.054688_g18592_i0 | PRJNA397065 | 18842 | 157 | 1.054688 | 1.65586016 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 71.2 | 5.61e-13 | NR | WP_018314988.1 | 1080187 | g18592 | i0 | 67.3 | 0.993630573248408 | 52 | 17 | 99.4 | 0 | 2 | 157 | 33 | 84 | WP_018314988.1 hypothetical protein [Cupriavidus sp. UYPR2.512] | diamond | 156 | 71.2 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 27233437 | 27233437 | PRJNA397065_S_NODE_18903_length_156_cov_2.811024_g18653_i0 | PRJNA397065 | 18903 | 156 | 2.811024 | 4.38519744 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 85.1 | 5.35e-18 | NR | WP_018315006.1 | 1080187 | g18653 | i0 | 82.2 | 0.865384615384615 | 45 | 8 | 86.5 | 0 | 2 | 136 | 283 | 327 | WP_018315006.1 N4-gp56 family major capsid protein [Cupriavidus sp. UYPR2.512] | diamond | 135 | 85.1 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 27265099 | 27265099 | PRJNA397065_S_NODE_9023_length_281_cov_1.646825_g8773_i0 | PRJNA397065 | 9023 | 281 | 1.646825 | 4.62757825 | Burkholderiaceae | 119060 | Bacteria | Bacteria | 140 | 9.3e-39 | NR | WP_029308547.1 | 119060 | g8773 | i0 | 72.8 | 0.98220640569395 | 92 | 25 | 98.2 | 0 | 277 | 2 | 68 | 159 | WP_029308547.1 MULTISPECIES: plasmid replication initiator TrfA [Burkholderiaceae] | diamond | 276 | 140 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | ||||
| 27517771 | 27517771 | PRJNA397065_S_NODE_14283_length_195_cov_1.698795_g14033_i0 | PRJNA397065 | 14283 | 195 | 1.698795 | 3.31265025 | Cupriavidus pinatubonensis | 248026 | Bacteria | Bacteria | 120 | 2.07e-33 | NR | WP_224001231.1 | 248026 | g14033 | i0 | 100 | 0.984615384615385 | 64 | 0 | 98.5 | 0 | 3 | 194 | 70 | 133 | WP_224001231.1 hypothetical protein [Cupriavidus pinatubonensis] | diamond | 192 | 120 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus pinatubonensis | ||
| 27534515 | 27534515 | PRJNA397065_S_NODE_18643_length_158_cov_2.178295_g18393_i0 | PRJNA397065 | 18643 | 158 | 2.178295 | 3.4417061 | root | 1 | Root_unresolved | Root_unresolved | 106 | 5.539999999999999e-28 | NR | WP_274598201.1 | 470 | g18393 | i0 | 100 | 7.89873417721519 | 52 | 0 | 98.7 | 0 | 1 | 156 | 15 | 66 | WP_274598201.1 3'-5' exonuclease, partial [Acinetobacter baumannii] | diamond | 1248 | 106 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter baumannii | ||
| 27802041 | 27802041 | PRJNA397065_S_NODE_15904_length_179_cov_2.193333_g15654_i0 | PRJNA397065 | 15904 | 179 | 2.193333 | 3.92606607 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 49.7 | 5.54e-5 | NR | WP_029309782.1 | 119219 | g15654 | i0 | 62.2 | 0.620111731843575 | 37 | 14 | 62 | 0 | 68 | 178 | 1 | 37 | WP_029309782.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 111 | 49.7 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 27818846 | 27818846 | PRJNA397065_S_NODE_17544_length_166_cov_1.715328_g17294_i0 | PRJNA397065 | 17544 | 166 | 1.715328 | 2.84744448 | Gammaproteobacteria | 1236 | Bacteria | Bacteria | 117 | 2.4199999999999998e-32 | NR | WP_277922997.1 | 470 | g17294 | i0 | 100 | 1.95180722891566 | 54 | 0 | 97.6 | 0 | 3 | 164 | 58 | 111 | WP_277922997.1 DNA polymerase domain-containing protein, partial [Acinetobacter baumannii] | diamond | 324 | 117 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter baumannii | ||
| 27991504 | 27991504 | PRJNA397065_S_NODE_17985_length_162_cov_3.526316_g17735_i0 | PRJNA397065 | 17985 | 162 | 3.526316 | 5.71263192 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 95.5 | 7.34e-22 | NR | WP_018315006.1 | 1080187 | g17735 | i0 | 79.2 | 0.981481481481482 | 53 | 11 | 98.1 | 0 | 161 | 3 | 196 | 248 | WP_018315006.1 N4-gp56 family major capsid protein [Cupriavidus sp. UYPR2.512] | diamond | 159 | 95.5 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 28212127 | 28212127 | PRJNA397065_S_NODE_18206_length_161_cov_1.780303_g17956_i0 | PRJNA397065 | 18206 | 161 | 1.780303 | 2.86628783 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 88.6 | 1.87e-21 | NR | WP_375199118.1 | 119219 | g17956 | i0 | 94.3 | 0.987577639751553 | 53 | 3 | 98.8 | 0 | 160 | 2 | 3 | 55 | WP_375199118.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 159 | 88.6 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 28528308 | 28528308 | PRJNA397065_S_NODE_11387_length_234_cov_1.146341_g11137_i0 | PRJNA397065 | 11387 | 234 | 1.146341 | 2.68243794 | Burkholderiales bacterium | 1891238 | Bacteria | Bacteria | 118 | 3.25e-29 | NR | MEO8296338.1 | 1891238 | g11137 | i0 | 75.3 | 0.987179487179487 | 77 | 19 | 98.7 | 0 | 232 | 2 | 54 | 130 | MEO8296338.1 hypothetical protein [Burkholderiales bacterium] | diamond | 231 | 118 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiales bacterium | ||||
| 28875418 | 28875418 | PRJNA397065_S_NODE_10908_length_241_cov_9.212264_g10658_i0 | PRJNA397065 | 10908 | 241 | 9.212264 | 22.20155624 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 101 | 3.74e-25 | NR | WP_060784391.1 | 119219 | g10658 | i0 | 100 | 0.622406639004149 | 50 | 0 | 62.2 | 0 | 6 | 155 | 105 | 154 | WP_060784391.1 pilin [Cupriavidus metallidurans] | diamond | 150 | 101 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 29033547 | 29033547 | PRJNA397065_S_NODE_15608_length_181_cov_6.348684_g15358_i0 | PRJNA397065 | 15608 | 181 | 6.348684 | 11.49111804 | Cupriavidus sp. SIMBA_ | 1873897 | Bacteria | Bacteria | 94.7 | 1.32e-23 | NR | WP_410747677.1 | 3085766 | g15358 | i0 | 90.6 | 0.878453038674033 | 53 | 5 | 87.8 | 0 | 1 | 159 | 43 | 95 | WP_410747677.1 hypothetical protein [Cupriavidus sp. SIMBA_020] | diamond | 159 | 94.7 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. SIMBA_020 | ||
| 29349130 | 29349130 | PRJNA397065_S_NODE_15709_length_181_cov_1.539474_g15459_i0 | PRJNA397065 | 15709 | 181 | 1.539474 | 2.78644794 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 102 | 6.670000000000001e-26 | NR | WP_018314989.1 | 1080187 | g15459 | i0 | 81.7 | 0.994475138121547 | 60 | 11 | 99.4 | 0 | 2 | 181 | 41 | 100 | WP_018314989.1 hypothetical protein [Cupriavidus sp. UYPR2.512] | diamond | 180 | 102 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 29538406 | 29538406 | PRJNA397065_S_NODE_13030_length_210_cov_2.303867_g12780_i0 | PRJNA397065 | 13030 | 210 | 2.303867 | 4.8381207 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 51.2 | 4.93e-6 | NR | WP_018315009.1 | 1080187 | g12780 | i0 | 40.6 | 0.985714285714286 | 69 | 37 | 94.3 | 3 | 3 | 200 | 30 | 97 | WP_018315009.1 hypothetical protein [Cupriavidus sp. UYPR2.512] | diamond | 207 | 51.2 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 29949064 | 29949064 | PRJNA397065_S_NODE_18531_length_159_cov_1.446154_g18281_i0 | PRJNA397065 | 18531 | 159 | 1.446154 | 2.29938486 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 49.3 | 5.93e-5 | NR | WP_051723089.1 | 119219 | g18281 | i0 | 45.3 | 1 | 53 | 29 | 100 | 0 | 1 | 159 | 25 | 77 | WP_051723089.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 159 | 49.3 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 30423283 | 30423283 | PRJNA397065_S_NODE_19633_length_152_cov_1.471545_g19383_i0 | PRJNA397065 | 19633 | 152 | 1.471545 | 2.2367484 | Cupriavidus sp. UYPR2.512 | 1080187 | Bacteria | Bacteria | 84.3 | 2.33e-17 | NR | WP_081624057.1 | 1080187 | g19383 | i0 | 80 | 0.986842105263158 | 50 | 10 | 98.7 | 0 | 1 | 150 | 3159 | 3208 | WP_081624057.1 PLxRFG domain-containing protein [Cupriavidus sp. UYPR2.512] | diamond | 150 | 84.3 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus sp. UYPR2.512 | ||
| 30549260 | 30549260 | PRJNA397065_S_NODE_15673_length_181_cov_2.473684_g15423_i0 | PRJNA397065 | 15673 | 181 | 2.473684 | 4.47736804 | Cupriavidus pinatubonensis | 248026 | Bacteria | Bacteria | 41.2 | 0.00715 | NR | WP_224001239.1 | 248026 | g15423 | i0 | 95 | 0.331491712707182 | 20 | 1 | 33.1 | 0 | 2 | 61 | 38 | 57 | WP_224001239.1 hypothetical protein [Cupriavidus pinatubonensis] | diamond | 60 | 41.2 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus pinatubonensis | ||
| 30913748 | 30913748 | PRJNA397065_S_NODE_19714_length_151_cov_2.311475_g19464_i0 | PRJNA397065 | 19714 | 151 | 2.311475 | 3.49032725 | Betaproteobacteria | 28216 | Bacteria | Bacteria | 40.8 | 0.0499 | NR | WP_175858439.1 | 179879 | g19464 | i0 | 100 | 3.39735099337748 | 19 | 0 | 37.7 | 0 | 93 | 149 | 1 | 19 | WP_175858439.1 type I restriction-modification system subunit M [Burkholderia anthina] | diamond | 513 | 40.8 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Burkholderia | Burkholderia anthina | ||
| 30928565 | 30928565 | PRJNA397065_S_NODE_13574_length_203_cov_1.620690_g13324_i0 | PRJNA397065 | 13574 | 203 | 1.62069 | 3.2900006999999998 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 88.6 | 3.19e-19 | NR | WP_141192944.1 | 119219 | g13324 | i0 | 100 | 2.40886699507389 | 48 | 0 | 70.9 | 0 | 202 | 59 | 240 | 287 | WP_141192944.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 489 | 88.6 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 31023267 | 31023267 | PRJNA397065_S_NODE_17935_length_163_cov_1.395522_g17685_i0 | PRJNA397065 | 17935 | 163 | 1.395522 | 2.27470086 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 106 | 1.03e-25 | NR | WP_231108877.1 | 119219 | g17685 | i0 | 100 | 0.975460122699387 | 53 | 0 | 97.5 | 0 | 161 | 3 | 69 | 121 | WP_231108877.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 159 | 106 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 31086441 | 31086441 | PRJNA397065_S_NODE_14055_length_197_cov_2.982143_g13805_i0 | PRJNA397065 | 14055 | 197 | 2.982143 | 5.87482171 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 128 | 5.57e-34 | NR | WP_231108877.1 | 119219 | g13805 | i0 | 100 | 0.989847715736041 | 65 | 0 | 99 | 0 | 195 | 1 | 2 | 66 | WP_231108877.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 195 | 128 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 31307635 | 31307635 | PRJNA397065_S_NODE_18935_length_156_cov_2.212598_g18685_i0 | PRJNA397065 | 18935 | 156 | 2.212598 | 3.45165288 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 110 | 1.06e-29 | NR | WP_375199121.1 | 119219 | g18685 | i0 | 100 | 1 | 52 | 0 | 100 | 0 | 1 | 156 | 6 | 57 | WP_375199121.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 156 | 110 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans | ||
| 31781973 | 31781973 | PRJNA397065_S_NODE_18397_length_160_cov_1.076336_g18147_i0 | PRJNA397065 | 18397 | 160 | 1.076336 | 1.7221376 | Aminobacter sp. MDW-2 | 2666139 | Bacteria | Bacteria | 87.4 | 2.2e-18 | NR | WP_154384638.1 | 2666139 | g18147 | i0 | 79.2 | 0.99375 | 53 | 11 | 99.4 | 0 | 1 | 159 | 1787 | 1839 | WP_154384638.1 PLxRFG domain-containing protein [Aminobacter sp. MDW-2] | diamond | 159 | 87.4 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Hyphomicrobiales | Phyllobacteriaceae | Aminobacter | Aminobacter sp. MDW-2 | ||
| 32667464 | 32667464 | PRJNA397065_S_NODE_9020_length_281_cov_2.015873_g8770_i0 | PRJNA397065 | 9020 | 281 | 2.015873 | 5.66460313 | Cupriavidus metallidurans | 119219 | Bacteria | Bacteria | 187 | 3.48e-57 | NR | WP_141192944.1 | 119219 | g8770 | i0 | 100 | 1.98576512455516 | 93 | 0 | 99.3 | 0 | 3 | 281 | 124 | 216 | WP_141192944.1 hypothetical protein [Cupriavidus metallidurans] | diamond | 558 | 187 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Cupriavidus | Cupriavidus metallidurans |
Advanced export
JSON shape: default, array, newline-delimited
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);;