contig_metadata
8 rows where bioproject = "PRJNA893346", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13622156 | 13622156 | PRJNA893346_P_NODE_36771_length_246_cov_0.890173_g36281_i0 | PRJNA893346 | 36771 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | Fungi | Fungi | 115 | 3.12e-28 | NR | KAI9183058.1 | 1313167 | g36281 | i0 | 85.7 | 5.02439024390244 | 63 | 9 | 76.8 | 0 | 192 | 4 | 3 | 65 | KAI9183058.1 centromere/microtubule-binding protein cbf5 [Blastocladiella emersonii ATCC 22665] | diamond | 1236 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 14896561 | 14896561 | PRJNA893346_P_NODE_6272_length_644_cov_1.486865_g5806_i0 | PRJNA893346 | 6272 | 644 | 1.486865 | 9.5754106 | Fungi | 4751 | Fungi | Fungi | 344 | 1.5699999999999996e-116 | NR | KAI9218401.1 | 64508 | g5806 | i0 | 79.2 | 30.167701863354 | 216 | 43 | 99.7 | 2 | 2 | 643 | 57 | 272 | KAI9218401.1 60S ribosomal protein L2 [Blastocladiella britannica] | diamond | 19428 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27245231 | 27245231 | PRJNA893346_P_NODE_40023_length_241_cov_0.916667_g39533_i0 | PRJNA893346 | 40023 | 241 | 0.916667 | 2.20916747 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 79.3 | 4.77e-15 | NR | KAI9139907.1 | 1500003 | g39533 | i0 | 64.4 | 0.734439834024896 | 59 | 21 | 73.4 | 0 | 61 | 237 | 643 | 701 | KAI9139907.1 FAD binding domain-containing protein, partial [Paraphysoderma sedebokerense] | diamond | 177 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29171549 | 29171549 | PRJNA893346_P_NODE_21369_length_333_cov_1.184615_g20880_i0 | PRJNA893346 | 21369 | 333 | 1.184615 | 3.94476795 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 60.8 | 1.08e-8 | NR | KAJ1507245.1 | 945690 | g20880 | i0 | 36.4 | 0.963963963963964 | 107 | 56 | 85.6 | 3 | 286 | 2 | 29 | 135 | KAJ1507245.1 hypothetical protein HMI56_000196 [Coelomomyces lativittatus] | diamond | 321 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 29897760 | 29897760 | PRJNA893346_P_NODE_39031_length_242_cov_0.911243_g38541_i0 | PRJNA893346 | 39031 | 242 | 0.911243 | 2.20520806 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 70.5 | 4.64e-12 | NR | KAI9145740.1 | 1500003 | g38541 | i0 | 57.1 | 1.64876033057851 | 56 | 24 | 69.4 | 0 | 205 | 38 | 21 | 76 | KAI9145740.1 maintenance of mitochondrial structure and function-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 399 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30758523 | 30758523 | PRJNA893346_P_NODE_27534_length_287_cov_1.126168_g27044_i0 | PRJNA893346 | 27534 | 287 | 1.126168 | 3.23210216 | Blastocladiaceae | 4806 | Fungi | Fungi | 130 | 5.47e-35 | NR | KAJ3375744.1 | 64504 | g27044 | i0 | 64.2 | 7.81881533101045 | 95 | 34 | 99.3 | 0 | 3 | 287 | 162 | 256 | KAJ3375744.1 40S ribosomal protein [Allomyces arbusculus] | diamond | 2244 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 31857161 | 31857161 | PRJNA893346_P_NODE_37717_length_244_cov_0.900585_g37227_i0 | PRJNA893346 | 37717 | 244 | 0.900585 | 2.1974274 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 60.8 | 1.47e-8 | NR | ORZ40782.1 | 765915 | g37227 | i0 | 46.1 | 1.86885245901639 | 76 | 28 | 92.2 | 2 | 230 | 6 | 132 | 195 | ORZ40782.1 hypothetical protein BCR44DRAFT_52752 [Catenaria anguillulae PL171] | diamond | 456 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 31952098 | 31952098 | PRJNA893346_P_NODE_39277_length_242_cov_0.911243_g38787_i0 | PRJNA893346 | 39277 | 242 | 0.911243 | 2.20520806 | Blastocladiella britannica | 64508 | Fungi | Fungi | 42.7 | 0.035 | NR | KAI9219837.1 | 64508 | g38787 | i0 | 44.9 | 0.607438016528926 | 49 | 27 | 60.7 | 0 | 147 | 1 | 38 | 86 | KAI9219837.1 hypothetical protein BC828DRAFT_385086 [Blastocladiella britannica] | diamond | 147 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica |
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);;