contig_metadata
16 rows where bioproject = "PRJNA1182301" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 318493 | 318493 | PRJNA1182301_P_NODE_2901_length_514_cov_3.725624_g2777_i0 | PRJNA1182301 | 2901 | 514 | 3.725624 | 19.14970736 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 904 | 0 | NTclustered | gi|166046792|emb|CU367367.1| | 100861 | g2777 | i0 | 97.674 | 99.1984435797665 | 516 | 10 | 100 | 1 | 1 | 514 | 195 | 710 | Aphanomyces euteiches cDNA | blastn | 50988 | 904 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 4870011 | 4870011 | PRJNA1182301_P_NODE_7664_length_377_cov_1.578947_g7539_i0 | PRJNA1182301 | 7664 | 377 | 1.578947 | 5.95263019 | root | 1 | Root_unresolved | Root_unresolved | 573 | 6.199999999999999e-159 | NTclustered | gi|166044534|emb|CU367443.1| | 100861 | g7539 | i0 | 99.681 | 1.83023872679045 | 313 | 1 | 83 | 0 | 1 | 313 | 70 | 382 | Aphanomyces euteiches cDNA | blastn | 690 | 573 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5421560 | 5421560 | PRJNA1182301_P_NODE_32145_length_272_cov_1.773869_g32020_i0 | PRJNA1182301 | 32145 | 272 | 1.773869 | 4.82492368 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 2.67e-136 | NTclustered | gi|1290336098|gb|MF784706.1| | 123356 | g32020 | i0 | 99.632 | 108.360294117647 | 272 | 1 | 100 | 0 | 1 | 272 | 849 | 1120 | Hyaloperonospora parasitica voucher KUS-F22302 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 29474 | 497 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 10521685 | 10521685 | PRJNA1182301_P_NODE_13389_length_313_cov_4.154167_g13264_i0 | PRJNA1182301 | 13389 | 313 | 4.154167 | 13.00254271 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.0899999999999999e-160 | NTclustered | gi|166044607|emb|CU367516.1| | 100861 | g13264 | i0 | 100 | 32.1182108626198 | 313 | 0 | 100 | 0 | 1 | 313 | 2 | 314 | Aphanomyces euteiches cDNA | blastn | 10053 | 579 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 11797678 | 11797678 | PRJNA1182301_P_NODE_5630_length_415_cov_2.078947_g5505_i0 | PRJNA1182301 | 5630 | 415 | 2.078947 | 8.62763005 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 767 | 0 | NTclustered | gi|166044613|emb|CU367522.1| | 100861 | g5505 | i0 | 100 | 182.968674698795 | 415 | 0 | 100 | 0 | 1 | 415 | 459 | 45 | Aphanomyces euteiches cDNA | blastn | 75932 | 767 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13794821 | 13794821 | PRJNA1182301_P_NODE_26311_length_280_cov_1.516908_g26186_i0 | PRJNA1182301 | 26311 | 280 | 1.516908 | 4.2473424 | root | 1 | Root_unresolved | Root_unresolved | 507 | 4.58e-139 | NTclustered | gi|166044538|emb|CU367447.1| | 100861 | g26186 | i0 | 99.286 | 113.214285714286 | 280 | 2 | 100 | 0 | 1 | 280 | 257 | 536 | Aphanomyces euteiches cDNA | blastn | 31700 | 507 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16896503 | 16896503 | PRJNA1182301_P_NODE_6934_length_388_cov_2.841270_g6809_i0 | PRJNA1182301 | 6934 | 388 | 2.84127 | 11.0241276 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 717 | 0 | NTclustered | gi|166046682|emb|CU367792.1| | 100861 | g6809 | i0 | 100 | 83.8376288659794 | 388 | 0 | 100 | 0 | 1 | 388 | 540 | 153 | Aphanomyces euteiches cDNA | blastn | 32529 | 717 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18169899 | 18169899 | PRJNA1182301_P_NODE_21835_length_286_cov_1.981221_g21710_i0 | PRJNA1182301 | 21835 | 286 | 1.981221 | 5.66629206 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1e-145 | NTclustered | gi|166044589|emb|CU367498.1| | 100861 | g21710 | i0 | 100 | 100.101398601399 | 286 | 0 | 100 | 0 | 1 | 286 | 371 | 86 | Aphanomyces euteiches cDNA | blastn | 28629 | 529 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18893186 | 18893186 | PRJNA1182301_P_NODE_47935_length_251_cov_3.252809_g47810_i0 | PRJNA1182301 | 47935 | 251 | 3.252809 | 8.16455059 | root | 1 | Root_unresolved | Root_unresolved | 414 | 2.52e-111 | NTclustered | gi|166046495|emb|CU367612.1| | 100861 | g47810 | i0 | 97.908 | 3.88446215139442 | 239 | 5 | 95 | 0 | 13 | 251 | 1 | 239 | Aphanomyces euteiches cDNA | blastn | 975 | 418 | 0.990430622009569 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20719859 | 20719859 | PRJNA1182301_P_NODE_32877_length_271_cov_1.944444_g32752_i0 | PRJNA1182301 | 32877 | 271 | 1.944444 | 5.26944324 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 6.129999999999998e-88 | NTclustered | gi|166046617|emb|CU367734.1| | 100861 | g32752 | i0 | 98.429 | 1.68634686346863 | 191 | 3 | 70 | 0 | 2 | 192 | 1 | 191 | Aphanomyces euteiches cDNA | blastn | 457 | 337 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21996101 | 21996101 | PRJNA1182301_P_NODE_9478_length_352_cov_1.655914_g9353_i0 | PRJNA1182301 | 9478 | 352 | 1.655914 | 5.82881728 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 651 | 0 | NTclustered | gi|166046520|emb|CU367637.1| | 100861 | g9353 | i0 | 100 | 30.0710227272727 | 352 | 0 | 100 | 0 | 1 | 352 | 476 | 125 | Aphanomyces euteiches cDNA | blastn | 10585 | 651 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25267596 | 25267596 | PRJNA1182301_P_NODE_15700_length_307_cov_1.974359_g15575_i0 | PRJNA1182301 | 15700 | 307 | 1.974359 | 6.06128213 | root | 1 | Root_unresolved | Root_unresolved | 568 | 2.3e-157 | NTclustered | gi|166046524|emb|CU367641.1| | 100861 | g15575 | i0 | 100 | 41.7459283387622 | 307 | 0 | 100 | 0 | 1 | 307 | 386 | 80 | Aphanomyces euteiches cDNA | blastn | 12816 | 568 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 26616516 | 26616516 | PRJNA1182301_P_NODE_49441_length_250_cov_3.016949_g49316_i0 | PRJNA1182301 | 49441 | 250 | 3.016949 | 7.5423725 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 4.25e-5 | NR | TYZ69087.1 | 1485010 | g49316 | i0 | 52.6 | 1.368 | 38 | 16 | 45.6 | 1 | 123 | 10 | 776 | 811 | TYZ69087.1 hypothetical protein PybrP1_010193, partial [[Pythium] brassicae (nom. inval.)] | diamond | 342 | 51.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32475263 | 32475263 | PRJNA1182301_P_NODE_66839_length_229_cov_3.987179_g66714_i0 | PRJNA1182301 | 66839 | 229 | 3.987179 | 9.13063991 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 9.52e-14 | NR | GLE02111.1 | 114742 | g66714 | i0 | 40.8 | 1.28384279475983 | 98 | 35 | 98.3 | 1 | 225 | 1 | 21 | 118 | GLE02111.1 hypothetical protein PINS_up010949 [Pythium insidiosum] | diamond | 294 | 75.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32695826 | 32695826 | PRJNA1182301_P_NODE_18740_length_291_cov_1.344037_g18615_i0 | PRJNA1182301 | 18740 | 291 | 1.344037 | 3.91114767 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 7.559999999999998e-54 | NR | RMX62511.1 | 542832 | g18615 | i0 | 91.8 | 1 | 97 | 7 | 100 | 1 | 291 | 1 | 166 | 261 | RMX62511.1 hypothetical protein DD238_007997 [Peronospora effusa] | diamond | 291 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 32714950 | 32714950 | PRJNA1182301_P_NODE_65420_length_235_cov_2.382716_g65295_i0 | PRJNA1182301 | 65420 | 235 | 2.382716 | 5.5993826 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 4.85e-8 | NR | KAH9115027.1 | 100861 | g65295 | i0 | 62.5 | 1.22553191489362 | 48 | 15 | 61.3 | 2 | 91 | 234 | 191 | 235 | KAH9115027.1 hypothetical protein AeMF1_010946 [Aphanomyces euteiches] | diamond | 288 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;