contig_metadata
6 rows where bioproject = "PRJNA492406", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26855155 | 26855155 | PRJNA492406_P_NODE_18281_length_291_cov_2.009174_g17982_i0 | PRJNA492406 | 18281 | 291 | 2.009174 | 5.84669634 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 67 | 1.97e-10 | NR | KAI9139437.1 | 1500003 | g17982 | i0 | 41.5 | 5.30927835051546 | 94 | 51 | 96.9 | 2 | 288 | 7 | 288 | 377 | KAI9139437.1 peptidase family M41-domain-containing protein, partial [Paraphysoderma sedebokerense] | diamond | 1545 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 26918262 | 26918262 | PRJNA492406_P_NODE_31642_length_242_cov_0.911243_g31343_i0 | PRJNA492406 | 31642 | 242 | 0.911243 | 2.20520806 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 69.7 | 1.04e-11 | NR | KAI9168192.1 | 1313167 | g31343 | i0 | 58.8 | 7.88429752066116 | 80 | 27 | 97.9 | 3 | 242 | 6 | 315 | 389 | KAI9168192.1 hypothetical protein H9P43_007564 [Blastocladiella emersonii ATCC 22665] | diamond | 1908 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 29081992 | 29081992 | PRJNA492406_P_NODE_20768_length_280_cov_0.951691_g20469_i0 | PRJNA492406 | 20768 | 280 | 0.951691 | 2.6647348 | Eukaryota | 2759 | Fungi | Fungi | 53.1 | 1.21e-5 | NR | ORZ34380.1 | 765915 | g20469 | i0 | 37.4 | 3.58928571428571 | 91 | 54 | 94.3 | 1 | 275 | 12 | 145 | 235 | ORZ34380.1 proteasome regulatory subunit C-terminal-domain-containing protein, partial [Catenaria anguillulae PL171] | diamond | 1005 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30392832 | 30392832 | PRJNA492406_P_NODE_32533_length_234_cov_2.596273_g32234_i0 | PRJNA492406 | 32533 | 234 | 2.596273 | 6.07527882 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 45.8 | 0.0028 | NR | KAJ1505895.1 | 945690 | g32234 | i0 | 39.7 | 1.65384615384615 | 63 | 38 | 80.8 | 0 | 43 | 231 | 29 | 91 | KAJ1505895.1 hypothetical protein HMI56_000882 [Coelomomyces lativittatus] | diamond | 387 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 32527215 | 32527215 | PRJNA492406_P_NODE_26139_length_252_cov_3.357542_g25840_i0 | PRJNA492406 | 26139 | 252 | 3.357542 | 8.46100584 | Fungi | 4751 | Fungi | Fungi | 100 | 2.8e-25 | NR | KAI9221418.1 | 64508 | g25840 | i0 | 58.8 | 11.1428571428571 | 80 | 33 | 95.2 | 0 | 1 | 240 | 31 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 2808 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32574418 | 32574418 | PRJNA492406_P_NODE_17199_length_301_cov_1.754386_g16900_i0 | PRJNA492406 | 17199 | 301 | 1.754386 | 5.28070186 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 94.7 | 1.82e-22 | NR | ORZ39709.1 | 765915 | g16900 | i0 | 50 | 0.916943521594684 | 92 | 46 | 91.7 | 0 | 277 | 2 | 6 | 97 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 276 | 94.7 | 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);;