contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17735353 | 17735353 | PRJNA641707_P_NODE_288034_length_167_cov_13.601695_g285371_i0 | PRJNA641707 | 288034 | 167 | 13.601695 | 22.71483065 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.33e-37 | NTclustered | gi|3983425|gb|AF104308.1|AF104308 | 70186 | g285371 | i0 | 93.103 | 69.3652694610778 | 116 | 6 | 69 | 2 | 42 | 156 | 295 | 181 | Spongospora subterranea 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 | 11584 | 169 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Spongospora | Spongospora subterranea | ||
| 17735511 | 17735511 | PRJNA641707_P_NODE_311714_length_161_cov_3.544643_g309051_i0 | PRJNA641707 | 311714 | 161 | 3.544643 | 5.70687523 | Plasmodiophoridae | 37358 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 4.39e-67 | NTclustered | gi|1938230909|gb|MW296909.1| | 70182 | g309051 | i0 | 99.32 | 91.1614906832298 | 147 | 1 | 91 | 0 | 13 | 159 | 64 | 210 | Polymyxa graminis isolate CN_SC-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 | 14677 | 268 | 0.996268656716418 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa graminis | ||
| 18467348 | 18467348 | PRJNA641707_P_NODE_292955_length_166_cov_4.324786_g290292_i0 | PRJNA641707 | 292955 | 166 | 4.324786 | 7.17914476 | Vampyrellidae sp. | 2588357 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.74e-26 | NTclustered | gi|2106138080|gb|OK381875.1| | 2588357 | g290292 | i0 | 83.007 | 91.7590361445783 | 153 | 19 | 90 | 7 | 7 | 155 | 1126 | 1275 | Vampyrellidae sp. isolate SCO4 small subunit ribosomal RNA gene, partial sequence | blastn | 15232 | 132 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Vampyrellidae | Vampyrellidae sp. | ||||
| 19008807 | 19008807 | PRJNA641707_P_NODE_270415_length_174_cov_3.864000_g267752_i0 | PRJNA641707 | 270415 | 174 | 3.864 | 6.72336 | Plasmodiophoridae | 37358 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 4.01e-13 | NTclustered | gi|2127897050|ref|NC_059071.1| | 41456 | g267752 | i0 | 94.643 | 30.5574712643678 | 56 | 3 | 32 | 0 | 29 | 84 | 20015 | 19960 | Polymyxa betae isolate A26-41 genome assembly, organelle: mitochondrion | blastn | 5317 | 87.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 19739435 | 19739435 | PRJNA641707_P_NODE_179516_length_200_cov_5.543046_g176853_i0 | PRJNA641707 | 179516 | 200 | 5.543046 | 11.086092 | Placopus flabellus | 1917526 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 5.95e-37 | NTclustered | gi|1102585904|gb|KY124641.1| | 1917526 | g176853 | i0 | 96.97 | 82.96 | 99 | 3 | 98 | 0 | 2 | 100 | 365 | 267 | Placopus flabellus strain Hfla01 small subunit ribosomal RNA gene, partial sequence | blastn | 16592 | 167 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Placopodidae | Placopus | Placopus flabellus | |||
| 21013523 | 21013523 | PRJNA641707_P_NODE_11357_length_638_cov_158.354839_g9249_i0 | PRJNA641707 | 11357 | 638 | 158.354839 | 1010.30387282 | Haplosporida sp. | 2651821 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 6.21e-17 | NTclustered | gi|1830680059|gb|MT334478.1| | 2651821 | g9249 | i0 | 85.714 | 14.6128526645768 | 98 | 13 | 15 | 1 | 522 | 618 | 458 | 555 | Haplosporida sp. isolate Water_P3Pool_Feb small subunit ribosomal RNA gene, partial sequence | blastn | 9323 | 102 | 1 | Eukaryota | Sar | Endomyxa | Ascetosporea | Haplosporida | Haplosporida sp. | ||||
| 24843444 | 24843444 | PRJNA641707_P_NODE_70720_length_249_cov_3.680000_g68057_i0 | PRJNA641707 | 70720 | 249 | 3.68 | 9.1632 | Vampyrellidae sp. | 2588357 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 4.48e-59 | NTclustered | gi|2106138081|gb|OK381876.1| | 2588357 | g68057 | i0 | 83.268 | 58.0923694779116 | 257 | 28 | 99 | 11 | 2 | 249 | 1570 | 1320 | Vampyrellidae sp. isolate BOP1 small subunit ribosomal RNA gene, partial sequence | blastn | 14465 | 241 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Vampyrellidae | Vampyrellidae sp. |
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);;