contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA532380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27203813 | 27203813 | PRJNA532380_P_NODE_31762_length_164_cov_0.904348_g31437_i0 | PRJNA532380 | 31762 | 164 | 0.904348 | 1.48313072 | Phakopsora pachyrhizi | 170000 | Fungi | Fungi | 67 | 3.17e-12 | NR | KAI8455471.1 | 170000 | g31437 | i0 | 66 | 0.914634146341463 | 50 | 17 | 91.5 | 0 | 153 | 4 | 8 | 57 | KAI8455471.1 dUTP diphosphatase [Phakopsora pachyrhizi] | diamond | 150 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 29193571 | 29193571 | PRJNA532380_P_NODE_22329_length_190_cov_1.106383_g22004_i0 | PRJNA532380 | 22329 | 190 | 1.106383 | 2.1021277 | Serendipita vermifera MAFF 3 | 109899 | Fungi | Fungi | 43.5 | 0.00274 | NR | KIM29253.1 | 933852 | g22004 | i0 | 52.3 | 1.68947368421053 | 44 | 20 | 67.9 | 1 | 129 | 1 | 23 | 66 | KIM29253.1 hypothetical protein M408DRAFT_328926 [Serendipita vermifera MAFF 305830] | diamond | 321 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 30962340 | 30962340 | PRJNA532380_P_NODE_31454_length_164_cov_0.904348_g31129_i0 | PRJNA532380 | 31454 | 164 | 0.904348 | 1.48313072 | Irpex lacteus | 5319 | Fungi | Fungi | 103 | 1.9e-26 | NR | KAI0763138.1 | 5319 | g31129 | i0 | 98.1 | 1.97560975609756 | 54 | 1 | 98.8 | 0 | 162 | 1 | 92 | 145 | KAI0763138.1 hypothetical protein BC629DRAFT_1443291 [Irpex lacteus] | diamond | 324 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Irpex | Irpex lacteus | |
| 31341557 | 31341557 | PRJNA532380_P_NODE_20376_length_199_cov_1.386667_g20051_i0 | PRJNA532380 | 20376 | 199 | 1.386667 | 2.75946733 | Pisolithus orientalis | 936130 | Fungi | Fungi | 75.9 | 4.45e-14 | NR | XP_051594294.1 | 936130 | g20051 | i0 | 48.4 | 17.7437185929648 | 62 | 32 | 93.5 | 0 | 199 | 14 | 459 | 520 | XP_051594294.1 adaptin N terminal region-domain-containing protein [Pisolithus orientalis] | diamond | 3531 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Pisolithaceae | Pisolithus | Pisolithus orientalis | |
| 31468251 | 31468251 | PRJNA532380_P_NODE_16876_length_219_cov_1.223529_g16551_i0 | PRJNA532380 | 16876 | 219 | 1.223529 | 2.67952851 | Schizopora paradoxa | 27342 | Fungi | Fungi | 87 | 4.84e-19 | NR | KLO20096.1 | 27342 | g16551 | i0 | 51.4 | 1.98630136986301 | 72 | 34 | 98.6 | 1 | 216 | 1 | 62 | 132 | KLO20096.1 E2 ubiquitin-conjugating enzyme [Schizopora paradoxa] | diamond | 435 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 31767750 | 31767750 | PRJNA532380_P_NODE_30277_length_166_cov_0.888889_g29952_i0 | PRJNA532380 | 30277 | 166 | 0.888889 | 1.47555574 | Opisthokonta | 33154 | Fungi | Fungi | 102 | 1.1799999999999999e-23 | NR | KAK0531972.1 | 155126 | g29952 | i0 | 85.2 | 168 | 54 | 8 | 97.6 | 0 | 163 | 2 | 175 | 228 | KAK0531972.1 26S proteasome regulatory subunit 7 [Tilletia horrida] | diamond | 27888 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida | |
| 32291002 | 32291002 | PRJNA532380_P_NODE_32679_length_163_cov_0.912281_g32354_i0 | PRJNA532380 | 32679 | 163 | 0.912281 | 1.48701803 | Ceratobasidium theobromae | 1582974 | Fungi | Fungi | 41.2 | 0.0454 | NR | KAB5588459.1 | 1582974 | g32354 | i0 | 48.8 | 0.791411042944785 | 43 | 22 | 79.1 | 0 | 150 | 22 | 308 | 350 | KAB5588459.1 hypothetical protein CTheo_8100 [Ceratobasidium theobromae] | diamond | 129 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium theobromae |
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);;