contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418279 | 418279 | PRJNA408129_S_NODE_11161_length_214_cov_29.361582_g11143_i0 | PRJNA408129 | 11161 | 214 | 29.361582 | 62.83378548 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 2.94e-50 | NTclustered | gi|1378171755|ref|XM_024720355.1| | 4781 | g11143 | i0 | 93.056 | 2.27102803738318 | 144 | 10 | 67 | 0 | 46 | 189 | 477 | 334 | Plasmopara halstedii CRN-like protein (PHALS_06969), partial mRNA | blastn | 486 | 211 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 1082755 | 1082755 | PRJNA408129_S_NODE_761_length_408_cov_13.568733_g743_i0 | PRJNA408129 | 761 | 408 | 13.568733 | 55.36043064 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 610 | 5.15e-170 | NTclustered | gi|2651589115|gb|PP108238.1| | 4785 | g743 | i0 | 97.479 | 91.031862745098 | 357 | 9 | 88 | 0 | 22 | 378 | 23130 | 22774 | Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome | blastn | 37141 | 616 | 0.99025974025974 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 8071664 | 8071664 | PRJNA408129_S_NODE_20047_length_179_cov_1.091549_g20029_i0 | PRJNA408129 | 20047 | 179 | 1.091549 | 1.95387271 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 4.19e-8 | NTclustered | gi|2794739894|ref|XM_067964161.1| | 4779 | g20029 | i0 | 85.294 | 0.379888268156425 | 68 | 10 | 38 | 0 | 110 | 177 | 449 | 382 | Bremia lactucae uncharacterized protein (CCR75_006089), partial mRNA | blastn | 68 | 71.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 11897192 | 11897192 | PRJNA408129_S_NODE_14210_length_199_cov_2.320988_g14192_i0 | PRJNA408129 | 14210 | 199 | 2.320988 | 4.61876612 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.75e-35 | NTclustered | gi|673051696|ref|XM_008881587.1| | 157072 | g14192 | i0 | 86.486 | 17.0050251256281 | 148 | 18 | 74 | 2 | 52 | 198 | 615 | 469 | Aphanomyces invadans 40S ribosomal protein mRNA | blastn | 3384 | 161 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 13172244 | 13172244 | PRJNA408129_S_NODE_3471_length_293_cov_21794.503906_g3453_i0 | PRJNA408129 | 3471 | 293 | 21794.503906 | 63857.89644458 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 6.699999999999997e-88 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g3453 | i0 | 97.475 | 29.3617747440273 | 198 | 4 | 67 | 1 | 13 | 209 | 511 | 708 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 8603 | 337 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 15721235 | 15721235 | PRJNA408129_S_NODE_6593_length_248_cov_4.815166_g6575_i0 | PRJNA408129 | 6593 | 248 | 4.815166 | 11.94161168 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 8.93e-111 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g6575 | i0 | 97.908 | 100.379032258065 | 239 | 4 | 96 | 1 | 1 | 239 | 9213 | 9450 | Pythium ultimum mitochondrion, complete genome | blastn | 24894 | 412 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 20208892 | 20208892 | PRJNA408129_S_NODE_1996_length_333_cov_70.577703_g1978_i0 | PRJNA408129 | 1996 | 333 | 70.577703 | 235.02375099 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.53e-149 | NTclustered | gi|440919553|gb|JX436353.1| | 1279233 | g1978 | i0 | 98.071 | 92.981981981982 | 311 | 6 | 93 | 0 | 20 | 330 | 33 | 343 | Myzocytiopsis sp. GPR-2013 28S ribosomal RNA gene, partial sequence | blastn | 30963 | 542 | 1 | Eukaryota | Sar | Oomycota | Myzocytiopsidales | Myzocytiopsidaceae | Myzocytiopsis | Myzocytiopsis sp. GPR-2013 | |||
| 22094859 | 22094859 | PRJNA408129_S_NODE_27658_length_162_cov_2.232000_g27640_i0 | PRJNA408129 | 27658 | 162 | 2.232 | 3.61584 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.73e-6 | NTclustered | gi|673042468|ref|XM_008876973.1| | 157072 | g27640 | i0 | 97.368 | 0.234567901234568 | 38 | 1 | 23 | 0 | 2 | 39 | 653 | 690 | Aphanomyces invadans hypothetical protein mRNA | blastn | 38 | 65.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 25308892 | 25308892 | PRJNA408129_S_NODE_22820_length_171_cov_50.328358_g22802_i0 | PRJNA408129 | 22820 | 171 | 50.328358 | 86.06149218 | Lagenidium | 4802 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.17e-70 | NTclustered | gi|319769386|gb|HQ343198.1| | 884622 | g22802 | i0 | 99.346 | 89.9181286549708 | 153 | 1 | 89 | 0 | 15 | 167 | 544 | 696 | Lagenidium sp. PWL-2010f strain CBS 127284 18S ribosomal RNA gene, partial sequence | blastn | 15376 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium sp. PWL-2010f |
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);;