contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26602591 | 26602591 | PRJNA533114_P_NODE_33981_length_394_cov_1.738318_g33729_i0 | PRJNA533114 | 33981 | 394 | 1.738318 | 6.84897292 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 58.9 | 4.36e-7 | NR | MBQ7221748.1 | 2053624 | g33729 | i0 | 36.3 | 0.944162436548223 | 124 | 66 | 93.7 | 4 | 392 | 24 | 558 | 669 | MBQ7221748.1 putative Ig domain-containing protein [Synergistaceae bacterium] | diamond | 372 | 58.9 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 26697781 | 26697781 | PRJNA533114_P_NODE_83901_length_265_cov_1.604167_g83649_i0 | PRJNA533114 | 83901 | 265 | 1.604167 | 4.25104255 | Deinococcus roseus | 392414 | Bacteria | Bacteria | 95.1 | 1.8e-20 | NR | WP_229684590.1 | 392414 | g83649 | i0 | 68.9 | 0.690566037735849 | 61 | 19 | 69.1 | 0 | 185 | 3 | 352 | 412 | WP_229684590.1 glycosyl hydrolase family 18 protein [Deinococcus roseus] | diamond | 183 | 95.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus roseus | ||
| 26934486 | 26934486 | PRJNA533114_P_NODE_97442_length_250_cov_0.870056_g97190_i0 | PRJNA533114 | 97442 | 250 | 0.870056 | 2.17514 | Deinococcus | 1298 | Bacteria | Bacteria | 135 | 4.28e-35 | NR | WP_409737543.1 | 47478 | g97190 | i0 | 81.9 | 5.976 | 83 | 14 | 99.6 | 1 | 2 | 250 | 59 | 140 | WP_409737543.1 hypothetical protein [Deinococcus sp.] | diamond | 1494 | 135 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 27488499 | 27488499 | PRJNA533114_P_NODE_35903_length_384_cov_2.228296_g35651_i0 | PRJNA533114 | 35903 | 384 | 2.228296 | 8.55665664 | Deinococcus sp. Arct2-2 | 2568653 | Bacteria | Bacteria | 48.5 | 0.00168 | NR | WP_136364215.1 | 2568653 | g35651 | i0 | 30 | 1.234375 | 100 | 58 | 75.8 | 3 | 71 | 361 | 700 | 790 | WP_136364215.1 NPCBM/NEW2 domain-containing protein [Deinococcus sp. Arct2-2] | diamond | 474 | 48.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. Arct2-2 | ||
| 27945535 | 27945535 | PRJNA533114_P_NODE_100645_length_248_cov_1.760000_g100393_i0 | PRJNA533114 | 100645 | 248 | 1.76 | 4.3648 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 4.76e-9 | NR | WP_073072295.1 | 238991 | g100393 | i0 | 78.4 | 0.895161290322581 | 37 | 8 | 44.8 | 0 | 134 | 244 | 13 | 49 | WP_073072295.1 macro domain-containing protein [Thermosipho atlanticus] | diamond | 222 | 61.2 | 0.993464052287582 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho atlanticus | ||
| 28056698 | 28056698 | PRJNA533114_P_NODE_54885_length_320_cov_1.226721_g54633_i0 | PRJNA533114 | 54885 | 320 | 1.226721 | 3.9255072 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 48.1 | 0.00115 | NR | MDZ7704734.1 | 2026798 | g54633 | i0 | 46.2 | 0.4875 | 52 | 28 | 48.8 | 0 | 157 | 2 | 77 | 128 | MDZ7704734.1 long-chain fatty acid--CoA ligase [Trueperaceae bacterium] | diamond | 156 | 48.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 28292695 | 28292695 | PRJNA533114_P_NODE_22606_length_477_cov_1.371287_g22356_i0 | PRJNA533114 | 22606 | 477 | 1.371287 | 6.54103899 | Thermotogae | 188708 | Bacteria | Bacteria | 66.2 | 3.71e-10 | NR | WP_072864000.1 | 287990 | g22356 | i0 | 49.3 | 1.27672955974843 | 69 | 29 | 42.8 | 2 | 412 | 209 | 24 | 87 | WP_072864000.1 hypoxanthine phosphoribosyltransferase [Marinitoga hydrogenitolerans] | diamond | 609 | 66.2 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Marinitoga | Marinitoga hydrogenitolerans | ||
| 28355865 | 28355865 | PRJNA533114_P_NODE_12526_length_639_cov_1.531802_g12285_i0 | PRJNA533114 | 12526 | 639 | 1.531802 | 9.78821478 | root | 1 | Root_unresolved | Root_unresolved | 103 | 1.95e-24 | NR | WP_128080917.1 | 2335 | g12285 | i0 | 45.6 | 6.09859154929577 | 125 | 60 | 57.7 | 4 | 517 | 149 | 6 | 124 | WP_128080917.1 MULTISPECIES: glycine cleavage system protein GcvH [Thermotoga] | diamond | 3897 | 104 | 0.990384615384615 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | |||
| 28576957 | 28576957 | PRJNA533114_P_NODE_41727_length_360_cov_1.442509_g41475_i0 | PRJNA533114 | 41727 | 360 | 1.442509 | 5.1930324 | Nitrospinota/Tectimicrobiota group | 1802340 | Bacteria | Bacteria | 81.6 | 2.96e-16 | NR | WP_092264064.1 | 856736 | g41475 | i0 | 45.7 | 7.28333333333333 | 92 | 46 | 76.7 | 1 | 3 | 278 | 4 | 91 | WP_092264064.1 MIP/aquaporin family protein [Deinococcus reticulitermitis] | diamond | 2622 | 82.4 | 0.990291262135922 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus reticulitermitis | ||
| 28956098 | 28956098 | PRJNA533114_P_NODE_10828_length_686_cov_1.582382_g10595_i0 | PRJNA533114 | 10828 | 686 | 1.582382 | 10.85514052 | Bacteria | 2 | Bacteria | Bacteria | 61.6 | 8.92e-8 | NR | MDR2137471.1 | 2053624 | g10595 | i0 | 43.8 | 1.66180758017493 | 80 | 33 | 31.5 | 3 | 221 | 6 | 23 | 98 | MDR2137471.1 TerD family protein [Synergistaceae bacterium] | diamond | 1140 | 61.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 29509134 | 29509134 | PRJNA533114_P_NODE_51470_length_329_cov_1.203125_g51218_i0 | PRJNA533114 | 51470 | 329 | 1.203125 | 3.95828125 | Deinococcus sp. QL22 | 2939437 | Bacteria | Bacteria | 47 | 0.00333 | NR | WP_249396030.1 | 2939437 | g51218 | i0 | 31.6 | 0.893617021276596 | 98 | 57 | 88.4 | 3 | 30 | 320 | 696 | 784 | WP_249396030.1 NPCBM/NEW2 domain-containing protein [Deinococcus sp. QL22] | diamond | 294 | 47 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. QL22 | ||
| 29524302 | 29524302 | PRJNA533114_P_NODE_93630_length_251_cov_0.865169_g93378_i0 | PRJNA533114 | 93630 | 251 | 0.865169 | 2.17157419 | Thermotogales | 2419 | Bacteria | Bacteria | 60.1 | 5.98e-9 | NR | WP_013931643.1 | 119394 | g93378 | i0 | 41.9 | 2.53386454183267 | 62 | 36 | 74.1 | 0 | 58 | 243 | 26 | 87 | WP_013931643.1 tetratricopeptide repeat protein [Pseudothermotoga thermarum] | diamond | 636 | 60.5 | 0.993388429752066 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Pseudothermotoga | Pseudothermotoga thermarum | ||
| 30267512 | 30267512 | PRJNA533114_P_NODE_119732_length_241_cov_0.916667_g119480_i0 | PRJNA533114 | 119732 | 241 | 0.916667 | 2.20916747 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 81.3 | 6.23e-16 | NR | WP_353542684.1 | 457454 | g119480 | i0 | 100 | 0.485477178423237 | 39 | 0 | 48.5 | 0 | 118 | 2 | 1 | 39 | WP_353542684.1 catalase family protein [Deinococcus xinjiangensis] | diamond | 117 | 81.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 30440414 | 30440414 | PRJNA533114_P_NODE_96213_length_250_cov_0.870056_g95961_i0 | PRJNA533114 | 96213 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 83.2 | 1.13e-16 | NR | MDQ3397887.1 | 1913990 | g95961 | i0 | 69.2 | 3.732 | 52 | 16 | 62.4 | 0 | 2 | 157 | 284 | 335 | MDQ3397887.1 aldo/keto reductase [Deinococcota bacterium] | diamond | 933 | 83.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 31721172 | 31721172 | PRJNA533114_P_NODE_36077_length_383_cov_3.890323_g35825_i0 | PRJNA533114 | 36077 | 383 | 3.890323 | 14.89993709 | unclassified Marinitoga | 2640159 | Bacteria | Bacteria | 63.2 | 4.59e-10 | NR | WP_047265677.1 | 2640159 | g35825 | i0 | 50.9 | 0.430809399477807 | 55 | 27 | 43.1 | 0 | 383 | 219 | 34 | 88 | WP_047265677.1 MULTISPECIES: 30S ribosomal protein S17 [unclassified Marinitoga] | diamond | 165 | 63.2 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Marinitoga | |||
| 31957569 | 31957569 | PRJNA533114_P_NODE_2837_length_1227_cov_4.104853_g2706_i0 | PRJNA533114 | 2837 | 1227 | 4.104853 | 50.36654631 | Bacteria | 2 | Bacteria | Bacteria | 51.6 | 1.7e-4 | NR | WP_296906451.1 | 28240 | g2706 | i0 | 44.8 | 0.855745721271394 | 58 | 28 | 14.2 | 1 | 817 | 644 | 22 | 75 | WP_296906451.1 acyl carrier protein [Thermotoga sp.] | diamond | 1050 | 51.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga sp. |
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);;