contig_metadata
15 rows where bioproject = "PRJNA849646", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838041 | 838041 | PRJNA849646_P_NODE_13821_length_280_cov_1.913043_g13703_i0 | PRJNA849646 | 13821 | 280 | 1.913043 | 5.3565204 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 4.32e-41 | NR | OQR97335.1 | 1202772 | g13703 | i0 | 75 | 6.83571428571429 | 92 | 23 | 98.6 | 0 | 3 | 278 | 128 | 219 | OQR97335.1 60S ribosomal protein L5 [Achlya hypogyna] | diamond | 1914 | 146 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 2113882 | 2113882 | PRJNA849646_P_NODE_8642_length_290_cov_4.041475_g8524_i0 | PRJNA849646 | 8642 | 290 | 4.041475 | 11.7202775 | Phytophthora angustata | 3073753 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.18e-40 | NTclustered | gi|2689410834|gb|OR588318.1| | 3073753 | g8524 | i0 | 78.007 | 8.15862068965517 | 291 | 60 | 99 | 4 | 2 | 290 | 37 | 325 | Phytophthora angustata isolate NI121 60S ribosomal protein L10 (rpl10) gene, partial cds | blastn | 2366 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora angustata | ||
| 4666530 | 4666530 | PRJNA849646_P_NODE_15564_length_277_cov_1.323529_g15446_i0 | PRJNA849646 | 15564 | 277 | 1.323529 | 3.66617533 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 2.53e-51 | NR | XP_067817684.1 | 4779 | g15446 | i0 | 85.9 | 7.97111913357401 | 92 | 13 | 99.6 | 0 | 276 | 1 | 147 | 238 | XP_067817684.1 hypothetical protein CCR75_004102 [Bremia lactucae] | diamond | 2208 | 172 | 0.994186046511628 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 14866076 | 14866076 | PRJNA849646_P_NODE_17552_length_273_cov_1.540000_g17434_i0 | PRJNA849646 | 17552 | 273 | 1.54 | 4.2042 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 2.6799999999999996e-31 | NR | XP_024586207.1 | 4781 | g17434 | i0 | 85.5 | 9.32967032967033 | 69 | 10 | 75.8 | 0 | 208 | 2 | 4 | 72 | XP_024586207.1 40s ribosomal protein s16 [Plasmopara halstedii] | diamond | 2547 | 122 | 0.991803278688525 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 14866236 | 14866236 | PRJNA849646_P_NODE_2972_length_332_cov_3.644788_g2854_i0 | PRJNA849646 | 2972 | 332 | 3.644788 | 12.10069616 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.79e-82 | NTclustered | gi|166044589|emb|CU367498.1| | 100861 | g2854 | i0 | 100 | 79.0632530120482 | 172 | 0 | 61 | 0 | 1 | 172 | 177 | 348 | Aphanomyces euteiches cDNA | blastn | 26249 | 318 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 14866287 | 14866287 | PRJNA849646_P_NODE_33772_length_246_cov_1.780347_g33654_i0 | PRJNA849646 | 33772 | 246 | 1.780347 | 4.37965362 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 2.470000000000001e-44 | NR | XP_024577919.1 | 4781 | g33654 | i0 | 84.1 | 10 | 82 | 13 | 100 | 0 | 246 | 1 | 138 | 219 | XP_024577919.1 proteasome subunit alpha type [Plasmopara halstedii] | diamond | 2460 | 153 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 16535896 | 16535896 | PRJNA849646_P_NODE_23753_length_261_cov_2.117021_g23635_i0 | PRJNA849646 | 23753 | 261 | 2.117021 | 5.52542481 | root | 1 | Root_unresolved | Root_unresolved | 477 | 3.3099999999999986e-130 | NTclustered | gi|166046482|emb|CU367599.1| | 100861 | g23635 | i0 | 99.617 | 100 | 261 | 1 | 100 | 0 | 1 | 261 | 153 | 413 | Aphanomyces euteiches cDNA | blastn | 26100 | 477 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16535980 | 16535980 | PRJNA849646_P_NODE_35113_length_245_cov_0.895349_g34995_i0 | PRJNA849646 | 35113 | 245 | 0.895349 | 2.19360505 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.4e-37 | NR | XP_024578065.1 | 4781 | g34995 | i0 | 88.9 | 22.8122448979592 | 81 | 9 | 99.2 | 0 | 1 | 243 | 440 | 520 | XP_024578065.1 heat shock protein 90 [Plasmopara halstedii] | diamond | 5589 | 143 | 0.993006993006993 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 18689393 | 18689393 | PRJNA849646_P_NODE_16595_length_275_cov_1.524752_g16477_i0 | PRJNA849646 | 16595 | 275 | 1.524752 | 4.193068 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.29e-36 | NR | ETM46751.1 | 4792 | g16477 | i0 | 84 | 4.90909090909091 | 75 | 12 | 81.8 | 0 | 273 | 49 | 10 | 84 | ETM46751.1 elongation factor 1-alpha, partial [Phytophthora nicotianae] | diamond | 1350 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 22515055 | 22515055 | PRJNA849646_P_NODE_32818_length_247_cov_1.770115_g32700_i0 | PRJNA849646 | 32818 | 247 | 1.770115 | 4.37218405 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 2.46e-35 | NR | KAK1942099.1 | 4793 | g32700 | i0 | 80 | 6.75303643724696 | 80 | 15 | 97.2 | 1 | 8 | 247 | 48 | 126 | KAK1942099.1 40S ribosomal protein S5-2 [Phytophthora citrophthora] | diamond | 1668 | 129 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 25064438 | 25064438 | PRJNA849646_P_NODE_320_length_939_cov_11.543880_g223_i0 | PRJNA849646 | 320 | 939 | 11.54388 | 108.3970332 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 1005 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g223 | i0 | 95.016 | 7.71884984025559 | 642 | 28 | 82 | 3 | 299 | 939 | 935 | 1573 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 7248 | 1005 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 26865331 | 26865331 | PRJNA849646_P_NODE_18221_length_272_cov_1.381910_g18103_i0 | PRJNA849646 | 18221 | 272 | 1.38191 | 3.7587952 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.05e-35 | NR | RQM08885.1 | 542832 | g18103 | i0 | 92.9 | 2.30514705882353 | 70 | 5 | 77.2 | 0 | 254 | 45 | 16 | 85 | RQM08885.1 hypothetical protein DD237_000613 [Peronospora effusa] | diamond | 627 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 27781561 | 27781561 | PRJNA849646_P_NODE_42124_length_226_cov_2.732026_g42006_i0 | PRJNA849646 | 42124 | 226 | 2.732026 | 6.17437876 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 1.95e-36 | NR | ETL93890.1 | 4792 | g42006 | i0 | 82.7 | 5.97345132743363 | 75 | 13 | 99.6 | 0 | 226 | 2 | 440 | 514 | ETL93890.1 6-phosphogluconate dehydrogenase (decarboxylating), partial [Phytophthora nicotianae] | diamond | 1350 | 138 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28002652 | 28002652 | PRJNA849646_P_NODE_25445_length_258_cov_1.664865_g25327_i0 | PRJNA849646 | 25445 | 258 | 1.664865 | 4.2953517 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 3.67e-11 | NR | TMW63146.1 | 41045 | g25327 | i0 | 38 | 0.918604651162791 | 79 | 48 | 90.7 | 1 | 22 | 255 | 386 | 464 | TMW63146.1 hypothetical protein Poli38472_002087 [Pythium oligandrum] | diamond | 237 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32363044 | 32363044 | PRJNA849646_P_NODE_35459_length_244_cov_1.801170_g35341_i0 | PRJNA849646 | 35459 | 244 | 1.80117 | 4.3948548 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 5.88e-4 | NR | TYZ66219.1 | 1485010 | g35341 | i0 | 47.8 | 0.565573770491803 | 46 | 22 | 54.1 | 1 | 134 | 3 | 254 | 299 | TYZ66219.1 hypothetical protein PybrP1_005628 [[Pythium] brassicae (nom. inval.)] | diamond | 138 | 47.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) |
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);;