contig_metadata
22 rows where bioproject = "PRJNA1073183", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2291479 | 2291479 | PRJNA1073183_P_NODE_6742_length_489_cov_2.074519_g6648_i0 | PRJNA1073183 | 6742 | 489 | 2.074519 | 10.14439791 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 3.999999999999999e-57 | NR | CEP01997.1 | 37360 | g6648 | i0 | 66.2 | 0.871165644171779 | 142 | 46 | 87.1 | 1 | 27 | 452 | 1 | 140 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 426 | 187 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 2738027 | 2738027 | PRJNA1073183_P_NODE_5463_length_543_cov_2.034043_g5370_i0 | PRJNA1073183 | 5463 | 543 | 2.034043 | 11.04485349 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 2.86e-35 | NR | CEP02236.1 | 37360 | g5370 | i0 | 47.6 | 0.790055248618785 | 143 | 75 | 79 | 0 | 511 | 83 | 1 | 143 | CEP02236.1 hypothetical protein PBRA_002501 [Plasmodiophora brassicae] | diamond | 429 | 130 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 3566716 | 3566716 | PRJNA1073183_P_NODE_3943_length_634_cov_2.392157_g3854_i0 | PRJNA1073183 | 3943 | 634 | 2.392157 | 15.16627538 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.01e-82 | NR | CEO98386.1 | 37360 | g3854 | i0 | 81.2 | 1.5615141955836 | 165 | 31 | 78.1 | 0 | 53 | 547 | 1 | 165 | CEO98386.1 hypothetical protein PBRA_006500 [Plasmodiophora brassicae] | diamond | 990 | 255 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 6119272 | 6119272 | PRJNA1073183_P_NODE_7285_length_472_cov_2.325815_g7191_i0 | PRJNA1073183 | 7285 | 472 | 2.325815 | 10.9778468 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 6.61e-44 | NR | SPQ93437.1 | 37360 | g7191 | i0 | 64.1 | 1.46186440677966 | 117 | 41 | 74.4 | 1 | 455 | 105 | 29 | 144 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 690 | 152 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 8669307 | 8669307 | PRJNA1073183_P_NODE_3627_length_659_cov_12.953925_g3539_i0 | PRJNA1073183 | 3627 | 659 | 12.953925 | 85.36636575 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 7.62e-73 | NR | CEP02281.1 | 37360 | g3539 | i0 | 61.3 | 4.70257966616085 | 204 | 76 | 92.9 | 2 | 646 | 35 | 1 | 201 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 3099 | 229 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 9115003 | 9115003 | PRJNA1073183_P_NODE_31648_length_244_cov_1.760234_g31553_i0 | PRJNA1073183 | 31648 | 244 | 1.760234 | 4.29497096 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 7.41e-43 | NR | CEP01219.1 | 37360 | g31553 | i0 | 84 | 6.97131147540984 | 81 | 13 | 99.6 | 0 | 243 | 1 | 132 | 212 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 1701 | 151 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 12941196 | 12941196 | PRJNA1073183_P_NODE_3451_length_675_cov_2.946844_g3364_i0 | PRJNA1073183 | 3451 | 675 | 2.946844 | 19.891197 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 1.7399999999999998e-99 | NR | CEO96095.1 | 37360 | g3364 | i0 | 61.8 | 1 | 225 | 86 | 100 | 0 | 675 | 1 | 34 | 258 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 675 | 300 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 18867701 | 18867701 | PRJNA1073183_P_NODE_3935_length_635_cov_2.460854_g3846_i0 | PRJNA1073183 | 3935 | 635 | 2.460854 | 15.6264229 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 7.9e-64 | NR | CEP03344.1 | 37360 | g3846 | i0 | 62 | 0.746456692913386 | 158 | 60 | 74.6 | 0 | 633 | 160 | 35 | 192 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 474 | 206 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 20588421 | 20588421 | PRJNA1073183_P_NODE_32137_length_244_cov_0.900585_g32042_i0 | PRJNA1073183 | 32137 | 244 | 0.900585 | 2.1974274 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 9.639999999999999e-24 | NR | CEO96617.1 | 37360 | g32042 | i0 | 77.4 | 1.53688524590164 | 62 | 14 | 76.2 | 0 | 243 | 58 | 182 | 243 | CEO96617.1 hypothetical protein PBRA_005226 [Plasmodiophora brassicae] | diamond | 375 | 100 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 20588506 | 20588506 | PRJNA1073183_P_NODE_5717_length_530_cov_2.199125_g5624_i0 | PRJNA1073183 | 5717 | 530 | 2.199125 | 11.6553625 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 256 | 8.19e-85 | NR | CEO97530.1 | 37360 | g5624 | i0 | 81.5 | 0.854716981132076 | 151 | 28 | 85.5 | 0 | 46 | 498 | 1 | 151 | CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] | diamond | 453 | 256 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21864014 | 21864014 | PRJNA1073183_P_NODE_21418_length_283_cov_1.461905_g21323_i0 | PRJNA1073183 | 21418 | 283 | 1.461905 | 4.13719115 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 8.07e-30 | NR | CEP01219.1 | 37360 | g21323 | i0 | 72.4 | 0.80565371024735 | 76 | 20 | 80.6 | 1 | 53 | 280 | 4 | 78 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 228 | 118 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21864231 | 21864231 | PRJNA1073183_P_NODE_3398_length_681_cov_1.771382_g3311_i0 | PRJNA1073183 | 3398 | 681 | 1.771382 | 12.06311142 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.92e-97 | NR | CEP02495.1 | 37360 | g3311 | i0 | 64.9 | 17.8105726872247 | 225 | 79 | 99.1 | 0 | 5 | 679 | 8 | 232 | CEP02495.1 hypothetical protein PBRA_009079 [Plasmodiophora brassicae] | diamond | 12129 | 294 | 0.993197278911565 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 24413394 | 24413394 | PRJNA1073183_P_NODE_6400_length_502_cov_1.256410_g6307_i0 | PRJNA1073183 | 6400 | 502 | 1.25641 | 6.3071782 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 1.53e-62 | NR | CEP02640.1 | 37360 | g6307 | i0 | 76.1 | 0.848605577689243 | 142 | 33 | 84.3 | 1 | 500 | 78 | 25 | 166 | CEP02640.1 hypothetical protein PBRA_002607 [Plasmodiophora brassicae] | diamond | 426 | 200 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27058923 | 27058923 | PRJNA1073183_P_NODE_5882_length_522_cov_2.766147_g5789_i0 | PRJNA1073183 | 5882 | 522 | 2.766147 | 14.43928734 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 2.12e-18 | NR | CEO94569.1 | 37360 | g5789 | i0 | 35 | 2.33908045977011 | 143 | 90 | 82.2 | 1 | 71 | 499 | 4 | 143 | CEO94569.1 hypothetical protein PBRA_000354 [Plasmodiophora brassicae] | diamond | 1221 | 87.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29111700 | 29111700 | PRJNA1073183_P_NODE_26228_length_252_cov_1.117318_g26133_i0 | PRJNA1073183 | 26228 | 252 | 1.117318 | 2.81564136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.5799999999999999e-32 | NR | CEO99768.1 | 37360 | g26133 | i0 | 65.4 | 1.85714285714286 | 78 | 27 | 92.9 | 0 | 236 | 3 | 1 | 78 | CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] | diamond | 468 | 120 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29941212 | 29941212 | PRJNA1073183_P_NODE_7371_length_469_cov_4.411616_g7277_i0 | PRJNA1073183 | 7371 | 469 | 4.411616 | 20.69047904 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 9.17e-29 | NR | CEP02593.1 | 37360 | g7277 | i0 | 59.8 | 0.588486140724947 | 92 | 37 | 58.8 | 0 | 50 | 325 | 11 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 276 | 112 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30699210 | 30699210 | PRJNA1073183_P_NODE_4514_length_594_cov_2.579655_g4422_i0 | PRJNA1073183 | 4514 | 594 | 2.579655 | 15.3231507 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 9.15e-51 | NR | SPQ93792.1 | 37360 | g4422 | i0 | 62 | 1.42929292929293 | 142 | 53 | 71.7 | 1 | 561 | 136 | 157 | 297 | SPQ93792.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 849 | 176 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30793993 | 30793993 | PRJNA1073183_P_NODE_2734_length_752_cov_2.366716_g2651_i0 | PRJNA1073183 | 2734 | 752 | 2.366716 | 17.79770432 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 242 | 7.77e-76 | NR | CEO97280.1 | 37360 | g2651 | i0 | 55.4 | 1.77127659574468 | 222 | 95 | 88.2 | 2 | 750 | 88 | 60 | 278 | CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] | diamond | 1332 | 242 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31204382 | 31204382 | PRJNA1073183_P_NODE_26755_length_251_cov_0.865169_g26660_i0 | PRJNA1073183 | 26755 | 251 | 0.865169 | 2.17157419 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 8.039999999999999e-38 | NR | CEO97902.1 | 37360 | g26660 | i0 | 76.8 | 0.9800796812749 | 82 | 19 | 98 | 0 | 249 | 4 | 792 | 873 | CEO97902.1 hypothetical protein PBRA_006016 [Plasmodiophora brassicae] | diamond | 246 | 144 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32122364 | 32122364 | PRJNA1073183_P_NODE_19578_length_295_cov_1.716216_g19483_i0 | PRJNA1073183 | 19578 | 295 | 1.716216 | 5.0628372 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0459 | NR | CEO96407.1 | 37360 | g19483 | i0 | 51.1 | 0.457627118644068 | 45 | 17 | 41.7 | 2 | 173 | 295 | 31 | 74 | CEO96407.1 hypothetical protein PBRA_005078 [Plasmodiophora brassicae] | diamond | 135 | 43.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32145393 | 32145393 | PRJNA1073183_P_NODE_29898_length_247_cov_0.885057_g29803_i0 | PRJNA1073183 | 29898 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.2099999999999999e-23 | NR | CEP00440.1 | 37360 | g29803 | i0 | 69.7 | 13.6153846153846 | 76 | 23 | 92.3 | 0 | 233 | 6 | 83 | 158 | CEP00440.1 hypothetical protein PBRA_001494 [Plasmodiophora brassicae] | diamond | 3363 | 103 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32596770 | 32596770 | PRJNA1073183_P_NODE_5620_length_535_cov_2.997835_g5527_i0 | PRJNA1073183 | 5620 | 535 | 2.997835 | 16.03841725 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 7.169999999999998e-42 | NR | CEP01632.1 | 37360 | g5527 | i0 | 63.9 | 3.5214953271028002 | 122 | 44 | 68.4 | 0 | 464 | 99 | 7 | 128 | CEP01632.1 hypothetical protein PBRA_008575 [Plasmodiophora brassicae] | diamond | 1884 | 147 | 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);;