contig_metadata
23 rows where bioproject = "PRJNA274362", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370334 | 370334 | PRJNA274362_S_NODE_12941_length_247_cov_1.570707_g12821_i0 | PRJNA274362 | 12941 | 247 | 1.570707 | 3.87964629 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.46e-36 | NR | CEP01219.1 | 37360 | g12821 | i0 | 72.8 | 55.1295546558704 | 81 | 22 | 98.4 | 0 | 4 | 246 | 6 | 86 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 13617 | 135 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 1058621 | 1058621 | PRJNA274362_S_NODE_22181_length_198_cov_0.946309_g22061_i0 | PRJNA274362 | 22181 | 198 | 0.946309 | 1.87369182 | Arachnula sp. CL12 | 862247 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 9.07e-31 | NR | ADK90073.1 | 862247 | g22061 | i0 | 78.8 | 2 | 66 | 14 | 100 | 0 | 198 | 1 | 284 | 349 | ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12] | diamond | 396 | 121 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula sp. CL12 | |||
| 1645198 | 1645198 | PRJNA274362_S_NODE_1542_length_635_cov_2.238908_g1439_i0 | PRJNA274362 | 1542 | 635 | 2.238908 | 14.2170658 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 280 | 8.01e-92 | NR | CEO96095.1 | 37360 | g1439 | i0 | 61.6 | 0.996850393700787 | 211 | 81 | 99.7 | 0 | 2 | 634 | 38 | 248 | CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] | diamond | 633 | 280 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 1645269 | 1645269 | PRJNA274362_S_NODE_18642_length_212_cov_1.276074_g18522_i0 | PRJNA274362 | 18642 | 212 | 1.276074 | 2.70527688 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 5.23e-36 | NR | CEP03336.1 | 37360 | g18522 | i0 | 84.3 | 0.990566037735849 | 70 | 11 | 99.1 | 0 | 3 | 212 | 32 | 101 | CEP03336.1 hypothetical protein PBRA_003096 [Plasmodiophora brassicae] | diamond | 210 | 127 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 1645299 | 1645299 | PRJNA274362_S_NODE_2002_length_568_cov_3.903661_g1891_i0 | PRJNA274362 | 2002 | 568 | 3.903661 | 22.17279448 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 197 | 2.53e-61 | NR | CEP02737.1 | 37360 | g1891 | i0 | 73.6 | 1.32570422535211 | 125 | 33 | 66 | 0 | 2 | 376 | 25 | 149 | CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] | diamond | 753 | 197 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 1645751 | 1645751 | PRJNA274362_S_NODE_9502_length_281_cov_1.353448_g9382_i0 | PRJNA274362 | 9502 | 281 | 1.353448 | 3.80318888 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 5.6e-35 | NR | CEP01997.1 | 37360 | g9382 | i0 | 72.9 | 1.81494661921708 | 85 | 23 | 90.7 | 0 | 262 | 8 | 1 | 85 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 510 | 128 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 6748206 | 6748206 | PRJNA274362_S_NODE_21366_length_201_cov_0.993421_g21246_i0 | PRJNA274362 | 21366 | 201 | 0.993421 | 1.99677621 | Arachnula sp. CL12 | 862247 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.27e-48 | NTclustered | gi|302026178|gb|GQ377695.1| | 862247 | g21246 | i0 | 86.559 | 95.5870646766169 | 186 | 25 | 93 | 0 | 14 | 199 | 416 | 231 | Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds | blastn | 19213 | 206 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula sp. CL12 | |||
| 13124505 | 13124505 | PRJNA274362_S_NODE_28771_length_177_cov_1.156250_g28651_i0 | PRJNA274362 | 28771 | 177 | 1.15625 | 2.0465625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 2.13e-28 | NR | CEP01219.1 | 37360 | g28651 | i0 | 84.2 | 26.1016949152542 | 57 | 9 | 96.6 | 0 | 173 | 3 | 164 | 220 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 4620 | 112 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 14399545 | 14399545 | PRJNA274362_S_NODE_2292_length_537_cov_1.930328_g2176_i0 | PRJNA274362 | 2292 | 537 | 1.930328 | 10.36586136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.77e-80 | NR | CEP01968.1 | 37360 | g2176 | i0 | 71.2 | 12.3351955307263 | 170 | 47 | 95 | 1 | 27 | 536 | 1 | 168 | CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] | diamond | 6624 | 250 | 0.992 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 16361133 | 16361133 | PRJNA274362_S_NODE_5433_length_360_cov_1.823151_g5313_i0 | PRJNA274362 | 5433 | 360 | 1.823151 | 6.5633436 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.4899999999999998e-31 | NR | CEP03344.1 | 37360 | g5313 | i0 | 53 | 0.975 | 117 | 55 | 97.5 | 0 | 8 | 358 | 1 | 117 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 351 | 120 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 19496825 | 19496825 | PRJNA274362_S_NODE_4776_length_381_cov_2.301205_g4656_i0 | PRJNA274362 | 4776 | 381 | 2.301205 | 8.76759105 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 197 | 1.66e-62 | NR | CEO97530.1 | 37360 | g4656 | i0 | 83.2 | 0.889763779527559 | 113 | 19 | 89 | 0 | 339 | 1 | 1 | 113 | CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] | diamond | 339 | 197 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 19496842 | 19496842 | PRJNA274362_S_NODE_5656_length_354_cov_1.668852_g5536_i0 | PRJNA274362 | 5656 | 354 | 1.668852 | 5.90773608 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 208 | 1.21e-64 | NR | CEP01219.1 | 37360 | g5536 | i0 | 82.1 | 1.98305084745763 | 117 | 21 | 99.2 | 0 | 2 | 352 | 157 | 273 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 702 | 208 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 25284642 | 25284642 | PRJNA274362_S_NODE_10240_length_272_cov_1.838565_g10120_i0 | PRJNA274362 | 10240 | 272 | 1.838565 | 5.0008968 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 1.8899999999999998e-20 | NR | SPQ93437.1 | 37360 | g10120 | i0 | 65.6 | 2.77941176470588 | 64 | 22 | 70.6 | 0 | 9 | 200 | 81 | 144 | SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 756 | 89.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27547955 | 27547955 | PRJNA274362_S_NODE_4684_length_385_cov_2.532738_g4564_i0 | PRJNA274362 | 4684 | 385 | 2.532738 | 9.7510413 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 3.28e-29 | NR | CEP02593.1 | 37360 | g4564 | i0 | 59.8 | 0.716883116883117 | 92 | 37 | 71.7 | 0 | 51 | 326 | 11 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 276 | 112 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28337375 | 28337375 | PRJNA274362_S_NODE_10806_length_266_cov_1.649770_g10686_i0 | PRJNA274362 | 10806 | 266 | 1.64977 | 4.3883882 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 5.099999999999999e-24 | NR | CEP02236.1 | 37360 | g10686 | i0 | 57.3 | 1.8609022556391 | 82 | 35 | 92.5 | 0 | 249 | 4 | 1 | 82 | CEP02236.1 hypothetical protein PBRA_002501 [Plasmodiophora brassicae] | diamond | 495 | 98.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29252737 | 29252737 | PRJNA274362_S_NODE_11749_length_257_cov_2.163462_g11629_i0 | PRJNA274362 | 11749 | 257 | 2.163462 | 5.5600973400000004 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 4.61e-13 | NR | CAL69925.1 | 37360 | g11629 | i0 | 56.1 | 1.64591439688716 | 66 | 29 | 77 | 0 | 199 | 2 | 3 | 68 | CAL69925.1 hypothetical protein [Plasmodiophora brassicae] | diamond | 423 | 72.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30358920 | 30358920 | PRJNA274362_S_NODE_16192_length_224_cov_2.531429_g16072_i0 | PRJNA274362 | 16192 | 224 | 2.531429 | 5.67040096 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.7e-24 | NR | CEO96284.1 | 37360 | g16072 | i0 | 71.2 | 2.77232142857143 | 66 | 19 | 88.4 | 0 | 21 | 218 | 1 | 66 | CEO96284.1 hypothetical protein PBRA_004955 [Plasmodiophora brassicae] | diamond | 621 | 99.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30611057 | 30611057 | PRJNA274362_S_NODE_34553_length_166_cov_0.863248_g34433_i0 | PRJNA274362 | 34553 | 166 | 0.863248 | 1.43299168 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 3.1e-10 | NR | SPQ94571.1 | 37360 | g34433 | i0 | 55.6 | 0.975903614457831 | 54 | 24 | 97.6 | 0 | 164 | 3 | 456 | 509 | SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 162 | 64.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31147889 | 31147889 | PRJNA274362_S_NODE_36795_length_163_cov_0.912281_g36675_i0 | PRJNA274362 | 36795 | 163 | 0.912281 | 1.48701803 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 4.53e-5 | NR | CEO95180.1 | 37360 | g36675 | i0 | 44 | 1.85889570552147 | 50 | 26 | 92 | 1 | 153 | 4 | 260 | 307 | CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] | diamond | 303 | 49.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31243051 | 31243051 | PRJNA274362_S_NODE_25575_length_186_cov_1.788321_g25455_i0 | PRJNA274362 | 25575 | 186 | 1.788321 | 3.32627706 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 7.42e-24 | NR | CEP02737.1 | 37360 | g25455 | i0 | 65.6 | 0.983870967741935 | 61 | 21 | 98.4 | 0 | 3 | 185 | 41 | 101 | CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] | diamond | 183 | 97.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31925022 | 31925022 | PRJNA274362_S_NODE_35597_length_164_cov_1.356522_g35477_i0 | PRJNA274362 | 35597 | 164 | 1.356522 | 2.22469608 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.86e-16 | NR | CEO95919.1 | 37360 | g35477 | i0 | 64.8 | 4.57317073170732 | 54 | 19 | 98.8 | 0 | 162 | 1 | 260 | 313 | CEO95919.1 hypothetical protein PBRA_004609 [Plasmodiophora brassicae] | diamond | 750 | 82 | 0.995121951219512 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31970612 | 31970612 | PRJNA274362_S_NODE_20338_length_205_cov_0.980769_g20218_i0 | PRJNA274362 | 20338 | 205 | 0.980769 | 2.01057645 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.59e-26 | NR | CEP02281.1 | 37360 | g20218 | i0 | 84.1 | 0.921951219512195 | 63 | 10 | 92.2 | 0 | 192 | 4 | 1 | 63 | CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] | diamond | 189 | 105 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32399852 | 32399852 | PRJNA274362_S_NODE_1039_length_753_cov_1.906250_g957_i0 | PRJNA274362 | 1039 | 753 | 1.90625 | 14.3540625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 223 | 2.84e-68 | NR | CEO97280.1 | 37360 | g957 | i0 | 55.7 | 6.37051792828685 | 194 | 86 | 77.3 | 0 | 4 | 585 | 85 | 278 | CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] | diamond | 4797 | 223 | 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);;