contig_metadata
6 rows where bioproject = "PRJEB75017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15437798 | 15437798 | PRJEB75017_P_NODE_11333_length_276_cov_1.192118_g11204_i0 | PRJEB75017 | 11333 | 276 | 1.192118 | 3.29024568 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 117 | 2.0299999999999997e-31 | NR | KAJ1509529.1 | 945690 | g11204 | i0 | 62.5 | 39.3804347826087 | 88 | 33 | 95.7 | 0 | 268 | 5 | 1 | 88 | KAJ1509529.1 60S ribosomal protein L32 [Coelomomyces lativittatus] | diamond | 10869 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 15437835 | 15437835 | PRJEB75017_P_NODE_16533_length_246_cov_1.352601_g16404_i0 | PRJEB75017 | 16533 | 246 | 1.352601 | 3.32739846 | Eukaryota | 2759 | Fungi | Fungi | 99.8 | 3.46e-22 | NR | KAI9168454.1 | 1313167 | g16404 | i0 | 55.7 | 8.71951219512195 | 79 | 35 | 96.3 | 0 | 1 | 237 | 470 | 548 | KAI9168454.1 succinate dehydrogenase flavoprotein subunit [Blastocladiella emersonii ATCC 22665] | diamond | 2145 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27223585 | 27223585 | PRJEB75017_P_NODE_12883_length_261_cov_1.239362_g12754_i0 | PRJEB75017 | 12883 | 261 | 1.239362 | 3.23473482 | Blastocladiella britannica | 64508 | Fungi | Fungi | 85.1 | 4.58e-17 | NR | KAI9219086.1 | 64508 | g12754 | i0 | 51.8 | 11 | 85 | 36 | 92 | 2 | 17 | 256 | 1 | 85 | KAI9219086.1 hypothetical protein BC828DRAFT_386956 [Blastocladiella britannica] | diamond | 2871 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 30280121 | 30280121 | PRJEB75017_P_NODE_13852_length_253_cov_0.866667_g13723_i0 | PRJEB75017 | 13852 | 253 | 0.866667 | 2.19266751 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 6.03e-5 | NR | KAJ3369523.1 | 64504 | g13723 | i0 | 46.6 | 4.05533596837945 | 58 | 31 | 68.8 | 0 | 178 | 5 | 276 | 333 | KAJ3369523.1 hypothetical protein GGF31_005233 [Allomyces arbusculus] | diamond | 1026 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 30848448 | 30848448 | PRJEB75017_P_NODE_11074_length_278_cov_2.165854_g10945_i0 | PRJEB75017 | 11074 | 278 | 2.165854 | 6.02107412 | Allomyces | 28581 | Fungi | Fungi | 48.9 | 3.77e-4 | NR | KAJ3374655.1 | 64504 | g10945 | i0 | 40.9 | 1.42446043165468 | 66 | 38 | 71.2 | 1 | 200 | 3 | 37 | 101 | KAJ3374655.1 hypothetical protein GGF31_006552 [Allomyces arbusculus] | diamond | 396 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 32563777 | 32563777 | PRJEB75017_P_NODE_5519_length_374_cov_1.554817_g5390_i0 | PRJEB75017 | 5519 | 374 | 1.554817 | 5.81501558 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 65.1 | 3.7e-10 | NR | KAI9136487.1 | 1500003 | g5390 | i0 | 45.1 | 0.56951871657754 | 71 | 36 | 57 | 1 | 374 | 162 | 107 | 174 | KAI9136487.1 cyclophilin-like domain-containing protein, partial [Paraphysoderma sedebokerense] | diamond | 213 | 65.1 | 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);;