contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA727760" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1988714 | 1988714 | PRJNA727760_S_NODE_2322_length_297_cov_2.089286_g2294_i0 | PRJNA727760 | 2322 | 297 | 2.089286 | 6.20517942 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 544 | 3.7299999999999996e-150 | NTclustered | gi|2741354647|ref|XM_065601239.1| | 33203 | g2294 | i0 | 99.663 | 1 | 297 | 1 | 100 | 0 | 1 | 297 | 795 | 499 | Purpureocillium lilacinum uncharacterized protein (PLICBS_007754), partial mRNA | blastn | 297 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 3263976 | 3263976 | PRJNA727760_S_NODE_1663_length_357_cov_1.373239_g1635_i0 | PRJNA727760 | 1663 | 357 | 1.373239 | 4.90246323 | Pseudogymnoascus destructans | 655981 | Fungi | Fungi | 108 | 7.11e-19 | NTclustered | gi|1370889069|ref|XM_024471176.1| | 655981 | g1635 | i0 | 82.258 | 0.34733893557423 | 124 | 22 | 35 | 0 | 232 | 355 | 799 | 676 | Pseudogymnoascus destructans uncharacterized protein (VC83_07609), mRNA | blastn | 124 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Thelebolales | Thelebolaceae | Pseudogymnoascus | Pseudogymnoascus destructans | |
| 5816325 | 5816325 | PRJNA727760_S_NODE_1205_length_425_cov_1.551136_g1177_i0 | PRJNA727760 | 1205 | 425 | 1.551136 | 6.592328 | Metarhizium acridum | 92637 | Fungi | Fungi | 364 | 4.629999999999998e-96 | NTclustered | gi|2749718875|ref|XM_066119671.1| | 92637 | g1177 | i0 | 98.086 | 48.9364705882353 | 209 | 4 | 49 | 0 | 217 | 425 | 1388 | 1180 | Metarhizium acridum translation elongation factor EF-1 alpha (TEF1_1), partial mRNA | blastn | 20798 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium acridum | |
| 12674369 | 12674369 | PRJNA727760_S_NODE_2270_length_301_cov_1.561404_g2242_i0 | PRJNA727760 | 2270 | 301 | 1.561404 | 4.69982604 | Ascomycota | 4890 | Fungi | Fungi | 556 | 4.87e-154 | NTclustered | gi|1473258532|gb|MH871476.1| | 5046 | g2242 | i0 | 100 | 100.013289036545 | 301 | 0 | 100 | 0 | 1 | 301 | 307 | 7 | Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence | blastn | 30104 | 556 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 14741723 | 14741723 | PRJNA727760_S_NODE_3892_length_235_cov_2.888889_g3864_i0 | PRJNA727760 | 3892 | 235 | 2.888889 | 6.78888915 | Diaporthe batatas | 748121 | Fungi | Fungi | 139 | 1.57e-28 | NTclustered | gi|2124358414|ref|XM_044782441.1| | 748121 | g3864 | i0 | 100 | 32.6255319148936 | 75 | 0 | 32 | 0 | 1 | 75 | 1004 | 1078 | Diaporthe batatas guanine nucleotide-binding protein subunit beta (KVR01_001289), mRNA | blastn | 7667 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe batatas | |
| 16015182 | 16015182 | PRJNA727760_S_NODE_1413_length_388_cov_1.234921_g1385_i0 | PRJNA727760 | 1413 | 388 | 1.234921 | 4.79149348 | Colletotrichum destructivum | 34406 | Fungi | Fungi | 370 | 9.01e-98 | NTclustered | gi|2670800169|ref|XM_062922625.1| | 34406 | g1385 | i0 | 90.034 | 61.6520618556701 | 291 | 21 | 75 | 8 | 25 | 315 | 240 | 522 | Colletotrichum destructivum Putative cytochrome c, class IA/ IB, cytochrome c-like domain superfamily (CDEST_06466), mRNA | blastn | 23921 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum destructivum | |
| 25421379 | 25421379 | PRJNA727760_S_NODE_3220_length_257_cov_1.695652_g3192_i0 | PRJNA727760 | 3220 | 257 | 1.695652 | 4.35782564 | Pyricularia | 48558 | Fungi | Fungi | 132 | 2.9200000000000003e-26 | NTclustered | gi|389639323|ref|XM_003717247.1| | 242507 | g3192 | i0 | 95.181 | 13.5525291828794 | 83 | 4 | 32 | 0 | 1 | 83 | 443 | 525 | Pyricularia oryzae 70-15 histone H4 (MGG_06293), mRNA | blastn | 3483 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia oryzae |
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);;