contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742315 | 742315 | PRJNA760976_P_NODE_18581_length_357_cov_2.616197_g18260_i0 | PRJNA760976 | 18581 | 357 | 2.616197 | 9.33982329 | Pythium torulosum | 4799 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 1.0499999999999998e-106 | NTclustered | gi|1780534029|gb|MK753000.1| | 4799 | g18260 | i0 | 88.889 | 85.7254901960784 | 324 | 36 | 91 | 0 | 34 | 357 | 1 | 324 | Pythium torulosum isolate MISO_8-29.1 beta-tubulin mRNA, complete cds | blastn | 30604 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium torulosum | ||
| 3293626 | 3293626 | PRJNA760976_P_NODE_27583_length_312_cov_0.891213_g27262_i0 | PRJNA760976 | 27583 | 312 | 0.891213 | 2.78058456 | Phytophthora lateralis | 129355 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.82e-27 | NTclustered | gi|2235892989|tpg|BK012092.1| | 129355 | g27262 | i0 | 89.623 | 0.67948717948718 | 106 | 11 | 34 | 0 | 47 | 152 | 17942 | 17837 | TPA_asm: Phytophthora lateralis strain SMST21 mitochondrion, complete genome | blastn | 212 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lateralis | ||
| 3756738 | 3756738 | PRJNA760976_P_NODE_12423_length_413_cov_4.111765_g12103_i0 | PRJNA760976 | 12423 | 413 | 4.111765 | 16.98158945 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 3.67e-57 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g12103 | i0 | 84.979 | 75.5326876513317 | 233 | 34 | 56 | 1 | 18 | 249 | 67 | 299 | Aphanomyces astaci polyubiquitin mRNA | blastn | 31195 | 235 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 9670731 | 9670731 | PRJNA760976_P_NODE_11908_length_421_cov_1.290230_g11588_i0 | PRJNA760976 | 11908 | 421 | 1.29023 | 5.4318683 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 697 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g11588 | i0 | 96.454 | 105.064133016627 | 423 | 13 | 100 | 2 | 1 | 421 | 2237 | 2659 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 44232 | 697 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13496062 | 13496062 | PRJNA760976_P_NODE_11411_length_428_cov_1.171831_g11091_i0 | PRJNA760976 | 11411 | 428 | 1.171831 | 5.01543668 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 8.38e-44 | NTclustered | gi|2794892223|ref|XM_067887285.1| | 164328 | g11091 | i0 | 80.645 | 58.231308411215 | 248 | 46 | 58 | 2 | 21 | 267 | 447 | 201 | Phytophthora ramorum 60S ribosomal protein L23a (KRP23_2536), partial mRNA | blastn | 24923 | 191 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 13496173 | 13496173 | PRJNA760976_P_NODE_48551_length_250_cov_0.870056_g48230_i0 | PRJNA760976 | 48551 | 250 | 0.870056 | 2.17514 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 7.75e-37 | NTclustered | gi|2795050181|ref|XM_067944756.1| | 4785 | g48230 | i0 | 89.394 | 53.256 | 132 | 14 | 53 | 0 | 1 | 132 | 135 | 266 | Phytophthora cinnamomi dynein light chain LC6, flagellar outer arm (IUM83_19694), partial mRNA | blastn | 13314 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 17782626 | 17782626 | PRJNA760976_P_NODE_11794_length_422_cov_2.100287_g11474_i0 | PRJNA760976 | 11794 | 422 | 2.100287 | 8.86321114 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 4.47e-116 | NTclustered | gi|698785784|ref|XM_009827634.1| | 112090 | g11474 | i0 | 86.945 | 91.9549763033175 | 383 | 50 | 91 | 0 | 2 | 384 | 383 | 1 | Aphanomyces astaci histone H3 partial mRNA | blastn | 38805 | 431 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 19869244 | 19869244 | PRJNA760976_P_NODE_28176_length_309_cov_1.610169_g27855_i0 | PRJNA760976 | 28176 | 309 | 1.610169 | 4.97542221 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 3.43e-61 | NTclustered | gi|301105318|ref|XM_002901697.1| | 403677 | g27855 | i0 | 84.646 | 35.5631067961165 | 254 | 33 | 81 | 5 | 32 | 282 | 86 | 336 | Phytophthora infestans T30-4 elongation factor 2 (PITG_10941), mRNA | blastn | 10989 | 248 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans |
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);;