contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13397150 | 13397150 | PRJNA674048_P_NODE_14491_length_236_cov_1.668449_g14288_i0 | PRJNA674048 | 14491 | 236 | 1.668449 | 3.93753964 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 5.5e-26 | NR | TMW60420.1 | 41045 | g14288 | i0 | 69.6 | 3 | 79 | 23 | 99.2 | 1 | 236 | 3 | 120 | 198 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 708 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 15194448 | 15194448 | PRJNA674048_P_NODE_14432_length_236_cov_4.213904_g14229_i0 | PRJNA674048 | 14432 | 236 | 4.213904 | 9.94481344 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.21e-32 | NR | KAF0743747.1 | 100861 | g14229 | i0 | 70.5 | 21.7881355932203 | 78 | 23 | 99.2 | 0 | 236 | 3 | 1 | 78 | KAF0743747.1 hypothetical protein Ae201684_001401 [Aphanomyces euteiches] | diamond | 5142 | 119 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 26669941 | 26669941 | PRJNA674048_P_NODE_28821_length_167_cov_0.881356_g28618_i0 | PRJNA674048 | 28821 | 167 | 0.881356 | 1.47186452 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.2e-20 | NR | OQR98052.1 | 1202772 | g28618 | i0 | 74.1 | 2.94610778443114 | 54 | 14 | 97 | 0 | 4 | 165 | 138 | 191 | OQR98052.1 alanyl-tRNA synthetase, mitochondrial precursor [Achlya hypogyna] | diamond | 492 | 94 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 27555479 | 27555479 | PRJNA674048_P_NODE_25984_length_172_cov_1.650407_g25781_i0 | PRJNA674048 | 25984 | 172 | 1.650407 | 2.83870004 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.74e-12 | NR | GMF45174.1 | 1490495 | g25781 | i0 | 82.5 | 3.62790697674419 | 40 | 7 | 69.8 | 0 | 171 | 52 | 123 | 162 | GMF45174.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 624 | 68.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 28029421 | 28029421 | PRJNA674048_P_NODE_14125_length_240_cov_0.984293_g13922_i0 | PRJNA674048 | 14125 | 240 | 0.984293 | 2.3623032 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.36e-7 | NR | KAF0697660.1 | 120398 | g13922 | i0 | 45.3 | 3.1875 | 64 | 34 | 80 | 1 | 1 | 192 | 122 | 184 | KAF0697660.1 hypothetical protein As57867_011637 [Aphanomyces stellatus] | diamond | 765 | 57 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 28281694 | 28281694 | PRJNA674048_P_NODE_27666_length_168_cov_1.016807_g27463_i0 | PRJNA674048 | 27666 | 168 | 1.016807 | 1.70823576 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 9.32e-17 | NR | CCA25446.1 | 890382 | g27463 | i0 | 74.5 | 3.92857142857143 | 55 | 14 | 98.2 | 0 | 167 | 3 | 317 | 371 | CCA25446.1 palmitoyltransferase putative [Albugo laibachii Nc14] | diamond | 660 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 28451851 | 28451851 | PRJNA674048_P_NODE_19586_length_199_cov_3.393333_g19383_i0 | PRJNA674048 | 19586 | 199 | 3.393333 | 6.75273267 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 3.85e-18 | NR | TMW60811.1 | 41045 | g19383 | i0 | 59.4 | 4.82412060301507 | 64 | 26 | 96.5 | 0 | 2 | 193 | 491 | 554 | TMW60811.1 hypothetical protein Poli38472_000853 [Pythium oligandrum] | diamond | 960 | 87.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28514887 | 28514887 | PRJNA674048_P_NODE_10807_length_284_cov_1.991489_g10604_i0 | PRJNA674048 | 10807 | 284 | 1.991489 | 5.65582876 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.21e-30 | NR | KAJ8524041.1 | 4785 | g10604 | i0 | 59.4 | 4.03521126760563 | 96 | 36 | 99.3 | 2 | 282 | 1 | 24 | 118 | KAJ8524041.1 hypothetical protein ON010_g17076 [Phytophthora cinnamomi] | diamond | 1146 | 115 | 0.991304347826087 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29493648 | 29493648 | PRJNA674048_P_NODE_30790_length_164_cov_0.904348_g30587_i0 | PRJNA674048 | 30790 | 164 | 0.904348 | 1.48313072 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.18e-7 | NR | KAG9408090.1 | 112091 | g30587 | i0 | 52.5 | 3.09146341463415 | 40 | 19 | 73.2 | 0 | 1 | 120 | 559 | 598 | KAG9408090.1 hypothetical protein AC1031_021324 [Aphanomyces cochlioides] | diamond | 507 | 57 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 30156607 | 30156607 | PRJNA674048_P_NODE_27332_length_169_cov_0.866667_g27129_i0 | PRJNA674048 | 27332 | 169 | 0.866667 | 1.46466723 | root | 1 | Root_unresolved | Root_unresolved | 62.8 | 1.18e-9 | NR | XP_067814863.1 | 4779 | g27129 | i0 | 49.1 | 12.0532544378698 | 57 | 28 | 99.4 | 1 | 2 | 169 | 712 | 768 | XP_067814863.1 hypothetical protein CCR75_002995 [Bremia lactucae] | diamond | 2037 | 63.2 | 0.993670886075949 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30239759 | 30239759 | PRJNA674048_P_NODE_30392_length_165_cov_0.896552_g30189_i0 | PRJNA674048 | 30392 | 165 | 0.896552 | 1.4793108 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 1.26e-9 | NR | TYZ62043.1 | 1485010 | g30189 | i0 | 54.7 | 0.963636363636364 | 53 | 24 | 96.4 | 0 | 7 | 165 | 189 | 241 | TYZ62043.1 hypothetical protein PybrP1_004634, partial [[Pythium] brassicae (nom. inval.)] | diamond | 159 | 62 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31357763 | 31357763 | PRJNA674048_P_NODE_31596_length_163_cov_0.912281_g31393_i0 | PRJNA674048 | 31596 | 163 | 0.912281 | 1.48701803 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 4.41e-8 | NR | KAH9141002.1 | 100861 | g31393 | i0 | 51.9 | 9.57055214723926 | 52 | 25 | 95.7 | 0 | 158 | 3 | 245 | 296 | KAH9141002.1 hypothetical protein AeRB84_014796 [Aphanomyces euteiches] | diamond | 1560 | 58.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31420906 | 31420906 | PRJNA674048_P_NODE_20616_length_194_cov_1.400000_g20413_i0 | PRJNA674048 | 20616 | 194 | 1.4 | 2.716 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 3.03e-6 | NR | TMW67882.1 | 41045 | g20413 | i0 | 41.7 | 11.9536082474227 | 60 | 34 | 92.8 | 1 | 192 | 13 | 60 | 118 | TMW67882.1 hypothetical protein Poli38472_007554 [Pythium oligandrum] | diamond | 2319 | 53.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31535726 | 31535726 | PRJNA674048_P_NODE_27216_length_169_cov_0.866667_g27013_i0 | PRJNA674048 | 27216 | 169 | 0.866667 | 1.46466723 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 1.92e-8 | NR | KAL0582063.1 | 65357 | g27013 | i0 | 50 | 0.994082840236686 | 56 | 28 | 99.4 | 0 | 2 | 169 | 89 | 144 | KAL0582063.1 hypothetical protein ABG067_008326, partial [Albugo candida] | diamond | 168 | 57.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31851661 | 31851661 | PRJNA674048_P_NODE_17457_length_212_cov_2.460123_g17254_i0 | PRJNA674048 | 17457 | 212 | 2.460123 | 5.21546076 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 2.79e-14 | NR | OQR90306.1 | 1202772 | g17254 | i0 | 78.4 | 0.721698113207547 | 51 | 10 | 72.2 | 1 | 3 | 155 | 569 | 618 | OQR90306.1 polyadenylate-binding protein 1-B [Achlya hypogyna] | diamond | 153 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 31926978 | 31926978 | PRJNA674048_P_NODE_21197_length_191_cov_1.464789_g20994_i0 | PRJNA674048 | 21197 | 191 | 1.464789 | 2.79774699 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 3.58e-5 | NR | XP_002999084.1 | 403677 | g20994 | i0 | 46.3 | 1.61780104712042 | 54 | 29 | 84.8 | 0 | 162 | 1 | 798 | 851 | XP_002999084.1 uncharacterized protein PITG_05441 [Phytophthora infestans T30-4] | diamond | 309 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32516496 | 32516496 | PRJNA674048_P_NODE_29819_length_165_cov_1.793103_g29616_i0 | PRJNA674048 | 29819 | 165 | 1.793103 | 2.95861995 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 1.27e-13 | NR | XP_012202126.1 | 695850 | g29616 | i0 | 61.8 | 18 | 55 | 21 | 100 | 0 | 1 | 165 | 216 | 270 | XP_012202126.1 hypothetical protein SPRG_07742 [Saprolegnia parasitica CBS 223.65] | diamond | 2970 | 73.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 32591484 | 32591484 | PRJNA674048_P_NODE_26799_length_169_cov_1.733333_g26596_i0 | PRJNA674048 | 26799 | 169 | 1.733333 | 2.92933277 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 8.12e-20 | NR | KAF0736723.1 | 100861 | g26596 | i0 | 74.5 | 10.5976331360947 | 55 | 14 | 97.6 | 0 | 5 | 169 | 610 | 664 | KAF0736723.1 hypothetical protein Ae201684_007170 [Aphanomyces euteiches] | diamond | 1791 | 92.4 | 0.992424242424242 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;