contig_metadata
22 rows where bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3450099 | 3450099 | PRJNA924320_S_NODE_3703_length_486_cov_1.345538_g3563_i0 | PRJNA924320 | 3703 | 486 | 1.345538 | 6.53931468 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.85e-37 | NR | CEO95778.1 | 37360 | g3563 | i0 | 85.5 | 1.40740740740741 | 76 | 11 | 46.9 | 0 | 484 | 257 | 176 | 251 | CEO95778.1 hypothetical protein PBRA_004491 [Plasmodiophora brassicae] | diamond | 684 | 140 | 0.992857142857143 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 3450336 | 3450336 | PRJNA924320_S_NODE_9843_length_312_cov_1.874525_g9701_i0 | PRJNA924320 | 9843 | 312 | 1.874525 | 5.848518 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 5.52e-32 | NR | CEO96095.1 | 37360 | g9701 | i0 | 54.4 | 0.990384615384615 | 103 | 46 | 99 | 1 | 309 | 1 | 106 | 207 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 309 | 123 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 11102867 | 11102867 | PRJNA924320_S_NODE_4809_length_431_cov_1.997382_g4668_i0 | PRJNA924320 | 4809 | 431 | 1.997382 | 8.60871642 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 8.559999999999999e-53 | NR | CEP00705.1 | 37360 | g4668 | i0 | 61.9 | 35.6380510440835 | 126 | 47 | 87.7 | 1 | 413 | 36 | 5 | 129 | CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae] | diamond | 15360 | 176 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26905446 | 26905446 | PRJNA924320_S_NODE_56541_length_161_cov_1.366071_g56399_i0 | PRJNA924320 | 56541 | 161 | 1.366071 | 2.19937431 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 4.55e-12 | NR | CEO98730.1 | 37360 | g56399 | i0 | 60.4 | 9.91304347826087 | 53 | 20 | 96.9 | 1 | 3 | 158 | 11 | 63 | CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae] | diamond | 1596 | 67.8 | 0.994100294985251 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26992811 | 26992811 | PRJNA924320_S_NODE_36702_length_184_cov_1.059259_g36560_i0 | PRJNA924320 | 36702 | 184 | 1.059259 | 1.94903656 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 5.17e-22 | NR | CEP03344.1 | 37360 | g36560 | i0 | 70.5 | 0.994565217391304 | 61 | 18 | 99.5 | 0 | 183 | 1 | 92 | 152 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 183 | 93.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27561595 | 27561595 | PRJNA924320_S_NODE_4944_length_425_cov_1.888298_g4802_i0 | PRJNA924320 | 4944 | 425 | 1.888298 | 8.0252665 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 1.16e-13 | NR | CEO97289.1 | 37360 | g4802 | i0 | 39.6 | 0.677647058823529 | 96 | 55 | 67.1 | 2 | 41 | 325 | 295 | 388 | CEO97289.1 hypothetical protein PBRA_000634 [Plasmodiophora brassicae] | diamond | 288 | 77.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28066952 | 28066952 | PRJNA924320_S_NODE_14205_length_266_cov_1.783410_g14063_i0 | PRJNA924320 | 14205 | 266 | 1.78341 | 4.7438706 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 5.2100000000000003e-08 | NR | CEO98325.1 | 37360 | g14063 | i0 | 33 | 0.992481203007519 | 88 | 58 | 98.1 | 1 | 265 | 5 | 476 | 563 | CEO98325.1 hypothetical protein PBRA_006439 [Plasmodiophora brassicae] | diamond | 264 | 59.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28856190 | 28856190 | PRJNA924320_S_NODE_18948_length_237_cov_1.085106_g18806_i0 | PRJNA924320 | 18948 | 237 | 1.085106 | 2.57170122 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 3.94e-19 | NR | CEP00524.1 | 37360 | g18806 | i0 | 68.8 | 2.13924050632911 | 64 | 18 | 81 | 1 | 14 | 205 | 4181 | 4242 | CEP00524.1 hypothetical protein PBRA_001578 [Plasmodiophora brassicae] | diamond | 507 | 90.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29266619 | 29266619 | PRJNA924320_S_NODE_21669_length_225_cov_0.869318_g21527_i0 | PRJNA924320 | 21669 | 225 | 0.869318 | 1.9559655 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 4.1e-5 | NR | CEO99637.1 | 37360 | g21527 | i0 | 41.4 | 0.933333333333333 | 70 | 39 | 93.3 | 1 | 13 | 222 | 53 | 120 | CEO99637.1 hypothetical protein PBRA_007370 [Plasmodiophora brassicae] | diamond | 210 | 50.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29715816 | 29715816 | PRJNA924320_S_NODE_8050_length_341_cov_2.972603_g7908_i0 | PRJNA924320 | 8050 | 341 | 2.972603 | 10.13657623 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 2.44e-5 | NR | CEP00542.1 | 37360 | g7908 | i0 | 27 | 3.84457478005865 | 111 | 76 | 93.3 | 2 | 333 | 16 | 325 | 435 | CEP00542.1 hypothetical protein PBRA_001596 [Plasmodiophora brassicae] | diamond | 1311 | 53.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29779223 | 29779223 | PRJNA924320_S_NODE_34171_length_189_cov_1.428571_g34029_i0 | PRJNA924320 | 34171 | 189 | 1.428571 | 2.69999919 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 5.89e-4 | NR | CEP03695.1 | 37360 | g34029 | i0 | 46.9 | 3.34920634920635 | 49 | 26 | 77.8 | 0 | 28 | 174 | 216 | 264 | CEP03695.1 hypothetical protein PBRA_003302, partial [Plasmodiophora brassicae] | diamond | 633 | 47 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30024863 | 30024863 | PRJNA924320_S_NODE_11791_length_288_cov_1.493724_g11649_i0 | PRJNA924320 | 11791 | 288 | 1.493724 | 4.30192512 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 2.68e-30 | NR | SPR00211.1 | 37360 | g11649 | i0 | 59.8 | 2.90625 | 92 | 34 | 92.7 | 2 | 21 | 287 | 37 | 128 | SPR00211.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 837 | 121 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30758682 | 30758682 | PRJNA924320_S_NODE_31374_length_195_cov_1.910959_g31232_i0 | PRJNA924320 | 31374 | 195 | 1.910959 | 3.72637005 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 2.68e-13 | NR | CEP03344.1 | 37360 | g31232 | i0 | 54.7 | 4.92307692307692 | 64 | 29 | 98.5 | 0 | 2 | 193 | 118 | 181 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 960 | 71.6 | 0.994413407821229 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31004230 | 31004230 | PRJNA924320_S_NODE_10594_length_302_cov_2.015810_g10452_i0 | PRJNA924320 | 10594 | 302 | 2.01581 | 6.0877462 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.24e-12 | NR | CEP01202.1 | 37360 | g10452 | i0 | 50 | 1.35099337748344 | 68 | 34 | 67.5 | 0 | 285 | 82 | 104 | 171 | CEP01202.1 hypothetical protein PBRA_008514 [Plasmodiophora brassicae] | diamond | 408 | 70.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31295810 | 31295810 | PRJNA924320_S_NODE_15495_length_257_cov_0.980769_g15353_i0 | PRJNA924320 | 15495 | 257 | 0.980769 | 2.52057633 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 7.2e-12 | NR | CEO94701.1 | 37360 | g15353 | i0 | 43 | 2.98832684824903 | 86 | 48 | 99.2 | 1 | 255 | 1 | 118 | 203 | CEO94701.1 hypothetical protein PBRA_000487 [Plasmodiophora brassicae] | diamond | 768 | 69.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31763043 | 31763043 | PRJNA924320_S_NODE_55357_length_162_cov_0.902655_g55215_i0 | PRJNA924320 | 55357 | 162 | 0.902655 | 1.4623011 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.04e-9 | NR | SPR01560.1 | 37360 | g55215 | i0 | 54 | 0.925925925925926 | 50 | 23 | 92.6 | 0 | 161 | 12 | 662 | 711 | SPR01560.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 150 | 62.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31857862 | 31857862 | PRJNA924320_S_NODE_52657_length_163_cov_2.236842_g52515_i0 | PRJNA924320 | 52657 | 163 | 2.236842 | 3.64605246 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 4.19e-9 | NR | CEP03576.1 | 37360 | g52515 | i0 | 51.9 | 0.957055214723926 | 52 | 25 | 95.7 | 0 | 159 | 4 | 148 | 199 | CEP03576.1 hypothetical protein PBRA_009461 [Plasmodiophora brassicae] | diamond | 156 | 60.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31952765 | 31952765 | PRJNA924320_S_NODE_14997_length_260_cov_1.672986_g14855_i0 | PRJNA924320 | 14997 | 260 | 1.672986 | 4.3497636 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 8.91e-5 | NR | CEO95356.1 | 37360 | g14855 | i0 | 45.2 | 0.715384615384615 | 62 | 34 | 71.5 | 0 | 252 | 67 | 572 | 633 | CEO95356.1 hypothetical protein PBRA_004122 [Plasmodiophora brassicae] | diamond | 186 | 50.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32118442 | 32118442 | PRJNA924320_S_NODE_38178_length_181_cov_1.007576_g38036_i0 | PRJNA924320 | 38178 | 181 | 1.007576 | 1.82371256 | root | 1 | Root_unresolved | Root_unresolved | 73.6 | 8.67e-14 | NR | CEP02444.1 | 37360 | g38036 | i0 | 55 | 1.95580110497238 | 60 | 27 | 99.4 | 0 | 2 | 181 | 152 | 211 | CEP02444.1 hypothetical protein PBRA_009028 [Plasmodiophora brassicae] | diamond | 354 | 73.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32490930 | 32490930 | PRJNA924320_S_NODE_18259_length_240_cov_1.753927_g18117_i0 | PRJNA924320 | 18259 | 240 | 1.753927 | 4.2094248 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 1.63e-14 | NR | CEO98408.1 | 37360 | g18117 | i0 | 37.7 | 2.8 | 77 | 48 | 96.3 | 0 | 240 | 10 | 78 | 154 | CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae] | diamond | 672 | 77.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32585797 | 32585797 | PRJNA924320_S_NODE_26899_length_207_cov_1.601266_g26757_i0 | PRJNA924320 | 26899 | 207 | 1.601266 | 3.31462062 | Marteilia pararefringens | 2184066 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0338 | NR | MEN2495968.1 | 2184066 | g26757 | i0 | 39.7 | 0.840579710144927 | 58 | 33 | 82.6 | 2 | 32 | 202 | 38 | 94 | MEN2495968.1 hypothetical protein [Marteilia pararefringens] | diamond | 174 | 41.2 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Paramyxida | Marteiliidae | Marteilia | Marteilia pararefringens | ||
| 32655443 | 32655443 | PRJNA924320_S_NODE_3040_length_532_cov_2.149068_g2901_i0 | PRJNA924320 | 3040 | 532 | 2.149068 | 11.43304176 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.88e-36 | NR | CEP00552.1 | 37360 | g2901 | i0 | 44.3 | 1.69172932330827 | 149 | 83 | 84 | 0 | 3 | 449 | 136 | 284 | CEP00552.1 hypothetical protein PBRA_001606 [Plasmodiophora brassicae] | diamond | 900 | 137 | 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);;