contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA825466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 820398 | 820398 | PRJNA825466_P_NODE_12141_length_274_cov_1.532338_g12040_i0 | PRJNA825466 | 12141 | 274 | 1.532338 | 4.19860612 | Schizophyllum commune | 5334 | Fungi | Fungi | 424 | 4.63e-114 | NTclustered | gi|302690605|ref|XM_003034936.1| | 578458 | g12040 | i0 | 94.526 | 10.8394160583942 | 274 | 15 | 100 | 0 | 1 | 274 | 1058 | 785 | Schizophyllum commune H4-8 T-complex protein 1 (SCHCODRAFT_081205), partial mRNA | blastn | 2970 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 2095953 | 2095953 | PRJNA825466_P_NODE_20162_length_248_cov_0.880000_g20061_i0 | PRJNA825466 | 20162 | 248 | 0.88 | 2.1824 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 211 | 3.5e-50 | NTclustered | gi|599397464|ref|XM_007411659.1| | 747676 | g20061 | i0 | 82.114 | 0.991935483870968 | 246 | 44 | 99 | 0 | 3 | 248 | 508 | 263 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_72264), mRNA | blastn | 246 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 8473331 | 8473331 | PRJNA825466_P_NODE_20127_length_248_cov_0.880000_g20026_i0 | PRJNA825466 | 20127 | 248 | 0.88 | 2.1824 | Malassezia globosa | 76773 | Fungi | Fungi | 459 | 1.13e-124 | NTclustered | gi|164658753|ref|XM_001730450.1| | 425265 | g20026 | i0 | 100 | 1 | 248 | 0 | 100 | 0 | 1 | 248 | 325 | 572 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2298), partial mRNA | blastn | 248 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 22497134 | 22497134 | PRJNA825466_P_NODE_10498_length_284_cov_11.146919_g10397_i0 | PRJNA825466 | 10498 | 284 | 11.146919 | 31.65724996 | Pseudomicrostroma glucosiphilum | 1684307 | Fungi | Fungi | 193 | 1.48e-44 | NTclustered | gi|1418633411|ref|XM_025492511.1| | 1684307 | g10397 | i0 | 79.371 | 91.612676056338 | 286 | 49 | 99 | 7 | 2 | 282 | 292 | 12 | Pseudomicrostroma glucosiphilum putative translation elongation factor eEF-1 alpha chain (BCV69DRAFT_282886), mRNA | blastn | 26018 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Pseudomicrostroma | Pseudomicrostroma glucosiphilum | ||
| 22497176 | 22497176 | PRJNA825466_P_NODE_22238_length_246_cov_0.890173_g22137_i0 | PRJNA825466 | 22238 | 246 | 0.890173 | 2.18982558 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 180 | 9.77e-41 | NTclustered | gi|599397464|ref|XM_007411659.1| | 747676 | g22137 | i0 | 84.264 | 0.800813008130081 | 197 | 18 | 80 | 10 | 7 | 202 | 220 | 36 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_72264), mRNA | blastn | 197 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 22497187 | 22497187 | PRJNA825466_P_NODE_27278_length_242_cov_0.911243_g27177_i0 | PRJNA825466 | 27278 | 242 | 0.911243 | 2.20520806 | Malassezia globosa | 76773 | Fungi | Fungi | 364 | 2.4699999999999992e-96 | NTclustered | gi|164658811|ref|XM_001730479.1| | 425265 | g27177 | i0 | 93.802 | 1 | 242 | 15 | 100 | 0 | 1 | 242 | 1541 | 1300 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2327), partial mRNA | blastn | 242 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa |
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);;