contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364636 | 364636 | PRJNA168635_P_NODE_41_length_2031_cov_22.740666_g34_i0 | PRJNA168635 | 41 | 2031 | 22.740666 | 461.86292646 | Woronina pythii | 1484336 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 5.06e-102 | NTclustered | gi|1031965309|gb|KX011114.1| | 1484336 | g34 | i0 | 80.344 | 26.2264894140817 | 524 | 92 | 26 | 11 | 513 | 1030 | 3618 | 3100 | Woronina pythii isolate PD0236 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 53266 | 387 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Woronina | Woronina pythii | ||
| 1054281 | 1054281 | PRJNA168635_P_NODE_20521_length_180_cov_5.977099_g20105_i0 | PRJNA168635 | 20521 | 180 | 5.977099 | 10.7587782 | Arachnula | 498001 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 5.04e-62 | NTclustered | gi|212674777|gb|EU853660.1| | 536091 | g20105 | i0 | 92.179 | 86.2777777777778 | 179 | 11 | 99 | 3 | 1 | 178 | 575 | 399 | Arachnula impatiens strain BaikalA155 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 15530 | 250 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula impatiens | |||
| 2329613 | 2329613 | PRJNA168635_P_NODE_32942_length_159_cov_10.881818_g32526_i0 | PRJNA168635 | 32942 | 159 | 10.881818 | 17.30209062 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 9.689999999999999e-39 | NTclustered | gi|475391924|emb|HE860056.1| | 41456 | g32526 | i0 | 93.162 | 81.3081761006289 | 117 | 8 | 74 | 0 | 1 | 117 | 127 | 243 | Polymyxa betae genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate 73Ren9 | blastn | 12928 | 172 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 8017744 | 8017744 | PRJNA168635_P_NODE_17787_length_190_cov_2.567376_g17371_i0 | PRJNA168635 | 17787 | 190 | 2.567376 | 4.8780144 | Hyalodiscus sp. (in: eukaryotes) | 2046764 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.47e-77 | NTclustered | gi|1681073020|gb|MH973260.1| | 2046764 | g17371 | i0 | 95.263 | 100.089473684211 | 190 | 9 | 100 | 0 | 1 | 190 | 184 | 373 | Hyalodiscus sp. (in: Vampyrellida) clone 13046771 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19017 | 302 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Hyalodiscidae | Hyalodiscus | Hyalodiscus sp. (in: eukaryotes) | |||
| 12532772 | 12532772 | PRJNA168635_P_NODE_13490_length_220_cov_7.988304_g13074_i0 | PRJNA168635 | 13490 | 220 | 7.988304 | 17.5742688 | Plasmodiophoridae | 37358 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.48e-13 | NTclustered | gi|15088524|gb|AF310902.1|AF310902 | 41456 | g13074 | i0 | 91.045 | 18.9136363636364 | 67 | 4 | 30 | 2 | 2 | 67 | 1 | 66 | Polymyxa betae 18S small subunit ribosomal RNA gene, partial sequence | blastn | 4161 | 89.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 13118449 | 13118449 | PRJNA168635_P_NODE_34491_length_154_cov_4.561905_g34075_i0 | PRJNA168635 | 34491 | 154 | 4.561905 | 7.0253337 | uncultured Plasmodiophora | 1938450 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 1.53e-46 | NTclustered | gi|1723854500|gb|MN323507.1| | 1938450 | g34075 | i0 | 90.196 | 96.5844155844156 | 153 | 13 | 99 | 2 | 3 | 154 | 35 | 186 | Uncultured Plasmodiophora clone OTU1441 small subunit ribosomal RNA gene, partial sequence | blastn | 14874 | 198 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | uncultured Plasmodiophora | |||
| 15667170 | 15667170 | PRJNA168635_P_NODE_15173_length_206_cov_3.471338_g14757_i0 | PRJNA168635 | 15173 | 206 | 3.471338 | 7.15095628 | Polymyxa betae | 41456 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 7.97e-36 | NTclustered | gi|2127897050|ref|NC_059071.1| | 41456 | g14757 | i0 | 84.118 | 155.364077669903 | 170 | 25 | 82 | 2 | 1 | 169 | 20026 | 20194 | Polymyxa betae isolate A26-41 genome assembly, organelle: mitochondrion | blastn | 32005 | 163 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 15667219 | 15667219 | PRJNA168635_P_NODE_17253_length_192_cov_6.706294_g16837_i0 | PRJNA168635 | 17253 | 192 | 6.706294 | 12.87608448 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 5.54e-52 | NTclustered | gi|1031965310|gb|KX011115.1| | 37360 | g16837 | i0 | 94.964 | 4.34895833333333 | 139 | 6 | 72 | 1 | 54 | 192 | 7899 | 7762 | 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 | 835 | 217 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 16356687 | 16356687 | PRJNA168635_P_NODE_26653_length_167_cov_4.711864_g26237_i0 | PRJNA168635 | 26653 | 167 | 4.711864 | 7.86881288 | Vampyrellida | 1367446 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.5e-78 | NTclustered | gi|2452456618|gb|OQ591878.1| | 3032651 | g26237 | i0 | 99.401 | 100.035928143713 | 167 | 1 | 100 | 0 | 1 | 167 | 731 | 897 | Vampyrella closterii strain VC01 small subunit ribosomal RNA gene, partial sequence | blastn | 16706 | 303 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Vampyrellidae | Vampyrella | Vampyrella closterii | |||
| 19490237 | 19490237 | PRJNA168635_P_NODE_12196_length_233_cov_16.739130_g11780_i0 | PRJNA168635 | 12196 | 233 | 16.73913 | 39.0021729 | uncultured Leptophrys | 2108307 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.01e-105 | NTclustered | gi|1746154085|gb|MN480833.1| | 2108307 | g11780 | i0 | 97.436 | 101.793991416309 | 234 | 1 | 98 | 2 | 1 | 229 | 1317 | 1550 | Uncultured Leptophrys clone em.91 small subunit ribosomal RNA gene, partial sequence | blastn | 23718 | 394 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | uncultured Leptophrys | ||||
| 19490403 | 19490403 | PRJNA168635_P_NODE_20236_length_181_cov_4.242424_g19820_i0 | PRJNA168635 | 20236 | 181 | 4.242424 | 7.67878744 | Leptophrys vorax | 1108494 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.08e-73 | NTclustered | gi|378735000|emb|HE609039.1| | 1108494 | g19820 | i0 | 95.556 | 100.701657458564 | 180 | 8 | 99 | 0 | 1 | 180 | 1372 | 1551 | Leptophrys vorax partial 18S rRNA gene, strain LV.04 | blastn | 18227 | 289 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Leptophrys | Leptophrys vorax | |||
| 20765908 | 20765908 | PRJNA168635_P_NODE_15377_length_204_cov_7.980645_g14961_i0 | PRJNA168635 | 15377 | 204 | 7.980645 | 16.2805158 | Vampyrellidae sp. | 2588357 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.87e-25 | NTclustered | gi|2106138081|gb|OK381876.1| | 2588357 | g14961 | i0 | 78.261 | 21.0490196078431 | 207 | 39 | 100 | 6 | 1 | 204 | 598 | 801 | Vampyrellidae sp. isolate BOP1 small subunit ribosomal RNA gene, partial sequence | blastn | 4294 | 128 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Vampyrellidae | Vampyrellidae sp. | ||||
| 22041402 | 22041402 | PRJNA168635_P_NODE_9458_length_271_cov_5.306306_g9043_i0 | PRJNA168635 | 9458 | 271 | 5.306306 | 14.38008926 | Haplosporida sp. | 2651821 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 5.23e-19 | NTclustered | gi|1830680059|gb|MT334478.1| | 2651821 | g9043 | i0 | 86.735 | 34.4022140221402 | 98 | 12 | 36 | 1 | 57 | 153 | 458 | 555 | Haplosporida sp. isolate Water_P3Pool_Feb small subunit ribosomal RNA gene, partial sequence | blastn | 9323 | 108 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Haplosporida sp. | ||||
| 22731008 | 22731008 | PRJNA168635_P_NODE_2018_length_569_cov_31.842308_g1652_i0 | PRJNA168635 | 2018 | 569 | 31.842308 | 181.18273252 | Vampyrellida | 1367446 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 1.03e-118 | NTclustered | gi|2452456618|gb|OQ591878.1| | 3032651 | g1652 | i0 | 81.142 | 99.8066783831283 | 578 | 83 | 100 | 19 | 1 | 569 | 523 | 1083 | Vampyrella closterii strain VC01 small subunit ribosomal RNA gene, partial sequence | blastn | 56790 | 440 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Vampyrellidae | Vampyrella | Vampyrella closterii | |||
| 25280187 | 25280187 | PRJNA168635_P_NODE_12300_length_232_cov_4.508197_g11884_i0 | PRJNA168635 | 12300 | 232 | 4.508197 | 10.45901704 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.98e-84 | NTclustered | gi|30141003|dbj|AB094974.1| | 37360 | g11884 | i0 | 92.174 | 84.4008620689655 | 230 | 16 | 99 | 2 | 1 | 230 | 65 | 292 | Plasmodiophora brassicae gene for 18S rRNA, partial sequence, isolate: Sak3 | blastn | 19581 | 324 | 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);;