contig_metadata
16 rows where bioproject = "PRJNA971593", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3494855 | 3494855 | PRJNA971593_P_NODE_16683_length_291_cov_2.431193_g16534_i0 | PRJNA971593 | 16683 | 291 | 2.431193 | 7.07477163 | root | 1 | Root_unresolved | Root_unresolved | 142 | 6.08e-40 | NR | KAI9183615.1 | 1313167 | g16534 | i0 | 80 | 9.72164948453608 | 85 | 17 | 87.6 | 0 | 256 | 2 | 1 | 85 | KAI9183615.1 40S ribosomal protein S4 [Blastocladiella emersonii ATCC 22665] | diamond | 2829 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 4772426 | 4772426 | PRJNA971593_P_NODE_1084_length_1083_cov_10.778218_g988_i0 | PRJNA971593 | 1084 | 1083 | 10.778218 | 116.72810094 | Blastocladiella britannica | 64508 | Fungi | Fungi | 150 | 1.54e-40 | NR | KAI9216354.1 | 64508 | g988 | i0 | 67.9 | 0.606648199445983 | 112 | 32 | 31 | 1 | 83 | 418 | 4 | 111 | KAI9216354.1 ribosomal protein L34e-domain-containing protein [Blastocladiella britannica] | diamond | 657 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 4772707 | 4772707 | PRJNA971593_P_NODE_3584_length_639_cov_1.111307_g3440_i0 | PRJNA971593 | 3584 | 639 | 1.111307 | 7.10125173 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 350 | 6.329999999999997e-119 | NR | KAJ1509686.1 | 945690 | g3440 | i0 | 80.7 | 1.9906103286385 | 212 | 40 | 99.5 | 1 | 3 | 638 | 40 | 250 | KAJ1509686.1 hypothetical protein HMI54_002183 [Coelomomyces lativittatus] | diamond | 1272 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 6047308 | 6047308 | PRJNA971593_P_NODE_13065_length_333_cov_1.776923_g12916_i0 | PRJNA971593 | 13065 | 333 | 1.776923 | 5.91715359 | Eukaryota | 2759 | Fungi | Fungi | 121 | 4.77e-33 | NR | KAI9221418.1 | 64508 | g12916 | i0 | 59.2 | 5.27027027027027 | 98 | 40 | 88.3 | 0 | 20 | 313 | 14 | 111 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1755 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 22621573 | 22621573 | PRJNA971593_P_NODE_9158_length_401_cov_1.524390_g9009_i0 | PRJNA971593 | 9158 | 401 | 1.52439 | 6.1128039 | Blastocladiales | 4805 | Fungi | Fungi | 148 | 1.76e-38 | NR | KNE60106.1 | 578462 | g9009 | i0 | 49.6 | 2.07231920199501 | 139 | 61 | 97.3 | 1 | 1 | 390 | 489 | 627 | KNE60106.1 glutamine-tRNA ligase [Allomyces macrogynus ATCC 38327] | diamond | 831 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 22621581 | 22621581 | PRJNA971593_P_NODE_9738_length_389_cov_1.462025_g9589_i0 | PRJNA971593 | 9738 | 389 | 1.462025 | 5.68727725 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 155 | 2.81e-44 | NR | KAI9137242.1 | 1500003 | g9589 | i0 | 57.4 | 3.9254498714653 | 122 | 51 | 93.3 | 1 | 25 | 387 | 12 | 133 | KAI9137242.1 phosphomannomutase [Paraphysoderma sedebokerense] | diamond | 1527 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 23896612 | 23896612 | PRJNA971593_P_NODE_12319_length_344_cov_1.420664_g12170_i0 | PRJNA971593 | 12319 | 344 | 1.420664 | 4.88708416 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 333 | 1.04e-86 | NTclustered | gi|108949307|gb|DQ533709.1| | 4808 | g12170 | i0 | 87.9 | 78.5174418604651 | 281 | 34 | 82 | 0 | 64 | 344 | 1537 | 1257 | Blastocladiella emersonii propionyl coenzyme A carboxylase mRNA, partial cds | blastn | 27010 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27151934 | 27151934 | PRJNA971593_P_NODE_10542_length_372_cov_4.096990_g10393_i0 | PRJNA971593 | 10542 | 372 | 4.09699 | 15.2408028 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 111 | 1.37e-28 | NR | ORZ39709.1 | 765915 | g10393 | i0 | 49.6 | 3.69354838709677 | 113 | 57 | 91.1 | 0 | 348 | 10 | 6 | 118 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 1374 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27380118 | 27380118 | PRJNA971593_P_NODE_4103_length_597_cov_1.131679_g3959_i0 | PRJNA971593 | 4103 | 597 | 1.131679 | 6.75612363 | Opisthokonta | 33154 | Fungi | Fungi | 94.4 | 1.79e-18 | NR | KAJ3360396.1 | 64505 | g3959 | i0 | 35.4 | 3.48241206030151 | 164 | 90 | 76.4 | 3 | 497 | 42 | 848 | 1007 | KAJ3360396.1 Intracellular distribution of mitochondria [Allomyces javanicus] | diamond | 2079 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 28225861 | 28225861 | PRJNA971593_P_NODE_15346_length_306_cov_1.321888_g15197_i0 | PRJNA971593 | 15346 | 306 | 1.321888 | 4.04497728 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 112 | 2.95e-29 | NR | KAJ1509529.1 | 945690 | g15197 | i0 | 63.2 | 1.70588235294118 | 87 | 32 | 85.3 | 0 | 306 | 46 | 45 | 131 | KAJ1509529.1 60S ribosomal protein L32 [Coelomomyces lativittatus] | diamond | 522 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 28927029 | 28927029 | PRJNA971593_P_NODE_8588_length_414_cov_1.366569_g8439_i0 | PRJNA971593 | 8588 | 414 | 1.366569 | 5.65759566 | Fungi | 4751 | Fungi | Fungi | 147 | 7.71e-38 | NR | KAI9137134.1 | 1500003 | g8439 | i0 | 50.4 | 3.94202898550725 | 133 | 66 | 96.4 | 0 | 412 | 14 | 278 | 410 | KAI9137134.1 armadillo-type protein [Paraphysoderma sedebokerense] | diamond | 1632 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30537750 | 30537750 | PRJNA971593_P_NODE_7913_length_432_cov_2.116992_g7764_i0 | PRJNA971593 | 7913 | 432 | 2.116992 | 9.14540544 | Eukaryota | 2759 | Fungi | Fungi | 127 | 1.22e-31 | NR | KAJ3363532.1 | 64504 | g7764 | i0 | 62.1 | 9.28472222222222 | 95 | 34 | 66 | 1 | 431 | 147 | 352 | 444 | KAJ3363532.1 hypothetical protein GGF31_000942 [Allomyces arbusculus] | diamond | 4011 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 30594551 | 30594551 | PRJNA971593_P_NODE_5893_length_501_cov_1.259346_g5745_i0 | PRJNA971593 | 5893 | 501 | 1.259346 | 6.30932346 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 192 | 9.26e-58 | NR | KAI9150923.1 | 1313167 | g5745 | i0 | 54.2 | 0.994011976047904 | 166 | 76 | 99.4 | 0 | 3 | 500 | 96 | 261 | KAI9150923.1 hypothetical protein H9P43_009538 [Blastocladiella emersonii ATCC 22665] | diamond | 498 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31707313 | 31707313 | PRJNA971593_P_NODE_8757_length_410_cov_1.258160_g8608_i0 | PRJNA971593 | 8757 | 410 | 1.25816 | 5.158456 | Fungi | 4751 | Fungi | Fungi | 127 | 9.059999999999999e-32 | NR | KNE54594.1 | 578462 | g8608 | i0 | 45.2 | 4.99756097560976 | 135 | 73 | 98 | 1 | 407 | 6 | 108 | 242 | KNE54594.1 hypothetical protein AMAG_00559 [Allomyces macrogynus ATCC 38327] | diamond | 2049 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31991990 | 31991990 | PRJNA971593_P_NODE_14958_length_310_cov_1.599156_g14809_i0 | PRJNA971593 | 14958 | 310 | 1.599156 | 4.9573836 | Eukaryota | 2759 | Fungi | Fungi | 140 | 1.63e-36 | NR | KAI9217153.1 | 64508 | g14809 | i0 | 68.6 | 8.83548387096774 | 102 | 31 | 98.7 | 1 | 306 | 1 | 243 | 343 | KAI9217153.1 phosphoglucomutase-like protein 2-like 1 [Blastocladiella britannica] | diamond | 2739 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32112401 | 32112401 | PRJNA971593_P_NODE_6718_length_469_cov_1.944444_g6570_i0 | PRJNA971593 | 6718 | 469 | 1.944444 | 9.11944236 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 112 | 2.46e-28 | NR | ORZ35424.1 | 765915 | g6570 | i0 | 40 | 2.53944562899787 | 135 | 80 | 85.7 | 1 | 457 | 56 | 1 | 135 | ORZ35424.1 hypothetical protein BCR44DRAFT_1434188 [Catenaria anguillulae PL171] | diamond | 1191 | 112 | 1 | 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);;