contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA195897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2916672 | 2916672 | PRJNA195897_P_NODE_4643_length_222_cov_4.346821_g4610_i0 | PRJNA195897 | 4643 | 222 | 4.346821 | 9.64994262 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 4.96e-73 | NTclustered | gi|695389557|ref|XM_009521174.1| | 67593 | g4610 | i0 | 90.045 | 289.027027027027 | 221 | 22 | 99 | 0 | 2 | 222 | 359 | 579 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 64164 | 287 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 3605770 | 3605770 | PRJNA195897_P_NODE_5803_length_202_cov_1.941176_g5770_i0 | PRJNA195897 | 5803 | 202 | 1.941176 | 3.92117552 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.23e-16 | NTclustered | gi|442591541|gb|JX115049.1| | 129356 | g5770 | i0 | 77.059 | 2.10891089108911 | 170 | 39 | 84 | 0 | 22 | 191 | 233 | 64 | Phytophthora mirabilis voucher CBS:678.85 PF16 gene, partial cds | blastn | 426 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora mirabilis | ||
| 7433187 | 7433187 | PRJNA195897_P_NODE_5766_length_203_cov_1.032468_g5733_i0 | PRJNA195897 | 5766 | 203 | 1.032468 | 2.09591004 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.35e-13 | NTclustered | gi|442591581|gb|JX115069.1| | 82932 | g5733 | i0 | 78.261 | 2.18226600985222 | 138 | 30 | 68 | 0 | 28 | 165 | 426 | 289 | Pythium arrhenomanes culture CCFC:DAOM BR 983 PF16 gene, partial cds | blastn | 443 | 89.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium arrhenomanes | ||
| 8019385 | 8019385 | PRJNA195897_P_NODE_7767_length_179_cov_1.769231_g7734_i0 | PRJNA195897 | 7767 | 179 | 1.769231 | 3.16692349 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.91e-21 | NTclustered | gi|698818146|ref|XM_009843800.1| | 112090 | g7734 | i0 | 81.69 | 2.17877094972067 | 142 | 23 | 78 | 3 | 1 | 139 | 241 | 100 | Aphanomyces astaci 40S ribosomal protein S27-like protein mRNA | blastn | 390 | 115 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11258500 | 11258500 | PRJNA195897_P_NODE_1189_length_488_cov_6.000000_g1158_i0 | PRJNA195897 | 1189 | 488 | 6 | 29.28 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 4.25e-82 | NTclustered | gi|2795050181|ref|XM_067944756.1| | 4785 | g1158 | i0 | 88.06 | 54.0102459016393 | 268 | 32 | 55 | 0 | 57 | 324 | 1 | 268 | Phytophthora cinnamomi dynein light chain LC6, flagellar outer arm (IUM83_19694), partial mRNA | blastn | 26357 | 320 | 0.99375 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15668740 | 15668740 | PRJNA195897_P_NODE_11593_length_164_cov_0.904348_g11560_i0 | PRJNA195897 | 11593 | 164 | 0.904348 | 1.48313072 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.32e-27 | NTclustered | gi|2794921676|ref|XM_067881069.1| | 164328 | g11560 | i0 | 84.559 | 2.79268292682927 | 136 | 21 | 83 | 0 | 13 | 148 | 353 | 218 | Phytophthora ramorum 40S ribosomal protein S8 (KRP23_10601), partial mRNA | blastn | 458 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 15668743 | 15668743 | PRJNA195897_P_NODE_1193_length_487_cov_4.618721_g1162_i0 | PRJNA195897 | 1193 | 487 | 4.618721 | 22.49317127 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 5.45e-86 | NTclustered | gi|2795045397|ref|XM_067939565.1| | 4785 | g1162 | i0 | 89.139 | 53.7289527720739 | 267 | 27 | 55 | 2 | 57 | 322 | 1 | 266 | Phytophthora cinnamomi dynein light chain LC6, flagellar outer arm (IUM83_14793), partial mRNA | blastn | 26166 | 331 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 17632933 | 17632933 | PRJNA195897_P_NODE_4434_length_227_cov_1.438202_g4401_i0 | PRJNA195897 | 4434 | 227 | 1.438202 | 3.26471854 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|673034947|ref|XM_008873213.1| | 157072 | g4401 | i0 | 100 | 0.656387665198238 | 30 | 0 | 13 | 0 | 36 | 65 | 617 | 588 | Aphanomyces invadans hypothetical protein mRNA | blastn | 149 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 18217684 | 18217684 | PRJNA195897_P_NODE_4695_length_221_cov_2.116279_g4662_i0 | PRJNA195897 | 4695 | 221 | 2.116279 | 4.67697659 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.46e-28 | NTclustered | gi|301121759|ref|XM_002908561.1| | 403677 | g4662 | i0 | 78.341 | 3.14932126696833 | 217 | 45 | 98 | 2 | 4 | 219 | 651 | 436 | Phytophthora infestans T30-4 succinyl-CoA ligase subunit alpha, mitochondrial precursor (PITG_02026), partial mRNA | blastn | 696 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 19491948 | 19491948 | PRJNA195897_P_NODE_1656_length_403_cov_3.692090_g1623_i0 | PRJNA195897 | 1656 | 403 | 3.69209 | 14.8791227 | Pythium torulosum | 4799 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 8.13e-19 | NTclustered | gi|1780534029|gb|MK753000.1| | 4799 | g1623 | i0 | 94.286 | 15.833746898263 | 70 | 4 | 17 | 0 | 334 | 403 | 1304 | 1235 | Pythium torulosum isolate MISO_8-29.1 beta-tubulin mRNA, complete cds | blastn | 6381 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium torulosum | ||
| 20767474 | 20767474 | PRJNA195897_P_NODE_11317_length_164_cov_1.113043_g11284_i0 | PRJNA195897 | 11317 | 164 | 1.113043 | 1.82539052 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.23e-20 | NTclustered | gi|2794909533|ref|XM_067890873.1| | 164328 | g11284 | i0 | 88.172 | 14.8475609756098 | 93 | 11 | 57 | 0 | 72 | 164 | 238 | 330 | Phytophthora ramorum Proteasome subunit beta type-7 (KRP23_5767), partial mRNA | blastn | 2435 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 20767522 | 20767522 | PRJNA195897_P_NODE_3897_length_244_cov_1.066667_g3864_i0 | PRJNA195897 | 3897 | 244 | 1.066667 | 2.60266748 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.58e-20 | NTclustered | gi|695437469|ref|XM_009533931.1| | 67593 | g3864 | i0 | 87 | 0.774590163934426 | 100 | 11 | 41 | 2 | 122 | 220 | 916 | 818 | Phytophthora sojae hypothetical protein mRNA | blastn | 189 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 22732061 | 22732061 | PRJNA195897_P_NODE_3618_length_254_cov_1.590244_g3585_i0 | PRJNA195897 | 3618 | 254 | 1.590244 | 4.03921976 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.92e-16 | NTclustered | gi|66270188|gb|AY961478.1| | 4787 | g3585 | i0 | 78.125 | 2.23622047244094 | 160 | 31 | 62 | 4 | 90 | 247 | 162 | 5 | Phytophthora infestans clone MY-09-A-12 ribosomal protein L39 mRNA, complete cds | blastn | 568 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 23318073 | 23318073 | PRJNA195897_P_NODE_2179_length_344_cov_1.094915_g2146_i0 | PRJNA195897 | 2179 | 344 | 1.094915 | 3.7665076 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 2.95e-72 | NTclustered | gi|695388586|ref|XM_009520922.1| | 67593 | g2146 | i0 | 89.083 | 375.96511627907 | 229 | 25 | 70 | 0 | 109 | 337 | 275 | 47 | Phytophthora sojae hypothetical protein mRNA | blastn | 129332 | 285 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 24592176 | 24592176 | PRJNA195897_P_NODE_1040_length_522_cov_1.794926_g1009_i0 | PRJNA195897 | 1040 | 522 | 1.794926 | 9.36951372 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 1.4e-12 | NTclustered | gi|1378169911|ref|XM_024719330.1| | 4781 | g1009 | i0 | 96.226 | 1.58045977011494 | 53 | 2 | 11 | 0 | 235 | 287 | 260 | 312 | Plasmopara halstedii uncharacterized protein (PHALS_06101), partial mRNA | blastn | 825 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii |
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);;