contig_metadata
11 rows where bioproject = "PRJNA533114", tax_kingdom = "Thermotogati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 504587 | 504587 | PRJNA533114_P_NODE_118981_length_241_cov_1.672619_g118729_i0 | PRJNA533114 | 118981 | 241 | 1.672619 | 4.03101179 | Deinococcus sonorensis | 309891 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2745307249|gb|CP158299.1| | 694439 | g118729 | i0 | 96.875 | 0.132780082987552 | 32 | 0 | 13 | 1 | 97 | 128 | 2506489 | 2506459 | Deinococcus sonorensis KR-87 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sonorensis | ||
| 3056479 | 3056479 | PRJNA533114_P_NODE_78483_length_273_cov_4.875000_g78231_i0 | PRJNA533114 | 78483 | 273 | 4.875 | 13.30875 | Deinococcus sonorensis | 309891 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2745307249|gb|CP158299.1| | 694439 | g78231 | i0 | 96.774 | 0.113553113553114 | 31 | 1 | 11 | 0 | 83 | 113 | 2384270 | 2384300 | Deinococcus sonorensis KR-87 chromosome, complete genome | blastn | 31 | 52.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sonorensis | ||
| 18969114 | 18969114 | PRJNA533114_P_NODE_86475_length_261_cov_1.638298_g86223_i0 | PRJNA533114 | 86475 | 261 | 1.638298 | 4.27595778 | Deinococcus | 1298 | Bacteria | Bacteria | 477 | 3.3099999999999986e-130 | NTclustered | gi|2113031129|gb|OK500351.1| | 47478 | g86223 | i0 | 99.617 | 104 | 261 | 1 | 100 | 0 | 1 | 261 | 491 | 751 | Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence | blastn | 27144 | 477 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 |
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);;