contig_metadata
20 rows where bioproject = "PRJNA591127", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3116104 | 3116104 | PRJNA591127_P_NODE_6983_length_278_cov_4.116183_g6815_i0 | PRJNA591127 | 6983 | 278 | 4.116183 | 11.44298874 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.97e-18 | NTclustered | gi|673036227|ref|XM_008873853.1| | 157072 | g6815 | i0 | 83.636 | 19.4928057553957 | 110 | 18 | 40 | 0 | 168 | 277 | 1081 | 972 | Aphanomyces invadans adenosylhomocysteinase 2 mRNA | blastn | 5419 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 5668931 | 5668931 | PRJNA591127_P_NODE_8525_length_252_cov_8.330233_g8357_i0 | PRJNA591127 | 8525 | 252 | 8.330233 | 20.99218716 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 5.88e-58 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g8357 | i0 | 86.916 | 78.1230158730159 | 214 | 24 | 84 | 2 | 41 | 251 | 1542 | 1330 | A.klebsiana beta-tubulin gene, complete cds | blastn | 19687 | 237 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 6943263 | 6943263 | PRJNA591127_P_NODE_25106_length_168_cov_1.389313_g24937_i0 | PRJNA591127 | 25106 | 168 | 1.389313 | 2.33404584 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 2.85e-49 | NTclustered | gi|2661425901|ref|XR_009934662.1| | 403677 | g24937 | i0 | 88.824 | 84.5119047619048 | 170 | 17 | 100 | 2 | 1 | 168 | 2924 | 3093 | Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33268), rRNA | blastn | 14198 | 207 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 8218376 | 8218376 | PRJNA591127_P_NODE_7587_length_267_cov_3.208696_g7419_i0 | PRJNA591127 | 7587 | 267 | 3.208696 | 8.56721832 | Plasmopara viticola | 143451 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.4299999999999996e-125 | NTclustered | gi|33520233|gb|AY273978.1| | 143451 | g7419 | i0 | 97.753 | 99.9588014981273 | 267 | 6 | 100 | 0 | 1 | 267 | 436 | 170 | Plasmopara viticola large subunit ribosomal RNA gene, partial sequence | blastn | 26689 | 460 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara viticola | ||
| 11342222 | 11342222 | PRJNA591127_P_NODE_29_length_2180_cov_23.082128_g20_i0 | PRJNA591127 | 29 | 2180 | 23.082128 | 503.1903904 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.52e-49 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g20 | i0 | 79.739 | 15.1169724770642 | 306 | 51 | 14 | 10 | 366 | 665 | 9797 | 10097 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 32955 | 213 | 0.990610328638498 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 12044230 | 12044230 | PRJNA591127_P_NODE_27730_length_155_cov_1.847458_g27561_i0 | PRJNA591127 | 27730 | 155 | 1.847458 | 2.8635599 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 1.66e-19 | NR | KAL0583940.1 | 65357 | g27561 | i0 | 84.3 | 6.90967741935484 | 51 | 8 | 98.7 | 0 | 2 | 154 | 36 | 86 | KAL0583940.1 hypothetical protein ABG067_006208 [Albugo candida] | diamond | 1071 | 86.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 12044280 | 12044280 | PRJNA591127_P_NODE_4770_length_334_cov_2.292929_g4602_i0 | PRJNA591127 | 4770 | 334 | 2.292929 | 7.65838286 | Phytophthora sp. ML-2023a | 3044284 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.42e-20 | NTclustered | gi|2500404807|gb|OQ735416.1| | 3044284 | g4602 | i0 | 76.733 | 55.2095808383234 | 202 | 47 | 60 | 0 | 114 | 315 | 15700 | 15901 | Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome | blastn | 18440 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. ML-2023a | ||
| 13319058 | 13319058 | PRJNA591127_P_NODE_26611_length_160_cov_1.902439_g26442_i0 | PRJNA591127 | 26611 | 160 | 1.902439 | 3.0439024 | Plasmopara viticola | 143451 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 5.55e-76 | NTclustered | gi|126565763|gb|EF426546.1| | 143451 | g26442 | i0 | 100 | 95 | 160 | 0 | 100 | 0 | 1 | 160 | 767 | 608 | Plasmopara viticola strain UASWS SG1 28S ribosomal RNA gene, complete sequence | blastn | 15200 | 296 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara viticola | ||
| 14593936 | 14593936 | PRJNA591127_P_NODE_27112_length_158_cov_1.132231_g26943_i0 | PRJNA591127 | 27112 | 158 | 1.132231 | 1.78892498 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.11e-25 | NTclustered | gi|675197364|ref|XM_008909319.1| | 761204 | g26943 | i0 | 86.325 | 4.80379746835443 | 117 | 16 | 74 | 0 | 13 | 129 | 2150 | 2034 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 759 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 19691495 | 19691495 | PRJNA591127_P_NODE_26776_length_159_cov_2.713115_g26607_i0 | PRJNA591127 | 26776 | 159 | 2.713115 | 4.31385285 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 2.0399999999999996e-55 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g26607 | i0 | 92.5 | 25.2075471698113 | 160 | 11 | 100 | 1 | 1 | 159 | 136 | 295 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 4008 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 21540816 | 21540816 | PRJNA591127_P_NODE_32217_length_150_cov_1.681416_g32048_i0 | PRJNA591127 | 32217 | 150 | 1.681416 | 2.522124 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 8.680000000000001e-64 | NTclustered | gi|158346541|gb|EU049279.1| | 123356 | g32048 | i0 | 97.959 | 98.0266666666667 | 147 | 3 | 98 | 0 | 1 | 147 | 189 | 335 | Hyaloperonospora parasitica voucher GG1 (MA) internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 14704 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 24090583 | 24090583 | PRJNA591127_P_NODE_13999_length_197_cov_5.462500_g13830_i0 | PRJNA591127 | 13999 | 197 | 5.4625 | 10.761125 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 6.05e-12 | NTclustered | gi|325195448|emb|FR826242.1| | 890382 | g13830 | i0 | 87.5 | 0.730964467005076 | 72 | 9 | 37 | 0 | 2 | 73 | 318 | 389 | Albugo laibachii Nc14, genomic contig CONTIG_3365_NC14_v4_389_722 | blastn | 144 | 84.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24791284 | 24791284 | PRJNA591127_P_NODE_27960_length_154_cov_1.666667_g27791_i0 | PRJNA591127 | 27960 | 154 | 1.666667 | 2.56666718 | Nothophytophthora sp. | 2853999 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 9.359999999999999e-34 | NTclustered | gi|2240249467|gb|MW648547.1| | 2853999 | g27791 | i0 | 85.161 | 62.0064935064935 | 155 | 19 | 99 | 4 | 2 | 154 | 17955 | 18107 | Nothophytophthora sp. culture ICMP:18719 mitochondrion, complete genome | blastn | 9549 | 156 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. | ||
| 27851127 | 27851127 | PRJNA591127_P_NODE_27204_length_157_cov_3.675000_g27035_i0 | PRJNA591127 | 27204 | 157 | 3.675 | 5.76975 | root | 1 | Root_unresolved | Root_unresolved | 87 | 1.65e-18 | NR | DAZ97811.1 | 4803 | g27035 | i0 | 80.4 | 63.1528662420382 | 51 | 10 | 97.5 | 0 | 156 | 4 | 282 | 332 | DAZ97811.1 TPA: hypothetical protein N0F65_002481 [Lagenidium giganteum] | diamond | 9915 | 87.8 | 0.990888382687927 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28324770 | 28324770 | PRJNA591127_P_NODE_30886_length_151_cov_2.350877_g30717_i0 | PRJNA591127 | 30886 | 151 | 2.350877 | 3.54982427 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 8.09e-9 | NR | TYZ63558.1 | 1485010 | g30717 | i0 | 68.3 | 8.64238410596026 | 41 | 13 | 81.5 | 0 | 150 | 28 | 642 | 682 | TYZ63558.1 hypothetical protein PybrP1_013152 [[Pythium] brassicae (nom. inval.)] | diamond | 1305 | 60.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 28924626 | 28924626 | PRJNA591127_P_NODE_11888_length_213_cov_6.721591_g11719_i0 | PRJNA591127 | 11888 | 213 | 6.721591 | 14.31698883 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 5.4300000000000006e-21 | NR | KAK1929143.1 | 4793 | g11719 | i0 | 66.2 | 3.84507042253521 | 68 | 22 | 94.4 | 1 | 9 | 209 | 53 | 120 | KAK1929143.1 40S ribosomal protein S7-2 [Phytophthora citrophthora] | diamond | 819 | 90.5 | 0.995580110497237 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 30205816 | 30205816 | PRJNA591127_P_NODE_29952_length_151_cov_3.280702_g29783_i0 | PRJNA591127 | 29952 | 151 | 3.280702 | 4.95386002 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 2.8e-5 | NR | KAJ0401938.1 | 114742 | g29783 | i0 | 42.4 | 5.26490066225166 | 66 | 13 | 81.5 | 1 | 23 | 145 | 1412 | 1477 | KAJ0401938.1 hypothetical protein ATCC90586_008269 [Pythium insidiosum] | diamond | 795 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31705052 | 31705052 | PRJNA591127_P_NODE_22457_length_185_cov_1.317568_g22288_i0 | PRJNA591127 | 22457 | 185 | 1.317568 | 2.4375008 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 8.35e-24 | NR | OQS01868.1 | 74557 | g22288 | i0 | 84.9 | 4.26486486486487 | 53 | 8 | 85.9 | 0 | 159 | 1 | 1 | 53 | OQS01868.1 H/ACA ribonucleoprotein complex subunit 3 [Thraustotheca clavata] | diamond | 789 | 94.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31881204 | 31881204 | PRJNA591127_P_NODE_25137_length_167_cov_14.630769_g24968_i0 | PRJNA591127 | 25137 | 167 | 14.630769 | 24.43338423 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.83e-5 | NR | RHY74090.1 | 112090 | g24968 | i0 | 57.1 | 0.754491017964072 | 42 | 13 | 66.5 | 1 | 11 | 121 | 114 | 155 | RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci] | diamond | 126 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32716777 | 32716777 | PRJNA591127_P_NODE_27100_length_158_cov_1.289256_g26931_i0 | PRJNA591127 | 27100 | 158 | 1.289256 | 2.03702448 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.43e-7 | NR | XP_067751051.1 | 164328 | g26931 | i0 | 50 | 3.79746835443038 | 50 | 22 | 94.9 | 1 | 152 | 3 | 25 | 71 | XP_067751051.1 Translationally-controlled tumor protein-like protein [Phytophthora ramorum] | diamond | 600 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum |
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);;