contig_metadata
11 rows where bioproject = "PRJNA685060", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8319227 | 8319227 | PRJNA685060_P_NODE_10867_length_285_cov_1.452830_g10777_i0 | PRJNA685060 | 10867 | 285 | 1.45283 | 4.1405655 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 5.2e-41 | NR | RHY19608.1 | 112090 | g10777 | i0 | 68.1 | 6.92631578947368 | 94 | 30 | 98.9 | 0 | 284 | 3 | 175 | 268 | RHY19608.1 hypothetical protein DYB25_003243 [Aphanomyces astaci] | diamond | 1974 | 150 | 0.993333333333333 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 9594755 | 9594755 | PRJNA685060_P_NODE_15808_length_245_cov_0.895349_g15718_i0 | PRJNA685060 | 15808 | 245 | 0.895349 | 2.19360505 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.26e-39 | NTclustered | gi|695382201|ref|XM_009519030.1| | 67593 | g15718 | i0 | 82.99 | 13.665306122449 | 194 | 33 | 79 | 0 | 52 | 245 | 289 | 96 | Phytophthora sojae hypothetical protein mRNA | blastn | 3348 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10104661 | 10104661 | PRJNA685060_P_NODE_10428_length_292_cov_0.867580_g10338_i0 | PRJNA685060 | 10428 | 292 | 0.86758 | 2.5333336 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 3.37e-9 | NR | RHY78209.1 | 112090 | g10338 | i0 | 72.7 | 11.6506849315068 | 44 | 10 | 45.2 | 1 | 160 | 291 | 1221 | 1262 | RHY78209.1 hypothetical protein DYB38_002210 [Aphanomyces astaci] | diamond | 3402 | 63.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 14695103 | 14695103 | PRJNA685060_P_NODE_1392_length_843_cov_1.928571_g1316_i0 | PRJNA685060 | 1392 | 843 | 1.928571 | 16.25785353 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 3.44e-5 | NR | KAH9113010.1 | 100861 | g1316 | i0 | 26.7 | 0.839857651245552 | 236 | 145 | 76.2 | 10 | 842 | 201 | 637 | 866 | KAH9113010.1 hypothetical protein AeMF1_012740 [Aphanomyces euteiches] | diamond | 708 | 57.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 26650446 | 26650446 | PRJNA685060_P_NODE_13681_length_250_cov_1.525424_g13591_i0 | PRJNA685060 | 13681 | 250 | 1.525424 | 3.81356 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 3.77e-11 | NR | XP_008880552.1 | 157072 | g13591 | i0 | 70 | 4.2 | 50 | 14 | 60 | 1 | 248 | 99 | 3 | 51 | XP_008880552.1 hypothetical protein H310_14464 [Aphanomyces invadans] | diamond | 1050 | 63.5 | 0.995275590551181 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 26829168 | 26829168 | PRJNA685060_P_NODE_11961_length_269_cov_1.571429_g11871_i0 | PRJNA685060 | 11961 | 269 | 1.571429 | 4.22714401 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.048 | NR | KAH9163861.1 | 100861 | g11871 | i0 | 29.4 | 0.758364312267658 | 68 | 47 | 75.8 | 1 | 60 | 263 | 171 | 237 | KAH9163861.1 hypothetical protein LEN26_000308 [Aphanomyces euteiches] | diamond | 204 | 42.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27346852 | 27346852 | PRJNA685060_P_NODE_10343_length_293_cov_1.400000_g10253_i0 | PRJNA685060 | 10343 | 293 | 1.4 | 4.102 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0329 | NR | CCI49469.1 | 65357 | g10253 | i0 | 41.1 | 0.921501706484642 | 56 | 31 | 55.3 | 1 | 170 | 9 | 96 | 151 | CCI49469.1 unnamed protein product [Albugo candida] | diamond | 270 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 27662627 | 27662627 | PRJNA685060_P_NODE_9004_length_316_cov_1.753086_g8914_i0 | PRJNA685060 | 9004 | 316 | 1.753086 | 5.53975176 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 4.99e-39 | NR | TMW69171.1 | 41045 | g8914 | i0 | 63.8 | 6.96835443037975 | 105 | 38 | 99.7 | 0 | 315 | 1 | 208 | 312 | TMW69171.1 hypothetical protein Poli38472_001327 [Pythium oligandrum] | diamond | 2202 | 147 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30619248 | 30619248 | PRJNA685060_P_NODE_4873_length_437_cov_2.486264_g4783_i0 | PRJNA685060 | 4873 | 437 | 2.486264 | 10.86497368 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.21e-15 | NR | KAI9906613.1 | 230839 | g4783 | i0 | 59.1 | 4.40045766590389 | 115 | 43 | 78.9 | 1 | 83 | 427 | 1 | 111 | KAI9906613.1 hypothetical protein PsorP6_016508 [Peronosclerospora sorghi] | diamond | 1923 | 77.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 31073343 | 31073343 | PRJNA685060_P_NODE_7455_length_349_cov_1.112319_g7365_i0 | PRJNA685060 | 7455 | 349 | 1.112319 | 3.88199331 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 4.94e-16 | NR | KAF0720512.1 | 120398 | g7365 | i0 | 59.3 | 2.93123209169054 | 113 | 44 | 97.1 | 1 | 346 | 8 | 272 | 382 | KAF0720512.1 hypothetical protein As57867_000231 [Aphanomyces stellatus] | diamond | 1023 | 83.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 31673947 | 31673947 | PRJNA685060_P_NODE_6117_length_387_cov_1.535032_g6027_i0 | PRJNA685060 | 6117 | 387 | 1.535032 | 5.94057384 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 4.16e-33 | NR | OQR88439.1 | 74557 | g6027 | i0 | 55.5 | 9.15503875968992 | 119 | 53 | 92.2 | 0 | 372 | 16 | 476 | 594 | OQR88439.1 glutamine-dependent NAD(+) synthetase [Thraustotheca clavata] | diamond | 3543 | 134 | 0.992537313432836 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;