contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000161 | 2000161 | PRJNA745553_S_NODE_17562_length_294_cov_7.407240_g17367_i0 | PRJNA745553 | 17562 | 294 | 7.40724 | 21.7772856 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.82e-125 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g17367 | i0 | 98.479 | 89.4625850340136 | 263 | 1 | 88 | 3 | 24 | 283 | 599 | 861 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 26302 | 460 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 2474071 | 2474071 | PRJNA745553_S_NODE_28042_length_232_cov_5.062893_g27847_i0 | PRJNA745553 | 28042 | 232 | 5.062893 | 11.74591176 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.41e-93 | NTclustered | gi|948299304|ref|NC_028331.1| | 230439 | g27847 | i0 | 97.143 | 93.6508620689655 | 210 | 6 | 91 | 0 | 23 | 232 | 749 | 958 | Peronospora tabacina isolate 968-J2 mitochondrion, complete genome | blastn | 21727 | 355 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora tabacina | ||
| 3275568 | 3275568 | PRJNA745553_S_NODE_25103_length_248_cov_0.880000_g24908_i0 | PRJNA745553 | 25103 | 248 | 0.88 | 2.1824 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 9e-106 | NTclustered | gi|90655144|gb|DQ361265.1| | 907947 | g24908 | i0 | 95.565 | 100.346774193548 | 248 | 10 | 100 | 1 | 1 | 248 | 342 | 96 | Pythium vexans large subunit ribosomal RNA gene, partial sequence | blastn | 24886 | 396 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 8377815 | 8377815 | PRJNA745553_S_NODE_7767_length_428_cov_1.985915_g7572_i0 | PRJNA745553 | 7767 | 428 | 1.985915 | 8.4997162 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 2.23e-74 | NTclustered | gi|2795022084|ref|XM_067941291.1| | 4785 | g7572 | i0 | 93.814 | 2.85747663551402 | 194 | 12 | 45 | 0 | 1 | 194 | 62 | 255 | Phytophthora cinnamomi 40S ribosomal protein S30 (IUM83_16413), partial mRNA | blastn | 1223 | 292 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9652604 | 9652604 | PRJNA745553_S_NODE_19148_length_282_cov_4.712919_g18953_i0 | PRJNA745553 | 19148 | 282 | 4.712919 | 13.29043158 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.2999999999999999e-129 | NTclustered | gi|1235732003|gb|MF693906.1| | 622444 | g18953 | i0 | 98.872 | 94.3049645390071 | 266 | 3 | 94 | 0 | 17 | 282 | 1095 | 1360 | Peronospora belbahrii isolate RC16DM5 large subunit ribosomal RNA gene, partial sequence | blastn | 26594 | 475 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 10928074 | 10928074 | PRJNA745553_S_NODE_15449_length_313_cov_6.937500_g15254_i0 | PRJNA745553 | 15449 | 313 | 6.9375 | 21.714375 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.69e-29 | NTclustered | gi|189083887|gb|BT031403.1| | 4784 | g15254 | i0 | 85.106 | 1.74121405750799 | 141 | 20 | 45 | 1 | 152 | 291 | 421 | 281 | Phytophthora capsici clone CBOT69-P12 mRNA sequence | blastn | 545 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 12203956 | 12203956 | PRJNA745553_S_NODE_9650_length_390_cov_2.097792_g9455_i0 | PRJNA745553 | 9650 | 390 | 2.097792 | 8.1813888 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 4.280000000000001e-86 | NTclustered | gi|166038792|emb|CU355022.1| | 100861 | g9455 | i0 | 88.339 | 10.2589743589744 | 283 | 24 | 71 | 3 | 98 | 374 | 756 | 477 | Aphanomyces euteiches cDNA | blastn | 4001 | 331 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 15227153 | 15227153 | PRJNA745553_S_NODE_17792_length_292_cov_20.607306_g17597_i0 | PRJNA745553 | 17792 | 292 | 20.607306 | 60.17333352 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 4.74e-149 | NTclustered | gi|1820797599|gb|MT192342.1| | 4798 | g17597 | i0 | 100 | 99.3013698630137 | 292 | 0 | 100 | 0 | 1 | 292 | 333 | 42 | Pythium hydnosporum isolate JZB3410001 large subunit ribosomal RNA gene, partial sequence | blastn | 28996 | 540 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium hydnosporum | ||
| 15227257 | 15227257 | PRJNA745553_S_NODE_8352_length_415_cov_289.581871_g8157_i0 | PRJNA745553 | 8352 | 415 | 289.581871 | 1201.76476465 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 7.2399999999999994e-124 | NTclustered | gi|33520229|gb|AY273974.1| | 162125 | g8157 | i0 | 97.736 | 64.110843373494 | 265 | 6 | 64 | 0 | 151 | 415 | 447 | 711 | Hyaloperonospora brassicae large subunit ribosomal RNA gene, partial sequence | blastn | 26606 | 457 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 17776337 | 17776337 | PRJNA745553_S_NODE_12934_length_342_cov_2.107807_g12739_i0 | PRJNA745553 | 12934 | 342 | 2.107807 | 7.20869994 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 6.03e-104 | NTclustered | gi|2794917654|ref|XM_067894117.1| | 164328 | g12739 | i0 | 91.259 | 3.74269005847953 | 286 | 25 | 84 | 0 | 57 | 342 | 624 | 339 | Phytophthora ramorum 60S ribosomal protein L26-1 (KRP23_8650), partial mRNA | blastn | 1280 | 390 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 18575986 | 18575986 | PRJNA745553_S_NODE_28035_length_232_cov_5.245283_g27840_i0 | PRJNA745553 | 28035 | 232 | 5.245283 | 12.16905656 | uncultured Oomycota | 179533 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 8.8e-66 | NTclustered | gi|307940046|gb|HM441723.1| | 179533 | g27840 | i0 | 91.237 | 84.5431034482759 | 194 | 16 | 83 | 1 | 7 | 199 | 194 | 1 | Uncultured oomycete clone s0-Alf-45 large subunit ribosomal RNA gene, partial sequence | blastn | 19614 | 263 | 1 | Eukaryota | Sar | Oomycota | uncultured Oomycota | ||||||
| 22876150 | 22876150 | PRJNA745553_S_NODE_17498_length_295_cov_2.369369_g17303_i0 | PRJNA745553 | 17498 | 295 | 2.369369 | 6.98963855 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 5.139999999999998e-99 | NTclustered | gi|66270180|gb|AY961474.1| | 4787 | g17303 | i0 | 90.21 | 2.90508474576271 | 286 | 28 | 97 | 0 | 1 | 286 | 392 | 107 | Phytophthora infestans clone MY-06-H-02 ribosomal protein S19 mRNA, complete cds | blastn | 857 | 374 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 23677029 | 23677029 | PRJNA745553_S_NODE_1159_length_742_cov_7.097160_g1038_i0 | PRJNA745553 | 1159 | 742 | 7.09716 | 52.6609272 | Plasmopara viticola | 143451 | SAR_Eukaryotes | SAR_Eukaryotes | 1227 | 0 | NTclustered | gi|33520233|gb|AY273978.1| | 143451 | g1038 | i0 | 96.515 | 100.506738544474 | 746 | 19 | 100 | 6 | 1 | 742 | 14 | 756 | Plasmopara viticola large subunit ribosomal RNA gene, partial sequence | blastn | 74576 | 1227 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara viticola | ||
| 23677092 | 23677092 | PRJNA745553_S_NODE_15419_length_314_cov_1.460581_g15224_i0 | PRJNA745553 | 15419 | 314 | 1.460581 | 4.58622434 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 7.14e-98 | NTclustered | gi|169643469|emb|CU469394.8| | 123356 | g15224 | i0 | 87.898 | 1 | 314 | 38 | 100 | 0 | 1 | 314 | 16120 | 16433 | H.parasitica DNA sequence from clone HpEmoy2-18C10, complete sequence | blastn | 314 | 370 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica |
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);;