contig_metadata
12 rows where bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16116994 | 16116994 | PRJNA812715_P_NODE_78993_length_286_cov_1.446009_g77193_i0 | PRJNA812715 | 78993 | 286 | 1.446009 | 4.13558574 | root | 1 | Root_unresolved | Root_unresolved | 141 | 1.09e-40 | NR | CEP00879.1 | 37360 | g77193 | i0 | 83.3 | 59.2342657342657 | 78 | 13 | 81.8 | 0 | 238 | 5 | 22 | 99 | CEP00879.1 hypothetical protein PBRA_008191 [Plasmodiophora brassicae] | diamond | 16941 | 141 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28042282 | 28042282 | PRJNA812715_P_NODE_67365_length_313_cov_2.437500_g65565_i0 | PRJNA812715 | 67365 | 313 | 2.4375 | 7.629375 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 1.12e-42 | NR | CEP02737.1 | 37360 | g65565 | i0 | 74.7 | 4.39936102236422 | 91 | 23 | 87.2 | 0 | 32 | 304 | 1 | 91 | CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] | diamond | 1377 | 146 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28159986 | 28159986 | PRJNA812715_P_NODE_82785_length_280_cov_1.367150_g80985_i0 | PRJNA812715 | 82785 | 280 | 1.36715 | 3.82802 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.59e-15 | NR | CEP02772.1 | 37360 | g80985 | i0 | 42.5 | 0.932142857142857 | 87 | 50 | 93.2 | 0 | 3 | 263 | 494 | 580 | CEP02772.1 hypothetical protein PBRA_002739 [Plasmodiophora brassicae] | diamond | 261 | 81.3 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28665062 | 28665062 | PRJNA812715_P_NODE_87867_length_272_cov_1.356784_g86066_i0 | PRJNA812715 | 87867 | 272 | 1.356784 | 3.69045248 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 7.42e-14 | NR | CEP03147.1 | 37360 | g86066 | i0 | 51.5 | 3.04411764705882 | 68 | 33 | 75 | 0 | 272 | 69 | 107 | 174 | CEP03147.1 hypothetical protein PBRA_009365 [Plasmodiophora brassicae] | diamond | 828 | 73.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28768356 | 28768356 | PRJNA812715_P_NODE_71167_length_303_cov_1.673913_g69367_i0 | PRJNA812715 | 71167 | 303 | 1.673913 | 5.07195639 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 2.4e-4 | NR | CEO94898.1 | 37360 | g69367 | i0 | 28.6 | 4.75247524752475 | 84 | 60 | 83.2 | 0 | 4 | 255 | 35 | 118 | CEO94898.1 hypothetical protein PBRA_003711 [Plasmodiophora brassicae] | diamond | 1440 | 50.1 | 0.992015968063872 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29264656 | 29264656 | PRJNA812715_P_NODE_117809_length_243_cov_0.905882_g116008_i0 | PRJNA812715 | 117809 | 243 | 0.905882 | 2.20129326 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.41e-15 | NR | CEP00414.1 | 37360 | g116008 | i0 | 54.8 | 0.901234567901235 | 73 | 32 | 88.9 | 1 | 19 | 234 | 258 | 330 | CEP00414.1 hypothetical protein PBRA_001468 [Plasmodiophora brassicae] | diamond | 219 | 80.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29928157 | 29928157 | PRJNA812715_P_NODE_76411_length_290_cov_1.419355_g74611_i0 | PRJNA812715 | 76411 | 290 | 1.419355 | 4.1161295 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 6.57e-5 | NR | SPQ93230.1 | 37360 | g74611 | i0 | 48.1 | 1.11724137931034 | 54 | 25 | 54.8 | 2 | 40 | 198 | 159 | 210 | SPQ93230.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 324 | 51.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30022897 | 30022897 | PRJNA812715_P_NODE_124311_length_227_cov_2.376623_g122510_i0 | PRJNA812715 | 124311 | 227 | 2.376623 | 5.39493421 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 6.16e-9 | NR | CEP00712.1 | 37360 | g122510 | i0 | 59.5 | 0.555066079295154 | 42 | 17 | 55.5 | 0 | 101 | 226 | 207 | 248 | CEP00712.1 hypothetical protein PBRA_001766 [Plasmodiophora brassicae] | diamond | 126 | 61.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30126058 | 30126058 | PRJNA812715_P_NODE_29392_length_562_cov_2.065440_g27631_i0 | PRJNA812715 | 29392 | 562 | 2.06544 | 11.6077728 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 4.4600000000000005e-58 | NR | CEP03653.1 | 37360 | g27631 | i0 | 52 | 8.33807829181495 | 175 | 84 | 93.4 | 0 | 525 | 1 | 4 | 178 | CEP03653.1 hypothetical protein PBRA_003260 [Plasmodiophora brassicae] | diamond | 4686 | 191 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30244010 | 30244010 | PRJNA812715_P_NODE_116152_length_244_cov_0.900585_g114351_i0 | PRJNA812715 | 116152 | 244 | 0.900585 | 2.1974274 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.27e-29 | NR | SPR02116.1 | 37360 | g114351 | i0 | 74 | 3.72540983606557 | 77 | 20 | 94.7 | 0 | 5 | 235 | 3210 | 3286 | SPR02116.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 909 | 119 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30339181 | 30339181 | PRJNA812715_P_NODE_90212_length_268_cov_1.579487_g88411_i0 | PRJNA812715 | 90212 | 268 | 1.579487 | 4.23302516 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 2.03e-5 | NR | CEO95889.1 | 37360 | g88411 | i0 | 51.9 | 0.582089552238806 | 52 | 22 | 58.2 | 1 | 156 | 1 | 234 | 282 | CEO95889.1 hypothetical protein PBRA_009688, partial [Plasmodiophora brassicae] | diamond | 156 | 52.4 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31444788 | 31444788 | PRJNA812715_P_NODE_51696_length_374_cov_1.109635_g49898_i0 | PRJNA812715 | 51696 | 374 | 1.109635 | 4.1500349 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 3.38e-4 | NR | CEO95712.1 | 37360 | g49898 | i0 | 32.3 | 2.18983957219251 | 96 | 58 | 74.6 | 4 | 17 | 295 | 802 | 893 | CEO95712.1 hypothetical protein PBRA_004425 [Plasmodiophora brassicae] | diamond | 819 | 50.4 | 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);;