contig_metadata
11 rows where bioproject = "PRJNA724039", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3262333 | 3262333 | PRJNA724039_S_NODE_10983_length_195_cov_0.987342_g10776_i0 | PRJNA724039 | 10983 | 195 | 0.987342 | 1.9253169 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.26e-28 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g10776 | i0 | 85.401 | 68.2 | 137 | 16 | 69 | 4 | 35 | 169 | 41659 | 41793 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 13299 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 7090014 | 7090014 | PRJNA724039_S_NODE_7426_length_245_cov_3.745192_g7219_i0 | PRJNA724039 | 7426 | 245 | 3.745192 | 9.1757204 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.65e-19 | NTclustered | gi|2431515601|ref|NC_070108.1| | 230839 | g7219 | i0 | 80.282 | 61.3632653061225 | 142 | 28 | 58 | 0 | 54 | 195 | 2157 | 2016 | Peronosclerospora sorghi isolate P6 mitochondrion, complete genome | blastn | 15034 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 8364579 | 8364579 | PRJNA724039_S_NODE_8007_length_234_cov_3.629442_g7800_i0 | PRJNA724039 | 8007 | 234 | 3.629442 | 8.49289428 | Phytophthora sp. ML-2023a | 3044284 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.62e-28 | NTclustered | gi|2500404807|gb|OQ735416.1| | 3044284 | g7800 | i0 | 82.609 | 3.27350427350427 | 161 | 23 | 67 | 5 | 38 | 194 | 5943 | 6102 | Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome | blastn | 766 | 137 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. ML-2023a | ||
| 14740082 | 14740082 | PRJNA724039_S_NODE_10272_length_202_cov_3.472727_g10065_i0 | PRJNA724039 | 10272 | 202 | 3.472727 | 7.01490854 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.97e-26 | NR | DBA04875.1 | 4803 | g10065 | i0 | 71.2 | 8.82178217821782 | 66 | 19 | 98 | 0 | 198 | 1 | 17 | 82 | DBA04875.1 TPA: hypothetical protein N0F65_006877 [Lagenidium giganteum] | diamond | 1782 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 23664301 | 23664301 | PRJNA724039_S_NODE_8119_length_232_cov_5.317949_g7912_i0 | PRJNA724039 | 8119 | 232 | 5.317949 | 12.33764168 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.56e-23 | NTclustered | gi|269812125|gb|GU138663.1| | 2052682 | g7912 | i0 | 76.923 | 16.4137931034483 | 234 | 42 | 98 | 10 | 1 | 228 | 34664 | 34891 | Pythium ultimum culture-collection CBS:398.51 mitochondrion, complete genome | blastn | 3808 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 24145750 | 24145750 | PRJNA724039_S_NODE_8659_length_223_cov_4.225806_g8452_i0 | PRJNA724039 | 8659 | 223 | 4.225806 | 9.42354738 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.4900000000000004e-21 | NTclustered | gi|58202010|gb|AY898628.1| | 4787 | g8452 | i0 | 91.765 | 39.2511210762332 | 85 | 4 | 38 | 3 | 2 | 85 | 2385 | 2467 | Phytophthora infestans haplotype IIb mitochondrion, complete genome | blastn | 8753 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 24937768 | 24937768 | PRJNA724039_S_NODE_7220_length_250_cov_1.737089_g7013_i0 | PRJNA724039 | 7220 | 250 | 1.737089 | 4.3427225 | Synchrospora medusiformis | 3033745 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.62e-58 | NTclustered | gi|2499019046|gb|OQ605381.1| | 3033745 | g7013 | i0 | 84 | 98.512 | 250 | 38 | 99 | 2 | 1 | 249 | 573 | 325 | Synchrospora medusiformis isolate PA228 beta-tubulin (btub) gene, partial cds | blastn | 24628 | 239 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Synchrospora | Synchrospora medusiformis | ||
| 29672910 | 29672910 | PRJNA724039_S_NODE_16170_length_158_cov_3.487603_g15963_i0 | PRJNA724039 | 16170 | 158 | 3.487603 | 5.51041274 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 1.8e-21 | NR | TYZ63444.1 | 1485010 | g15963 | i0 | 74.5 | 2.67721518987342 | 47 | 12 | 89.2 | 0 | 3 | 143 | 101 | 147 | TYZ63444.1 hypothetical protein PybrP1_007303 [[Pythium] brassicae (nom. inval.)] | diamond | 423 | 90.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31073708 | 31073708 | PRJNA724039_S_NODE_15935_length_160_cov_1.178862_g15728_i0 | PRJNA724039 | 15935 | 160 | 1.178862 | 1.8861792 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 5.49e-10 | NR | KAI9917785.1 | 230839 | g15728 | i0 | 61.8 | 2.0625 | 55 | 18 | 97.5 | 2 | 5 | 160 | 17 | 71 | KAI9917785.1 hypothetical protein PsorP6_012390 [Peronosclerospora sorghi] | diamond | 330 | 62.4 | 0.993589743589744 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 32275762 | 32275762 | PRJNA724039_S_NODE_2098_length_529_cov_2.292683_g1902_i0 | PRJNA724039 | 2098 | 529 | 2.292683 | 12.12829307 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 1.22e-45 | NR | KAH9082828.1 | 100861 | g1902 | i0 | 64.5 | 12.6238185255198 | 124 | 44 | 70.3 | 0 | 529 | 158 | 139 | 262 | KAH9082828.1 hypothetical protein LEN26_021124 [Aphanomyces euteiches] | diamond | 6678 | 160 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32560606 | 32560606 | PRJNA724039_S_NODE_4339_length_340_cov_2.577558_g4132_i0 | PRJNA724039 | 4339 | 340 | 2.577558 | 8.7636972 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.51e-28 | NR | DBA01302.1 | 4803 | g4132 | i0 | 53.5 | 8.82352941176471 | 101 | 41 | 84.7 | 2 | 340 | 53 | 83 | 182 | DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum] | diamond | 3000 | 112 | 0.991071428571429 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;