contig_metadata
6 rows where bioproject = "PRJNA870096", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5954003 | 5954003 | PRJNA870096_S_NODE_89245_length_186_cov_1.678322_g87581_i0 | PRJNA870096 | 89245 | 186 | 1.678322 | 3.12167892 | Fungi | 4751 | Fungi | Fungi | 94 | 3.9300000000000005e-21 | NR | KAI9141123.1 | 1500003 | g87581 | i0 | 72.1 | 1.95161290322581 | 61 | 17 | 98.4 | 0 | 3 | 185 | 256 | 316 | KAI9141123.1 ATPase GET3 [Paraphysoderma sedebokerense] | diamond | 363 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 18700950 | 18700950 | PRJNA870096_S_NODE_12375_length_524_cov_2.521830_g10759_i0 | PRJNA870096 | 12375 | 524 | 2.52183 | 13.2143892 | Blastocladiella britannica | 64508 | Fungi | Fungi | 271 | 2.3299999999999997e-88 | NR | KAI9218401.1 | 64508 | g10759 | i0 | 77.3 | 21.0114503816794 | 176 | 38 | 99.6 | 2 | 1 | 522 | 64 | 239 | KAI9218401.1 60S ribosomal protein L2 [Blastocladiella britannica] | diamond | 11010 | 271 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 26841984 | 26841984 | PRJNA870096_S_NODE_97781_length_178_cov_3.200000_g96117_i0 | PRJNA870096 | 97781 | 178 | 3.2 | 5.696 | Opisthokonta | 33154 | Fungi | Fungi | 49.3 | 7.3e-5 | NR | KAI9217773.1 | 64508 | g96117 | i0 | 50 | 2.8314606741573 | 56 | 27 | 94.4 | 1 | 176 | 9 | 80 | 134 | KAI9217773.1 PCI domain-containing protein [Blastocladiella britannica] | diamond | 504 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28286716 | 28286716 | PRJNA870096_S_NODE_58146_length_230_cov_1.796791_g56482_i0 | PRJNA870096 | 58146 | 230 | 1.796791 | 4.1326193 | Blastocladiella britannica | 64508 | Fungi | Fungi | 46.6 | 0.00132 | NR | KAI9217468.1 | 64508 | g56482 | i0 | 50 | 0.808695652173913 | 62 | 28 | 80.9 | 1 | 27 | 212 | 44 | 102 | KAI9217468.1 hypothetical protein BC828DRAFT_391095 [Blastocladiella britannica] | diamond | 186 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28381639 | 28381639 | PRJNA870096_S_NODE_98386_length_178_cov_1.296296_g96722_i0 | PRJNA870096 | 98386 | 178 | 1.296296 | 2.30740688 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 79.7 | 1.45e-15 | NR | KNE54225.1 | 578462 | g96722 | i0 | 60.3 | 0.97752808988764 | 58 | 23 | 97.8 | 0 | 174 | 1 | 662 | 719 | KNE54225.1 hypothetical protein AMAG_00216 [Allomyces macrogynus ATCC 38327] | diamond | 174 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28444954 | 28444954 | PRJNA870096_S_NODE_12446_length_522_cov_9.567850_g10828_i0 | PRJNA870096 | 12446 | 522 | 9.56785 | 49.944177 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 79.3 | 6.3e-15 | NR | KAJ1507245.1 | 945690 | g10828 | i0 | 33.8 | 0.885057471264368 | 154 | 90 | 81.6 | 3 | 464 | 39 | 12 | 165 | KAJ1507245.1 hypothetical protein HMI56_000196 [Coelomomyces lativittatus] | diamond | 462 | 79.3 | 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);;