contig_metadata
12 rows where bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3119152 | 3119152 | PRJNA596870_P_NODE_14683_length_340_cov_2.018727_g14550_i0 | PRJNA596870 | 14683 | 340 | 2.018727 | 6.8636718 | root | 1 | Root_unresolved | Root_unresolved | 162 | 1.2899999999999999e-43 | NR | KAG6973752.1 | 29920 | g14550 | i0 | 72.6 | 94.7294117647059 | 113 | 30 | 98.8 | 1 | 1 | 336 | 257 | 369 | KAG6973752.1 hypothetical protein JG687_00000716 [Phytophthora cactorum] | diamond | 32208 | 163 | 0.993865030674847 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 8793289 | 8793289 | PRJNA596870_P_NODE_22727_length_283_cov_1.247619_g22594_i0 | PRJNA596870 | 22727 | 283 | 1.247619 | 3.53076177 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.929999999999999e-101 | NTclustered | gi|698822380|ref|XM_009845917.1| | 112090 | g22594 | i0 | 91.103 | 60.3533568904594 | 281 | 25 | 99 | 0 | 1 | 281 | 160 | 440 | Aphanomyces astaci hypothetical protein mRNA | blastn | 17080 | 381 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18991991 | 18991991 | PRJNA596870_P_NODE_6815_length_471_cov_0.967337_g6682_i0 | PRJNA596870 | 6815 | 471 | 0.967337 | 4.55615727 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 1.92e-75 | NTclustered | gi|2795032738|ref|XM_067933181.1| | 4785 | g6682 | i0 | 82.456 | 78.791932059448 | 342 | 57 | 73 | 2 | 24 | 365 | 991 | 653 | Phytophthora cinnamomi Electron transfer flavoprotein subunit alpha, mitochondrial precursor (IUM83_08787), partial mRNA | blastn | 37111 | 296 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 23520523 | 23520523 | PRJNA596870_P_NODE_13779_length_349_cov_1.394928_g13646_i0 | PRJNA596870 | 13779 | 349 | 1.394928 | 4.86829872 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 9.66e-60 | NR | TMW57100.1 | 41045 | g13646 | i0 | 80.2 | 4.96848137535817 | 116 | 23 | 99.7 | 0 | 348 | 1 | 222 | 337 | TMW57100.1 hypothetical protein Poli38472_003025 [Pythium oligandrum] | diamond | 1734 | 197 | 0.99492385786802 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 26604757 | 26604757 | PRJNA596870_P_NODE_22901_length_282_cov_1.392344_g22768_i0 | PRJNA596870 | 22901 | 282 | 1.392344 | 3.92641008 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 2.02e-14 | NR | TYZ68600.1 | 1485010 | g22768 | i0 | 47.6 | 0.893617021276596 | 84 | 42 | 87.2 | 1 | 13 | 258 | 4 | 87 | TYZ68600.1 hypothetical protein PybrP1_005498 [[Pythium] brassicae (nom. inval.)] | diamond | 252 | 78.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 26649837 | 26649837 | PRJNA596870_P_NODE_35521_length_245_cov_0.895349_g35388_i0 | PRJNA596870 | 35521 | 245 | 0.895349 | 2.19360505 | Globisporangium | 1448052 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 4.15e-16 | NR | KAF1323743.1 | 82926 | g35388 | i0 | 48.7 | 5.70612244897959 | 78 | 36 | 95.5 | 1 | 245 | 12 | 34 | 107 | KAF1323743.1 Thioredoxin/protein disulfide isomerase, partial [Globisporangium splendens] | diamond | 1398 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 27585329 | 27585329 | PRJNA596870_P_NODE_33844_length_247_cov_0.885057_g33711_i0 | PRJNA596870 | 33844 | 247 | 0.885057 | 2.18609079 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 8.46e-36 | NR | KAG9411200.1 | 112091 | g33711 | i0 | 78 | 0.995951417004049 | 82 | 16 | 97.2 | 2 | 241 | 2 | 2 | 83 | KAG9411200.1 Sulfhydryl oxidase 1 [Aphanomyces cochlioides] | diamond | 246 | 136 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 29619061 | 29619061 | PRJNA596870_P_NODE_38570_length_242_cov_0.911243_g38437_i0 | PRJNA596870 | 38570 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 5.19e-17 | NR | KAJ0411300.1 | 114742 | g38437 | i0 | 58.5 | 8.02066115702479 | 65 | 27 | 80.6 | 0 | 203 | 9 | 4 | 68 | KAJ0411300.1 hypothetical protein ATCC90586_005709 [Pythium insidiosum] | diamond | 1941 | 80.1 | 0.995006242197254 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30333065 | 30333065 | PRJNA596870_P_NODE_12632_length_362_cov_1.065744_g12499_i0 | PRJNA596870 | 12632 | 362 | 1.065744 | 3.85799328 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 8.04e-44 | NR | TMW56654.1 | 41045 | g12499 | i0 | 64.3 | 1.9060773480663 | 115 | 41 | 95.3 | 0 | 15 | 359 | 29 | 143 | TMW56654.1 hypothetical protein Poli38472_006664 [Pythium oligandrum] | diamond | 690 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31628408 | 31628408 | PRJNA596870_P_NODE_23836_length_277_cov_1.509804_g23703_i0 | PRJNA596870 | 23836 | 277 | 1.509804 | 4.18215708 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00924 | NR | KAH9096795.1 | 100861 | g23703 | i0 | 37.7 | 1.24548736462094 | 53 | 32 | 56.3 | 1 | 185 | 30 | 136 | 188 | KAH9096795.1 hypothetical protein LEN26_017312 [Aphanomyces euteiches] | diamond | 345 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32134735 | 32134735 | PRJNA596870_P_NODE_29138_length_251_cov_0.865169_g29005_i0 | PRJNA596870 | 29138 | 251 | 0.865169 | 2.17157419 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 1.33e-9 | NR | RHZ42841.1 | 112090 | g29005 | i0 | 44.1 | 1.41035856573705 | 59 | 33 | 70.5 | 0 | 48 | 224 | 61 | 119 | RHZ42841.1 hypothetical protein DYB26_008897 [Aphanomyces astaci] | diamond | 354 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32829490 | 32829490 | PRJNA596870_P_NODE_31900_length_249_cov_0.875000_g31767_i0 | PRJNA596870 | 31900 | 249 | 0.875 | 2.17875 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.98e-33 | NR | KAF0727801.1 | 100861 | g31767 | i0 | 78.8 | 2.91566265060241 | 80 | 17 | 96.4 | 0 | 243 | 4 | 1 | 80 | KAF0727801.1 hypothetical protein Ae201684_014237 [Aphanomyces euteiches] | diamond | 726 | 126 | 1 | 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);;