contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3238526 | 3238526 | PRJNA704949_P_NODE_1193103_length_233_cov_1.407609_g1177766_i0 | PRJNA704949 | 1193103 | 233 | 1.407609 | 3.27972897 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.39e-19 | NTclustered | gi|695403836|ref|XM_009525087.1| | 67593 | g1177766 | i0 | 88.636 | 2.60944206008584 | 88 | 10 | 38 | 0 | 18 | 105 | 346 | 259 | Phytophthora sojae hypothetical protein mRNA | blastn | 608 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5798471 | 5798471 | PRJNA704949_P_NODE_2114485_length_163_cov_2.736842_g2099146_i0 | PRJNA704949 | 2114485 | 163 | 2.736842 | 4.46105246 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 4.75e-22 | NTclustered | gi|2431515601|ref|NC_070108.1| | 230839 | g2099146 | i0 | 79.878 | 16.2453987730061 | 164 | 29 | 99 | 4 | 2 | 163 | 37470 | 37631 | Peronosclerospora sorghi isolate P6 mitochondrion, complete genome | blastn | 2648 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 9623821 | 9623821 | PRJNA704949_P_NODE_2173408_length_162_cov_0.920354_g2158069_i0 | PRJNA704949 | 2173408 | 162 | 0.920354 | 1.49097348 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 9.64e-59 | NTclustered | gi|325193489|emb|FR824676.1| | 890382 | g2158069 | i0 | 93.865 | 2.01851851851852 | 163 | 3 | 100 | 5 | 1 | 162 | 6006 | 5850 | Albugo laibachii Nc14, genomic contig CONTIG_697_NC14_v4_7373_108 | blastn | 327 | 239 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 10892516 | 10892516 | PRJNA704949_P_NODE_1304809_length_220_cov_1.520468_g1289472_i0 | PRJNA704949 | 1304809 | 220 | 1.520468 | 3.3450296 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.19e-4 | NTclustered | gi|669151135|ref|XM_008612908.1| | 1156394 | g1289472 | i0 | 97.059 | 0.677272727272727 | 34 | 1 | 15 | 0 | 105 | 138 | 298 | 265 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 149 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 14717760 | 14717760 | PRJNA704949_P_NODE_134892_length_691_cov_3.186916_g121697_i0 | PRJNA704949 | 134892 | 691 | 3.186916 | 22.02158956 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 1225 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g121697 | i0 | 99.12 | 8.60057887120116 | 682 | 5 | 99 | 1 | 10 | 691 | 882 | 1562 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 5943 | 1225 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14723431 | 14723431 | PRJNA704949_P_NODE_206132_length_578_cov_3.124764_g191930_i0 | PRJNA704949 | 206132 | 578 | 3.124764 | 18.06113592 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 749 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g191930 | i0 | 94.512 | 1.37024221453287 | 492 | 15 | 85 | 1 | 1 | 492 | 480 | 1 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 792 | 749 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 16002671 | 16002671 | PRJNA704949_P_NODE_70793_length_914_cov_2.615029_g59239_i0 | PRJNA704949 | 70793 | 914 | 2.615029 | 23.90136506 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.002 | NTclustered | gi|1378144770|ref|XM_024728103.1| | 4781 | g59239 | i0 | 97.059 | 0.037199124726477 | 34 | 1 | 4 | 0 | 195 | 228 | 117 | 150 | Plasmopara halstedii uncharacterized protein (PHALS_00122), partial mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 17269849 | 17269849 | PRJNA704949_P_NODE_1739874_length_182_cov_1.172932_g1724535_i0 | PRJNA704949 | 1739874 | 182 | 1.172932 | 2.13473624 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 5.08e-67 | NTclustered | gi|166046574|emb|CU367691.1| | 100861 | g1724535 | i0 | 100 | 1.58791208791209 | 144 | 0 | 79 | 0 | 21 | 164 | 418 | 275 | Aphanomyces euteiches cDNA | blastn | 289 | 267 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 17271471 | 17271471 | PRJNA704949_P_NODE_1947114_length_169_cov_0.866667_g1931775_i0 | PRJNA704949 | 1947114 | 169 | 0.866667 | 1.46466723 | Peronospora sanguisorbae | 162112 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.6e-72 | NTclustered | gi|33520209|gb|AY273954.1| | 162112 | g1931775 | i0 | 98.148 | 95.8165680473373 | 162 | 3 | 96 | 0 | 1 | 162 | 223 | 384 | Peronospora sanguisorbae large subunit ribosomal RNA gene, partial sequence | blastn | 16193 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora sanguisorbae | ||
| 18540145 | 18540145 | PRJNA704949_P_NODE_1298735_length_221_cov_1.209302_g1283398_i0 | PRJNA704949 | 1298735 | 221 | 1.209302 | 2.67255742 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.93e-12 | NTclustered | gi|325194219|emb|FR825080.1| | 890382 | g1283398 | i0 | 98 | 0.226244343891403 | 50 | 0 | 23 | 1 | 169 | 218 | 1872 | 1824 | Albugo laibachii Nc14, genomic contig CONTIG_1593_NC14_v4_1885_55 | blastn | 50 | 86.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 22368096 | 22368096 | PRJNA704949_P_NODE_1601758_length_192_cov_2.545455_g1586419_i0 | PRJNA704949 | 1601758 | 192 | 2.545455 | 4.8872736 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 9.67e-20 | NTclustered | gi|325194684|emb|FR825494.1| | 890382 | g1586419 | i0 | 78.613 | 83.765625 | 173 | 31 | 89 | 6 | 23 | 192 | 202 | 33 | Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 | blastn | 16083 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii |
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);;