contig_metadata
22 rows where bioproject = "PRJNA492406", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3002905 | 3002905 | PRJNA492406_P_NODE_10603_length_379_cov_1.718954_g10304_i0 | PRJNA492406 | 10603 | 379 | 1.718954 | 6.51483566 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 6.399999999999999e-57 | NR | CEO99947.1 | 37360 | g10304 | i0 | 71.4 | 2.01846965699208 | 126 | 36 | 99.7 | 0 | 378 | 1 | 34 | 159 | CEO99947.1 hypothetical protein PBRA_007681 [Plasmodiophora brassicae] | diamond | 765 | 193 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 3003264 | 3003264 | PRJNA492406_P_NODE_25763_length_254_cov_3.011050_g25464_i0 | PRJNA492406 | 25763 | 254 | 3.01105 | 7.648067 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 2.66e-47 | NR | CEP01219.1 | 37360 | g25464 | i0 | 90.5 | 0.992125984251969 | 84 | 8 | 99.2 | 0 | 253 | 2 | 172 | 255 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 252 | 162 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 7477188 | 7477188 | PRJNA492406_P_NODE_12086_length_358_cov_1.122807_g11787_i0 | PRJNA492406 | 12086 | 358 | 1.1228070000000001 | 4.01964906 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.16e-45 | NR | CEO96142.1 | 37360 | g11787 | i0 | 61 | 4.79329608938547 | 118 | 43 | 98.9 | 2 | 355 | 2 | 26 | 140 | CEO96142.1 hypothetical protein PBRA_004832 [Plasmodiophora brassicae] | diamond | 1716 | 156 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 8105337 | 8105337 | PRJNA492406_P_NODE_11007_length_373_cov_1.880000_g10708_i0 | PRJNA492406 | 11007 | 373 | 1.88 | 7.0124 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 212 | 3.2599999999999996e-68 | NR | CEO97530.1 | 37360 | g10708 | i0 | 82.9 | 0.989276139410188 | 123 | 21 | 98.9 | 0 | 3 | 371 | 3 | 125 | CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] | diamond | 369 | 212 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9380124 | 9380124 | PRJNA492406_P_NODE_12828_length_349_cov_2.177536_g12529_i0 | PRJNA492406 | 12828 | 349 | 2.177536 | 7.59960064 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 5.869999999999998e-55 | NR | CEP01968.1 | 37360 | g12529 | i0 | 75 | 0.997134670487106 | 116 | 29 | 99.7 | 0 | 2 | 349 | 41 | 156 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 348 | 181 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 15127310 | 15127310 | PRJNA492406_P_NODE_29952_length_245_cov_0.895349_g29653_i0 | PRJNA492406 | 29952 | 245 | 0.895349 | 2.19360505 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 1.04e-20 | NR | CEO97902.1 | 37360 | g29653 | i0 | 65 | 0.979591836734694 | 80 | 27 | 98 | 1 | 240 | 1 | 889 | 967 | CEO97902.1 hypothetical protein PBRA_006016 [Plasmodiophora brassicae] | diamond | 240 | 95.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 15754909 | 15754909 | PRJNA492406_P_NODE_14353_length_331_cov_1.193798_g14054_i0 | PRJNA492406 | 14353 | 331 | 1.193798 | 3.95147138 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 7.01e-41 | NR | CEP01997.1 | 37360 | g14054 | i0 | 65.1 | 2.98187311178248 | 109 | 38 | 98.8 | 0 | 1 | 327 | 21 | 129 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 987 | 144 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 17029599 | 17029599 | PRJNA492406_P_NODE_15894_length_315_cov_0.921488_g15595_i0 | PRJNA492406 | 15894 | 315 | 0.921488 | 2.9026872 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 1.04e-19 | NR | CEO98766.1 | 37360 | g15595 | i0 | 82.1 | 1.06666666666667 | 56 | 10 | 53.3 | 0 | 313 | 146 | 369 | 424 | CEO98766.1 hypothetical protein PBRA_006880 [Plasmodiophora brassicae] | diamond | 336 | 93.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27013099 | 27013099 | PRJNA492406_P_NODE_27562_length_249_cov_1.261364_g27263_i0 | PRJNA492406 | 27562 | 249 | 1.261364 | 3.14079636 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 6.78e-12 | NR | SPR00252.1 | 37360 | g27263 | i0 | 48.7 | 0.939759036144578 | 78 | 40 | 94 | 0 | 238 | 5 | 596 | 673 | SPR00252.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 234 | 70.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27408731 | 27408731 | PRJNA492406_P_NODE_18583_length_290_cov_1.064516_g18284_i0 | PRJNA492406 | 18583 | 290 | 1.064516 | 3.0870964 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.15e-23 | NR | CEO95256.1 | 37360 | g18284 | i0 | 52.1 | 1.96551724137931 | 96 | 46 | 99.3 | 0 | 289 | 2 | 53 | 148 | CEO95256.1 hypothetical protein PBRA_004022 [Plasmodiophora brassicae] | diamond | 570 | 102 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27708659 | 27708659 | PRJNA492406_P_NODE_15264_length_321_cov_1.241935_g14965_i0 | PRJNA492406 | 15264 | 321 | 1.241935 | 3.98661135 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 6.42e-51 | NR | CEO95919.1 | 37360 | g14965 | i0 | 79.4 | 2 | 107 | 22 | 100 | 0 | 321 | 1 | 43 | 149 | CEO95919.1 hypothetical protein PBRA_004609 [Plasmodiophora brassicae] | diamond | 642 | 175 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27897546 | 27897546 | PRJNA492406_P_NODE_32485_length_235_cov_2.697531_g32186_i0 | PRJNA492406 | 32485 | 235 | 2.697531 | 6.33919785 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 4.24e-4 | NR | SPQ94367.1 | 37360 | g32186 | i0 | 43.1 | 1.30212765957447 | 51 | 28 | 65.1 | 1 | 78 | 230 | 1683 | 1732 | SPQ94367.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 306 | 48.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29507854 | 29507854 | PRJNA492406_P_NODE_18950_length_288_cov_1.432558_g18651_i0 | PRJNA492406 | 18950 | 288 | 1.432558 | 4.12576704 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.67e-12 | NR | CEP03932.1 | 37360 | g18651 | i0 | 64 | 1.02083333333333 | 50 | 18 | 52.1 | 0 | 286 | 137 | 92 | 141 | CEP03932.1 hypothetical protein PBRA_003539 [Plasmodiophora brassicae] | diamond | 294 | 68.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29539407 | 29539407 | PRJNA492406_P_NODE_22710_length_270_cov_1.345178_g22411_i0 | PRJNA492406 | 22710 | 270 | 1.345178 | 3.6319806 | Bonamia ostreae | 126728 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 4.06e-9 | NR | MES1921420.1 | 126728 | g22411 | i0 | 44.7 | 1.8 | 76 | 42 | 84.4 | 0 | 235 | 8 | 16 | 91 | MES1921420.1 hypothetical protein [Bonamia ostreae] | diamond | 486 | 61.2 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Bonamia | Bonamia ostreae | |||
| 30171084 | 30171084 | PRJNA492406_P_NODE_16792_length_305_cov_2.012931_g16493_i0 | PRJNA492406 | 16792 | 305 | 2.012931 | 6.13943955 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 4.03e-48 | NR | CEO98710.1 | 37360 | g16493 | i0 | 77.2 | 11.9213114754098 | 101 | 23 | 99.3 | 0 | 304 | 2 | 160 | 260 | CEO98710.1 hypothetical protein PBRA_006824 [Plasmodiophora brassicae] | diamond | 3636 | 167 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30361271 | 30361271 | PRJNA492406_P_NODE_9452_length_399_cov_1.659509_g9153_i0 | PRJNA492406 | 9452 | 399 | 1.659509 | 6.62144091 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 5.88e-13 | NR | CEP03344.1 | 37360 | g9153 | i0 | 65.4 | 0.390977443609023 | 52 | 18 | 39.1 | 0 | 1 | 156 | 142 | 193 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 156 | 73.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31197828 | 31197828 | PRJNA492406_P_NODE_18895_length_288_cov_1.967442_g18596_i0 | PRJNA492406 | 18895 | 288 | 1.967442 | 5.66623296 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 2.96e-20 | NR | CEP03932.1 | 37360 | g18596 | i0 | 51.6 | 9.6875 | 93 | 42 | 96.9 | 1 | 279 | 1 | 28 | 117 | CEP03932.1 hypothetical protein PBRA_003539 [Plasmodiophora brassicae] | diamond | 2790 | 90.1 | 0.992230854605993 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31245446 | 31245446 | PRJNA492406_P_NODE_13195_length_345_cov_1.121324_g12896_i0 | PRJNA492406 | 13195 | 345 | 1.121324 | 3.8685678 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 1.62e-18 | NR | CEO94323.1 | 37360 | g12896 | i0 | 45.5 | 0.878260869565217 | 101 | 36 | 71.3 | 1 | 35 | 280 | 719 | 819 | CEO94323.1 hypothetical protein PBRA_000108 [Plasmodiophora brassicae] | diamond | 303 | 90.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31846353 | 31846353 | PRJNA492406_P_NODE_22097_length_273_cov_1.400000_g21798_i0 | PRJNA492406 | 22097 | 273 | 1.4 | 3.822 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 9.41e-22 | NR | CEO98004.1 | 37360 | g21798 | i0 | 54.4 | 0.989010989010989 | 90 | 41 | 98.9 | 0 | 2 | 271 | 3259 | 3348 | CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] | diamond | 270 | 99 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32036258 | 32036258 | PRJNA492406_P_NODE_18898_length_288_cov_1.920930_g18599_i0 | PRJNA492406 | 18898 | 288 | 1.92093 | 5.5322784 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 2.38e-19 | NR | SPR02116.1 | 37360 | g18599 | i0 | 47.1 | 2.88541666666667 | 102 | 48 | 100 | 2 | 1 | 288 | 2501 | 2602 | SPR02116.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 831 | 92.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32163037 | 32163037 | PRJNA492406_P_NODE_31078_length_243_cov_0.905882_g30779_i0 | PRJNA492406 | 31078 | 243 | 0.905882 | 2.20129326 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 5.34e-8 | NR | CEP03397.1 | 37360 | g30779 | i0 | 45.3 | 0.925925925925926 | 75 | 28 | 90.1 | 3 | 2 | 220 | 478 | 541 | CEP03397.1 hypothetical protein PBRA_003157 [Plasmodiophora brassicae] | diamond | 225 | 59.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32384324 | 32384324 | PRJNA492406_P_NODE_20459_length_281_cov_1.572115_g20160_i0 | PRJNA492406 | 20459 | 281 | 1.572115 | 4.41764315 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 9.04e-11 | NR | CEO95180.1 | 37360 | g20160 | i0 | 36.3 | 0.97153024911032 | 91 | 58 | 97.2 | 0 | 8 | 280 | 105 | 195 | CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] | diamond | 273 | 67.8 | 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);;