contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26746374 | 26746374 | PRJNA859990_S_NODE_21981_length_241_cov_1.583333_g21720_i0 | PRJNA859990 | 21981 | 241 | 1.583333 | 3.8158325299999998 | Basidiomycota | 5204 | Fungi | Fungi | 50.8 | 5.23e-5 | NR | KAK0567960.1 | 155126 | g21720 | i0 | 42.9 | 3.90871369294606 | 77 | 39 | 95.9 | 2 | 231 | 1 | 633 | 704 | KAK0567960.1 hypothetical protein OC861_002411 [Tilletia horrida] | diamond | 942 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida | |
| 27687308 | 27687308 | PRJNA859990_S_NODE_19044_length_248_cov_0.880000_g18783_i0 | PRJNA859990 | 19044 | 248 | 0.88 | 2.1824 | Testicularia cyperi | 1882483 | Fungi | Fungi | 93.2 | 6.97e-20 | NR | PWZ02367.1 | 1882483 | g18783 | i0 | 57.3 | 0.991935483870968 | 82 | 23 | 99.2 | 2 | 2 | 247 | 509 | 578 | PWZ02367.1 CLPTM1-domain-containing protein [Testicularia cyperi] | diamond | 246 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Anthracoideaceae | Testicularia | Testicularia cyperi | |
| 28286622 | 28286622 | PRJNA859990_S_NODE_21326_length_243_cov_0.888235_g21065_i0 | PRJNA859990 | 21326 | 243 | 0.888235 | 2.15841105 | Rhizoctonia solani | 456999 | Fungi | Fungi | 153 | 5.63e-41 | NR | CAE7226744.1 | 456999 | g21065 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 241 | 2 | 458 | 537 | CAE7226744.1 unnamed protein product, partial [Rhizoctonia solani] | diamond | 240 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 29842108 | 29842108 | PRJNA859990_S_NODE_19391_length_247_cov_0.885057_g19130_i0 | PRJNA859990 | 19391 | 247 | 0.885057 | 2.18609079 | Ustilaginomycetes | 5257 | Fungi | Fungi | 50.4 | 7.55e-5 | NR | XP_007882196.1 | 1277687 | g19130 | i0 | 64.7 | 2.30769230769231 | 34 | 12 | 41.3 | 0 | 106 | 5 | 457 | 490 | XP_007882196.1 uncharacterized protein PFL1_06464 [Pseudozyma flocculosa PF-1] | diamond | 570 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 29928920 | 29928920 | PRJNA859990_S_NODE_19471_length_247_cov_0.885057_g19210_i0 | PRJNA859990 | 19471 | 247 | 0.885057 | 2.18609079 | Grifola frondosa | 5627 | Fungi | Fungi | 160 | 9.98e-44 | NR | OBZ72764.1 | 5627 | g19210 | i0 | 92.7 | 0.995951417004049 | 82 | 6 | 99.6 | 0 | 1 | 246 | 661 | 742 | OBZ72764.1 Extracellular metalloproteinase [Grifola frondosa] | diamond | 246 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Grifolaceae | Grifola | Grifola frondosa | |
| 31192155 | 31192155 | PRJNA859990_S_NODE_20855_length_244_cov_0.877193_g20594_i0 | PRJNA859990 | 20855 | 244 | 0.877193 | 2.14035092 | Violaceomyces palustris | 1673888 | Fungi | Fungi | 86.7 | 1.28e-17 | NR | PWN52203.1 | 1673888 | g20594 | i0 | 55 | 0.983606557377049 | 80 | 36 | 98.4 | 0 | 3 | 242 | 101 | 180 | PWN52203.1 hypothetical protein IE53DRAFT_385362, partial [Violaceomyces palustris] | diamond | 240 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Violaceomycetales | Violaceomycetaceae | Violaceomyces | Violaceomyces palustris | |
| 32331730 | 32331730 | PRJNA859990_S_NODE_20199_length_245_cov_1.052326_g19938_i0 | PRJNA859990 | 20199 | 245 | 1.052326 | 2.5781987 | Mycosarcoma maydis | 5270 | Fungi | Fungi | 75.9 | 2.5e-14 | NR | XP_011386059.1 | 5270 | g19938 | i0 | 72.5 | 2.48571428571429 | 51 | 14 | 62.4 | 0 | 243 | 91 | 211 | 261 | XP_011386059.1 uncharacterized protein UMAG_00095 [Mycosarcoma maydis] | diamond | 609 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 32394722 | 32394722 | PRJNA859990_S_NODE_16319_length_260_cov_0.941176_g16058_i0 | PRJNA859990 | 16319 | 260 | 0.941176 | 2.4470576 | Botryobasidium botryosum FD-172 SS1 | 930990 | Fungi | Fungi | 42.7 | 0.0468 | NR | KDQ15921.1 | 930990 | g16058 | i0 | 41.8 | 0.634615384615385 | 55 | 32 | 63.5 | 0 | 233 | 69 | 949 | 1003 | KDQ15921.1 hypothetical protein BOTBODRAFT_173584 [Botryobasidium botryosum FD-172 SS1] | diamond | 165 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Botryobasidiaceae | Botryobasidium | Botryobasidium botryosum | |
| 32489736 | 32489736 | PRJNA859990_S_NODE_18879_length_248_cov_1.405714_g18618_i0 | PRJNA859990 | 18879 | 248 | 1.405714 | 3.48617072 | Meira miltonrushii | 1280837 | Fungi | Fungi | 105 | 3.62e-27 | NR | XP_025353847.1 | 1280837 | g18618 | i0 | 65.3 | 0.907258064516129 | 75 | 26 | 90.7 | 0 | 246 | 22 | 44 | 118 | XP_025353847.1 MAT1-domain-containing protein, partial [Meira miltonrushii] | diamond | 225 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii |
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);;