contig_metadata
12 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2200011 | 2200011 | PRJNA944406_P_NODE_50522_length_262_cov_3.883598_g49563_i0 | PRJNA944406 | 50522 | 262 | 3.883598 | 10.17502676 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.8e-23 | NTclustered | gi|1031965310|gb|KX011115.1| | 37360 | g49563 | i0 | 97.222 | 2.66793893129771 | 72 | 2 | 27 | 0 | 1 | 72 | 7828 | 7899 | Plasmodiophora brassicae isolate AT 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 699 | 122 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 2535029 | 2535029 | PRJNA944406_P_NODE_12482_length_357_cov_3.975352_g11523_i0 | PRJNA944406 | 12482 | 357 | 3.975352 | 14.19200664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|15088520|gb|AF310898.1|AF310898 | 70182 | g11523 | i0 | 99.44 | 84.7927170868347 | 357 | 2 | 100 | 0 | 1 | 357 | 87 | 443 | Polymyxa graminis 18S small subunit ribosomal RNA gene, partial sequence | blastn | 30271 | 649 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa graminis | ||
| 13678690 | 13678690 | PRJNA944406_P_NODE_84131_length_246_cov_2.606936_g83172_i0 | PRJNA944406 | 84131 | 246 | 2.606936 | 6.41306256 | uncultured Pseudodifflugiidae | 765885 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|1915672690|emb|LR866303.1| | 765885 | g83172 | i0 | 100 | 58.7073170731707 | 246 | 0 | 100 | 0 | 1 | 246 | 265 | 20 | uncultured Pseudodifflugiidae partial 18S rRNA gene | blastn | 14442 | 455 | 1 | Eukaryota | Sar | Endomyxa | Gromiida | Pseudodifflugiidae | uncultured Pseudodifflugiidae | ||||
| 15287288 | 15287288 | PRJNA944406_P_NODE_15412_length_327_cov_6.944882_g14453_i0 | PRJNA944406 | 15412 | 327 | 6.944882 | 22.70976414 | Polymyxa | 41455 | SAR_Eukaryotes | SAR_Eukaryotes | 604 | 1.8799999999999993e-168 | NTclustered | gi|607252075|gb|KF111232.1| | 70182 | g14453 | i0 | 100 | 92.4067278287462 | 327 | 0 | 100 | 0 | 1 | 327 | 729 | 403 | Polymyxa graminis isolate PD0239 18S ribosomal RNA gene, partial sequence | blastn | 30217 | 604 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa graminis | ||
| 21326398 | 21326398 | PRJNA944406_P_NODE_18877_length_302_cov_2.510917_g17918_i0 | PRJNA944406 | 18877 | 302 | 2.510917 | 7.58296934 | uncultured Leptophryidae | 2603696 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.4199999999999996e-124 | NTclustered | gi|1723855423|gb|MN324342.1| | 2603696 | g17918 | i0 | 99.602 | 92.8543046357616 | 251 | 1 | 83 | 0 | 52 | 302 | 1 | 251 | Uncultured Leptophryidae clone OTU1557 small subunit ribosomal RNA gene, partial sequence | blastn | 28042 | 459 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | uncultured Leptophryidae | ||||
| 25485921 | 25485921 | PRJNA944406_P_NODE_113620_length_205_cov_4.628788_g112661_i0 | PRJNA944406 | 113620 | 205 | 4.628788 | 9.4890154 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.3599999999999997e-99 | NTclustered | gi|1938230889|gb|MW296889.1| | 70182 | g112661 | i0 | 99.512 | 98.6 | 205 | 1 | 100 | 0 | 1 | 205 | 229 | 25 | Polymyxa graminis isolate CN_AH-i01 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 20213 | 374 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa graminis | ||
| 26835613 | 26835613 | PRJNA944406_P_NODE_97461_length_243_cov_1.811765_g96502_i0 | PRJNA944406 | 97461 | 243 | 1.811765 | 4.40258895 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 8.5e-11 | NR | SPQ96630.1 | 37360 | g96502 | i0 | 60.7 | 1.51851851851852 | 61 | 21 | 74.1 | 2 | 192 | 13 | 60 | 118 | SPQ96630.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 369 | 67 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 26968721 | 26968721 | PRJNA944406_P_NODE_54722_length_259_cov_1.268817_g53763_i0 | PRJNA944406 | 54722 | 259 | 1.268817 | 3.28623603 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 3.14e-4 | NR | CEO95672.1 | 37360 | g53763 | i0 | 72.7 | 0.764478764478765 | 33 | 9 | 38.2 | 0 | 258 | 160 | 204 | 236 | CEO95672.1 hypothetical protein PBRA_009680 [Plasmodiophora brassicae] | diamond | 198 | 48.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28699305 | 28699305 | PRJNA944406_P_NODE_47487_length_265_cov_2.213542_g46528_i0 | PRJNA944406 | 47487 | 265 | 2.213542 | 5.8658863 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.49e-15 | NR | CEP03657.1 | 37360 | g46528 | i0 | 74 | 0.566037735849057 | 50 | 13 | 56.6 | 0 | 71 | 220 | 121 | 170 | CEP03657.1 hypothetical protein PBRA_003264 [Plasmodiophora brassicae] | diamond | 150 | 80.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30151493 | 30151493 | PRJNA944406_P_NODE_92992_length_244_cov_2.274854_g92033_i0 | PRJNA944406 | 92992 | 244 | 2.274854 | 5.55064376 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.01e-10 | NR | SPR01967.1 | 37360 | g92033 | i0 | 52.9 | 1.77049180327869 | 87 | 26 | 88.5 | 4 | 216 | 1 | 141 | 227 | SPR01967.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 432 | 67 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31068186 | 31068186 | PRJNA944406_P_NODE_84375_length_246_cov_1.780347_g83416_i0 | PRJNA944406 | 84375 | 246 | 1.780347 | 4.37965362 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0209 | NR | CEP00780.1 | 37360 | g83416 | i0 | 42.6 | 0.74390243902439 | 61 | 31 | 73.2 | 2 | 225 | 46 | 247 | 304 | CEP00780.1 hypothetical protein PBRA_008092 [Plasmodiophora brassicae] | diamond | 183 | 43.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32459890 | 32459890 | PRJNA944406_P_NODE_42499_length_270_cov_1.563452_g41540_i0 | PRJNA944406 | 42499 | 270 | 1.563452 | 4.2213204 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.54e-23 | NR | CEP00412.1 | 37360 | g41540 | i0 | 57.3 | 0.988888888888889 | 89 | 37 | 97.8 | 1 | 268 | 5 | 158 | 246 | CEP00412.1 hypothetical protein PBRA_001466 [Plasmodiophora brassicae] | diamond | 267 | 103 | 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);;