contig_metadata
23 rows where bioproject = "PRJNA692200", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3223835 | 3223835 | PRJNA692200_S_NODE_563_length_494_cov_120.620225_g527_i0 | PRJNA692200 | 563 | 494 | 120.620225 | 595.8639115 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 2.79e-29 | NR | CEP01219.1 | 37360 | g527 | i0 | 71.3 | 3.61336032388664 | 80 | 17 | 44.9 | 1 | 494 | 273 | 239 | 318 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 1785 | 120 | 0.991666666666667 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 3731109 | 3731109 | PRJNA692200_S_NODE_4823_length_292_cov_6.283951_g4766_i0 | PRJNA692200 | 4823 | 292 | 6.283951 | 18.34913692 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 1.13e-23 | NR | SPQ93437.1 | 37360 | g4766 | i0 | 64.3 | 1.43835616438356 | 70 | 25 | 71.9 | 0 | 287 | 78 | 75 | 144 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 420 | 98.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 4500528 | 4500528 | PRJNA692200_S_NODE_104_length_658_cov_7.474548_g85_i0 | PRJNA692200 | 104 | 658 | 7.474548 | 49.18252584 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.12e-42 | NR | CEP03007.1 | 37360 | g85 | i0 | 82.8 | 6.41945288753799 | 87 | 15 | 39.7 | 0 | 652 | 392 | 4 | 90 | CEP03007.1 hypothetical protein PBRA_009225 [Plasmodiophora brassicae] | diamond | 4224 | 150 | 0.993333333333333 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 5776015 | 5776015 | PRJNA692200_S_NODE_105_length_656_cov_12.612850_g86_i0 | PRJNA692200 | 105 | 656 | 12.61285 | 82.740296 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 7.069999999999999e-31 | NR | CEP02379.1 | 37360 | g86 | i0 | 49.6 | 0.644817073170732 | 141 | 68 | 63.1 | 2 | 4 | 417 | 170 | 310 | CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] | diamond | 423 | 125 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9601240 | 9601240 | PRJNA692200_S_NODE_228_length_577_cov_120.348485_g202_i0 | PRJNA692200 | 228 | 577 | 120.348485 | 694.41075845 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.07e-12 | NR | CEO99669.1 | 37360 | g202 | i0 | 66.7 | 0.530329289428076 | 54 | 18 | 28.1 | 0 | 6 | 167 | 12 | 65 | CEO99669.1 hypothetical protein PBRA_007402 [Plasmodiophora brassicae] | diamond | 306 | 70.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 18524938 | 18524938 | PRJNA692200_S_NODE_6795_length_259_cov_1985.852381_g6738_i0 | PRJNA692200 | 6795 | 259 | 1985.852381 | 5143.35766679 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 1.13e-17 | NR | CEO94714.1 | 37360 | g6738 | i0 | 66.7 | 0.72972972972973 | 63 | 21 | 73 | 0 | 257 | 69 | 521 | 583 | CEO94714.1 hypothetical protein PBRA_000500, partial [Plasmodiophora brassicae] | diamond | 189 | 87 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 22350304 | 22350304 | PRJNA692200_S_NODE_718_length_472_cov_1477.676123_g680_i0 | PRJNA692200 | 718 | 472 | 1477.676123 | 6974.6313005600005 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 7.22e-15 | NR | CEO99151.1 | 37360 | g680 | i0 | 90.2 | 0.260593220338983 | 41 | 4 | 26.1 | 0 | 2 | 124 | 106 | 146 | CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae] | diamond | 123 | 77.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 23625232 | 23625232 | PRJNA692200_S_NODE_10879_length_215_cov_6.259036_g10822_i0 | PRJNA692200 | 10879 | 215 | 6.259036 | 13.4569274 | Polymyxa betae | 41456 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.08e-39 | NTclustered | gi|2127897050|ref|NC_059071.1| | 41456 | g10822 | i0 | 89.437 | 72.8697674418605 | 142 | 12 | 65 | 3 | 3 | 142 | 20021 | 20161 | Polymyxa betae isolate A26-41 genome assembly, organelle: mitochondrion | blastn | 15667 | 176 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 23625576 | 23625576 | PRJNA692200_S_NODE_3819_length_316_cov_7.220974_g3762_i0 | PRJNA692200 | 3819 | 316 | 7.220974 | 22.81827784 | root | 1 | Root_unresolved | Root_unresolved | 127 | 5.31e-33 | NR | SPQ94563.1 | 37360 | g3762 | i0 | 65.9 | 20.373417721519 | 85 | 29 | 80.7 | 0 | 313 | 59 | 237 | 321 | SPQ94563.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 6438 | 127 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26607561 | 26607561 | PRJNA692200_S_NODE_11321_length_212_cov_1.619632_g11264_i0 | PRJNA692200 | 11321 | 212 | 1.619632 | 3.43361984 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 1.48e-24 | NR | CEO99241.1 | 37360 | g11264 | i0 | 71.6 | 1.81132075471698 | 67 | 19 | 94.8 | 0 | 203 | 3 | 106 | 172 | CEO99241.1 hypothetical protein PBRA_001147 [Plasmodiophora brassicae] | diamond | 384 | 105 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27177208 | 27177208 | PRJNA692200_S_NODE_182_length_601_cov_7.072464_g158_i0 | PRJNA692200 | 182 | 601 | 7.072464 | 42.50550864 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 2.71e-19 | NR | CEP02593.1 | 37360 | g158 | i0 | 63.8 | 0.344425956738769 | 69 | 25 | 34.4 | 0 | 600 | 394 | 34 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 207 | 89.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28199099 | 28199099 | PRJNA692200_S_NODE_10946_length_215_cov_1.530120_g10889_i0 | PRJNA692200 | 10946 | 215 | 1.53012 | 3.289758 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 5.54e-22 | NR | CEP03344.1 | 37360 | g10889 | i0 | 63.8 | 4.42325581395349 | 69 | 25 | 96.3 | 0 | 7 | 213 | 107 | 175 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 951 | 94 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28977495 | 28977495 | PRJNA692200_S_NODE_868_length_456_cov_11.481572_g828_i0 | PRJNA692200 | 868 | 456 | 11.481572 | 52.35596832 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.91e-7 | NR | CEO95143.1 | 37360 | g828 | i0 | 59.6 | 0.342105263157895 | 52 | 19 | 34.2 | 2 | 454 | 299 | 132 | 181 | CEO95143.1 hypothetical protein PBRA_003909 [Plasmodiophora brassicae] | diamond | 156 | 58.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29052006 | 29052006 | PRJNA692200_S_NODE_4188_length_307_cov_2.403101_g4131_i0 | PRJNA692200 | 4188 | 307 | 2.403101 | 7.37752007 | root | 1 | Root_unresolved | Root_unresolved | 162 | 3.72e-49 | NR | CEP02373.1 | 37360 | g4131 | i0 | 78.4 | 9.99674267100977 | 102 | 20 | 99.7 | 1 | 306 | 1 | 11 | 110 | CEP02373.1 hypothetical protein PBRA_008957 [Plasmodiophora brassicae] | diamond | 3069 | 163 | 0.993865030674847 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29450670 | 29450670 | PRJNA692200_S_NODE_9110_length_232_cov_9.311475_g9053_i0 | PRJNA692200 | 9110 | 232 | 9.311475 | 21.602622 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 3.48e-8 | NR | SPQ97132.1 | 37360 | g9053 | i0 | 52.4 | 1.62931034482759 | 63 | 26 | 80.2 | 2 | 231 | 46 | 496 | 555 | SPQ97132.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 378 | 59.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29513925 | 29513925 | PRJNA692200_S_NODE_15030_length_187_cov_7.630435_g14973_i0 | PRJNA692200 | 15030 | 187 | 7.630435 | 14.26891345 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 6.76e-13 | NR | CEO99081.1 | 37360 | g14973 | i0 | 62.8 | 0.689839572192513 | 43 | 16 | 69 | 0 | 3 | 131 | 100 | 142 | CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] | diamond | 129 | 68.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30050838 | 30050838 | PRJNA692200_S_NODE_17851_length_174_cov_1.936000_g17794_i0 | PRJNA692200 | 17851 | 174 | 1.936 | 3.36864 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 6.39e-4 | NR | CEO95879.1 | 37360 | g17794 | i0 | 59.5 | 1.44827586206897 | 42 | 17 | 72.4 | 0 | 169 | 44 | 852 | 893 | CEO95879.1 hypothetical protein PBRA_004592, partial [Plasmodiophora brassicae] | diamond | 252 | 46.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30240599 | 30240599 | PRJNA692200_S_NODE_20412_length_166_cov_0.888889_g20355_i0 | PRJNA692200 | 20412 | 166 | 0.888889 | 1.47555574 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 1.64e-4 | NR | CEO95109.1 | 37360 | g20355 | i0 | 41.5 | 1.73493975903614 | 53 | 31 | 95.8 | 0 | 4 | 162 | 133 | 185 | CEO95109.1 hypothetical protein PBRA_003875 [Plasmodiophora brassicae] | diamond | 288 | 48.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31062300 | 31062300 | PRJNA692200_S_NODE_9655_length_227_cov_1.887640_g9598_i0 | PRJNA692200 | 9655 | 227 | 1.88764 | 4.2849428 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 4.2400000000000005e-21 | NR | CEO95180.1 | 37360 | g9598 | i0 | 66.7 | 1.53303964757709 | 63 | 21 | 83.3 | 0 | 226 | 38 | 535 | 597 | CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] | diamond | 348 | 96.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32232579 | 32232579 | PRJNA692200_S_NODE_8458_length_239_cov_2.468421_g8401_i0 | PRJNA692200 | 8458 | 239 | 2.468421 | 5.89952619 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 2.34e-16 | NR | CEP02444.1 | 37360 | g8401 | i0 | 58.5 | 0.815899581589958 | 65 | 27 | 81.6 | 0 | 234 | 40 | 203 | 267 | CEP02444.1 hypothetical protein PBRA_009028 [Plasmodiophora brassicae] | diamond | 195 | 81.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32390541 | 32390541 | PRJNA692200_S_NODE_20199_length_166_cov_2.179487_g20142_i0 | PRJNA692200 | 20199 | 166 | 2.179487 | 3.61794842 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 1.59e-4 | NR | CEO95571.1 | 37360 | g20142 | i0 | 46.2 | 1.87951807228916 | 52 | 27 | 92.2 | 1 | 6 | 158 | 189 | 240 | CEO95571.1 hypothetical protein PBRA_004297 [Plasmodiophora brassicae] | diamond | 312 | 48.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32485601 | 32485601 | PRJNA692200_S_NODE_12599_length_202_cov_3.071895_g12542_i0 | PRJNA692200 | 12599 | 202 | 3.071895 | 6.2052279 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.71e-9 | NR | SPQ99994.1 | 37360 | g12542 | i0 | 49.1 | 0.846534653465347 | 57 | 29 | 84.7 | 0 | 6 | 176 | 168 | 224 | SPQ99994.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 171 | 62.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32769107 | 32769107 | PRJNA692200_S_NODE_740_length_470_cov_11.465558_g702_i0 | PRJNA692200 | 740 | 470 | 11.465558 | 53.8881226 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.63e-15 | NR | CEO96912.1 | 37360 | g702 | i0 | 62.5 | 2.42553191489362 | 56 | 21 | 35.7 | 0 | 468 | 301 | 167 | 222 | CEO96912.1 hypothetical protein PBRA_005516 [Plasmodiophora brassicae] | diamond | 1140 | 81.3 | 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);;