contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Deinococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124943 | 124943 | PRJEB58983_P_NODE_27281_length_255_cov_1.714286_g26866_i0 | PRJEB58983 | 27281 | 255 | 1.714286 | 4.3714293 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 119 | 6.66e-29 | NR | WP_034339137.1 | 392413 | g26866 | i0 | 100 | 0.682352941176471 | 58 | 0 | 68.2 | 0 | 2 | 175 | 718 | 775 | WP_034339137.1 3-hydroxyacyl-CoA dehydrogenase/enoyl-CoA hydratase family protein [Deinococcus misasensis] | diamond | 174 | 119 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 124999 | 124999 | PRJEB58983_P_NODE_30181_length_247_cov_1.568966_g29766_i0 | PRJEB58983 | 30181 | 247 | 1.568966 | 3.87534602 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 167 | 4.32e-50 | NR | WP_034344118.1 | 392413 | g29766 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 247 | 2 | 102 | 183 | WP_034344118.1 electron transfer flavoprotein subunit beta/FixA family protein [Deinococcus misasensis] | diamond | 246 | 167 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 1399306 | 1399306 | PRJEB58983_P_NODE_22462_length_277_cov_1.313725_g22047_i0 | PRJEB58983 | 22462 | 277 | 1.313725 | 3.63901825 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 186 | 3.8399999999999997e-53 | NR | WP_188998899.1 | 392414 | g22047 | i0 | 98.9 | 0.996389891696751 | 92 | 1 | 99.6 | 0 | 276 | 1 | 120 | 211 | WP_188998899.1 ATP-dependent Clp protease ATP-binding subunit [Deinococcus roseus] | diamond | 276 | 186 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 1399596 | 1399596 | PRJEB58983_P_NODE_3942_length_614_cov_3.290203_g3536_i0 | PRJEB58983 | 3942 | 614 | 3.290203 | 20.20184642 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 346 | 7.429999999999999e-118 | NR | WP_034334850.1 | 392413 | g3536 | i0 | 97.8 | 0.86970684039088 | 178 | 4 | 87 | 0 | 535 | 2 | 1 | 178 | WP_034334850.1 complex I NDUFA9 subunit family protein [Deinococcus misasensis] | diamond | 534 | 346 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 2674848 | 2674848 | PRJEB58983_P_NODE_18383_length_301_cov_1.271930_g17968_i0 | PRJEB58983 | 18383 | 301 | 1.27193 | 3.8285093 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 186 | 7.949999999999999e-56 | NR | WP_189002451.1 | 392414 | g17968 | i0 | 93.9 | 0.976744186046512 | 98 | 6 | 97.7 | 0 | 299 | 6 | 136 | 233 | WP_189002451.1 BMP family lipoprotein [Deinococcus roseus] | diamond | 294 | 186 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 9920290 | 9920290 | PRJEB58983_P_NODE_16548_length_315_cov_2.723140_g16133_i0 | PRJEB58983 | 16548 | 315 | 2.72314 | 8.577891 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 177 | 1e-55 | NR | WP_034339520.1 | 392413 | g16133 | i0 | 100 | 0.80952380952381 | 85 | 0 | 81 | 0 | 261 | 7 | 1 | 85 | WP_034339520.1 cold-shock protein [Deinococcus misasensis] | diamond | 255 | 177 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 13745516 | 13745516 | PRJEB58983_P_NODE_17651_length_306_cov_2.592275_g17236_i0 | PRJEB58983 | 17651 | 306 | 2.592275 | 7.9323615 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 186 | 2.39e-53 | NR | WP_034340944.1 | 392413 | g17236 | i0 | 99 | 0.990196078431373 | 101 | 1 | 99 | 0 | 2 | 304 | 385 | 485 | WP_034340944.1 ATP-binding protein [Deinococcus misasensis] | diamond | 303 | 186 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 19250619 | 19250619 | PRJEB58983_P_NODE_31656_length_244_cov_0.888889_g31241_i0 | PRJEB58983 | 31656 | 244 | 0.888889 | 2.16888916 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 128 | 6.49e-36 | NR | WP_034342016.1 | 392413 | g31241 | i0 | 95.5 | 0.823770491803279 | 67 | 3 | 82.4 | 0 | 243 | 43 | 86 | 152 | WP_034342016.1 hypothetical protein [Deinococcus misasensis] | diamond | 201 | 128 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 27065139 | 27065139 | PRJEB58983_P_NODE_5342_length_532_cov_2.047930_g4929_i0 | PRJEB58983 | 5342 | 532 | 2.04793 | 10.8949876 | Deinococcus cellulosilyticus | 401558 | Bacteria | Bacteria | 162 | 1.9999999999999998e-42 | NR | WP_146891557.1 | 401558 | g4929 | i0 | 48.4 | 1.06015037593985 | 188 | 70 | 93.6 | 3 | 500 | 3 | 718 | 900 | WP_146891557.1 S-layer homology domain-containing protein [Deinococcus cellulosilyticus] | diamond | 564 | 162 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cellulosilyticus | ||
| 27128009 | 27128009 | PRJEB58983_P_NODE_9522_length_404_cov_2.290030_g9108_i0 | PRJEB58983 | 9522 | 404 | 2.29003 | 9.2517212 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 265 | 1.75e-83 | NR | WP_245618372.1 | 392413 | g9108 | i0 | 98.5 | 0.995049504950495 | 134 | 2 | 99.5 | 0 | 2 | 403 | 406 | 539 | WP_245618372.1 ABC transporter substrate-binding protein [Deinococcus misasensis] | diamond | 402 | 265 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 27318228 | 27318228 | PRJEB58983_P_NODE_4043_length_607_cov_2.086142_g3636_i0 | PRJEB58983 | 4043 | 607 | 2.086142 | 12.66288194 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 83.2 | 1.4e-14 | NR | WP_034343365.1 | 392413 | g3636 | i0 | 93.3 | 1.17133443163097 | 193 | 13 | 95.4 | 0 | 28 | 606 | 231 | 423 | WP_034343365.1 S-layer homology domain-containing protein [Deinococcus misasensis] | diamond | 711 | 83.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 27343143 | 27343143 | PRJEB58983_P_NODE_26163_length_260_cov_1.245989_g25748_i0 | PRJEB58983 | 26163 | 260 | 1.245989 | 3.2395714 | Deinococcus | 1298 | Bacteria | Bacteria | 90.5 | 7.24e-19 | NR | WP_291428517.1 | 47478 | g25748 | i0 | 57.1 | 2.90769230769231 | 84 | 35 | 96.9 | 1 | 1 | 252 | 161 | 243 | WP_291428517.1 hypothetical protein [Deinococcus sp.] | diamond | 756 | 90.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 27539264 | 27539264 | PRJEB58983_P_NODE_8064_length_436_cov_2.820937_g7650_i0 | PRJEB58983 | 8064 | 436 | 2.820937 | 12.29928532 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 189 | 1.6499999999999996e-52 | NR | WP_034343365.1 | 392413 | g7650 | i0 | 67.1 | 2.00229357798165 | 146 | 47 | 99.8 | 1 | 435 | 1 | 941 | 1086 | WP_034343365.1 S-layer homology domain-containing protein [Deinococcus misasensis] | diamond | 873 | 189 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 27728980 | 27728980 | PRJEB58983_P_NODE_27484_length_254_cov_2.149171_g27069_i0 | PRJEB58983 | 27484 | 254 | 2.149171 | 5.45889434 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 155 | 7.399999999999998e-44 | NR | WP_342668530.1 | 392413 | g27069 | i0 | 98.8 | 0.992125984251969 | 84 | 1 | 99.2 | 0 | 253 | 2 | 183 | 266 | WP_342668530.1 ABC transporter permease [Deinococcus misasensis] | diamond | 252 | 155 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 27760499 | 27760499 | PRJEB58983_P_NODE_27504_length_254_cov_1.928177_g27089_i0 | PRJEB58983 | 27504 | 254 | 1.928177 | 4.89756958 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 144 | 4.97e-40 | NR | WP_034341371.1 | 392413 | g27089 | i0 | 100 | 0.874015748031496 | 74 | 0 | 87.4 | 0 | 2 | 223 | 165 | 238 | WP_034341371.1 DNA-directed RNA polymerase subunit alpha [Deinococcus misasensis] | diamond | 222 | 144 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 27791860 | 27791860 | PRJEB58983_P_NODE_29504_length_249_cov_0.886364_g29089_i0 | PRJEB58983 | 29504 | 249 | 0.886364 | 2.20704636 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 154 | 2.0999999999999996e-41 | NR | WP_034344668.1 | 392413 | g29089 | i0 | 92.7 | 0.987951807228916 | 82 | 6 | 98.8 | 0 | 3 | 248 | 205 | 286 | WP_034344668.1 BamA/OMP85 family outer membrane protein [Deinococcus misasensis] | diamond | 246 | 154 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 28075811 | 28075811 | PRJEB58983_P_NODE_9765_length_399_cov_2.487730_g9351_i0 | PRJEB58983 | 9765 | 399 | 2.48773 | 9.9260427 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 255 | 3.01e-83 | NR | WP_034334850.1 | 392413 | g9351 | i0 | 98.4 | 0.93984962406015 | 125 | 2 | 94 | 0 | 3 | 377 | 168 | 292 | WP_034334850.1 complex I NDUFA9 subunit family protein [Deinococcus misasensis] | diamond | 375 | 255 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 28328403 | 28328403 | PRJEB58983_P_NODE_28926_length_250_cov_1.502825_g28511_i0 | PRJEB58983 | 28926 | 250 | 1.502825 | 3.7570625 | Deinococcus sedimenti | 1867090 | Bacteria | Bacteria | 115 | 7.55e-32 | NR | WP_189071260.1 | 1867090 | g28511 | i0 | 91.8 | 0.732 | 61 | 5 | 73.2 | 0 | 25 | 207 | 1 | 61 | WP_189071260.1 hypothetical protein [Deinococcus sedimenti] | diamond | 183 | 115 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sedimenti | ||
| 29591098 | 29591098 | PRJEB58983_P_NODE_20730_length_286_cov_1.309859_g20315_i0 | PRJEB58983 | 20730 | 286 | 1.309859 | 3.74619674 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 185 | 1.67e-56 | NR | WP_034338184.1 | 392413 | g20315 | i0 | 100 | 0.996503496503496 | 95 | 0 | 99.7 | 0 | 285 | 1 | 34 | 128 | WP_034338184.1 enoyl-CoA hydratase/isomerase family protein [Deinococcus misasensis] | diamond | 285 | 185 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 29812342 | 29812342 | PRJEB58983_P_NODE_22631_length_276_cov_1.793103_g22216_i0 | PRJEB58983 | 22631 | 276 | 1.793103 | 4.94896428 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 179 | 3.99e-53 | NR | WP_229684824.1 | 392414 | g22216 | i0 | 95.7 | 1 | 92 | 4 | 100 | 0 | 276 | 1 | 147 | 238 | WP_229684824.1 urea ABC transporter substrate-binding protein [Deinococcus roseus] | diamond | 276 | 179 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 30223125 | 30223125 | PRJEB58983_P_NODE_4612_length_570_cov_2.378270_g4203_i0 | PRJEB58983 | 4612 | 570 | 2.37827 | 13.556139 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 224 | 3.8e-64 | NR | WP_034343365.1 | 392413 | g4203 | i0 | 90.4 | 0.989473684210526 | 188 | 18 | 98.9 | 0 | 568 | 5 | 25 | 212 | WP_034343365.1 S-layer homology domain-containing protein [Deinococcus misasensis] | diamond | 564 | 224 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 30350098 | 30350098 | PRJEB58983_P_NODE_13612_length_343_cov_4.822222_g13197_i0 | PRJEB58983 | 13612 | 343 | 4.822222 | 16.54022146 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 223 | 6.329999999999999e-72 | NR | WP_051963039.1 | 392413 | g13197 | i0 | 100 | 0.997084548104956 | 114 | 0 | 99.7 | 0 | 342 | 1 | 77 | 190 | WP_051963039.1 Crp/Fnr family transcriptional regulator [Deinococcus misasensis] | diamond | 342 | 223 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 31202175 | 31202175 | PRJEB58983_P_NODE_26595_length_258_cov_1.578378_g26180_i0 | PRJEB58983 | 26595 | 258 | 1.578378 | 4.07221524 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 147 | 1.69e-40 | NR | WP_034341891.1 | 392413 | g26180 | i0 | 88.4 | 1 | 86 | 10 | 100 | 0 | 1 | 258 | 54 | 139 | WP_034341891.1 type II secretion system F family protein [Deinococcus misasensis] | diamond | 258 | 147 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 31487517 | 31487517 | PRJEB58983_P_NODE_20736_length_286_cov_1.225352_g20321_i0 | PRJEB58983 | 20736 | 286 | 1.225352 | 3.50450672 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 174 | 1.29e-53 | NR | WP_229684872.1 | 392414 | g20321 | i0 | 94.7 | 2.98951048951049 | 95 | 4 | 99.7 | 1 | 1 | 285 | 19 | 112 | WP_229684872.1 extracellular solute-binding protein, partial [Deinococcus roseus] | diamond | 855 | 174 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 31740185 | 31740185 | PRJEB58983_P_NODE_26817_length_257_cov_1.608696_g26402_i0 | PRJEB58983 | 26817 | 257 | 1.608696 | 4.13434872 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 160 | 2.19e-43 | NR | WP_169743888.1 | 392413 | g26402 | i0 | 96.5 | 0.992217898832685 | 85 | 3 | 99.2 | 0 | 3 | 257 | 677 | 761 | WP_169743888.1 FtsX-like permease family protein [Deinococcus misasensis] | diamond | 255 | 160 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 31993396 | 31993396 | PRJEB58983_P_NODE_29858_length_248_cov_0.891429_g29443_i0 | PRJEB58983 | 29858 | 248 | 0.891429 | 2.21074392 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 167 | 5.83e-51 | NR | WP_034342783.1 | 392413 | g29443 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 3 | 248 | 29 | 110 | WP_034342783.1 LEA type 2 family protein [Deinococcus misasensis] | diamond | 246 | 167 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 32436693 | 32436693 | PRJEB58983_P_NODE_22779_length_275_cov_2.673267_g22364_i0 | PRJEB58983 | 22779 | 275 | 2.673267 | 7.35148425 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 126 | 2.88e-33 | NR | WP_189005853.1 | 392414 | g22364 | i0 | 95.3 | 0.698181818181818 | 64 | 3 | 69.8 | 0 | 275 | 84 | 243 | 306 | WP_189005853.1 GTP cyclohydrolase FolE2 [Deinococcus roseus] | diamond | 192 | 126 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 32563226 | 32563226 | PRJEB58983_P_NODE_9519_length_404_cov_2.498489_g9105_i0 | PRJEB58983 | 9519 | 404 | 2.498489 | 10.09389556 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 146 | 9.85e-38 | NR | WP_034343365.1 | 392413 | g9105 | i0 | 62.1 | 0.98019801980198 | 132 | 44 | 96.5 | 4 | 402 | 13 | 591 | 718 | WP_034343365.1 S-layer homology domain-containing protein [Deinococcus misasensis] | diamond | 396 | 146 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis | ||
| 32657101 | 32657101 | PRJEB58983_P_NODE_23060_length_274_cov_1.562189_g22645_i0 | PRJEB58983 | 23060 | 274 | 1.562189 | 4.28039786 | Deinococcus misasensis | 392413 | Bacteria | Bacteria | 187 | 1.3e-55 | NR | WP_034340354.1 | 392413 | g22645 | i0 | 100 | 0.985401459854015 | 90 | 0 | 98.5 | 0 | 3 | 272 | 60 | 149 | WP_034340354.1 allantoinase AllB [Deinococcus misasensis] | diamond | 270 | 187 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus misasensis |
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);;