contig_metadata
6 rows where analysis = "blastn", 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 |
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);;