contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1143173" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8685781 | 8685781 | PRJNA1143173_P_NODE_21067_length_284_cov_1.914692_g21041_i0 | PRJNA1143173 | 21067 | 284 | 1.914692 | 5.43772528 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 184 | 2.7e-56 | NR | WP_092265102.1 | 856736 | g21041 | i0 | 98.9 | 0.992957746478873 | 94 | 1 | 99.3 | 0 | 284 | 3 | 150 | 243 | WP_092265102.1 50S ribosomal protein L11 methyltransferase [Deinococcus reticulitermitis] | diamond | 282 | 184 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 12511549 | 12511549 | PRJNA1143173_P_NODE_41290_length_219_cov_4.479452_g41264_i0 | PRJNA1143173 | 41290 | 219 | 4.479452 | 9.80999988 | Deinococcus sp. SL84 | 2994663 | Bacteria | Bacteria | 113 | 4.49e-29 | NR | WP_268093771.1 | 2994663 | g41264 | i0 | 75 | 0.986301369863014 | 72 | 18 | 98.6 | 0 | 217 | 2 | 31 | 102 | WP_268093771.1 metallophosphoesterase family protein [Deinococcus sp. SL84] | diamond | 216 | 113 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. SL84 | ||
| 13040078 | 13040078 | PRJNA1143173_P_NODE_31751_length_252_cov_12.882682_g31725_i0 | PRJNA1143173 | 31751 | 252 | 12.882682 | 32.46435864 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 84.7 | 8.76e-18 | NR | WP_038064183.1 | 276 | g31725 | i0 | 52.4 | 4.97619047619048 | 84 | 40 | 100 | 0 | 1 | 252 | 69 | 152 | WP_038064183.1 ABC transporter ATP-binding protein [Thermus filiformis] | diamond | 1254 | 85.5 | 0.990643274853801 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus filiformis | ||
| 13040131 | 13040131 | PRJNA1143173_P_NODE_34271_length_245_cov_7.401163_g34245_i0 | PRJNA1143173 | 34271 | 245 | 7.401163 | 18.13284935 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 123 | 1.37e-30 | NR | WP_092265558.1 | 856736 | g34245 | i0 | 75.3 | 0.991836734693878 | 81 | 20 | 99.2 | 0 | 2 | 244 | 35 | 115 | WP_092265558.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Deinococcus reticulitermitis] | diamond | 243 | 123 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 14314831 | 14314831 | PRJNA1143173_P_NODE_11472_length_310_cov_3.008439_g11446_i0 | PRJNA1143173 | 11472 | 310 | 3.008439 | 9.3261609 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 100 | 5.42e-24 | NR | WP_092265472.1 | 856736 | g11446 | i0 | 100 | 0.483870967741935 | 50 | 0 | 48.4 | 0 | 309 | 160 | 84 | 133 | WP_092265472.1 molybdenum cofactor guanylyltransferase [Deinococcus reticulitermitis] | diamond | 150 | 100 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 15060492 | 15060492 | PRJNA1143173_P_NODE_32012_length_252_cov_2.983240_g31986_i0 | PRJNA1143173 | 32012 | 252 | 2.98324 | 7.5177648 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 167 | 5.61e-46 | NR | WP_380075765.1 | 1298767 | g31986 | i0 | 100 | 0.988095238095238 | 83 | 0 | 98.8 | 0 | 3 | 251 | 515 | 597 | WP_380075765.1 ATP-binding protein [Deinococcus antarcticus] | diamond | 249 | 167 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 20159345 | 20159345 | PRJNA1143173_P_NODE_7756_length_310_cov_8.864979_g7730_i0 | PRJNA1143173 | 7756 | 310 | 8.864979 | 27.4814349 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 86.3 | 1.29e-18 | NR | WP_386847111.1 | 536443 | g7730 | i0 | 95.9 | 0.474193548387097 | 49 | 2 | 47.4 | 0 | 149 | 3 | 8 | 56 | WP_386847111.1 GNAT family N-acetyltransferase [Deinococcus taklimakanensis] | diamond | 147 | 86.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 26721796 | 26721796 | PRJNA1143173_P_NODE_17941_length_293_cov_3.722727_g17915_i0 | PRJNA1143173 | 17941 | 293 | 3.722727 | 10.90759011 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 47 | 7e-4 | NR | MDQ3461008.1 | 1913990 | g17915 | i0 | 59 | 0.399317406143345 | 39 | 15 | 38.9 | 1 | 115 | 2 | 1 | 39 | MDQ3461008.1 cupin domain-containing protein [Deinococcota bacterium] | diamond | 117 | 47 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 26721808 | 26721808 | PRJNA1143173_P_NODE_29321_length_259_cov_8.532258_g29295_i0 | PRJNA1143173 | 29321 | 259 | 8.532258 | 22.09854822 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 183 | 1.15e-52 | NR | WP_380080996.1 | 1298767 | g29295 | i0 | 100 | 0.996138996138996 | 86 | 0 | 99.6 | 0 | 259 | 2 | 28 | 113 | WP_380080996.1 malto-oligosyltrehalose trehalohydrolase [Deinococcus antarcticus] | diamond | 258 | 183 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 26943754 | 26943754 | PRJNA1143173_P_NODE_24562_length_273_cov_6.380000_g24536_i0 | PRJNA1143173 | 24562 | 273 | 6.38 | 17.4174 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 85.9 | 2.59e-17 | NR | MEX2534527.1 | 2026798 | g24536 | i0 | 58.5 | 2.14285714285714 | 65 | 27 | 71.4 | 0 | 271 | 77 | 349 | 413 | MEX2534527.1 CoA transferase [Trueperaceae bacterium] | diamond | 585 | 85.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 26975465 | 26975465 | PRJNA1143173_P_NODE_23302_length_277_cov_3.990196_g23276_i0 | PRJNA1143173 | 23302 | 277 | 3.990196 | 11.05284292 | Deinococcus sp. HSC-46F16 | 2910968 | Bacteria | Bacteria | 188 | 7.889999999999998e-54 | NR | WP_253581142.1 | 2910968 | g23276 | i0 | 100 | 0.985559566787004 | 91 | 0 | 98.6 | 0 | 3 | 275 | 245 | 335 | WP_253581142.1 GAF domain-containing protein [Deinococcus sp. HSC-46F16] | diamond | 273 | 188 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. HSC-46F16 | ||
| 27859963 | 27859963 | PRJNA1143173_P_NODE_35385_length_242_cov_5.171598_g35359_i0 | PRJNA1143173 | 35385 | 242 | 5.171598 | 12.51526716 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 124 | 1.27e-34 | NR | WP_380077009.1 | 1298767 | g35359 | i0 | 96.8 | 0.768595041322314 | 62 | 2 | 76.9 | 0 | 187 | 2 | 1 | 62 | WP_380077009.1 type II toxin-antitoxin system PemK/MazF family toxin [Deinococcus antarcticus] | diamond | 186 | 124 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 27859967 | 27859967 | PRJNA1143173_P_NODE_37565_length_235_cov_3.598765_g37539_i0 | PRJNA1143173 | 37565 | 235 | 3.598765 | 8.45709775 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 77.4 | 1.68e-15 | NR | WP_380078643.1 | 1298767 | g37539 | i0 | 100 | 0.497872340425532 | 39 | 0 | 49.8 | 0 | 234 | 118 | 149 | 187 | WP_380078643.1 YIP1 family protein [Deinococcus antarcticus] | diamond | 117 | 77.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 28554919 | 28554919 | PRJNA1143173_P_NODE_40807_length_221_cov_10.391892_g40781_i0 | PRJNA1143173 | 40807 | 221 | 10.391892 | 22.96608132 | Deinococcus sedimenti | 1867090 | Bacteria | Bacteria | 161 | 1.38e-45 | NR | WP_189073034.1 | 1867090 | g40781 | i0 | 100 | 0.990950226244344 | 73 | 0 | 99.1 | 0 | 219 | 1 | 134 | 206 | WP_189073034.1 right-handed parallel beta-helix repeat-containing protein [Deinococcus sedimenti] | diamond | 219 | 161 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sedimenti | ||
| 28838812 | 28838812 | PRJNA1143173_P_NODE_35208_length_243_cov_1.788235_g35182_i0 | PRJNA1143173 | 35208 | 243 | 1.788235 | 4.34541105 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 95.1 | 1.43e-20 | NR | WP_299075832.1 | 1678694 | g35182 | i0 | 63 | 0.901234567901235 | 73 | 27 | 90.1 | 0 | 219 | 1 | 458 | 530 | WP_299075832.1 hypothetical protein [uncultured Fretibacterium sp.] | diamond | 219 | 95.1 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 29312528 | 29312528 | PRJNA1143173_P_NODE_29129_length_260_cov_4.454545_g29103_i0 | PRJNA1143173 | 29129 | 260 | 4.454545 | 11.581817 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 133 | 3.219999999999999e-38 | NR | WP_299081011.1 | 1678694 | g29103 | i0 | 97.1 | 0.796153846153846 | 69 | 2 | 79.6 | 0 | 52 | 258 | 1 | 69 | WP_299081011.1 DUF134 domain-containing protein [uncultured Fretibacterium sp.] | diamond | 207 | 133 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 29691061 | 29691061 | PRJNA1143173_P_NODE_31890_length_252_cov_5.061453_g31864_i0 | PRJNA1143173 | 31890 | 252 | 5.061453 | 12.75486156 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 86.3 | 3.34e-18 | NR | MEX2542718.1 | 2026798 | g31864 | i0 | 57.4 | 1.67857142857143 | 68 | 29 | 81 | 0 | 5 | 208 | 189 | 256 | MEX2542718.1 cytochrome c oxidase assembly protein [Trueperaceae bacterium] | diamond | 423 | 86.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 29849374 | 29849374 | PRJNA1143173_P_NODE_37151_length_236_cov_7.024540_g37125_i0 | PRJNA1143173 | 37151 | 236 | 7.02454 | 16.5779144 | Deinococcus multiflagellatus | 1656887 | Bacteria | Bacteria | 133 | 1.9399999999999997e-37 | NR | WP_380053977.1 | 1656887 | g37125 | i0 | 83.3 | 1.98305084745763 | 78 | 13 | 99.2 | 0 | 235 | 2 | 2 | 79 | WP_380053977.1 DNA cytosine methyltransferase [Deinococcus multiflagellatus] | diamond | 468 | 133 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus multiflagellatus | ||
| 30512716 | 30512716 | PRJNA1143173_P_NODE_34633_length_244_cov_6.713450_g34607_i0 | PRJNA1143173 | 34633 | 244 | 6.71345 | 16.380818 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 173 | 2.1e-53 | NR | WP_380076198.1 | 1298767 | g34607 | i0 | 98.8 | 0.995901639344262 | 81 | 1 | 99.6 | 0 | 244 | 2 | 21 | 101 | WP_380076198.1 GNAT family N-acetyltransferase [Deinococcus antarcticus] | diamond | 243 | 173 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 30923743 | 30923743 | PRJNA1143173_P_NODE_8774_length_310_cov_6.042194_g8748_i0 | PRJNA1143173 | 8774 | 310 | 6.042194 | 18.7308014 | Deinococcus reticulitermitis | 856736 | Bacteria | Bacteria | 183 | 7.6e-52 | NR | WP_092265780.1 | 856736 | g8748 | i0 | 86.4 | 1.06451612903226 | 110 | 7 | 98.7 | 1 | 308 | 3 | 582 | 691 | WP_092265780.1 Eco57I restriction-modification methylase domain-containing protein [Deinococcus reticulitermitis] | diamond | 330 | 183 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 31903659 | 31903659 | PRJNA1143173_P_NODE_7457_length_310_cov_11.729958_g7431_i0 | PRJNA1143173 | 7457 | 310 | 11.729958 | 36.3628698 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 43.5 | 0.0418 | NR | WP_119762921.1 | 2320857 | g7431 | i0 | 78.3 | 0.445161290322581 | 23 | 5 | 22.3 | 0 | 241 | 309 | 1 | 23 | WP_119762921.1 exopolysaccharide biosynthesis polyprenyl glycosylphosphotransferase [Deinococcus cavernae] | diamond | 138 | 43.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 31966865 | 31966865 | PRJNA1143173_P_NODE_37838_length_234_cov_3.627329_g37812_i0 | PRJNA1143173 | 37838 | 234 | 3.627329 | 8.48794986 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 139 | 3.73e-36 | NR | WP_119760012.1 | 2320857 | g37812 | i0 | 93.6 | 1 | 78 | 5 | 100 | 0 | 1 | 234 | 1460 | 1537 | WP_119760012.1 RecQ family ATP-dependent DNA helicase [Deinococcus cavernae] | diamond | 234 | 139 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae | ||
| 32030405 | 32030405 | PRJNA1143173_P_NODE_44858_length_196_cov_4.406504_g44832_i0 | PRJNA1143173 | 44858 | 196 | 4.406504 | 8.63674784 | Deinococcus | 1298 | Bacteria | Bacteria | 74.3 | 6.14e-16 | NR | WP_158591557.1 | 1298 | g44832 | i0 | 100 | 0.596938775510204 | 39 | 0 | 59.7 | 0 | 117 | 1 | 1 | 39 | WP_158591557.1 MULTISPECIES: hypothetical protein [Deinococcus] | diamond | 117 | 74.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 32378417 | 32378417 | PRJNA1143173_P_NODE_39659_length_227_cov_5.512987_g39633_i0 | PRJNA1143173 | 39659 | 227 | 5.512987 | 12.51448049 | Deinococcus fonticola | 2528713 | Bacteria | Bacteria | 125 | 6.399999999999999e-32 | NR | WP_135228191.1 | 2528713 | g39633 | i0 | 87.8 | 0.977973568281938 | 74 | 9 | 97.8 | 0 | 5 | 226 | 99 | 172 | WP_135228191.1 hemolysin family protein [Deinococcus fonticola] | diamond | 222 | 125 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus fonticola |
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);;