contig_metadata
14 rows where bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7267729 | 7267729 | PRJNA906294_P_NODE_79186_length_496_cov_5.640662_g75076_i0 | PRJNA906294 | 79186 | 496 | 5.640662 | 27.97768352 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 4.0700000000000005e-73 | NR | CEP00218.1 | 37360 | g75076 | i0 | 70.3 | 2.83064516129032 | 155 | 43 | 91.9 | 1 | 461 | 6 | 7 | 161 | CEP00218.1 hypothetical protein PBRA_007952 [Plasmodiophora brassicae] | diamond | 1404 | 226 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 8539779 | 8539779 | PRJNA906294_P_NODE_168487_length_288_cov_1.316279_g164371_i0 | PRJNA906294 | 168487 | 288 | 1.316279 | 3.79088352 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 3.87e-47 | NR | SPQ96286.1 | 37360 | g164371 | i0 | 86.3 | 1.97916666666667 | 95 | 13 | 99 | 0 | 287 | 3 | 107 | 201 | SPQ96286.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 570 | 166 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 14002875 | 14002875 | PRJNA906294_P_NODE_59731_length_616_cov_3.970534_g55668_i0 | PRJNA906294 | 59731 | 616 | 3.970534 | 24.45848944 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 210 | 1.76e-65 | NR | CEP02281.1 | 37360 | g55668 | i0 | 59.3 | 6.7012987012987 | 194 | 76 | 94.5 | 2 | 1 | 582 | 11 | 201 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 4128 | 212 | 0.990566037735849 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21287711 | 21287711 | PRJNA906294_P_NODE_122197_length_359_cov_1.062937_g118081_i0 | PRJNA906294 | 122197 | 359 | 1.062937 | 3.81594383 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 1.8899999999999998e-20 | NR | SPQ99257.1 | 37360 | g118081 | i0 | 42.9 | 0.877437325905292 | 105 | 59 | 87.7 | 1 | 38 | 352 | 1659 | 1762 | SPQ99257.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 315 | 96.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 25113782 | 25113782 | PRJNA906294_P_NODE_205420_length_250_cov_1.700565_g201304_i0 | PRJNA906294 | 205420 | 250 | 1.700565 | 4.2514125 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.69e-35 | NR | CEP02737.1 | 37360 | g201304 | i0 | 69.9 | 0.996 | 83 | 25 | 99.6 | 0 | 249 | 1 | 51 | 133 | CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] | diamond | 249 | 127 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27277333 | 27277333 | PRJNA906294_P_NODE_214903_length_246_cov_2.098266_g210787_i0 | PRJNA906294 | 214903 | 246 | 2.098266 | 5.16173436 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.09e-25 | NR | CEP02402.1 | 37360 | g210787 | i0 | 63.8 | 0.975609756097561 | 80 | 28 | 97.6 | 1 | 2 | 241 | 304 | 382 | CEP02402.1 hypothetical protein PBRA_008986 [Plasmodiophora brassicae] | diamond | 240 | 107 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28168902 | 28168902 | PRJNA906294_P_NODE_192185_length_263_cov_1.368421_g188069_i0 | PRJNA906294 | 192185 | 263 | 1.368421 | 3.59894723 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 1.58e-19 | NR | MES1919342.1 | 126728 | g188069 | i0 | 45.7 | 8.29277566539924 | 81 | 44 | 92.4 | 0 | 244 | 2 | 285 | 365 | MES1919342.1 Actin, cytoplasmic A3a [Bonamia ostreae] | diamond | 2181 | 91.7 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 28255957 | 28255957 | PRJNA906294_P_NODE_170046_length_286_cov_1.516432_g165930_i0 | PRJNA906294 | 170046 | 286 | 1.516432 | 4.33699552 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.36e-8 | NR | CEO94225.1 | 37360 | g165930 | i0 | 54.2 | 1.77272727272727 | 48 | 22 | 50.3 | 0 | 284 | 141 | 28 | 75 | CEO94225.1 hypothetical protein PBRA_000010 [Plasmodiophora brassicae] | diamond | 507 | 58.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28295120 | 28295120 | PRJNA906294_P_NODE_130986_length_342_cov_1.100372_g126870_i0 | PRJNA906294 | 130986 | 342 | 1.100372 | 3.76327224 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00762 | NR | CEO99991.1 | 37360 | g126870 | i0 | 44.9 | 1.79824561403509 | 49 | 27 | 43 | 0 | 333 | 187 | 134 | 182 | CEO99991.1 hypothetical protein PBRA_007725 [Plasmodiophora brassicae] | diamond | 615 | 45.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29866447 | 29866447 | PRJNA906294_P_NODE_202831_length_252_cov_2.877095_g198715_i0 | PRJNA906294 | 202831 | 252 | 2.877095 | 7.2502794 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 1.34e-11 | NR | CEO98595.1 | 37360 | g198715 | i0 | 63.5 | 0.619047619047619 | 52 | 19 | 61.9 | 0 | 247 | 92 | 1 | 52 | CEO98595.1 hypothetical protein PBRA_006708 [Plasmodiophora brassicae] | diamond | 156 | 64.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30316736 | 30316736 | PRJNA906294_P_NODE_123072_length_357_cov_1.475352_g118956_i0 | PRJNA906294 | 123072 | 357 | 1.475352 | 5.26700664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 4.22e-14 | NR | CEO99700.1 | 37360 | g118956 | i0 | 44.4 | 2.13445378151261 | 90 | 42 | 68.9 | 2 | 107 | 352 | 132 | 221 | CEO99700.1 hypothetical protein PBRA_007433 [Plasmodiophora brassicae] | diamond | 762 | 77.8 | 0.994858611825193 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30379775 | 30379775 | PRJNA906294_P_NODE_107932_length_392_cov_2.771160_g103817_i0 | PRJNA906294 | 107932 | 392 | 2.77116 | 10.8629472 | Endomyxa | 2604748 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 6.51e-38 | NR | CEP00766.1 | 37360 | g103817 | i0 | 71.1 | 2.24234693877551 | 97 | 28 | 74.2 | 0 | 291 | 1 | 2 | 98 | CEP00766.1 hypothetical protein PBRA_008078 [Plasmodiophora brassicae] | diamond | 879 | 139 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31390806 | 31390806 | PRJNA906294_P_NODE_222056_length_244_cov_0.888889_g217940_i0 | PRJNA906294 | 222056 | 244 | 0.888889 | 2.16888916 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 1.76e-10 | NR | MES1918299.1 | 126728 | g217940 | i0 | 44.6 | 5.92622950819672 | 74 | 38 | 91 | 2 | 228 | 7 | 206 | 276 | MES1918299.1 ATP-binding cassette sub- F member 3 [Bonamia ostreae] | diamond | 1446 | 66.6 | 0.993993993993994 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 31896703 | 31896703 | PRJNA906294_P_NODE_210397_length_248_cov_0.874286_g206281_i0 | PRJNA906294 | 210397 | 248 | 0.874286 | 2.16822928 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 2.56e-27 | NR | CEP02495.1 | 37360 | g206281 | i0 | 66.7 | 3.95564516129032 | 81 | 27 | 98 | 0 | 244 | 2 | 54 | 134 | CEP02495.1 hypothetical protein PBRA_009079 [Plasmodiophora brassicae] | diamond | 981 | 110 | 0.990909090909091 | 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);;