contig_metadata
19 rows where bioproject = "PRJNA1005695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1428235 | 1428235 | PRJNA1005695_P_NODE_24482_length_303_cov_2.426087_g23630_i0 | PRJNA1005695 | 24482 | 303 | 2.426087 | 7.35104361 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|698803785|ref|XM_009836620.1| | 112090 | g23630 | i0 | 96.774 | 0.102310231023102 | 31 | 1 | 10 | 0 | 130 | 160 | 963 | 993 | Aphanomyces astaci hypothetical protein mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 9081180 | 9081180 | PRJNA1005695_P_NODE_8768_length_527_cov_3.821586_g7921_i0 | PRJNA1005695 | 8768 | 527 | 3.821586 | 20.13975822 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.2999999999999999e-58 | NR | KAG1709295.1 | 4784 | g7921 | i0 | 64.5 | 58.3377609108159 | 172 | 48 | 96.8 | 3 | 515 | 6 | 546 | 706 | KAG1709295.1 hypothetical protein DVH05_019938 [Phytophthora capsici] | diamond | 30744 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 12907144 | 12907144 | PRJNA1005695_P_NODE_17531_length_361_cov_1.888889_g16679_i0 | PRJNA1005695 | 17531 | 361 | 1.888889 | 6.81888929 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 5.6e-34 | NR | KAJ8578052.1 | 4785 | g16679 | i0 | 64.9 | 2.32686980609418 | 94 | 32 | 78.1 | 1 | 287 | 6 | 117 | 209 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 840 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15456146 | 15456146 | PRJNA1005695_P_NODE_25933_length_294_cov_2.117647_g25081_i0 | PRJNA1005695 | 25933 | 294 | 2.117647 | 6.22588218 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.22e-25 | NTclustered | gi|2794923360|ref|XM_067881981.1| | 164328 | g25081 | i0 | 80.723 | 4.21768707482993 | 166 | 32 | 56 | 0 | 80 | 245 | 274 | 439 | Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA | blastn | 1240 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 20554728 | 20554728 | PRJNA1005695_P_NODE_30977_length_268_cov_1.825641_g30125_i0 | PRJNA1005695 | 30977 | 268 | 1.825641 | 4.89271788 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 5.09e-29 | NTclustered | gi|669161029|ref|XM_008617855.1| | 1156394 | g30125 | i0 | 81.111 | 2.01119402985075 | 180 | 30 | 66 | 4 | 5 | 182 | 715 | 892 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 539 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 23105685 | 23105685 | PRJNA1005695_P_NODE_19339_length_343_cov_2.714815_g18487_i0 | PRJNA1005695 | 19339 | 343 | 2.714815 | 9.31181545 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.032 | NTclustered | gi|2795027578|ref|XM_067926281.1| | 4785 | g18487 | i0 | 100 | 0.0816326530612245 | 28 | 0 | 8 | 0 | 174 | 201 | 135 | 162 | Phytophthora cinnamomi myosinlike protein (IUM83_02370), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 26939387 | 26939387 | PRJNA1005695_P_NODE_39522_length_243_cov_0.917647_g38670_i0 | PRJNA1005695 | 39522 | 243 | 0.917647 | 2.22988221 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.21e-11 | NR | TYZ67071.1 | 1485010 | g38670 | i0 | 50.8 | 4.65432098765432 | 65 | 32 | 80.2 | 0 | 241 | 47 | 880 | 944 | TYZ67071.1 hypothetical protein PybrP1_012233 [[Pythium] brassicae (nom. inval.)] | diamond | 1131 | 68.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 27982117 | 27982117 | PRJNA1005695_P_NODE_38085_length_246_cov_0.901734_g37233_i0 | PRJNA1005695 | 38085 | 246 | 0.901734 | 2.21826564 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 3.43e-9 | NR | GMF12222.1 | 2077276 | g37233 | i0 | 51 | 6.14634146341463 | 51 | 25 | 62.2 | 0 | 94 | 246 | 243 | 293 | GMF12222.1 unnamed protein product [Phytophthora lilii] | diamond | 1512 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 29143112 | 29143112 | PRJNA1005695_P_NODE_36949_length_248_cov_1.502857_g36097_i0 | PRJNA1005695 | 36949 | 248 | 1.502857 | 3.72708536 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 3.49e-19 | NR | KUF95612.1 | 4792 | g36097 | i0 | 76.8 | 1.98387096774194 | 82 | 19 | 99.2 | 0 | 246 | 1 | 85 | 166 | KUF95612.1 RNA polymerase I-specific transcription initiation factor RRN3 [Phytophthora nicotianae] | diamond | 492 | 90.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 29245060 | 29245060 | PRJNA1005695_P_NODE_17409_length_362_cov_2.595156_g16557_i0 | PRJNA1005695 | 17409 | 362 | 2.595156 | 9.39446472 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.46e-34 | NR | KAJ8578052.1 | 4785 | g16557 | i0 | 63.9 | 2.39502762430939 | 97 | 34 | 80.4 | 1 | 59 | 349 | 117 | 212 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 867 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29553059 | 29553059 | PRJNA1005695_P_NODE_29270_length_276_cov_1.783251_g28418_i0 | PRJNA1005695 | 29270 | 276 | 1.783251 | 4.92177276 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 2.8100000000000003e-21 | NR | KAF1329759.1 | 82926 | g28418 | i0 | 60.5 | 3.26086956521739 | 76 | 30 | 82.6 | 0 | 47 | 274 | 92 | 167 | KAF1329759.1 Agc protein kinase, partial [Globisporangium splendens] | diamond | 900 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 30375022 | 30375022 | PRJNA1005695_P_NODE_20092_length_337_cov_0.905303_g19240_i0 | PRJNA1005695 | 20092 | 337 | 0.905303 | 3.05087111 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 1.37e-8 | NR | KAJ8552539.1 | 4785 | g19240 | i0 | 35.1 | 4.9406528189911 | 111 | 70 | 98.8 | 2 | 335 | 3 | 119 | 227 | KAJ8552539.1 hypothetical protein ON010_g10006 [Phytophthora cinnamomi] | diamond | 1665 | 62.8 | 0.993630573248408 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30666318 | 30666318 | PRJNA1005695_P_NODE_15873_length_381_cov_1.012987_g15021_i0 | PRJNA1005695 | 15873 | 381 | 1.012987 | 3.85948047 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.39e-24 | NR | KAF0775164.1 | 112090 | g15021 | i0 | 47.2 | 1.96850393700787 | 125 | 47 | 98.4 | 3 | 381 | 7 | 295 | 400 | KAF0775164.1 hypothetical protein AaE_001134 [Aphanomyces astaci] | diamond | 750 | 107 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30729558 | 30729558 | PRJNA1005695_P_NODE_28074_length_282_cov_1.526316_g27222_i0 | PRJNA1005695 | 28074 | 282 | 1.526316 | 4.30421112 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0314 | NR | GLD97538.1 | 114742 | g27222 | i0 | 38.5 | 1.1063829787234 | 52 | 23 | 45.7 | 1 | 135 | 7 | 137 | 188 | GLD97538.1 hypothetical protein PINS_up006228 [Pythium insidiosum] | diamond | 312 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31108573 | 31108573 | PRJNA1005695_P_NODE_19975_length_338_cov_1.177358_g19123_i0 | PRJNA1005695 | 19975 | 338 | 1.177358 | 3.97947004 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 2.12e-23 | NR | KAF0763703.1 | 112090 | g19123 | i0 | 46.7 | 8.38757396449704 | 105 | 54 | 93.2 | 1 | 2 | 316 | 35 | 137 | KAF0763703.1 hypothetical protein AaE_003161, partial [Aphanomyces astaci] | diamond | 2835 | 97.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31329980 | 31329980 | PRJNA1005695_P_NODE_33276_length_258_cov_1.848649_g32424_i0 | PRJNA1005695 | 33276 | 258 | 1.848649 | 4.76951442 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0222 | NR | KAI9906496.1 | 230839 | g32424 | i0 | 37.3 | 0.779069767441861 | 67 | 40 | 77.9 | 1 | 203 | 3 | 201 | 265 | KAI9906496.1 hypothetical protein PsorP6_003465 [Peronosclerospora sorghi] | diamond | 201 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 31899407 | 31899407 | PRJNA1005695_P_NODE_35837_length_250_cov_2.429379_g34985_i0 | PRJNA1005695 | 35837 | 250 | 2.429379 | 6.0734475 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 9.83e-4 | NR | RLN93368.1 | 2483409 | g34985 | i0 | 35.7 | 1.584 | 70 | 44 | 82.8 | 1 | 44 | 250 | 62 | 131 | RLN93368.1 hypothetical protein BBJ28_00024098, partial [Nothophytophthora sp. Chile5] | diamond | 396 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 31986703 | 31986703 | PRJNA1005695_P_NODE_32118_length_263_cov_1.678947_g31266_i0 | PRJNA1005695 | 32118 | 263 | 1.678947 | 4.41563061 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 1.4e-6 | NR | KAI9991102.1 | 4787 | g31266 | i0 | 47.6 | 4.58555133079848 | 82 | 43 | 93.5 | 0 | 247 | 2 | 29 | 110 | KAI9991102.1 hypothetical protein PInf_018730 [Phytophthora infestans] | diamond | 1206 | 53.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32113500 | 32113500 | PRJNA1005695_P_NODE_24338_length_304_cov_2.025974_g23486_i0 | PRJNA1005695 | 24338 | 304 | 2.025974 | 6.15896096 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 1.39e-8 | NR | GMF20669.1 | 2077276 | g23486 | i0 | 43.1 | 1.98355263157895 | 72 | 32 | 62.2 | 2 | 2 | 190 | 3004 | 3075 | GMF20669.1 unnamed protein product [Phytophthora lilii] | diamond | 603 | 62 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii |
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);;