contig_metadata
18 rows where bioproject = "PRJNA1093380", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1473771 | 1473771 | PRJNA1093380_P_NODE_5922_length_286_cov_1.084507_g5816_i0 | PRJNA1093380 | 5922 | 286 | 1.084507 | 3.10169002 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.15e-50 | NTclustered | gi|2795040101|ref|XM_067937224.1| | 4785 | g5816 | i0 | 85.366 | 295.524475524476 | 205 | 30 | 72 | 0 | 79 | 283 | 683 | 479 | Phytophthora cinnamomi Polyubiquitin (IUM83_12589), partial mRNA | blastn | 84520 | 213 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 4025914 | 4025914 | PRJNA1093380_P_NODE_9704_length_264_cov_1.209424_g9598_i0 | PRJNA1093380 | 9704 | 264 | 1.209424 | 3.19287936 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.9899999999999995e-31 | NTclustered | gi|166043101|emb|CU357747.1| | 100861 | g9598 | i0 | 84.314 | 3.92045454545455 | 153 | 22 | 58 | 2 | 16 | 167 | 742 | 893 | Aphanomyces euteiches cDNA | blastn | 1035 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7851979 | 7851979 | PRJNA1093380_P_NODE_9227_length_266_cov_2.155440_g9121_i0 | PRJNA1093380 | 9227 | 266 | 2.15544 | 5.7334704 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.36e-34 | NR | KAG1700969.1 | 4784 | g9121 | i0 | 76.1 | 17.8646616541353 | 88 | 21 | 99.2 | 0 | 264 | 1 | 781 | 868 | KAG1700969.1 hypothetical protein DVH05_011213 [Phytophthora capsici] | diamond | 4752 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 9947474 | 9947474 | PRJNA1093380_P_NODE_9708_length_264_cov_1.209424_g9602_i0 | PRJNA1093380 | 9708 | 264 | 1.209424 | 3.19287936 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.9899999999999997e-35 | NR | KAJ0400315.1 | 114742 | g9602 | i0 | 72.4 | 6.92045454545455 | 87 | 24 | 98.9 | 0 | 262 | 2 | 35 | 121 | KAJ0400315.1 hypothetical protein P43SY_002063 [Pythium insidiosum] | diamond | 1827 | 127 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 14227843 | 14227843 | PRJNA1093380_P_NODE_17032_length_241_cov_0.916667_g16926_i0 | PRJNA1093380 | 17032 | 241 | 0.916667 | 2.20916747 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.6100000000000002e-33 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g16926 | i0 | 79.452 | 98.6721991701245 | 219 | 45 | 91 | 0 | 1 | 219 | 441 | 659 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 23780 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14227915 | 14227915 | PRJNA1093380_P_NODE_6832_length_280_cov_1.487923_g6726_i0 | PRJNA1093380 | 6832 | 280 | 1.487923 | 4.1661844 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.1099999999999995e-55 | NTclustered | gi|813102101|ref|XM_012338325.1| | 695850 | g6726 | i0 | 83.27 | 62.4535714285714 | 263 | 30 | 91 | 10 | 1 | 256 | 516 | 261 | Saprolegnia parasitica CBS 223.65 ATP synthase subunit beta partial mRNA | blastn | 17487 | 230 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 20600146 | 20600146 | PRJNA1093380_P_NODE_14697_length_246_cov_0.890173_g14591_i0 | PRJNA1093380 | 14697 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 162 | 4.69e-44 | NR | KAK1930851.1 | 4793 | g14591 | i0 | 93.8 | 17.780487804878 | 81 | 5 | 98.8 | 0 | 2 | 244 | 1284 | 1364 | KAK1930851.1 Eukaryotic initiation factor 4A-III [Phytophthora citrophthora] | diamond | 4374 | 162 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 20600214 | 20600214 | PRJNA1093380_P_NODE_3257_length_337_cov_1.375000_g3151_i0 | PRJNA1093380 | 3257 | 337 | 1.375 | 4.63375 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 190 | 4.810000000000001e-59 | NR | KAL0583279.1 | 65357 | g3151 | i0 | 80.2 | 2.83976261127596 | 106 | 21 | 94.4 | 0 | 19 | 336 | 1 | 106 | KAL0583279.1 hypothetical protein ABG067_006780 [Albugo candida] | diamond | 957 | 190 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 20600229 | 20600229 | PRJNA1093380_P_NODE_4457_length_304_cov_1.939394_g4351_i0 | PRJNA1093380 | 4457 | 304 | 1.939394 | 5.89575776 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 3.989999999999999e-52 | NR | KAF0715182.1 | 112090 | g4351 | i0 | 92.1 | 3.98684210526316 | 101 | 8 | 99.7 | 0 | 2 | 304 | 227 | 327 | KAF0715182.1 hypothetical protein AaE_011386 [Aphanomyces astaci] | diamond | 1212 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23151461 | 23151461 | PRJNA1093380_P_NODE_3439_length_330_cov_2.311284_g3333_i0 | PRJNA1093380 | 3439 | 330 | 2.311284 | 7.6272372 | Aphanomyces sinensis | 1125843 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 1.01e-71 | NTclustered | gi|2813228406|dbj|LC754346.1| | 1125843 | g3333 | i0 | 82.335 | 94.0272727272727 | 334 | 51 | 100 | 7 | 1 | 330 | 513 | 184 | Aphanomyces sinensis NBRC 106581 btub gene for beta-tubulin, partial cds | blastn | 31029 | 283 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sinensis | ||
| 23151567 | 23151567 | PRJNA1093380_P_NODE_899_length_586_cov_0.820663_g796_i0 | PRJNA1093380 | 899 | 586 | 0.820663 | 4.80908518 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.33e-112 | NR | XP_024578065.1 | 4781 | g796 | i0 | 85.6 | 10.981228668942 | 195 | 28 | 99.8 | 0 | 586 | 2 | 148 | 342 | XP_024578065.1 heat shock protein 90 [Plasmopara halstedii] | diamond | 6435 | 345 | 0.991304347826087 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 27817287 | 27817287 | PRJNA1093380_P_NODE_11864_length_251_cov_1.376404_g11758_i0 | PRJNA1093380 | 11864 | 251 | 1.376404 | 3.45477404 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.5600000000000004e-33 | NR | POM63389.1 | 4796 | g11758 | i0 | 77.1 | 6.94422310756972 | 83 | 19 | 99.2 | 0 | 250 | 2 | 146 | 228 | POM63389.1 Isocitrate lyase, partial [Phytophthora palmivora] | diamond | 1743 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 28164445 | 28164445 | PRJNA1093380_P_NODE_12725_length_249_cov_2.522727_g12619_i0 | PRJNA1093380 | 12725 | 249 | 2.522727 | 6.28159023 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 2.25e-27 | NR | ETL95768.1 | 4792 | g12619 | i0 | 65.1 | 10 | 83 | 29 | 100 | 0 | 249 | 1 | 126 | 208 | ETL95768.1 hypothetical protein L917_06488 [Phytophthora nicotianae] | diamond | 2490 | 112 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28322226 | 28322226 | PRJNA1093380_P_NODE_15226_length_245_cov_0.895349_g15120_i0 | PRJNA1093380 | 15226 | 245 | 0.895349 | 2.19360505 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 1.26e-19 | NR | TYZ58888.1 | 1485010 | g15120 | i0 | 63.2 | 3.69795918367347 | 76 | 28 | 93.1 | 0 | 17 | 244 | 819 | 894 | TYZ58888.1 hypothetical protein PybrP1_008177 [[Pythium] brassicae (nom. inval.)] | diamond | 906 | 92.8 | 0.995689655172414 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 29246483 | 29246483 | PRJNA1093380_P_NODE_1469_length_458_cov_0.885714_g1364_i0 | PRJNA1093380 | 1469 | 458 | 0.885714 | 4.05657012 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.0169 | NR | CAI5730517.1 | 162125 | g1364 | i0 | 32.4 | 0.445414847161572 | 68 | 41 | 44.5 | 1 | 37 | 240 | 35 | 97 | CAI5730517.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 204 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 29553426 | 29553426 | PRJNA1093380_P_NODE_14410_length_246_cov_0.890173_g14304_i0 | PRJNA1093380 | 14410 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 5.78e-24 | NR | XP_009831264.1 | 112090 | g14304 | i0 | 62.7 | 6.52439024390244 | 75 | 28 | 91.5 | 0 | 245 | 21 | 33 | 107 | XP_009831264.1 hypothetical protein H257_07436 [Aphanomyces astaci] | diamond | 1605 | 100 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30762800 | 30762800 | PRJNA1093380_P_NODE_8394_length_271_cov_1.419192_g8288_i0 | PRJNA1093380 | 8394 | 271 | 1.419192 | 3.84601032 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 3.66e-10 | NR | KAF1319583.1 | 82926 | g8288 | i0 | 39.6 | 2.8450184501845 | 91 | 47 | 96.3 | 2 | 266 | 6 | 372 | 458 | KAF1319583.1 hypothetical protein FI667_g13067, partial [Globisporangium splendens] | diamond | 771 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 32871620 | 32871620 | PRJNA1093380_P_NODE_10440_length_259_cov_1.666667_g10334_i0 | PRJNA1093380 | 10440 | 259 | 1.666667 | 4.31666753 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 5.45e-19 | NR | OQS06019.1 | 74557 | g10334 | i0 | 61.3 | 3.59073359073359 | 62 | 24 | 71.8 | 0 | 7 | 192 | 1548 | 1609 | OQS06019.1 hypothetical protein THRCLA_01913 [Thraustotheca clavata] | diamond | 930 | 91.7 | 0.991275899672846 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;