contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981720 | 1981720 | PRJNA715462_P_NODE_30162_length_325_cov_1.154762_g29366_i0 | PRJNA715462 | 30162 | 325 | 1.154762 | 3.7529765 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.68e-64 | NTclustered | gi|673019533|ref|XM_008865506.1| | 157072 | g29366 | i0 | 83.333 | 74.8369230769231 | 282 | 45 | 86 | 2 | 45 | 325 | 117 | 397 | Aphanomyces invadans hypothetical protein mRNA | blastn | 24322 | 259 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 3256792 | 3256792 | PRJNA715462_P_NODE_18963_length_429_cov_1.620787_g18167_i0 | PRJNA715462 | 18963 | 429 | 1.620787 | 6.95317623 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 8.170000000000001e-64 | NTclustered | gi|695406446|ref|XM_009525816.1| | 67593 | g18167 | i0 | 81.505 | 62.9300699300699 | 319 | 53 | 74 | 6 | 4 | 319 | 397 | 82 | Phytophthora sojae hypothetical protein mRNA | blastn | 26997 | 257 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5020618 | 5020618 | PRJNA715462_P_NODE_7064_length_865_cov_1.535354_g6371_i0 | PRJNA715462 | 7064 | 865 | 1.535354 | 13.2808121 | Globisporangium | 1448052 | SAR_Eukaryotes | SAR_Eukaryotes | 704 | 0 | NTclustered | gi|1780534031|gb|MK753001.1| | 2052683 | g6371 | i0 | 81.959 | 90.9606936416185 | 837 | 145 | 96 | 6 | 1 | 834 | 846 | 13 | Globisporangium ultimum var. ultimum isolate KSSO_5-45 beta-tubulin mRNA, complete cds | blastn | 78681 | 708 | 0.994350282485876 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 7084383 | 7084383 | PRJNA715462_P_NODE_29626_length_328_cov_1.207843_g28830_i0 | PRJNA715462 | 29626 | 328 | 1.207843 | 3.96172504 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 7.34e-113 | NTclustered | gi|2794923360|ref|XM_067881981.1| | 164328 | g28830 | i0 | 89.877 | 99.3567073170732 | 326 | 33 | 99 | 0 | 1 | 326 | 37 | 362 | Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA | blastn | 32589 | 420 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 7570179 | 7570179 | PRJNA715462_P_NODE_6166_length_954_cov_2.835414_g5520_i0 | PRJNA715462 | 6166 | 954 | 2.835414 | 27.04984956 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 3.14e-71 | NTclustered | gi|695431986|ref|XM_009532530.1| | 67593 | g5520 | i0 | 84.429 | 24.6624737945493 | 289 | 44 | 30 | 1 | 11 | 298 | 798 | 1086 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 23528 | 285 | 0.992982456140351 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8358889 | 8358889 | PRJNA715462_P_NODE_23927_length_370_cov_2.239057_g23131_i0 | PRJNA715462 | 23927 | 370 | 2.239057 | 8.2845109 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.15e-66 | NTclustered | gi|2794910559|ref|XM_067891130.1| | 164328 | g23131 | i0 | 79.73 | 6.19189189189189 | 370 | 71 | 99 | 4 | 2 | 369 | 728 | 361 | Phytophthora ramorum 3-oxoacyl-[acyl-carrier-protein] reductase FabG (KRP23_5997), partial mRNA | blastn | 2291 | 265 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 8359439 | 8359439 | PRJNA715462_P_NODE_49607_length_253_cov_1.461111_g48811_i0 | PRJNA715462 | 49607 | 253 | 1.461111 | 3.69661083 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.8499999999999995e-31 | NTclustered | gi|698795769|ref|XM_009832612.1| | 112090 | g48811 | i0 | 81.421 | 1.87351778656126 | 183 | 32 | 72 | 2 | 66 | 247 | 93 | 274 | Aphanomyces astaci hypothetical protein mRNA | blastn | 474 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 9634309 | 9634309 | PRJNA715462_P_NODE_32588_length_311_cov_1.260504_g31792_i0 | PRJNA715462 | 32588 | 311 | 1.260504 | 3.92016744 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 4.5e-55 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g31792 | i0 | 81.852 | 81.9967845659164 | 270 | 49 | 87 | 0 | 1 | 270 | 314 | 45 | Pythium splendens calmodulin mRNA, complete cds | blastn | 25501 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 9634503 | 9634503 | PRJNA715462_P_NODE_42508_length_273_cov_1.540000_g41712_i0 | PRJNA715462 | 42508 | 273 | 1.54 | 4.2042 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 8.339999999999999e-57 | NTclustered | gi|695423734|ref|XM_009530461.1| | 67593 | g41712 | i0 | 83.534 | 91.5787545787546 | 249 | 41 | 91 | 0 | 16 | 264 | 899 | 1147 | Phytophthora sojae hypothetical protein mRNA | blastn | 25001 | 233 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 14734513 | 14734513 | PRJNA715462_P_NODE_22712_length_382_cov_1.834951_g21916_i0 | PRJNA715462 | 22712 | 382 | 1.834951 | 7.00951282 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 3.229999999999999e-87 | NTclustered | gi|675199240|ref|XM_008910257.1| | 761204 | g21916 | i0 | 83.2 | 87.8612565445026 | 375 | 53 | 98 | 8 | 1 | 373 | 1017 | 651 | Phytophthora parasitica INRA-310 ATP synthase subunit beta, mitochondrial mRNA | blastn | 33563 | 335 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 15220782 | 15220782 | PRJNA715462_P_NODE_32392_length_312_cov_1.288703_g31596_i0 | PRJNA715462 | 32392 | 312 | 1.288703 | 4.02075336 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.6e-64 | NTclustered | gi|166036286|emb|CU356935.1| | 100861 | g31596 | i0 | 82.653 | 89.4326923076923 | 294 | 49 | 94 | 2 | 15 | 307 | 481 | 773 | Aphanomyces euteiches cDNA | blastn | 27903 | 259 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22383486 | 22383486 | PRJNA715462_P_NODE_42438_length_273_cov_2.230000_g41642_i0 | PRJNA715462 | 42438 | 273 | 2.23 | 6.0879 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 8.11e-77 | NTclustered | gi|189084354|gb|BT031870.1| | 4784 | g41642 | i0 | 88.934 | 86.6959706959707 | 244 | 25 | 89 | 2 | 32 | 273 | 75 | 318 | Phytophthora capsici clone CBOT85-O08 mRNA sequence | blastn | 23668 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 24932137 | 24932137 | PRJNA715462_P_NODE_24380_length_366_cov_2.317406_g23584_i0 | PRJNA715462 | 24380 | 366 | 2.317406 | 8.48170596 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.91e-64 | NTclustered | gi|695426125|ref|XM_009531049.1| | 67593 | g23584 | i0 | 80.46 | 42.1502732240437 | 348 | 60 | 94 | 8 | 3 | 346 | 747 | 404 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 15427 | 259 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;