contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 538807 | 538807 | PRJNA558770_P_NODE_184141_length_234_cov_4.447236_g182136_i0 | PRJNA558770 | 184141 | 234 | 4.447236 | 10.40653224 | Pseudoperonospora cubensis | 143453 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 9.55e-16 | NTclustered | gi|2250226911|gb|MW582838.1| | 143453 | g182136 | i0 | 96.552 | 5.35470085470085 | 58 | 2 | 25 | 0 | 1 | 58 | 47 | 104 | Pseudoperonospora cubensis microsatellite PC14 sequence | blastn | 1253 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora cubensis | ||
| 5642193 | 5642193 | PRJNA558770_P_NODE_160825_length_234_cov_5.708543_g158820_i0 | PRJNA558770 | 160825 | 234 | 5.708543 | 13.35799062 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.35e-29 | NTclustered | gi|1235732003|gb|MF693906.1| | 622444 | g158820 | i0 | 100 | 45.5726495726496 | 76 | 0 | 65 | 0 | 159 | 234 | 108 | 33 | Peronospora belbahrii isolate RC16DM5 large subunit ribosomal RNA gene, partial sequence | blastn | 10664 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 7507350 | 7507350 | PRJNA558770_P_NODE_250506_length_234_cov_2.296482_g248501_i0 | PRJNA558770 | 250506 | 234 | 2.296482 | 5.37376788 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 9.41e-26 | NTclustered | gi|1820797599|gb|MT192342.1| | 4798 | g248501 | i0 | 98.63 | 37.9786324786325 | 73 | 1 | 31 | 0 | 4 | 76 | 334 | 406 | Pythium hydnosporum isolate JZB3410001 large subunit ribosomal RNA gene, partial sequence | blastn | 8887 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium hydnosporum | ||
| 10058174 | 10058174 | PRJNA558770_P_NODE_314668_length_233_cov_10.565657_g312663_i0 | PRJNA558770 | 314668 | 233 | 10.565657 | 24.61798081 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.39e-19 | NTclustered | gi|325183168|emb|FR824083.1| | 890382 | g312663 | i0 | 96.875 | 1.6480686695279 | 64 | 2 | 27 | 0 | 170 | 233 | 35882 | 35819 | Albugo laibachii Nc14, genomic contig CONTIG_38_NC14_v4_136441_241 | blastn | 384 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 11332171 | 11332171 | PRJNA558770_P_NODE_196969_length_234_cov_3.899497_g194964_i0 | PRJNA558770 | 196969 | 234 | 3.899497 | 9.12482298 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.23e-19 | NTclustered | gi|2795034905|ref|XM_067944651.1| | 4785 | g194964 | i0 | 93.243 | 17.6965811965812 | 74 | 5 | 32 | 0 | 161 | 234 | 3740 | 3813 | Phytophthora cinnamomi Gag-Pol polyprotein (IUM83_19595), partial mRNA | blastn | 4141 | 111 | 0.990990990990991 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 16431786 | 16431786 | PRJNA558770_P_NODE_209673_length_234_cov_3.427136_g207668_i0 | PRJNA558770 | 209673 | 234 | 3.427136 | 8.01949824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.38e-25 | NTclustered | gi|2260101629|gb|ON860620.1| | 135482 | g207668 | i0 | 98.611 | 30.7564102564103 | 72 | 1 | 31 | 0 | 4 | 75 | 799 | 870 | Myzocytiopsis humana voucher CCIBt4304 large subunit ribosomal RNA gene, partial sequence | blastn | 7197 | 128 | 1 | Eukaryota | Sar | Oomycota | Myzocytiopsidales | Myzocytiopsidaceae | Myzocytiopsis | Myzocytiopsis humana | |||
| 19667791 | 19667791 | PRJNA558770_P_NODE_361236_length_232_cov_6.329949_g359231_i0 | PRJNA558770 | 361236 | 232 | 6.329949 | 14.68548168 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 7.25e-22 | NTclustered | gi|2248512836|ref|NC_063790.1| | 622444 | g359231 | i0 | 94.667 | 0.323275862068966 | 75 | 4 | 32 | 0 | 1 | 75 | 4568 | 4642 | Peronospora belbahrii isolate HI01 mitochondrion, complete genome | blastn | 75 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 20255450 | 20255450 | PRJNA558770_P_NODE_174536_length_234_cov_4.919598_g172531_i0 | PRJNA558770 | 174536 | 234 | 4.919598 | 11.51185932 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.35e-29 | NTclustered | gi|122703753|gb|EF153666.1| | 417820 | g172531 | i0 | 100 | 59.3376068376068 | 76 | 0 | 65 | 0 | 1 | 76 | 24 | 99 | Peronospora sp. S4 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 | 13885 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora sp. S4 | ||
| 21531735 | 21531735 | PRJNA558770_P_NODE_332977_length_233_cov_5.484848_g330972_i0 | PRJNA558770 | 332977 | 233 | 5.484848 | 12.77969584 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 7.39e-12 | NTclustered | gi|73917512|gb|DQ163008.1| | 129354 | g330972 | i0 | 91.667 | 0.570815450643777 | 60 | 5 | 26 | 0 | 1 | 60 | 142 | 83 | Phytophthora katsurae strain SCRP388 intergenic spacer region 2, partial sequence | blastn | 133 | 84.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora katsurae | ||
| 24766020 | 24766020 | PRJNA558770_P_NODE_235600_length_234_cov_2.653266_g233595_i0 | PRJNA558770 | 235600 | 234 | 2.653266 | 6.20864244 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 5.74e-13 | NTclustered | gi|2795036851|ref|XM_067927300.1| | 4785 | g233595 | i0 | 94.643 | 0.239316239316239 | 56 | 3 | 24 | 0 | 20 | 75 | 1788 | 1843 | Phytophthora cinnamomi phosphatidylinositol kinase (IUM83_03309), partial mRNA | blastn | 56 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;