contig_metadata
16 rows where bioproject = "PRJNA734348" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4547551 | 4547551 | PRJNA734348_P_NODE_87204_length_254_cov_2.535912_g86506_i0 | PRJNA734348 | 87204 | 254 | 2.535912 | 6.44121648 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 4.88e-44 | NR | OQS00308.1 | 74557 | g86506 | i0 | 90.5 | 19.8425196850394 | 84 | 8 | 99.2 | 0 | 253 | 2 | 223 | 306 | OQS00308.1 ATP-dependent RNA helicase eIF4A, partial [Thraustotheca clavata] | diamond | 5040 | 162 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 5025655 | 5025655 | PRJNA734348_P_NODE_57184_length_282_cov_2.421053_g56487_i0 | PRJNA734348 | 57184 | 282 | 2.421053 | 6.82736946 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 1.6499999999999996e-143 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g56487 | i0 | 100 | 100.028368794326 | 282 | 0 | 100 | 0 | 1 | 282 | 196 | 477 | Aphanomyces euteiches cDNA | blastn | 28208 | 521 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13472096 | 13472096 | PRJNA734348_P_NODE_44671_length_301_cov_2.771930_g43974_i0 | PRJNA734348 | 44671 | 301 | 2.77193 | 8.3435093 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.31e-137 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g43974 | i0 | 96.678 | 1.37541528239203 | 301 | 10 | 100 | 0 | 1 | 301 | 365 | 665 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 414 | 501 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14746422 | 14746422 | PRJNA734348_P_NODE_142432_length_229_cov_2.064103_g141734_i0 | PRJNA734348 | 142432 | 229 | 2.064103 | 4.72679587 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 3.07e-75 | NTclustered | gi|325195136|emb|FR825930.1| | 890382 | g141734 | i0 | 89.627 | 2.96069868995633 | 241 | 12 | 100 | 7 | 1 | 229 | 403 | 164 | Albugo laibachii Nc14, genomic contig CONTIG_2990_NC14_v4_499_54 | blastn | 678 | 294 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 17295248 | 17295248 | PRJNA734348_P_NODE_126294_length_242_cov_2.958580_g125596_i0 | PRJNA734348 | 126294 | 242 | 2.95858 | 7.1597636 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.2100000000000004e-59 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g125596 | i0 | 84.898 | 4.87603305785124 | 245 | 31 | 100 | 5 | 1 | 242 | 839 | 598 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 1180 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 18570022 | 18570022 | PRJNA734348_P_NODE_41695_length_310_cov_2.565401_g40999_i0 | PRJNA734348 | 41695 | 310 | 2.565401 | 7.9527431 | Peronospora aparines | 162109 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 4.39e-70 | NTclustered | gi|23306501|gb|AY035484.1| | 162109 | g40999 | i0 | 100 | 81.6483870967742 | 150 | 0 | 97 | 0 | 1 | 150 | 677 | 528 | Peronospora aparines isolate MG 4-5 large subunit ribosomal RNA gene, partial sequence | blastn | 25311 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora aparines | ||
| 26609022 | 26609022 | PRJNA734348_P_NODE_143381_length_227_cov_3.551948_g142683_i0 | PRJNA734348 | 143381 | 227 | 3.551948 | 8.06292196 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 4.24e-5 | NR | CCA27515.1 | 890382 | g142683 | i0 | 58.1 | 0.568281938325991 | 43 | 17 | 55.5 | 1 | 52 | 177 | 380 | 422 | CCA27515.1 hypothetical protein CHGG_03237 [Albugo laibachii Nc14] | diamond | 129 | 50.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27273693 | 27273693 | PRJNA734348_P_NODE_129623_length_242_cov_0.911243_g128925_i0 | PRJNA734348 | 129623 | 242 | 0.911243 | 2.20520806 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 9.54e-28 | NR | KAF0724467.1 | 100861 | g128925 | i0 | 81.3 | 1.58677685950413 | 64 | 12 | 79.3 | 0 | 2 | 193 | 13 | 76 | KAF0724467.1 hypothetical protein Ae201684_016874 [Aphanomyces euteiches] | diamond | 384 | 105 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27400203 | 27400203 | PRJNA734348_P_NODE_127923_length_242_cov_0.911243_g127225_i0 | PRJNA734348 | 127923 | 242 | 0.911243 | 2.20520806 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 8.88e-18 | NR | OWZ08250.1 | 4795 | g127225 | i0 | 52.5 | 3.91735537190083 | 80 | 38 | 99.2 | 0 | 2 | 241 | 116 | 195 | OWZ08250.1 Retrovirus-related Pol Polyprotein from transposon 17.6 [Phytophthora megakarya] | diamond | 948 | 85.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 29262727 | 29262727 | PRJNA734348_P_NODE_113449_length_246_cov_0.890173_g112751_i0 | PRJNA734348 | 113449 | 246 | 0.890173 | 2.18982558 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.57e-4 | NR | XP_008867870.1 | 157072 | g112751 | i0 | 38.7 | 0.914634146341463 | 75 | 43 | 91.5 | 2 | 21 | 245 | 723 | 794 | XP_008867870.1 hypothetical protein H310_05039 [Aphanomyces invadans] | diamond | 225 | 48.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 29609950 | 29609950 | PRJNA734348_P_NODE_68390_length_271_cov_1.989899_g67693_i0 | PRJNA734348 | 68390 | 271 | 1.989899 | 5.39262629 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.1399999999999993e-46 | NR | OWZ15692.1 | 4795 | g67693 | i0 | 93.3 | 4.98154981549815 | 90 | 6 | 99.6 | 0 | 270 | 1 | 152 | 241 | OWZ15692.1 Major Facilitator Superfamily (MFS) transporter [Phytophthora megakarya] | diamond | 1350 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 29736312 | 29736312 | PRJNA734348_P_NODE_106210_length_247_cov_2.454023_g105512_i0 | PRJNA734348 | 106210 | 247 | 2.454023 | 6.06143681 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 5.34e-10 | NR | KAE9345885.1 | 53985 | g105512 | i0 | 51.9 | 2.56275303643725 | 52 | 25 | 63.2 | 0 | 214 | 59 | 379 | 430 | KAE9345885.1 Pre-mRNA-splicing factor [Phytophthora fragariae] | diamond | 633 | 65.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 30979070 | 30979070 | PRJNA734348_P_NODE_103114_length_248_cov_1.405714_g102416_i0 | PRJNA734348 | 103114 | 248 | 1.405714 | 3.48617072 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 5.65e-4 | NR | XP_008880287.1 | 157072 | g102416 | i0 | 41.1 | 10.5725806451613 | 56 | 33 | 67.7 | 0 | 169 | 2 | 126 | 181 | XP_008880287.1 hypothetical protein H310_14250 [Aphanomyces invadans] | diamond | 2622 | 48.1 | 0.993762993762994 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 31294900 | 31294900 | PRJNA734348_P_NODE_33955_length_334_cov_3.099617_g33259_i0 | PRJNA734348 | 33955 | 334 | 3.099617 | 10.35272078 | root | 1 | Root_unresolved | Root_unresolved | 206 | 2.5000000000000008e-65 | NR | KAL0582261.1 | 65357 | g33259 | i0 | 100 | 1.97604790419162 | 110 | 0 | 98.8 | 0 | 3 | 332 | 11 | 120 | KAL0582261.1 hypothetical protein ABG067_007890, partial [Albugo candida] | diamond | 660 | 206 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31358306 | 31358306 | PRJNA734348_P_NODE_114036_length_245_cov_2.860465_g113338_i0 | PRJNA734348 | 114036 | 245 | 2.860465 | 7.00813925 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.81e-26 | NR | XP_024573476.1 | 4781 | g113338 | i0 | 60.5 | 9.51428571428571 | 81 | 32 | 99.2 | 0 | 1 | 243 | 533 | 613 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 2331 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32865106 | 32865106 | PRJNA734348_P_NODE_61360_length_278_cov_1.814634_g60663_i0 | PRJNA734348 | 61360 | 278 | 1.814634 | 5.04468252 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 2.04e-4 | NR | OQS01009.1 | 74557 | g60663 | i0 | 59.6 | 0.507194244604317 | 47 | 19 | 50.7 | 0 | 44 | 184 | 484 | 530 | OQS01009.1 hypothetical protein THRCLA_21647, partial [Thraustotheca clavata] | diamond | 141 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;