contig_metadata
7 rows where bioproject = "PRJNA674308", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26796992 | 26796992 | PRJNA674308_P_NODE_35241_length_170_cov_1.719008_g35006_i0 | PRJNA674308 | 35241 | 170 | 1.719008 | 2.9223136 | Blastocladiella britannica | 64508 | Fungi | Fungi | 53.9 | 1.4e-6 | NR | KAI9220302.1 | 64508 | g35006 | i0 | 66 | 0.829411764705882 | 47 | 16 | 82.9 | 0 | 10 | 150 | 186 | 232 | KAI9220302.1 hypothetical protein BC828DRAFT_383858 [Blastocladiella britannica] | diamond | 141 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27334822 | 27334822 | PRJNA674308_P_NODE_7043_length_358_cov_1.530744_g6808_i0 | PRJNA674308 | 7043 | 358 | 1.530744 | 5.48006352 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 63.2 | 9.77e-9 | NR | KAI9144769.1 | 1500003 | g6808 | i0 | 37.7 | 0.645251396648045 | 77 | 48 | 64.5 | 0 | 357 | 127 | 229 | 305 | KAI9144769.1 hypothetical protein BKA69DRAFT_1054309 [Paraphysoderma sedebokerense] | diamond | 231 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29292273 | 29292273 | PRJNA674308_P_NODE_33849_length_174_cov_1.488000_g33614_i0 | PRJNA674308 | 33849 | 174 | 1.488 | 2.58912 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 46.2 | 9.09e-4 | NR | KAI9175326.1 | 1313167 | g33614 | i0 | 46.3 | 0.706896551724138 | 41 | 22 | 70.7 | 0 | 52 | 174 | 662 | 702 | KAI9175326.1 ATP-dependent DNA helicase II subunit 1 [Blastocladiella emersonii ATCC 22665] | diamond | 123 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30271643 | 30271643 | PRJNA674308_P_NODE_32932_length_176_cov_2.047244_g32697_i0 | PRJNA674308 | 32932 | 176 | 2.047244 | 3.60314944 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 47 | 4.02e-4 | NR | KAI9144088.1 | 1500003 | g32697 | i0 | 58.1 | 0.528409090909091 | 31 | 13 | 52.8 | 0 | 83 | 175 | 11 | 41 | KAI9144088.1 putative catechol O-methyltransferase [Paraphysoderma sedebokerense] | diamond | 93 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30472963 | 30472963 | PRJNA674308_P_NODE_49013_length_164_cov_0.904348_g48778_i0 | PRJNA674308 | 49013 | 164 | 0.904348 | 1.48313072 | Fungi | 4751 | Fungi | Fungi | 41.2 | 0.0449 | NR | KAJ1515512.1 | 945690 | g48778 | i0 | 35.6 | 3.38414634146341 | 45 | 29 | 82.3 | 0 | 137 | 3 | 49 | 93 | KAJ1515512.1 hypothetical protein HMI56_004055 [Coelomomyces lativittatus] | diamond | 555 | 41.6 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30745288 | 30745288 | PRJNA674308_P_NODE_23074_length_207_cov_1.316456_g22839_i0 | PRJNA674308 | 23074 | 207 | 1.316456 | 2.72506392 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 84.3 | 4.18e-18 | NR | KAI9139035.1 | 1500003 | g22839 | i0 | 58.5 | 1.84057971014493 | 65 | 27 | 94.2 | 0 | 206 | 12 | 133 | 197 | KAI9139035.1 B9 domain-containing protein 1 [Paraphysoderma sedebokerense] | diamond | 381 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32799724 | 32799724 | PRJNA674308_P_NODE_33120_length_176_cov_1.244094_g32885_i0 | PRJNA674308 | 33120 | 176 | 1.244094 | 2.18960544 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 52.8 | 4.36e-6 | NR | KAJ1514152.1 | 945690 | g32885 | i0 | 66.7 | 0.5625 | 33 | 11 | 56.3 | 0 | 173 | 75 | 475 | 507 | KAJ1514152.1 UDP-N-acetylglucosamine pyrophosphorylase [Coelomomyces lativittatus] | diamond | 99 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus |
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);;