contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6190849 | 6190849 | PRJNA429937_P_NODE_78765_length_370_cov_3.557185_g56437_i0 | PRJNA429937 | 78765 | 370 | 3.557185 | 13.1615845 | Verrucalvaceae | 120409 | SAR_Eukaryotes | SAR_Eukaryotes | 665 | 0 | NTclustered | gi|698793877|ref|XR_717099.1| | 112090 | g56437 | i0 | 99.189 | 99.7108108108108 | 370 | 2 | 100 | 1 | 1 | 370 | 609 | 977 | Aphanomyces astaci 18S ribosomal RNA rRNA | blastn | 36893 | 671 | 0.991058122205663 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8079255 | 8079255 | PRJNA429937_P_NODE_144867_length_197_cov_3.797619_g122240_i0 | PRJNA429937 | 144867 | 197 | 3.797619 | 7.48130943 | Phytophthora megasperma | 4788 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.1899999999999998e-73 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g122240 | i0 | 95.604 | 86.6192893401015 | 182 | 4 | 91 | 2 | 18 | 197 | 2855 | 2676 | P.megasperma gene for 28S ribosomal RNA | blastn | 17064 | 289 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 10629446 | 10629446 | PRJNA429937_P_NODE_10689_length_1111_cov_4.596118_g6277_i0 | PRJNA429937 | 10689 | 1111 | 4.596118 | 51.06287098 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.32e-70 | NTclustered | gi|2794924106|ref|XM_067882382.1| | 164328 | g6277 | i0 | 85.294 | 1.13951395139514 | 272 | 40 | 43 | 0 | 1 | 272 | 1735 | 1464 | Phytophthora ramorum Cyclin-dependent kinase 3 (KRP23_11803), partial mRNA | blastn | 1266 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 10629465 | 10629465 | PRJNA429937_P_NODE_108389_length_278_cov_7343.935743_g85768_i0 | PRJNA429937 | 108389 | 278 | 7343.935743 | 20416.14136554 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.189999999999999e-112 | NTclustered | gi|325194343|emb|FR825184.1| | 890382 | g85768 | i0 | 93.617 | 101.809352517986 | 282 | 14 | 100 | 2 | 1 | 278 | 85 | 366 | Albugo laibachii Nc14, genomic contig CONTIG_1822_NC14_v4_1483_32232 | blastn | 28303 | 418 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 13179505 | 13179505 | PRJNA429937_P_NODE_12991_length_1013_cov_4.948171_g6277_i2 | PRJNA429937 | 12991 | 1013 | 4.948171 | 50.12497223 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 1.8799999999999998e-118 | NTclustered | gi|675195502|ref|XM_008908388.1| | 761204 | g6277 | i2 | 85.116 | 3.67620927936821 | 430 | 64 | 42 | 0 | 584 | 1013 | 1595 | 2024 | Phytophthora parasitica INRA-310 CMGC/CDK/CDC2 protein kinase, variant 1 mRNA | blastn | 3724 | 440 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14454805 | 14454805 | PRJNA429937_P_NODE_137552_length_209_cov_10.488889_g114925_i0 | PRJNA429937 | 137552 | 209 | 10.488889 | 21.92177801 | Globisporangium rostratifingens | 2711122 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 5.72e-102 | NTclustered | gi|573007537|gb|HQ643761.2| | 2711122 | g114925 | i0 | 100 | 99.0526315789474 | 207 | 0 | 99 | 0 | 3 | 209 | 3813 | 3607 | Pythium rostratifingens voucher CBS115464 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 | 20702 | 383 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium rostratifingens | ||
| 15728689 | 15728689 | PRJNA429937_P_NODE_154373_length_165_cov_6.610294_g131746_i0 | PRJNA429937 | 154373 | 165 | 6.610294 | 10.9069851 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.46e-77 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g131746 | i0 | 99.398 | 100.575757575758 | 166 | 0 | 100 | 1 | 1 | 165 | 235 | 400 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 16595 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 17003715 | 17003715 | PRJNA429937_P_NODE_29454_length_672_cov_6.611198_g17844_i0 | PRJNA429937 | 29454 | 672 | 6.611198 | 44.42725056 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 6.65e-7 | NTclustered | gi|166997812|emb|CU469389.7| | 123356 | g17844 | i0 | 83.784 | 0.327380952380952 | 74 | 11 | 11 | 1 | 50 | 122 | 103503 | 103430 | H.parasitica DNA sequence from clone HpEmoy2-12J23, complete sequence | blastn | 220 | 69.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 19553481 | 19553481 | PRJNA429937_P_NODE_8876_length_1203_cov_11.770017_g5224_i0 | PRJNA429937 | 8876 | 1203 | 11.770017 | 141.59330451 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 689 | 0 | NTclustered | gi|669172050|ref|XM_008623152.1| | 1156394 | g5224 | i0 | 79.753 | 4.25436408977556 | 973 | 180 | 80 | 14 | 215 | 1179 | 1406 | 443 | Saprolegnia diclina VS20 ketol-acid reductoisomerase partial mRNA | blastn | 5118 | 689 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 22104265 | 22104265 | PRJNA429937_P_NODE_97838_length_308_cov_663.028674_g75232_i0 | PRJNA429937 | 97838 | 308 | 663.028674 | 2042.12831592 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.0799999999999999e-150 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g75232 | i0 | 99.016 | 98.6558441558442 | 305 | 1 | 99 | 2 | 5 | 308 | 844 | 541 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 30386 | 545 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 23378964 | 23378964 | PRJNA429937_P_NODE_47599_length_515_cov_103.670782_g30896_i0 | PRJNA429937 | 47599 | 515 | 103.670782 | 533.9045273 | Globisporangium rostratifingens | 2711122 | SAR_Eukaryotes | SAR_Eukaryotes | 911 | 0 | NTclustered | gi|573007537|gb|HQ643761.2| | 2711122 | g30896 | i0 | 98.459 | 99.7145631067961 | 519 | 4 | 100 | 1 | 1 | 515 | 3102 | 3620 | Pythium rostratifingens voucher CBS115464 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 | 51353 | 911 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium rostratifingens | ||
| 24039484 | 24039484 | PRJNA429937_P_NODE_67119_length_414_cov_716.877922_g46052_i0 | PRJNA429937 | 67119 | 414 | 716.877922 | 2967.87459708 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2.5199999999999992e-143 | NTclustered | gi|33520249|gb|AY273994.1| | 127444 | g46052 | i0 | 89.951 | 98.3115942028985 | 408 | 36 | 98 | 5 | 5 | 408 | 413 | 7 | Pythium undulatum large subunit ribosomal RNA gene, partial sequence | blastn | 40701 | 521 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Elongisporangium | Elongisporangium undulatum | ||
| 24039510 | 24039510 | PRJNA429937_P_NODE_71839_length_395_cov_541.628415_g50082_i0 | PRJNA429937 | 71839 | 395 | 541.628415 | 2139.43223925 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 2.9899999999999996e-167 | NTclustered | gi|90655131|gb|DQ361252.1| | 4794 | g50082 | i0 | 94.602 | 98.2455696202532 | 389 | 20 | 98 | 1 | 4 | 391 | 75 | 463 | Phytophthora drechsleri large subunit ribosomal RNA gene, partial sequence | blastn | 38807 | 606 | 0.991749174917492 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora drechsleri |
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);;