contig_metadata
8 rows where bioproject = "PRJNA1010662", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1429694 | 1429694 | PRJNA1010662_P_NODE_3062_length_295_cov_1.548780_g3003_i0 | PRJNA1010662 | 3062 | 295 | 1.54878 | 4.568901 | Eukaryota | 2759 | Fungi | Fungi | 163 | 1.6999999999999998e-49 | NR | KAI9216707.1 | 64508 | g3003 | i0 | 85.1 | 22.2610169491525 | 87 | 13 | 88.5 | 0 | 293 | 33 | 61 | 147 | KAI9216707.1 ubiquitin-conjugating enzyme [Blastocladiella britannica] | diamond | 6567 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 26773886 | 26773886 | PRJNA1010662_P_NODE_12101_length_171_cov_1.155738_g12042_i0 | PRJNA1010662 | 12101 | 171 | 1.155738 | 1.97631198 | Allomyces | 28581 | Fungi | Fungi | 55.5 | 4.66e-7 | NR | KAJ3373385.1 | 64504 | g12042 | i0 | 52.8 | 3.71929824561404 | 53 | 25 | 93 | 0 | 7 | 165 | 324 | 376 | KAJ3373385.1 hypothetical protein GGF31_000818 [Allomyces arbusculus] | diamond | 636 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 26781460 | 26781460 | PRJNA1010662_P_NODE_17021_length_161_cov_2.276786_g16962_i0 | PRJNA1010662 | 17021 | 161 | 2.276786 | 3.66562546 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 69.3 | 5.07e-12 | NR | KNE54457.1 | 578462 | g16962 | i0 | 54.5 | 2.03105590062112 | 55 | 23 | 98.8 | 1 | 1 | 159 | 392 | 446 | KNE54457.1 hypothetical protein AMAG_00431 [Allomyces macrogynus ATCC 38327] | diamond | 327 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 26837286 | 26837286 | PRJNA1010662_P_NODE_1281_length_452_cov_1.503722_g1222_i0 | PRJNA1010662 | 1281 | 452 | 1.503722 | 6.79682344 | Eukaryota | 2759 | Fungi | Fungi | 56.2 | 3.06e-6 | NR | KAI9142715.1 | 1500003 | g1222 | i0 | 56.9 | 1.1283185840708 | 51 | 10 | 27.2 | 3 | 123 | 1 | 34 | 82 | KAI9142715.1 hypothetical protein BKA69DRAFT_240339 [Paraphysoderma sedebokerense] | diamond | 510 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28487425 | 28487425 | PRJNA1010662_P_NODE_9127_length_191_cov_0.992958_g9068_i0 | PRJNA1010662 | 9127 | 191 | 0.992958 | 1.89654978 | Blastocladiella britannica | 64508 | Fungi | Fungi | 46.2 | 9.61e-4 | NR | KAI9220248.1 | 64508 | g9068 | i0 | 45.7 | 3.15706806282722 | 46 | 25 | 72.3 | 0 | 187 | 50 | 173 | 218 | KAI9220248.1 phosphatase 2C-like domain-containing protein, partial [Blastocladiella britannica] | diamond | 603 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29521721 | 29521721 | PRJNA1010662_P_NODE_10910_length_178_cov_1.596899_g10851_i0 | PRJNA1010662 | 10910 | 178 | 1.596899 | 2.84248022 | Fungi | 4751 | Fungi | Fungi | 42.4 | 0.0201 | NR | KAI9220248.1 | 64508 | g10851 | i0 | 35.6 | 5.84831460674157 | 59 | 29 | 99.4 | 1 | 1 | 177 | 52 | 101 | KAI9220248.1 phosphatase 2C-like domain-containing protein, partial [Blastocladiella britannica] | diamond | 1041 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 30224027 | 30224027 | PRJNA1010662_P_NODE_6572_length_216_cov_1.233533_g6513_i0 | PRJNA1010662 | 6572 | 216 | 1.233533 | 2.66443128 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 58.2 | 4.48e-8 | NR | KNE59214.1 | 578462 | g6513 | i0 | 38.6 | 2.47222222222222 | 57 | 35 | 79.2 | 0 | 180 | 10 | 2 | 58 | KNE59214.1 hypothetical protein AMAG_03533 [Allomyces macrogynus ATCC 38327] | diamond | 534 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31583306 | 31583306 | PRJNA1010662_P_NODE_4896_length_241_cov_2.156250_g4837_i0 | PRJNA1010662 | 4896 | 241 | 2.15625 | 5.1965625 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 117 | 2.24e-31 | NR | KAJ1500207.1 | 945690 | g4837 | i0 | 67.5 | 10.8298755186722 | 80 | 26 | 99.6 | 0 | 2 | 241 | 63 | 142 | KAJ1500207.1 nucleoside diphosphate kinase [Coelomomyces lativittatus] | diamond | 2610 | 117 | 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);;