contig_metadata
7 rows where bioproject = "PRJNA573544" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 559491 | 559491 | PRJNA573544_P_NODE_6981_length_246_cov_0.901734_g6963_i0 | PRJNA573544 | 6981 | 246 | 0.901734 | 2.21826564 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 403 | 5.32e-108 | NTclustered | gi|2837766649|ref|XM_069376682.1| | 1052096 | g6963 | i0 | 96.327 | 10.2642276422764 | 245 | 9 | 99 | 0 | 2 | 246 | 581 | 337 | Cladosporium halotolerans 60S ribosomal protein eL21 (WHR41_08078), mRNA | blastn | 2525 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 14588250 | 14588250 | PRJNA573544_P_NODE_7272_length_245_cov_0.906977_g7254_i0 | PRJNA573544 | 7272 | 245 | 0.906977 | 2.22209365 | Boeremia exigua | 749465 | Fungi | Fungi | 300 | 7.15e-77 | NTclustered | gi|2185343551|ref|XM_046136258.1| | 749465 | g7254 | i0 | 90.351 | 1.94285714285714 | 228 | 22 | 93 | 0 | 5 | 232 | 263 | 490 | Boeremia exigua uncharacterized protein (C7974DRAFT_176418), mRNA | blastn | 476 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Boeremia | Boeremia exigua | |
| 20961638 | 20961638 | PRJNA573544_P_NODE_8017_length_242_cov_0.923077_g7999_i0 | PRJNA573544 | 8017 | 242 | 0.923077 | 2.23384634 | Zasmidium cellare | 395010 | Fungi | Fungi | 387 | 5.26e-103 | NTclustered | gi|1835143467|ref|XM_033818558.1| | 1080233 | g7999 | i0 | 95.455 | 99.3553719008264 | 242 | 11 | 100 | 0 | 1 | 242 | 493 | 252 | Zasmidium cellare ATCC 36951 uncharacterized protein (M409DRAFT_70071), partial mRNA | blastn | 24044 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 22236503 | 22236503 | PRJNA573544_P_NODE_7078_length_246_cov_0.901734_g7060_i0 | PRJNA573544 | 7078 | 246 | 0.901734 | 2.21826564 | Boeremia exigua | 749465 | Fungi | Fungi | 394 | 3.2e-105 | NTclustered | gi|2185337141|ref|XM_046141431.1| | 749465 | g7060 | i0 | 95.528 | 59.280487804878 | 246 | 11 | 100 | 0 | 1 | 246 | 225 | 470 | Boeremia exigua aconitase family-domain-containing protein (C7974DRAFT_389984), mRNA | blastn | 14583 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Boeremia | Boeremia exigua | |
| 23511798 | 23511798 | PRJNA573544_P_NODE_5859_length_251_cov_0.876404_g5841_i0 | PRJNA573544 | 5859 | 251 | 0.876404 | 2.19977404 | Aspergillus sydowii | 75750 | Fungi | Fungi | 73.1 | 1.75e-8 | NTclustered | gi|2028203140|ref|XM_040847334.1| | 1036612 | g5841 | i0 | 92.308 | 0.207171314741036 | 52 | 2 | 20 | 2 | 68 | 118 | 76 | 126 | Aspergillus sydowii CBS 593.65 uncharacterized protein (ASPSYDRAFT_469001), mRNA | blastn | 52 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sydowii | |
| 30742991 | 30742991 | PRJNA573544_P_NODE_7554_length_244_cov_0.912281_g7536_i0 | PRJNA573544 | 7554 | 244 | 0.912281 | 2.22596564 | Extremus antarcticus | 702011 | Fungi | Fungi | 96.3 | 5e-21 | NR | KAK3057624.1 | 702011 | g7536 | i0 | 62.5 | 0.983606557377049 | 80 | 29 | 98.4 | 1 | 5 | 244 | 4 | 82 | KAK3057624.1 transcriptional regulator opi1 [Extremus antarcticus] | diamond | 240 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 31691366 | 31691366 | PRJNA573544_P_NODE_6577_length_248_cov_0.891429_g6559_i0 | PRJNA573544 | 6577 | 248 | 0.891429 | 2.21074392 | Parastagonospora nodorum SN15 | 321614 | Fungi | Fungi | 120 | 1.07e-29 | NR | XP_001794956.1 | 321614 | g6559 | i0 | 82.2 | 0.883064516129032 | 73 | 13 | 88.3 | 0 | 220 | 2 | 291 | 363 | XP_001794956.1 hypothetical protein SNOG_04541 [Parastagonospora nodorum SN15] | diamond | 219 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum |
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);;