contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1038642 | 1038642 | PRJNA1160211_S_NODE_254541_length_258_cov_1.875676_g253308_i0 | PRJNA1160211 | 254541 | 258 | 1.875676 | 4.83924408 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.79e-61 | NTclustered | gi|2795037549|ref|XM_067927198.1| | 4785 | g253308 | i0 | 93.902 | 4.92248062015504 | 164 | 10 | 64 | 0 | 23 | 186 | 233 | 396 | Phytophthora cinnamomi 40S ribosomal protein S20 (IUM83_03212), partial mRNA | blastn | 1270 | 250 | 0.992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 1038759 | 1038759 | PRJNA1160211_S_NODE_28861_length_657_cov_163.839041_g27770_i0 | PRJNA1160211 | 28861 | 657 | 163.839041 | 1076.42249937 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 9.3e-115 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g27770 | i0 | 86.216 | 59.0076103500761 | 399 | 50 | 60 | 4 | 164 | 560 | 483 | 88 | Pythium splendens calmodulin mRNA, complete cds | blastn | 38768 | 431 | 0.990719257540603 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 3588853 | 3588853 | PRJNA1160211_S_NODE_175203_length_340_cov_10.546816_g173970_i0 | PRJNA1160211 | 175203 | 340 | 10.546816 | 35.8591744 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 4.3799999999999985e-145 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g173970 | i0 | 96.552 | 99.2 | 319 | 9 | 93 | 2 | 1 | 317 | 9947 | 9629 | Saprolegnia ferax mitochondrion, complete genome | blastn | 33728 | 527 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 7963519 | 7963519 | PRJNA1160211_S_NODE_285167_length_238_cov_6.503030_g283934_i0 | PRJNA1160211 | 285167 | 238 | 6.50303 | 15.4772114 | Peronospora aparines | 162109 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.11e-104 | NTclustered | gi|23306501|gb|AY035484.1| | 162109 | g283934 | i0 | 99.535 | 90.8865546218487 | 215 | 1 | 90 | 0 | 1 | 215 | 473 | 259 | Peronospora aparines isolate MG 4-5 large subunit ribosomal RNA gene, partial sequence | blastn | 21631 | 392 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora aparines | ||
| 8692035 | 8692035 | PRJNA1160211_S_NODE_91087_length_475_cov_3.318408_g89864_i0 | PRJNA1160211 | 91087 | 475 | 3.318408 | 15.762438 | root | 1 | Root_unresolved | Root_unresolved | 710 | 0 | NTclustered | gi|166046695|emb|CU367805.1| | 100861 | g89864 | i0 | 100 | 46.1936842105263 | 384 | 0 | 81 | 0 | 27 | 410 | 1 | 384 | Aphanomyces euteiches cDNA | blastn | 21942 | 717 | 0.99023709902371 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9238447 | 9238447 | PRJNA1160211_S_NODE_45008_length_592_cov_5.978805_g43853_i0 | PRJNA1160211 | 45008 | 592 | 5.978805 | 35.3945256 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.86e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g43853 | i0 | 80.533 | 57.1418918918919 | 375 | 65 | 62 | 4 | 32 | 399 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 10514056 | 10514056 | PRJNA1160211_S_NODE_299089_length_206_cov_7.977444_g297856_i0 | PRJNA1160211 | 299089 | 206 | 7.977444 | 16.43353464 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 2.09e-76 | NTclustered | gi|256009645|gb|GQ374534.1| | 112090 | g297856 | i0 | 96.154 | 25.0728155339806 | 182 | 7 | 88 | 0 | 5 | 186 | 384 | 203 | Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence | blastn | 5165 | 298 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11241626 | 11241626 | PRJNA1160211_S_NODE_182169_length_331_cov_22.624031_g180936_i0 | PRJNA1160211 | 182169 | 331 | 22.624031 | 74.88554261 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 544 | 4.22e-150 | NTclustered | gi|827085599|gb|KM058092.1| | 120572 | g180936 | i0 | 98.693 | 92.3987915407855 | 306 | 4 | 92 | 0 | 26 | 331 | 1 | 306 | Peronospora bulbocapni isolate HV7 28S ribosomal RNA gene, partial sequence | blastn | 30584 | 544 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora bulbocapni | ||
| 11242069 | 11242069 | PRJNA1160211_S_NODE_300889_length_199_cov_4.007937_g299656_i0 | PRJNA1160211 | 300889 | 199 | 4.007937 | 7.97579463 | Aquastella | 1495611 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.2699999999999996e-94 | NTclustered | gi|629632980|gb|KF294792.1| | 1495612 | g299656 | i0 | 100 | 96.9095477386935 | 193 | 0 | 97 | 0 | 7 | 199 | 1568 | 1376 | Aquastella attenuata isolate SL45 18S ribosomal RNA gene, partial sequence | blastn | 19285 | 357 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aquastella | Aquastella attenuata | ||
| 11788224 | 11788224 | PRJNA1160211_S_NODE_183370_length_330_cov_4.097276_g182137_i0 | PRJNA1160211 | 183370 | 330 | 4.097276 | 13.521010800000001 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 1.41e-15 | NTclustered | gi|698793878|ref|XR_717100.1| | 112090 | g182137 | i0 | 80.153 | 42.3333333333333 | 131 | 25 | 48 | 1 | 130 | 259 | 3791 | 3661 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 13970 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13791967 | 13791967 | PRJNA1160211_S_NODE_253691_length_259_cov_1.161290_g252458_i0 | PRJNA1160211 | 253691 | 259 | 1.16129 | 3.0077411 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.98e-127 | NTclustered | gi|166044613|emb|CU367522.1| | 100861 | g252458 | i0 | 99.609 | 248.320463320463 | 256 | 1 | 99 | 0 | 4 | 259 | 478 | 223 | Aphanomyces euteiches cDNA | blastn | 64315 | 468 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 17616720 | 17616720 | PRJNA1160211_S_NODE_63234_length_539_cov_3.236052_g62042_i0 | PRJNA1160211 | 63234 | 539 | 3.236052 | 17.44232028 | Achlyaceae | 3456998 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 1.6800000000000002e-91 | NTclustered | gi|22086549|gb|AF402100.1| | 4768 | g62042 | i0 | 78.558 | 93.9165120593692 | 541 | 108 | 99 | 7 | 3 | 539 | 942 | 1478 | Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds | blastn | 50621 | 350 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis | ||
| 18889640 | 18889640 | PRJNA1160211_S_NODE_108995_length_440_cov_6.792916_g107767_i0 | PRJNA1160211 | 108995 | 440 | 6.792916 | 29.8888304 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 706 | 0 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g107767 | i0 | 95.682 | 106.897727272727 | 440 | 17 | 100 | 2 | 1 | 440 | 11082 | 10645 | Saprolegnia ferax mitochondrion, complete genome | blastn | 47035 | 706 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 20164548 | 20164548 | PRJNA1160211_S_NODE_129216_length_406_cov_4.138138_g127984_i0 | PRJNA1160211 | 129216 | 406 | 4.138138 | 16.80084028 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 1.04e-32 | NTclustered | gi|328802538|emb|FR832890.1| | 890382 | g127984 | i0 | 76.038 | 58.9581280788177 | 313 | 66 | 76 | 8 | 93 | 402 | 1392 | 1086 | Albugo laibachii Nc14, mitochondrial genomic contig NODE_36_length_2553_cov_1396.121460 | blastn | 23937 | 154 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 20710505 | 20710505 | PRJNA1160211_S_NODE_126117_length_411_cov_4.337278_g124886_i0 | PRJNA1160211 | 126117 | 411 | 4.337278 | 17.82621258 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 760 | 0 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g124886 | i0 | 100 | 99.9318734793187 | 411 | 0 | 100 | 0 | 1 | 411 | 590 | 180 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 41072 | 760 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 21440674 | 21440674 | PRJNA1160211_S_NODE_289677_length_232_cov_2.905660_g288444_i0 | PRJNA1160211 | 289677 | 232 | 2.90566 | 6.7411312 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 8.379999999999998e-101 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g288444 | i0 | 97.309 | 100.827586206897 | 223 | 6 | 96 | 0 | 10 | 232 | 4088 | 4310 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 23392 | 379 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23261942 | 23261942 | PRJNA1160211_S_NODE_205459_length_304_cov_13.753247_g204226_i0 | PRJNA1160211 | 205459 | 304 | 13.753247 | 41.80987088 | Phytophthora ilicis | 89335 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2314988899|ref|NC_067072.1| | 89335 | g204226 | i0 | 94.444 | 0.118421052631579 | 36 | 2 | 12 | 0 | 257 | 292 | 24827 | 24792 | Phytophthora ilicis voucher P3939 mitochondrion, complete genome | blastn | 36 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ilicis | ||
| 23262055 | 23262055 | PRJNA1160211_S_NODE_221779_length_287_cov_20.990654_g220546_i0 | PRJNA1160211 | 221779 | 287 | 20.990654 | 60.24317698 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 4.749999999999998e-134 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g220546 | i0 | 100 | 92.1742160278746 | 265 | 0 | 92 | 0 | 23 | 287 | 50 | 314 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 26454 | 490 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 23262486 | 23262486 | PRJNA1160211_S_NODE_286159_length_237_cov_3.158537_g284926_i0 | PRJNA1160211 | 286159 | 237 | 3.158537 | 7.48573269 | Myzocytiopsis humana | 135482 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4e-118 | NTclustered | gi|918464080|gb|KT257319.1| | 135482 | g284926 | i0 | 100 | 98.7805907172996 | 237 | 0 | 100 | 0 | 1 | 237 | 2624 | 2860 | Lagenidium humanum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 23411 | 438 | 1 | Eukaryota | Sar | Oomycota | Myzocytiopsidales | Myzocytiopsidaceae | Myzocytiopsis | Myzocytiopsis humana | |||
| 25264451 | 25264451 | PRJNA1160211_S_NODE_129580_length_405_cov_13.831325_g128348_i0 | PRJNA1160211 | 129580 | 405 | 13.831325 | 56.01686625 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g128348 | i0 | 98.158 | 102.82962962963 | 380 | 7 | 94 | 0 | 26 | 405 | 3572 | 3951 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 41646 | 667 | 0.995502248875562 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 25264734 | 25264734 | PRJNA1160211_S_NODE_198620_length_312_cov_4.271967_g197387_i0 | PRJNA1160211 | 198620 | 312 | 4.271967 | 13.32853704 | Peronosporales | 4776 | SAR_Eukaryotes | SAR_Eukaryotes | 551 | 2.359999999999999e-152 | NTclustered | gi|1238675774|gb|MF783088.1| | 4784 | g197387 | i0 | 99.668 | 96.474358974359 | 301 | 1 | 96 | 0 | 1 | 301 | 981 | 681 | Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence | blastn | 30100 | 551 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici |
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);;