contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA454503" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2992923 | 2992923 | PRJNA454503_P_NODE_2903_length_704_cov_4.617418_g2609_i0 | PRJNA454503 | 2903 | 704 | 4.617418 | 32.50662272 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 1205 | 0 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g2609 | i0 | 97.589 | 100.026988636364 | 705 | 13 | 100 | 4 | 1 | 704 | 716 | 15 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 70419 | 1205 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 4269855 | 4269855 | PRJNA454503_P_NODE_78364_length_204_cov_0.909091_g78035_i0 | PRJNA454503 | 78364 | 204 | 0.909091 | 1.85454564 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.69e-29 | NTclustered | gi|675204844|ref|XM_008913059.1| | 761204 | g78035 | i0 | 84.932 | 1.40686274509804 | 146 | 15 | 72 | 4 | 2 | 147 | 537 | 675 | Phytophthora parasitica INRA-310 ribosomal protein S4 mRNA | blastn | 287 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 8095358 | 8095358 | PRJNA454503_P_NODE_26747_length_244_cov_2.114754_g26418_i0 | PRJNA454503 | 26747 | 244 | 2.114754 | 5.15999976 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 7.6900000000000005e-22 | NTclustered | gi|189084883|gb|BT032414.1| | 4784 | g26418 | i0 | 83.594 | 0.524590163934426 | 128 | 17 | 51 | 2 | 3 | 127 | 671 | 797 | Phytophthora capsici clone CBOU93-B03 mRNA sequence | blastn | 128 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 8746597 | 8746597 | PRJNA454503_P_NODE_26467_length_245_cov_1.413043_g26138_i0 | PRJNA454503 | 26467 | 245 | 1.413043 | 3.46195535 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 3.35e-70 | NTclustered | gi|695412177|ref|XM_009527379.1| | 67593 | g26138 | i0 | 87.243 | 7.08163265306122 | 243 | 31 | 99 | 0 | 1 | 243 | 260 | 18 | Phytophthora sojae hypothetical protein mRNA | blastn | 1735 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10021834 | 10021834 | PRJNA454503_P_NODE_26028_length_246_cov_3.178378_g25699_i0 | PRJNA454503 | 26028 | 246 | 3.178378 | 7.81880988 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 5.76e-53 | NTclustered | gi|813144478|ref|XM_012344373.1| | 695850 | g25699 | i0 | 87.435 | 10.1260162601626 | 191 | 24 | 78 | 0 | 1 | 191 | 489 | 679 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein mRNA | blastn | 2491 | 220 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14470664 | 14470664 | PRJNA454503_P_NODE_12752_length_318_cov_1.494163_g12423_i0 | PRJNA454503 | 12752 | 318 | 1.494163 | 4.75143834 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.02e-36 | NTclustered | gi|813118806|ref|XM_012340678.1| | 695850 | g12423 | i0 | 90.476 | 1.16037735849057 | 126 | 12 | 40 | 0 | 193 | 318 | 354 | 229 | Saprolegnia parasitica CBS 223.65 50S ribosomal protein L36e mRNA | blastn | 369 | 167 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17019385 | 17019385 | PRJNA454503_P_NODE_16374_length_288_cov_2.035242_g16045_i0 | PRJNA454503 | 16374 | 288 | 2.035242 | 5.86149696 | Pythium sp. AP | 378252 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.3499999999999993e-119 | NTclustered | gi|90855438|dbj|AB254193.1| | 378252 | g16045 | i0 | 95.956 | 71.6666666666667 | 272 | 11 | 94 | 0 | 17 | 288 | 1 | 272 | Pythium sp. AP genes for 28S rRNA, IGS, 5S rRNA, partial and complete sequence, strain: AP-1, AP-2 and AP-3 | blastn | 20640 | 442 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium sp. AP | ||
| 19568656 | 19568656 | PRJNA454503_P_NODE_796_length_1287_cov_15.225122_g605_i0 | PRJNA454503 | 796 | 1287 | 15.225122 | 195.94732014 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 2244 | 0 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g605 | i0 | 98.135 | 103.869463869464 | 1287 | 24 | 100 | 0 | 1 | 1287 | 11293 | 10007 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 133680 | 2244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 20844574 | 20844574 | PRJNA454503_P_NODE_81317_length_203_cov_0.915493_g80988_i0 | PRJNA454503 | 81317 | 203 | 0.915493 | 1.85845079 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.25e-68 | NTclustered | gi|695405971|ref|XM_009525682.1| | 67593 | g80988 | i0 | 92.593 | 78.7241379310345 | 189 | 14 | 93 | 0 | 13 | 201 | 446 | 258 | Phytophthora sojae hypothetical protein mRNA | blastn | 15981 | 272 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 20844667 | 20844667 | PRJNA454503_P_NODE_89477_length_190_cov_3.023256_g89148_i0 | PRJNA454503 | 89477 | 190 | 3.023256 | 5.7441864 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.4399999999999997e-92 | NTclustered | gi|338798212|gb|HQ665273.1| | 114742 | g89148 | i0 | 100 | 100.147368421053 | 190 | 0 | 100 | 0 | 1 | 190 | 801 | 990 | Pythium insidiosum isolate CBS 574.85 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19028 | 351 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 23395076 | 23395076 | PRJNA454503_P_NODE_7759_length_404_cov_1.137026_g7430_i0 | PRJNA454503 | 7759 | 404 | 1.137026 | 4.59358504 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 4.7e-46 | NTclustered | gi|695460914|ref|XM_009539807.1| | 67593 | g7430 | i0 | 91.608 | 35.7772277227723 | 143 | 12 | 35 | 0 | 1 | 143 | 212 | 354 | Phytophthora sojae hypothetical protein mRNA | blastn | 14454 | 198 | 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);;