contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168610 | 3168610 | PRJNA641991_S_NODE_12203_length_167_cov_0.864407_g12084_i0 | PRJNA641991 | 12203 | 167 | 0.864407 | 1.44355969 | Rhizoctonia solani | 456999 | Fungi | Fungi | 76.8 | 8.31e-10 | NTclustered | gi|2086753559|ref|XM_043320575.1| | 456999 | g12084 | i0 | 89.062 | 0.383233532934132 | 64 | 3 | 37 | 3 | 18 | 79 | 376 | 437 | Rhizoctonia solani ribosomal S13/S15 N-terminal domain (RhiXN_00756), partial mRNA | blastn | 64 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 4445448 | 4445448 | PRJNA641991_S_NODE_12984_length_165_cov_0.879310_g12865_i0 | PRJNA641991 | 12984 | 165 | 0.87931 | 1.4508615 | Malassezia restricta | 76775 | Fungi | Fungi | 294 | 2.08e-75 | NTclustered | gi|1546634604|ref|XM_027628962.1| | 76775 | g12865 | i0 | 98.788 | 1 | 165 | 2 | 100 | 0 | 1 | 165 | 256 | 420 | Malassezia restricta Bacterial low temperature requirement A protein (LtrA) (MRET_2335), partial mRNA | blastn | 165 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5721306 | 5721306 | PRJNA641991_S_NODE_1285_length_464_cov_2.812048_g1166_i0 | PRJNA641991 | 1285 | 464 | 2.812048 | 13.04790272 | Psilocybe cubensis | 181762 | Fungi | Fungi | 54.7 | 0.013 | NTclustered | gi|2234859650|ref|XM_047892278.1| | 181762 | g1166 | i0 | 100 | 0.0625 | 29 | 0 | 6 | 0 | 436 | 464 | 1003 | 1031 | Psilocybe cubensis uncharacterized protein (JR316_0006532), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cubensis | |
| 6996304 | 6996304 | PRJNA641991_P_NODE_4026_length_162_cov_0.902655_g3985_i0 | PRJNA641991 | 4026 | 162 | 0.902655 | 1.4623011 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 86.1 | 1.33e-12 | NTclustered | gi|1423587683|ref|XM_025743277.1| | 58919 | g3985 | i0 | 82.979 | 0.580246913580247 | 94 | 16 | 58 | 0 | 22 | 115 | 634 | 541 | Tilletiopsis washingtonensis putative RPS8A-ribosomal protein S8.e (FA09DRAFT_332012), mRNA | blastn | 94 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 10086926 | 10086926 | PRJNA641991_S_NODE_8328_length_194_cov_1.227586_g8209_i0 | PRJNA641991 | 8328 | 194 | 1.227586 | 2.38151684 | Opisthokonta | 33154 | Fungi | Fungi | 134 | 5.81e-27 | NTclustered | gi|558519992|gb|KF037144.1| | 5610 | g8209 | i0 | 86.667 | 58.4948453608247 | 120 | 16 | 62 | 0 | 8 | 127 | 248 | 367 | Fellomyces penicillatus strain CBS5492 translation elongation factor EF1-alpha (TEF-1) gene, partial cds | blastn | 11348 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Fellomyces | Fellomyces penicillatus | |
| 18470014 | 18470014 | PRJNA641991_S_NODE_13895_length_163_cov_0.894737_g13776_i0 | PRJNA641991 | 13895 | 163 | 0.894737 | 1.45842131 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|599418079|ref|XM_007415681.1| | 747676 | g13776 | i0 | 96.774 | 0.190184049079755 | 31 | 1 | 19 | 0 | 118 | 148 | 67 | 97 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_26220), partial mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 21020165 | 21020165 | PRJNA641991_S_NODE_14077_length_162_cov_1.805310_g13958_i0 | PRJNA641991 | 14077 | 162 | 1.80531 | 2.9246022 | Dichomitus squalens | 114155 | Fungi | Fungi | 128 | 2.18e-25 | NTclustered | gi|597980546|ref|XM_007363215.1| | 732165 | g13958 | i0 | 82.237 | 42.2283950617284 | 152 | 24 | 93 | 3 | 13 | 162 | 967 | 817 | Dichomitus squalens LYAD-421 SS1 endopeptidase (DICSQDRAFT_134116), mRNA | blastn | 6841 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Dichomitus | Dichomitus squalens | |
| 22294882 | 22294882 | PRJNA641991_S_NODE_3078_length_300_cov_1.219124_g2959_i0 | PRJNA641991 | 3078 | 300 | 1.219124 | 3.657372 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 183 | 9.479999999999998e-42 | NTclustered | gi|2669764391|ref|XM_062774797.1| | 143232 | g2959 | i0 | 80.321 | 20.75 | 249 | 43 | 82 | 5 | 10 | 255 | 300 | 55 | Vanrija pseudolonga 60S ribosomal protein L44 (RPL44), partial mRNA | blastn | 6225 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga |
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);;