contig_metadata
25 rows where bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 311969 | 311969 | PRJNA1164198_P_NODE_19281_length_282_cov_1.550239_g19012_i0 | PRJNA1164198 | 19281 | 282 | 1.550239 | 4.37167398 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 5.06e-74 | NTclustered | gi|698815387|ref|XM_009842421.1| | 112090 | g19012 | i0 | 88.382 | 81.2943262411348 | 241 | 28 | 85 | 0 | 2 | 242 | 304 | 64 | Aphanomyces astaci actin mRNA | blastn | 22925 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 1039476 | 1039476 | PRJNA1164198_P_NODE_12761_length_347_cov_1.266423_g12492_i0 | PRJNA1164198 | 12761 | 347 | 1.266423 | 4.39448781 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 4.84e-48 | NR | CCI45297.1 | 65357 | g12492 | i0 | 66.4 | 14.4121037463977 | 113 | 38 | 97.7 | 0 | 2 | 340 | 366 | 478 | CCI45297.1 unnamed protein product [Albugo candida] | diamond | 5001 | 176 | 0.994318181818182 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 3589978 | 3589978 | PRJNA1164198_P_NODE_23523_length_256_cov_1.278689_g23254_i0 | PRJNA1164198 | 23523 | 256 | 1.278689 | 3.27344384 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.65e-45 | NTclustered | gi|166040017|emb|CU350235.1| | 100861 | g23254 | i0 | 82.379 | 82.76171875 | 227 | 36 | 88 | 4 | 32 | 256 | 395 | 171 | Aphanomyces euteiches cDNA | blastn | 21187 | 196 | 0.994897959183674 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6689898 | 6689898 | PRJNA1164198_P_NODE_23146_length_258_cov_1.486486_g22877_i0 | PRJNA1164198 | 23146 | 258 | 1.486486 | 3.83513388 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 6.21e-38 | NTclustered | gi|1378148413|ref|XM_024722856.1| | 4781 | g22877 | i0 | 82.979 | 43.4883720930233 | 188 | 32 | 73 | 0 | 60 | 247 | 188 | 1 | Plasmopara halstedii 60s ribosomal protein l27a (PHALS_05303), partial mRNA | blastn | 11220 | 171 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 6689959 | 6689959 | PRJNA1164198_P_NODE_8166_length_437_cov_1.376374_g7904_i0 | PRJNA1164198 | 8166 | 437 | 1.376374 | 6.01475438 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.08e-15 | NR | DBA03679.1 | 4803 | g7904 | i0 | 59.1 | 2.33409610983982 | 66 | 27 | 45.3 | 0 | 39 | 236 | 1 | 66 | DBA03679.1 TPA: hypothetical protein N0F65_004096 [Lagenidium giganteum] | diamond | 1020 | 78.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 7965197 | 7965197 | PRJNA1164198_P_NODE_19927_length_278_cov_0.926829_g19658_i0 | PRJNA1164198 | 19927 | 278 | 0.926829 | 2.57658462 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.43e-49 | NTclustered | gi|813114452|ref|XM_012339991.1| | 695850 | g19658 | i0 | 81.061 | 15.9388489208633 | 264 | 48 | 95 | 2 | 14 | 276 | 484 | 222 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 4431 | 209 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 7965217 | 7965217 | PRJNA1164198_P_NODE_24047_length_253_cov_1.300000_g23778_i0 | PRJNA1164198 | 24047 | 253 | 1.3 | 3.289 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 3.6499999999999998e-25 | NR | CCI44493.1 | 65357 | g23778 | i0 | 72.9 | 3.49802371541502 | 70 | 19 | 83 | 0 | 4 | 213 | 312 | 381 | CCI44493.1 unnamed protein product [Albugo candida] | diamond | 885 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 10515562 | 10515562 | PRJNA1164198_P_NODE_10269_length_388_cov_1.438095_g10002_i0 | PRJNA1164198 | 10269 | 388 | 1.438095 | 5.5798086 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 9.67e-48 | NTclustered | gi|813111021|ref|XM_012339685.1| | 695850 | g10002 | i0 | 76.425 | 32.8350515463918 | 386 | 86 | 99 | 5 | 3 | 386 | 514 | 132 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 12740 | 204 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10515660 | 10515660 | PRJNA1164198_P_NODE_30209_length_243_cov_0.917647_g29940_i0 | PRJNA1164198 | 30209 | 243 | 0.917647 | 2.22988221 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.4000000000000002e-22 | NR | XP_024577070.1 | 4781 | g29940 | i0 | 62 | 6.71604938271605 | 79 | 28 | 95.1 | 1 | 9 | 239 | 187 | 265 | XP_024577070.1 ras-like protein [Plasmopara halstedii] | diamond | 1632 | 101 | 0.99009900990099 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 16342017 | 16342017 | PRJNA1164198_P_NODE_28013_length_246_cov_3.797688_g27744_i0 | PRJNA1164198 | 28013 | 246 | 3.797688 | 9.34231248 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.06e-57 | NTclustered | gi|1103652769|gb|AF085345.2| | 82926 | g27744 | i0 | 84.914 | 91.630081300813 | 232 | 35 | 94 | 0 | 1 | 232 | 270 | 39 | Pythium splendens actin mRNA, complete cds | blastn | 22541 | 237 | 0.991561181434599 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 26679670 | 26679670 | PRJNA1164198_P_NODE_28421_length_246_cov_0.901734_g28152_i0 | PRJNA1164198 | 28421 | 246 | 0.901734 | 2.21826564 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 2.1e-33 | NR | XP_067815200.1 | 4779 | g28152 | i0 | 75.3 | 8.89024390243902 | 81 | 20 | 98.8 | 0 | 3 | 245 | 289 | 369 | XP_067815200.1 hypothetical protein CCR75_009252 [Bremia lactucae] | diamond | 2187 | 131 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 26977105 | 26977105 | PRJNA1164198_P_NODE_25002_length_252_cov_0.871508_g24733_i0 | PRJNA1164198 | 25002 | 252 | 0.871508 | 2.19620016 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.92e-4 | NR | KAF0733465.1 | 100861 | g24733 | i0 | 50 | 1.78571428571429 | 32 | 16 | 38.1 | 0 | 241 | 146 | 33 | 64 | KAF0733465.1 hypothetical protein Ae201684_009709 [Aphanomyces euteiches] | diamond | 450 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27628620 | 27628620 | PRJNA1164198_P_NODE_24184_length_253_cov_0.866667_g23915_i0 | PRJNA1164198 | 24184 | 253 | 0.866667 | 2.19266751 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 4.52e-13 | NR | KAF1333497.1 | 82926 | g23915 | i0 | 48.2 | 6.88932806324111 | 83 | 43 | 98.4 | 0 | 250 | 2 | 839 | 921 | KAF1333497.1 Multidrug resistance-associated protein 1, partial [Globisporangium splendens] | diamond | 1743 | 74.3 | 0.994616419919246 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28544278 | 28544278 | PRJNA1164198_P_NODE_14247_length_328_cov_1.160784_g13978_i0 | PRJNA1164198 | 14247 | 328 | 1.160784 | 3.80737152 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 2.3899999999999998e-54 | NR | CCA19147.1 | 890382 | g13978 | i0 | 76.9 | 5.70731707317073 | 104 | 24 | 95.1 | 0 | 17 | 328 | 1 | 104 | CCA19147.1 40S ribosomal protein S4 putative [Albugo laibachii Nc14] | diamond | 1872 | 181 | 0.994475138121547 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 28607195 | 28607195 | PRJNA1164198_P_NODE_30707_length_242_cov_0.923077_g30438_i0 | PRJNA1164198 | 30707 | 242 | 0.923077 | 2.23384634 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.4899999999999996e-35 | NR | OQS04692.1 | 74557 | g30438 | i0 | 82.5 | 6.91735537190083 | 80 | 14 | 99.2 | 0 | 241 | 2 | 6 | 85 | OQS04692.1 aspartyl/Asparaginyl beta-hydroxylase [Thraustotheca clavata] | diamond | 1674 | 132 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28891179 | 28891179 | PRJNA1164198_P_NODE_29748_length_244_cov_0.912281_g29479_i0 | PRJNA1164198 | 29748 | 244 | 0.912281 | 2.22596564 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.24e-25 | NR | OQR89707.1 | 74557 | g29479 | i0 | 65 | 5.9016393442623 | 80 | 28 | 98.4 | 0 | 3 | 242 | 176 | 255 | OQR89707.1 60S acidic ribosomal protein P0, partial [Thraustotheca clavata] | diamond | 1440 | 110 | 0.990909090909091 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 29914282 | 29914282 | PRJNA1164198_P_NODE_30251_length_243_cov_0.917647_g29982_i0 | PRJNA1164198 | 30251 | 243 | 0.917647 | 2.22988221 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.46e-10 | NR | DBA04010.1 | 4803 | g29982 | i0 | 43.7 | 0.876543209876543 | 71 | 39 | 87.7 | 1 | 7 | 219 | 217 | 286 | DBA04010.1 TPA: hypothetical protein N0F65_009357 [Lagenidium giganteum] | diamond | 213 | 66.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30230026 | 30230026 | PRJNA1164198_P_NODE_8832_length_419_cov_3.355491_g8570_i0 | PRJNA1164198 | 8832 | 419 | 3.355491 | 14.05950729 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.19e-33 | NR | KAJ8578052.1 | 4785 | g8570 | i0 | 54.6 | 3.87350835322196 | 130 | 53 | 89.5 | 4 | 17 | 391 | 117 | 245 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 1623 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30609053 | 30609053 | PRJNA1164198_P_NODE_27793_length_247_cov_0.896552_g27524_i0 | PRJNA1164198 | 27793 | 247 | 0.896552 | 2.21448344 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.34e-4 | NR | XP_067820148.1 | 4779 | g27524 | i0 | 32.9 | 2.55060728744939 | 70 | 47 | 85 | 0 | 240 | 31 | 5 | 74 | XP_067820148.1 hypothetical protein CCR75_007162 [Bremia lactucae] | diamond | 630 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 31133684 | 31133684 | PRJNA1164198_P_NODE_29555_length_244_cov_0.912281_g29286_i0 | PRJNA1164198 | 29555 | 244 | 0.912281 | 2.22596564 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.7599999999999994e-23 | NR | DBA03690.1 | 4803 | g29286 | i0 | 67.6 | 1.7827868852459 | 71 | 23 | 87.3 | 0 | 215 | 3 | 220 | 290 | DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum] | diamond | 435 | 101 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31513682 | 31513682 | PRJNA1164198_P_NODE_18316_length_289_cov_1.958333_g18047_i0 | PRJNA1164198 | 18316 | 289 | 1.958333 | 5.65958237 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 5.5799999999999996e-42 | NR | KAF0727766.1 | 100861 | g18047 | i0 | 80.2 | 39.0934256055363 | 81 | 16 | 84.1 | 0 | 288 | 46 | 3 | 83 | KAF0727766.1 hypothetical protein Ae201684_014280 [Aphanomyces euteiches] | diamond | 11298 | 144 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31639887 | 31639887 | PRJNA1164198_P_NODE_14496_length_325_cov_1.238095_g14227_i0 | PRJNA1164198 | 14496 | 325 | 1.238095 | 4.02380875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 3.12e-25 | NR | OQR82037.1 | 74557 | g14227 | i0 | 56.2 | 1.60615384615385 | 89 | 39 | 82.2 | 0 | 268 | 2 | 13 | 101 | OQR82037.1 leucyl-tRNA synthetase, cytoplasmic [Thraustotheca clavata] | diamond | 522 | 110 | 0.990909090909091 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32285385 | 32285385 | PRJNA1164198_P_NODE_19179_length_283_cov_1.333333_g18910_i0 | PRJNA1164198 | 19179 | 283 | 1.333333 | 3.77333239 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 1.52e-6 | NR | CCA24294.1 | 890382 | g18910 | i0 | 70.6 | 0.360424028268551 | 34 | 9 | 36 | 1 | 108 | 7 | 704 | 736 | CCA24294.1 PREDICTED: DNA topoisomerase 3beta1like isoform 1 putative [Albugo laibachii Nc14] | diamond | 102 | 55.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 32557733 | 32557733 | PRJNA1164198_P_NODE_16419_length_305_cov_1.728448_g16150_i0 | PRJNA1164198 | 16419 | 305 | 1.728448 | 5.2717664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.78e-31 | NR | KAJ0412157.1 | 114742 | g16150 | i0 | 65.6 | 6.30491803278689 | 93 | 29 | 91.5 | 2 | 9 | 287 | 620 | 709 | KAJ0412157.1 hypothetical protein ATCC90586_005770 [Pythium insidiosum] | diamond | 1923 | 128 | 0.9921875 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32746473 | 32746473 | PRJNA1164198_P_NODE_25480_length_251_cov_0.876404_g25211_i0 | PRJNA1164198 | 25480 | 251 | 0.876404 | 2.19977404 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 1.29e-24 | NR | DBA03688.1 | 4803 | g25211 | i0 | 54.2 | 8.90438247011952 | 83 | 38 | 99.2 | 0 | 250 | 2 | 65 | 147 | DBA03688.1 TPA: hypothetical protein N0F65_004105 [Lagenidium giganteum] | diamond | 2235 | 105 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;