contig_metadata
12 rows where bioproject = "PRJNA825466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16530781 | 16530781 | PRJNA825466_P_NODE_13513_length_266_cov_1.849741_g13412_i0 | PRJNA825466 | 13513 | 266 | 1.849741 | 4.92031106 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.0399999999999999e-60 | NTclustered | gi|301113823|ref|XM_002998636.1| | 403677 | g13412 | i0 | 84.19 | 94.1052631578947 | 253 | 40 | 95 | 0 | 2 | 254 | 870 | 618 | Phytophthora infestans T30-4 ATP synthase subunit beta, putative (PITG_06595), partial mRNA | blastn | 25032 | 248 | 0.991935483870968 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 22497214 | 22497214 | PRJNA825466_P_NODE_7038_length_318_cov_1.257143_g6937_i0 | PRJNA825466 | 7038 | 318 | 1.257143 | 3.99771474 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.9e-41 | NR | TMW60107.1 | 41045 | g6937 | i0 | 71.3 | 7.9811320754717 | 94 | 27 | 88.7 | 0 | 37 | 318 | 1 | 94 | TMW60107.1 hypothetical protein Poli38472_000149 [Pythium oligandrum] | diamond | 2538 | 144 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 25046761 | 25046761 | PRJNA825466_P_NODE_2740_length_438_cov_1.621918_g2639_i0 | PRJNA825466 | 2740 | 438 | 1.621918 | 7.10400084 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 227 | 5.920000000000001e-70 | NR | RLN26386.1 | 325452 | g2639 | i0 | 78.3 | 2.82191780821918 | 138 | 30 | 94.5 | 0 | 414 | 1 | 179 | 316 | RLN26386.1 hypothetical protein BBI17_008018 [Phytophthora kernoviae] | diamond | 1236 | 227 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 28728257 | 28728257 | PRJNA825466_P_NODE_11027_length_281_cov_1.182692_g10926_i0 | PRJNA825466 | 11027 | 281 | 1.182692 | 3.32336452 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.16e-4 | NR | KAF1320884.1 | 82926 | g10926 | i0 | 28 | 0.99288256227758 | 93 | 64 | 96.1 | 1 | 6 | 275 | 460 | 552 | KAF1320884.1 hypothetical protein FI667_g12257, partial [Globisporangium splendens] | diamond | 279 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28791244 | 28791244 | PRJNA825466_P_NODE_28027_length_241_cov_3.458333_g27926_i0 | PRJNA825466 | 28027 | 241 | 3.458333 | 8.33458253 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 5.37e-34 | NR | KAH9108398.1 | 100861 | g27926 | i0 | 82.4 | 2.76348547717842 | 74 | 13 | 92.1 | 0 | 3 | 224 | 407 | 480 | KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] | diamond | 666 | 131 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29264802 | 29264802 | PRJNA825466_P_NODE_26169_length_243_cov_0.905882_g26068_i0 | PRJNA825466 | 26169 | 243 | 0.905882 | 2.20129326 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 7.48e-6 | NR | OQS01349.1 | 1202772 | g26068 | i0 | 49 | 0.62962962962963 | 51 | 24 | 63 | 1 | 89 | 241 | 4 | 52 | OQS01349.1 hypothetical protein ACHHYP_01176 [Achlya hypogyna] | diamond | 153 | 53.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 30220984 | 30220984 | PRJNA825466_P_NODE_12912_length_270_cov_1.233503_g12811_i0 | PRJNA825466 | 12912 | 270 | 1.233503 | 3.3304581 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.83e-9 | NR | KAG7396956.1 | 109152 | g12811 | i0 | 34.7 | 4.35555555555556 | 98 | 55 | 98.9 | 2 | 267 | 1 | 11 | 108 | KAG7396956.1 hypothetical protein PHYBOEH_001469 [Phytophthora boehmeriae] | diamond | 1176 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 30220986 | 30220986 | PRJNA825466_P_NODE_26292_length_243_cov_0.905882_g26191_i0 | PRJNA825466 | 26292 | 243 | 0.905882 | 2.20129326 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00224 | NR | KAF0756398.1 | 112090 | g26191 | i0 | 37.3 | 5.17283950617284 | 59 | 36 | 72.8 | 1 | 198 | 22 | 404 | 461 | KAF0756398.1 hypothetical protein AaE_004647 [Aphanomyces astaci] | diamond | 1257 | 46.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31255091 | 31255091 | PRJNA825466_P_NODE_21235_length_247_cov_0.885057_g21134_i0 | PRJNA825466 | 21235 | 247 | 0.885057 | 2.18609079 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 9.14e-36 | NR | TMW57036.1 | 41045 | g21134 | i0 | 75.6 | 11.6477732793522 | 78 | 19 | 94.7 | 0 | 239 | 6 | 198 | 275 | TMW57036.1 hypothetical protein Poli38472_002961 [Pythium oligandrum] | diamond | 2877 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31896353 | 31896353 | PRJNA825466_P_NODE_1717_length_532_cov_2.629630_g1618_i0 | PRJNA825466 | 1717 | 532 | 2.62963 | 13.9896316 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 8.140000000000001e-36 | NR | XP_067814377.1 | 4779 | g1618 | i0 | 45.9 | 7.12218045112782 | 159 | 66 | 88 | 4 | 494 | 27 | 39 | 180 | XP_067814377.1 hypothetical protein CCR75_006867 [Bremia lactucae] | diamond | 3789 | 133 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 32362605 | 32362605 | PRJNA825466_P_NODE_10259_length_286_cov_1.929577_g10158_i0 | PRJNA825466 | 10259 | 286 | 1.929577 | 5.51859022 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0456 | NR | KAG2506600.1 | 325452 | g10158 | i0 | 41.8 | 0.576923076923077 | 55 | 29 | 56.6 | 2 | 164 | 3 | 158 | 210 | KAG2506600.1 hypothetical protein JM16_008512 [Phytophthora kernoviae] | diamond | 165 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 32749796 | 32749796 | PRJNA825466_P_NODE_18140_length_250_cov_0.870056_g18039_i0 | PRJNA825466 | 18140 | 250 | 0.870056 | 2.17514 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.00134 | NR | KAJ8578692.1 | 4785 | g18039 | i0 | 33.8 | 4.788 | 80 | 48 | 90 | 1 | 2 | 226 | 284 | 363 | KAJ8578692.1 hypothetical protein ON010_g512 [Phytophthora cinnamomi] | diamond | 1197 | 47 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;