contig_metadata
17 rows where bioproject = "PRJEB39643" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12811149 | 12811149 | PRJEB39643_P_NODE_152011_length_237_cov_3.536585_g151818_i0 | PRJEB39643 | 152011 | 237 | 3.536585 | 8.38170645 | Allomyces arbusculus | 64504 | Fungi | Fungi | 126 | 5.05e-34 | NR | KAJ3366916.1 | 64504 | g151818 | i0 | 75.6 | 1.9620253164557 | 78 | 19 | 98.7 | 0 | 3 | 236 | 2 | 79 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 465 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 13742765 | 13742765 | PRJEB39643_P_NODE_11031_length_585_cov_4.210938_g10845_i0 | PRJEB39643 | 11031 | 585 | 4.210938 | 24.6339873 | Allomyces arbusculus | 64504 | Fungi | Fungi | 278 | 7.18e-92 | NR | KAJ3366916.1 | 64504 | g10845 | i0 | 73.3 | 0.979487179487179 | 191 | 51 | 97.9 | 0 | 7 | 579 | 1 | 191 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 573 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 16292306 | 16292306 | PRJEB39643_P_NODE_8393_length_695_cov_3.757235_g8218_i0 | PRJEB39643 | 8393 | 695 | 3.757235 | 26.11278325 | Blastocladiomycota | 451459 | Fungi | Fungi | 215 | 1.46e-62 | NR | KAJ1516774.1 | 945690 | g8218 | i0 | 67.5 | 3.92374100719424 | 200 | 55 | 86.3 | 2 | 693 | 94 | 407 | 596 | KAJ1516774.1 70-kilodalton heat shock protein [Coelomomyces lativittatus] | diamond | 2727 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26685058 | 26685058 | PRJEB39643_P_NODE_14561_length_489_cov_5.447115_g14370_i0 | PRJEB39643 | 14561 | 489 | 5.447115 | 26.63639235 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 139 | 5.85e-39 | NR | KAI9159512.1 | 1313167 | g14370 | i0 | 54.7 | 2.42944785276074 | 148 | 60 | 87.7 | 2 | 487 | 59 | 2 | 147 | KAI9159512.1 60S ribosomal protein L24 [Blastocladiella emersonii ATCC 22665] | diamond | 1188 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27475839 | 27475839 | PRJEB39643_P_NODE_81703_length_270_cov_1.563452_g81510_i0 | PRJEB39643 | 81703 | 270 | 1.563452 | 4.2213204 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 68.6 | 4.51e-11 | NR | KAI9144507.1 | 1500003 | g81510 | i0 | 40.7 | 0.955555555555556 | 86 | 49 | 95.6 | 1 | 267 | 10 | 1689 | 1772 | KAI9144507.1 hypothetical protein BKA69DRAFT_1122349 [Paraphysoderma sedebokerense] | diamond | 258 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 27910983 | 27910983 | PRJEB39643_P_NODE_36625_length_309_cov_2.338983_g36432_i0 | PRJEB39643 | 36625 | 309 | 2.338983 | 7.22745747 | Allomyces | 28581 | Fungi | Fungi | 103 | 7.22e-25 | NR | KAJ3365375.1 | 64504 | g36432 | i0 | 47 | 2.9126213592233 | 100 | 52 | 96.1 | 1 | 299 | 3 | 117 | 216 | KAJ3365375.1 cofilin [Allomyces arbusculus] | diamond | 900 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 28423212 | 28423212 | PRJEB39643_P_NODE_28646_length_343_cov_4.196296_g28453_i0 | PRJEB39643 | 28646 | 343 | 4.196296 | 14.39329528 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 114 | 2.23e-28 | NR | KAI9143793.1 | 1500003 | g28453 | i0 | 56.1 | 0.935860058309038 | 107 | 46 | 93.6 | 1 | 21 | 341 | 7 | 112 | KAI9143793.1 Endoribonuclease XendoU [Paraphysoderma sedebokerense] | diamond | 321 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29054641 | 29054641 | PRJEB39643_P_NODE_140868_length_244_cov_1.801170_g140675_i0 | PRJEB39643 | 140868 | 244 | 1.80117 | 4.3948548 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 97.1 | 5.33e-24 | NR | KAI9141997.1 | 1500003 | g140675 | i0 | 75.4 | 1.40163934426229 | 57 | 14 | 70.1 | 0 | 243 | 73 | 52 | 108 | KAI9141997.1 cytochrome c [Paraphysoderma sedebokerense] | diamond | 342 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29875570 | 29875570 | PRJEB39643_P_NODE_70591_length_275_cov_1.524752_g70398_i0 | PRJEB39643 | 70591 | 275 | 1.524752 | 4.193068 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 77.4 | 3.52e-14 | NR | KAI9145186.1 | 1500003 | g70398 | i0 | 44.2 | 3.85090909090909 | 86 | 45 | 92.7 | 2 | 5 | 259 | 15 | 98 | KAI9145186.1 phosphatidylserine decarboxylase-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1059 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29938734 | 29938734 | PRJEB39643_P_NODE_20331_length_404_cov_6.906344_g20138_i0 | PRJEB39643 | 20331 | 404 | 6.906344 | 27.90162976 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 137 | 2.21e-38 | NR | ORZ37379.1 | 765915 | g20138 | i0 | 69 | 4.45544554455446 | 100 | 31 | 74.3 | 0 | 3 | 302 | 14 | 113 | ORZ37379.1 ribosomal protein L24e-domain-containing protein [Catenaria anguillulae PL171] | diamond | 1800 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30184695 | 30184695 | PRJEB39643_P_NODE_15852_length_464_cov_1.969309_g15660_i0 | PRJEB39643 | 15852 | 464 | 1.969309 | 9.13759376 | Fungi | 4751 | Fungi | Fungi | 114 | 1.18e-26 | NR | KAJ1500810.1 | 945690 | g15660 | i0 | 53.8 | 3.05818965517241 | 93 | 43 | 60.1 | 0 | 442 | 164 | 199 | 291 | KAJ1500810.1 Sphingolipid delta(4)-desaturase DES1 [Coelomomyces lativittatus] | diamond | 1419 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30879798 | 30879798 | PRJEB39643_P_NODE_153714_length_232_cov_2.905660_g153521_i0 | PRJEB39643 | 153714 | 232 | 2.90566 | 6.7411312 | Fungi | 4751 | Fungi | Fungi | 45.8 | 0.00266 | NR | KNE66356.1 | 578462 | g153521 | i0 | 30.3 | 8.56034482758621 | 76 | 37 | 98.3 | 1 | 4 | 231 | 128 | 187 | KNE66356.1 hypothetical protein AMAG_11499 [Allomyces macrogynus ATCC 38327] | diamond | 1986 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31733345 | 31733345 | PRJEB39643_P_NODE_23117_length_379_cov_2.313725_g22924_i0 | PRJEB39643 | 23117 | 379 | 2.313725 | 8.76901775 | Allomyces | 28581 | Fungi | Fungi | 75.9 | 4.4e-13 | NR | KAJ3366379.1 | 64505 | g22924 | i0 | 46.2 | 4.35356200527704 | 91 | 45 | 71.2 | 2 | 348 | 79 | 395 | 482 | KAJ3366379.1 Protein phosphatase PP2A regulatory subunit B [Allomyces javanicus] | diamond | 1650 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 31739988 | 31739988 | PRJEB39643_P_NODE_51357_length_285_cov_1.452830_g51164_i0 | PRJEB39643 | 51357 | 285 | 1.45283 | 4.1405655 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 48.1 | 7.69e-4 | NR | KAI9183659.1 | 1313167 | g51164 | i0 | 64.7 | 1.52631578947368 | 34 | 12 | 35.8 | 0 | 184 | 285 | 109 | 142 | KAI9183659.1 DnaJ-like protein [Blastocladiella emersonii ATCC 22665] | diamond | 435 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31828210 | 31828210 | PRJEB39643_P_NODE_145477_length_242_cov_3.644970_g145284_i0 | PRJEB39643 | 145477 | 242 | 3.64497 | 8.8208274 | Eukaryota | 2759 | Fungi | Fungi | 139 | 3.21e-40 | NR | ORZ32866.1 | 765915 | g145284 | i0 | 72.2 | 3.9297520661157 | 79 | 22 | 97.9 | 0 | 238 | 2 | 4 | 82 | ORZ32866.1 ubiquitin-conjugating enzyme/RWD-like protein [Catenaria anguillulae PL171] | diamond | 951 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32625617 | 32625617 | PRJEB39643_P_NODE_159000_length_210_cov_6.744526_g158806_i0 | PRJEB39643 | 159000 | 210 | 6.744526 | 14.1635046 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 43.5 | 0.0121 | NR | KNE61625.1 | 578462 | g158806 | i0 | 45.5 | 0.628571428571429 | 44 | 24 | 62.9 | 0 | 204 | 73 | 91 | 134 | KNE61625.1 hypothetical protein AMAG_06435 [Allomyces macrogynus ATCC 38327] | diamond | 132 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32745197 | 32745197 | PRJEB39643_P_NODE_39020_length_300_cov_2.713656_g38827_i0 | PRJEB39643 | 39020 | 300 | 2.713656 | 8.140968 | Fungi | 4751 | Fungi | Fungi | 111 | 1.42e-27 | NR | ORZ33908.1 | 765915 | g38827 | i0 | 57.4 | 13.21 | 94 | 40 | 94 | 0 | 2 | 283 | 3 | 96 | ORZ33908.1 galactose-binding domain-like protein [Catenaria anguillulae PL171] | diamond | 3963 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;