contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA756891" and tax_phylum = "Endomyxa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5030524 | 5030524 | PRJNA756891_P_NODE_13004_length_249_cov_0.875000_g12935_i0 | PRJNA756891 | 13004 | 249 | 0.875 | 2.17875 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 2.45e-21 | NR | CEP01042.1 | 37360 | g12935 | i0 | 57.8 | 2.28915662650602 | 90 | 30 | 98.8 | 2 | 247 | 2 | 182 | 271 | CEP01042.1 hypothetical protein PBRA_008354 [Plasmodiophora brassicae] | diamond | 570 | 97.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 17779997 | 17779997 | PRJNA756891_P_NODE_1714_length_628_cov_13.090090_g1647_i0 | PRJNA756891 | 1714 | 628 | 13.09009 | 82.2057652 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.7099999999999998e-47 | NR | SPQ93437.1 | 37360 | g1647 | i0 | 68.1 | 2.19745222929936 | 119 | 36 | 56.8 | 1 | 12 | 368 | 32 | 148 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 1380 | 163 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27473609 | 27473609 | PRJNA756891_P_NODE_6143_length_344_cov_1.568266_g6074_i0 | PRJNA756891 | 6143 | 344 | 1.568266 | 5.39483504 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.11e-51 | NR | CEO94730.1 | 37360 | g6074 | i0 | 66.7 | 11.9302325581395 | 114 | 38 | 99.4 | 0 | 3 | 344 | 6 | 119 | CEO94730.1 hypothetical protein PBRA_000516 [Plasmodiophora brassicae] | diamond | 4104 | 171 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27536773 | 27536773 | PRJNA756891_P_NODE_5663_length_357_cov_1.056338_g5594_i0 | PRJNA756891 | 5663 | 357 | 1.056338 | 3.77112666 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 3.62e-42 | NR | AVG22652.1 | 37360 | g5594 | i0 | 58.8 | 6.94957983193277 | 119 | 48 | 99.2 | 1 | 357 | 4 | 132 | 250 | AVG22652.1 MAPKKK5 [Plasmodiophora brassicae] | diamond | 2481 | 158 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28095198 | 28095198 | PRJNA756891_P_NODE_1725_length_627_cov_2.698556_g1658_i0 | PRJNA756891 | 1725 | 627 | 2.698556 | 16.91994612 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 1.19e-53 | NR | CEO99213.1 | 37360 | g1658 | i0 | 51.9 | 2.96172248803828 | 206 | 95 | 98.1 | 3 | 2 | 616 | 129 | 331 | CEO99213.1 hypothetical protein PBRA_001119 [Plasmodiophora brassicae] | diamond | 1857 | 186 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28547331 | 28547331 | PRJNA756891_P_NODE_16247_length_241_cov_3.434524_g16178_i0 | PRJNA756891 | 16247 | 241 | 3.434524 | 8.27720284 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 1.13e-21 | NR | CEO97381.1 | 37360 | g16178 | i0 | 63.3 | 7.87966804979253 | 79 | 29 | 98.3 | 0 | 2 | 238 | 848 | 926 | CEO97381.1 hypothetical protein PBRA_000726 [Plasmodiophora brassicae] | diamond | 1899 | 98.6 | 0.995943204868154 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29137422 | 29137422 | PRJNA756891_P_NODE_14529_length_245_cov_1.604651_g14460_i0 | PRJNA756891 | 14529 | 245 | 1.604651 | 3.93139495 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.78e-11 | NR | CEP02293.1 | 37360 | g14460 | i0 | 57.4 | 0.661224489795918 | 54 | 23 | 66.1 | 0 | 241 | 80 | 50 | 103 | CEP02293.1 hypothetical protein PBRA_008877 [Plasmodiophora brassicae] | diamond | 162 | 66.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29326510 | 29326510 | PRJNA756891_P_NODE_8469_length_299_cov_1.022124_g8400_i0 | PRJNA756891 | 8469 | 299 | 1.022124 | 3.05615076 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 3.67e-7 | NR | CEP03756.1 | 37360 | g8400 | i0 | 52.2 | 0.953177257525084 | 46 | 22 | 46.2 | 0 | 3 | 140 | 414 | 459 | CEP03756.1 hypothetical protein PBRA_003363 [Plasmodiophora brassicae] | diamond | 285 | 57.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30369346 | 30369346 | PRJNA756891_P_NODE_3672_length_438_cov_2.208219_g3603_i0 | PRJNA756891 | 3672 | 438 | 2.208219 | 9.67199922 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 2.45e-9 | NR | CEO97710.1 | 37360 | g3603 | i0 | 34 | 2.66438356164384 | 94 | 62 | 64.4 | 0 | 379 | 98 | 21 | 114 | CEO97710.1 hypothetical protein PBRA_005824 [Plasmodiophora brassicae] | diamond | 1167 | 64.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30400959 | 30400959 | PRJNA756891_P_NODE_1413_length_683_cov_4.134426_g1349_i0 | PRJNA756891 | 1413 | 683 | 4.134426 | 28.23812958 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 2.25e-36 | NR | CEO99991.1 | 37360 | g1349 | i0 | 42.8 | 2.10834553440703 | 166 | 86 | 72.9 | 1 | 599 | 102 | 38 | 194 | CEO99991.1 hypothetical protein PBRA_007725 [Plasmodiophora brassicae] | diamond | 1440 | 138 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30526789 | 30526789 | PRJNA756891_P_NODE_12353_length_251_cov_0.865169_g12284_i0 | PRJNA756891 | 12353 | 251 | 0.865169 | 2.17157419 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 6.54e-9 | NR | CEO95993.1 | 37360 | g12284 | i0 | 33.8 | 1.76892430278884 | 74 | 48 | 87.3 | 1 | 242 | 24 | 389 | 462 | CEO95993.1 hypothetical protein PBRA_004683 [Plasmodiophora brassicae] | diamond | 444 | 62 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30726205 | 30726205 | PRJNA756891_P_NODE_5994_length_348_cov_1.400000_g5925_i0 | PRJNA756891 | 5994 | 348 | 1.4 | 4.872 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.18e-25 | NR | CEP03242.1 | 37360 | g5925 | i0 | 50 | 2.81034482758621 | 108 | 54 | 93.1 | 0 | 2 | 325 | 544 | 651 | CEP03242.1 hypothetical protein PBRA_003002 [Plasmodiophora brassicae] | diamond | 978 | 110 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae |
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);;