contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB65329" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2269142 | 2269142 | PRJEB65329_S_NODE_6722_length_288_cov_4.528958_g6560_i0 | PRJEB65329 | 6722 | 288 | 4.528958 | 13.04339904 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.027 | NTclustered | gi|1758257202|ref|XM_031120922.1| | 148305 | g6560 | i0 | 100 | 0.208333333333333 | 28 | 0 | 10 | 0 | 105 | 132 | 1237 | 1264 | Pyricularia grisea uncharacterized protein (PgNI_00845), partial mRNA | blastn | 60 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia grisea | |
| 3544429 | 3544429 | PRJEB65329_S_NODE_13703_length_179_cov_1.960000_g13541_i0 | PRJEB65329 | 13703 | 179 | 1.96 | 3.5084 | Blastomyces | 229219 | Fungi | Fungi | 152 | 1.45e-32 | NTclustered | gi|2163354133|ref|XM_045423294.1| | 559297 | g13541 | i0 | 82.022 | 42.0670391061453 | 178 | 32 | 99 | 0 | 2 | 179 | 418 | 595 | Blastomyces dermatitidis ER-3 50S ribosomal protein L40e (BDCG_07509), partial mRNA | blastn | 7530 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Blastomyces | Blastomyces dermatitidis | |
| 4821963 | 4821963 | PRJEB65329_S_NODE_18444_length_150_cov_3.867769_g18282_i0 | PRJEB65329 | 18444 | 150 | 3.867769 | 5.8016535 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.85e-70 | NTclustered | gi|2612872|gb|AF010303.1| | 63354 | g18282 | i0 | 100 | 100 | 150 | 0 | 100 | 0 | 1 | 150 | 666 | 815 | Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence | blastn | 15000 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotiniaceae sp. BSC-97 | ||
| 9057542 | 9057542 | PRJEB65329_S_NODE_8428_length_245_cov_3.662037_g8266_i0 | PRJEB65329 | 8428 | 245 | 3.662037 | 8.97199065 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2724881403|ref|XM_064835180.1| | 574656 | g8266 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 27 | 55 | 1808 | 1780 | Recurvomyces mirabilis mitogen-activated protein kinase kinase kinase (BCK1), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 11608599 | 11608599 | PRJEB65329_S_NODE_17330_length_156_cov_1.677165_g17168_i0 | PRJEB65329 | 17330 | 156 | 1.677165 | 2.6163774 | Aspergillus melleus | 138277 | Fungi | Fungi | 132 | 1.6e-26 | NTclustered | gi|2185263466|ref|XM_046087683.1| | 138277 | g17168 | i0 | 83.942 | 4.56410256410256 | 137 | 22 | 88 | 0 | 15 | 151 | 622 | 758 | Aspergillus melleus RuvB ATP-dependent DNA helicase pontin (RVB1), partial mRNA | blastn | 712 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus melleus | |
| 18845548 | 18845548 | PRJEB65329_S_NODE_15075_length_168_cov_4.446043_g14913_i0 | PRJEB65329 | 15075 | 168 | 4.446043 | 7.46935224 | Sordariomycetes | 147550 | Fungi | Fungi | 60.2 | 8.43e-5 | NTclustered | gi|2897698624|ref|XM_071023815.1| | 591952 | g14913 | i0 | 94.737 | 1.42261904761905 | 38 | 2 | 23 | 0 | 130 | 167 | 337 | 300 | Sodiomyces alcalophilus JCM 7366 uncharacterized protein (ACRALDRAFT_212015), partial mRNA | blastn | 239 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Sodiomyces | Sodiomyces alcalophilus | |
| 20530972 | 20530972 | PRJEB65329_S_NODE_11717_length_197_cov_2.660714_g11555_i0 | PRJEB65329 | 11717 | 197 | 2.660714 | 5.24160658 | Lipomyces japonicus | 56871 | Fungi | Fungi | 137 | 4.58e-28 | NTclustered | gi|2781531505|ref|XM_066929761.1| | 56871 | g11555 | i0 | 86.4 | 1.79695431472081 | 125 | 17 | 63 | 0 | 62 | 186 | 369 | 493 | Lipomyces japonicus 60S ribosomal eL21 domain-containing protein (V1514DRAFT_363258), mRNA | blastn | 354 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces japonicus | |
| 24355817 | 24355817 | PRJEB65329_S_NODE_11400_length_200_cov_3.467836_g11238_i0 | PRJEB65329 | 11400 | 200 | 3.467836 | 6.935672 | Magnusiomyces paraingens | 2606893 | Fungi | Fungi | 54.7 | 0.005 | NTclustered | gi|1800258659|ref|XM_031999881.1| | 2606893 | g11238 | i0 | 100 | 0.145 | 29 | 0 | 15 | 0 | 24 | 52 | 518 | 546 | Magnusiomyces paraingens uncharacterized protein (SAPINGB_P005166), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Magnusiomyces | Magnusiomyces paraingens | |
| 24355878 | 24355878 | PRJEB65329_S_NODE_15420_length_166_cov_3.204380_g15258_i0 | PRJEB65329 | 15420 | 166 | 3.20438 | 5.3192708 | Durotheca rogersii | 419775 | Fungi | Fungi | 110 | 8.13e-20 | NTclustered | gi|2324015613|ref|XM_051514482.1| | 419775 | g15258 | i0 | 79.012 | 2.42771084337349 | 162 | 32 | 97 | 2 | 6 | 166 | 254 | 414 | Durotheca rogersii ras family protein (GGS23DRAFT_502017), mRNA | blastn | 403 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Durotheca | Durotheca rogersii |
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);;