contig_metadata
8 rows where bioproject = "PRJNA795983", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8433316 | 8433316 | PRJNA795983_S_NODE_38607_length_247_cov_0.885057_g38482_i0 | PRJNA795983 | 38607 | 247 | 0.885057 | 2.18609079 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 111 | 4.16e-28 | NR | ORZ32611.1 | 765915 | g38482 | i0 | 65.9 | 2.96356275303644 | 82 | 28 | 99.6 | 0 | 246 | 1 | 111 | 192 | ORZ32611.1 kinase-like domain-containing protein, partial [Catenaria anguillulae PL171] | diamond | 732 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 13533907 | 13533907 | PRJNA795983_S_NODE_44411_length_229_cov_2.038462_g44286_i0 | PRJNA795983 | 44411 | 229 | 2.038462 | 4.66807798 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 82.8 | 3.31e-17 | NR | KAI9182903.1 | 1313167 | g44286 | i0 | 60.9 | 1.67685589519651 | 69 | 23 | 85.2 | 1 | 2 | 196 | 167 | 235 | KAI9182903.1 40S ribosomal protein S3 [Blastocladiella emersonii ATCC 22665] | diamond | 384 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 18631773 | 18631773 | PRJNA795983_S_NODE_5035_length_499_cov_6.866197_g4911_i0 | PRJNA795983 | 5035 | 499 | 6.866197 | 34.26232303 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 207 | 1.25e-65 | NR | KAJ1500207.1 | 945690 | g4911 | i0 | 67.1 | 17.9639278557114 | 149 | 49 | 89.6 | 0 | 25 | 471 | 4 | 152 | KAJ1500207.1 nucleoside diphosphate kinase [Coelomomyces lativittatus] | diamond | 8964 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 28799650 | 28799650 | PRJNA795983_S_NODE_11887_length_365_cov_2.020548_g11762_i0 | PRJNA795983 | 11887 | 365 | 2.020548 | 7.3750002 | Eukaryota | 2759 | Fungi | Fungi | 160 | 7.769999999999999e-47 | NR | KAJ3372140.1 | 64504 | g11762 | i0 | 64.2 | 51.9123287671233 | 120 | 43 | 98.6 | 0 | 4 | 363 | 66 | 185 | KAJ3372140.1 ribosomal 40S subunit protein S18B [Allomyces arbusculus] | diamond | 18948 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 29304974 | 29304974 | PRJNA795983_S_NODE_26109_length_281_cov_1.283654_g25984_i0 | PRJNA795983 | 26109 | 281 | 1.283654 | 3.60706774 | Blastocladiomycota | 451459 | Fungi | Fungi | 98.2 | 1.9e-21 | NR | KAI9179662.1 | 1313167 | g25984 | i0 | 58.2 | 9.61921708185053 | 91 | 34 | 97.2 | 2 | 7 | 279 | 650 | 736 | KAI9179662.1 Elongation factor G, mitochondrial [Blastocladiella emersonii ATCC 22665] | diamond | 2703 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30379293 | 30379293 | PRJNA795983_S_NODE_13492_length_349_cov_7.862319_g13367_i0 | PRJNA795983 | 13492 | 349 | 7.862319 | 27.43949331 | Fungi | 4751 | Fungi | Fungi | 121 | 5.9999999999999997e-33 | NR | KAI9221418.1 | 64508 | g13367 | i0 | 59.8 | 5.00286532951289 | 97 | 39 | 83.4 | 0 | 327 | 37 | 14 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1746 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31199970 | 31199970 | PRJNA795983_S_NODE_27895_length_274_cov_4.582090_g27770_i0 | PRJNA795983 | 27895 | 274 | 4.58209 | 12.5549266 | Fungi | 4751 | Fungi | Fungi | 83.2 | 4.46e-18 | NR | ORZ39709.1 | 765915 | g27770 | i0 | 48.2 | 6.47080291970803 | 83 | 43 | 90.9 | 0 | 25 | 273 | 6 | 88 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 1773 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32203558 | 32203558 | PRJNA795983_S_NODE_43838_length_235_cov_2.024691_g43713_i0 | PRJNA795983 | 43838 | 235 | 2.024691 | 4.75802385 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 86.3 | 7.05e-20 | NR | KAI9137792.1 | 1500003 | g43713 | i0 | 65.7 | 0.85531914893617 | 67 | 23 | 85.5 | 0 | 201 | 1 | 4 | 70 | KAI9137792.1 ribosomal protein L36e [Paraphysoderma sedebokerense] | diamond | 201 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;