contig_metadata
13 rows where bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1835603 | 1835603 | PRJNA575566_P_NODE_29662_length_201_cov_0.914286_g29465_i0 | PRJNA575566 | 29662 | 201 | 0.914286 | 1.83771486 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 6.0700000000000006e-27 | NTclustered | gi|2795016998|ref|XM_067930413.1| | 4785 | g29465 | i0 | 79 | 3.41791044776119 | 200 | 38 | 99 | 3 | 4 | 201 | 2319 | 2122 | Phytophthora cinnamomi Aconitate hydratase, mitochondrial (IUM83_06227), partial mRNA | blastn | 687 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3110945 | 3110945 | PRJNA575566_P_NODE_20923_length_229_cov_1.142857_g20726_i0 | PRJNA575566 | 20923 | 229 | 1.142857 | 2.61714253 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.3e-25 | NTclustered | gi|301107276|ref|XM_002902675.1| | 403677 | g20726 | i0 | 77.578 | 10.6244541484716 | 223 | 42 | 96 | 7 | 5 | 223 | 772 | 990 | Phytophthora infestans T30-4 adenosylhomocysteinase (PITG_10198), partial mRNA | blastn | 2433 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 5663706 | 5663706 | PRJNA575566_P_NODE_15825_length_265_cov_1.254902_g15628_i0 | PRJNA575566 | 15825 | 265 | 1.254902 | 3.3254903 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.31e-37 | NTclustered | gi|2795045505|ref|XM_067944074.1| | 4785 | g15628 | i0 | 84 | 4.33962264150943 | 175 | 28 | 66 | 0 | 2 | 176 | 254 | 80 | Phytophthora cinnamomi Ribosomal protein S2 (IUM83_19045), partial mRNA | blastn | 1150 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15862769 | 15862769 | PRJNA575566_P_NODE_24213_length_209_cov_0.864865_g24016_i0 | PRJNA575566 | 24213 | 209 | 0.864865 | 1.80756785 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.3e-21 | NTclustered | gi|2431515601|ref|NC_070108.1| | 230839 | g24016 | i0 | 77.358 | 20.4545454545455 | 212 | 37 | 99 | 9 | 2 | 209 | 624 | 420 | Peronosclerospora sorghi isolate P6 mitochondrion, complete genome | blastn | 4275 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 19686586 | 19686586 | PRJNA575566_P_NODE_23276_length_214_cov_1.254902_g23079_i0 | PRJNA575566 | 23276 | 214 | 1.254902 | 2.68549028 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 6.41e-42 | NTclustered | gi|669150047|ref|XM_008612364.1| | 1156394 | g23079 | i0 | 82.609 | 5.69158878504673 | 207 | 36 | 97 | 0 | 8 | 214 | 7 | 213 | Saprolegnia diclina VS20 hypothetical protein partial mRNA | blastn | 1218 | 183 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 22237238 | 22237238 | PRJNA575566_P_NODE_3098_length_587_cov_2.131179_g2903_i0 | PRJNA575566 | 3098 | 587 | 2.131179 | 12.51002073 | Phytophthora citrophthora | 4793 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 2.26e-125 | NTclustered | gi|2314988661|ref|NC_067066.1| | 4793 | g2903 | i0 | 81.326 | 82.8006814310051 | 573 | 103 | 97 | 4 | 10 | 580 | 8776 | 8206 | Phytophthora citrophthora voucher CBS950_87 mitochondrion, complete genome | blastn | 48604 | 462 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 23512469 | 23512469 | PRJNA575566_P_NODE_2619_length_640_cov_2.906736_g2429_i0 | PRJNA575566 | 2619 | 640 | 2.906736 | 18.6031104 | root | 1 | Root_unresolved | Root_unresolved | 111 | 8.43e-27 | NR | NP_037602.1 | 4787 | g2429 | i0 | 69.7 | 14.9390625 | 66 | 20 | 30.9 | 0 | 553 | 356 | 115 | 180 | NP_037602.1 NADH dehydrogenase subunit 9 [Phytophthora infestans] | diamond | 9561 | 112 | 0.991071428571429 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 26604464 | 26604464 | PRJNA575566_P_NODE_17701_length_250_cov_1.693122_g17504_i0 | PRJNA575566 | 17701 | 250 | 1.693122 | 4.232805 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 3.17e-9 | NR | KAF0690082.1 | 120398 | g17504 | i0 | 43.2 | 0.888 | 74 | 42 | 88.8 | 0 | 29 | 250 | 19 | 92 | KAF0690082.1 hypothetical protein As57867_018414 [Aphanomyces stellatus] | diamond | 222 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27819837 | 27819837 | PRJNA575566_P_NODE_25964_length_207_cov_0.876712_g25767_i0 | PRJNA575566 | 25964 | 207 | 0.876712 | 1.81479384 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.5599999999999998e-23 | NR | CAI5729819.1 | 86335 | g25767 | i0 | 77 | 9.01449275362319 | 61 | 14 | 88.4 | 0 | 184 | 2 | 450 | 510 | CAI5729819.1 unnamed protein product [Peronospora destructor] | diamond | 1866 | 103 | 0.990291262135922 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora destructor | ||
| 28229819 | 28229819 | PRJNA575566_P_NODE_14546_length_276_cov_1.190698_g14349_i0 | PRJNA575566 | 14546 | 276 | 1.190698 | 3.28632648 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 3.26e-6 | NR | YP_010394262.1 | 4786 | g14349 | i0 | 42.4 | 3.32608695652174 | 59 | 34 | 64.1 | 0 | 54 | 230 | 18 | 76 | YP_010394262.1 ribosomal protein L5 [Phytophthora cryptogea] | diamond | 918 | 53.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cryptogea | ||
| 29240521 | 29240521 | PRJNA575566_P_NODE_29689_length_201_cov_0.914286_g29492_i0 | PRJNA575566 | 29689 | 201 | 0.914286 | 1.83771486 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0163 | NR | OQR89803.1 | 74557 | g29492 | i0 | 32 | 2.85074626865672 | 75 | 40 | 95.5 | 2 | 201 | 10 | 512 | 586 | OQR89803.1 hypothetical protein THRCLA_09572 [Thraustotheca clavata] | diamond | 573 | 43.5 | 0.990804597701149 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 29745411 | 29745411 | PRJNA575566_P_NODE_12670_length_295_cov_1.094017_g12473_i0 | PRJNA575566 | 12670 | 295 | 1.094017 | 3.22735015 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0383 | NR | KAF1332378.1 | 82926 | g12473 | i0 | 29.3 | 1.83050847457627 | 92 | 53 | 89.5 | 3 | 2 | 265 | 812 | 895 | KAF1332378.1 Heat shock 70 kda protein, partial [Globisporangium splendens] | diamond | 540 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 31375245 | 31375245 | PRJNA575566_P_NODE_24476_length_209_cov_0.864865_g24279_i0 | PRJNA575566 | 24476 | 209 | 0.864865 | 1.80756785 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 1.51e-9 | NR | KAE9166247.1 | 53985 | g24279 | i0 | 44.4 | 3.61722488038277 | 63 | 35 | 90.4 | 0 | 11 | 199 | 763 | 825 | KAE9166247.1 ABC transporter G family member 36 [Phytophthora fragariae] | diamond | 756 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae |
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);;