contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Oomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7596790 | 7596790 | PRJNA799842_P_NODE_125966_length_260_cov_1.951872_g124393_i0 | PRJNA799842 | 125966 | 260 | 1.951872 | 5.0748672 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.1899999999999999e-129 | NTclustered | gi|51235482|gb|AY598628.1| | 82932 | g124393 | i0 | 99.615 | 99.8884615384615 | 260 | 1 | 100 | 0 | 1 | 260 | 1397 | 1138 | Pythium arrhenomanes strain CBS 324.62 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25971 | 475 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium arrhenomanes | ||
| 8872722 | 8872722 | PRJNA799842_P_NODE_68867_length_344_cov_1.988930_g67294_i0 | PRJNA799842 | 68867 | 344 | 1.98893 | 6.8419192 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 3.289999999999999e-176 | NTclustered | gi|505574760|gb|AY598624.2| | 4799 | g67294 | i0 | 99.709 | 100.25 | 344 | 1 | 100 | 0 | 1 | 344 | 604 | 947 | Pythium torulosum strain CBS 316.33 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 | 34486 | 636 | 0.990566037735849 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium torulosum | ||
| 10998740 | 10998740 | PRJNA799842_P_NODE_39049_length_458_cov_1.184416_g37478_i0 | PRJNA799842 | 39049 | 458 | 1.184416 | 5.42462528 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 1.43e-81 | NTclustered | gi|57903352|gb|AY729827.1| | 74557 | g37478 | i0 | 80.63 | 91.0502183406114 | 413 | 76 | 90 | 4 | 2 | 412 | 385 | 795 | Thraustotheca clavata beta-tubulin gene, partial cds | blastn | 41701 | 316 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 12273262 | 12273262 | PRJNA799842_P_NODE_164850_length_245_cov_1.877907_g163277_i0 | PRJNA799842 | 164850 | 245 | 1.877907 | 4.60087215 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.1299999999999999e-114 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g163277 | i0 | 97.959 | 101.608163265306 | 245 | 5 | 100 | 0 | 1 | 245 | 463 | 707 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 24894 | 425 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 16097244 | 16097244 | PRJNA799842_P_NODE_34613_length_489_cov_2.596154_g33043_i0 | PRJNA799842 | 34613 | 489 | 2.596154 | 12.69519306 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 837 | 0 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g33043 | i0 | 97.741 | 103.513292433538 | 487 | 10 | 99 | 1 | 2 | 488 | 9961 | 9476 | Pythium ultimum mitochondrion, complete genome | blastn | 50618 | 837 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 19920359 | 19920359 | PRJNA799842_P_NODE_144276_length_249_cov_1.750000_g142703_i0 | PRJNA799842 | 144276 | 249 | 1.75 | 4.3575 | Phytophthora pluvialis | 1330343 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.09e-23 | NTclustered | gi|2308292446|gb|OK574297.1| | 1330343 | g142703 | i0 | 81.633 | 59.2449799196787 | 147 | 25 | 58 | 2 | 1 | 145 | 24494 | 24640 | Phytophthora pluvialis voucher NZFS3000 mitochondrion, complete genome | blastn | 14752 | 121 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora pluvialis | ||
| 20346190 | 20346190 | PRJNA799842_P_NODE_93336_length_300_cov_1.625551_g91763_i0 | PRJNA799842 | 93336 | 300 | 1.625551 | 4.876653 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 549 | 8.119999999999997e-152 | NTclustered | gi|51235482|gb|AY598628.1| | 82932 | g91763 | i0 | 99.667 | 99.8433333333333 | 300 | 1 | 100 | 0 | 1 | 300 | 1155 | 856 | Pythium arrhenomanes strain CBS 324.62 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 29953 | 549 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium arrhenomanes | ||
| 21197493 | 21197493 | PRJNA799842_P_NODE_50937_length_398_cov_1.313846_g49364_i0 | PRJNA799842 | 50937 | 398 | 1.313846 | 5.22910708 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 725 | 0 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g49364 | i0 | 99.497 | 97.0125628140703 | 398 | 2 | 100 | 0 | 1 | 398 | 52 | 449 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 38611 | 725 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 25021415 | 25021415 | PRJNA799842_P_NODE_39940_length_452_cov_1.588391_g38369_i0 | PRJNA799842 | 39940 | 452 | 1.588391 | 7.17952732 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 828 | 0 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g38369 | i0 | 99.778 | 100.648230088496 | 451 | 1 | 99 | 0 | 2 | 452 | 889 | 439 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 45493 | 828 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 25445376 | 25445376 | PRJNA799842_P_NODE_122400_length_264_cov_1.989529_g120827_i0 | PRJNA799842 | 122400 | 264 | 1.989529 | 5.25235656 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.219999999999998e-132 | NTclustered | gi|51235482|gb|AY598628.1| | 82932 | g120827 | i0 | 99.621 | 97.3863636363636 | 264 | 1 | 100 | 0 | 1 | 264 | 1357 | 1620 | Pythium arrhenomanes strain CBS 324.62 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25710 | 483 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium arrhenomanes |
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);;