contig_metadata
7 rows where bioproject = "PRJNA1057075" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1011332 | 1011332 | PRJNA1057075_S_NODE_1601_length_305_cov_5.835938_g1502_i0 | PRJNA1057075 | 1601 | 305 | 5.835938 | 17.7996109 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.028 | NTclustered | gi|2837842073|ref|XM_069420121.1| | 89139 | g1502 | i0 | 100 | 0.19672131147541 | 28 | 0 | 9 | 0 | 31 | 58 | 2292 | 2265 | Rasamsonia byssochlamydoides uncharacterized protein (VTN77DRAFT_41), partial mRNA | blastn | 60 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Rasamsonia | Rasamsonia byssochlamydoides | |
| 3562016 | 3562016 | PRJNA1057075_S_NODE_863_length_367_cov_38221.251572_g764_i0 | PRJNA1057075 | 863 | 367 | 38221.251572 | 140271.99326924 | Ascomycota | 4890 | Fungi | Fungi | 542 | 1.6999999999999995e-149 | NTclustered | gi|1802567479|gb|MT000479.1| | 45277 | g764 | i0 | 97.771 | 85.558583106267 | 314 | 7 | 86 | 0 | 50 | 363 | 315 | 2 | Sarocladium kiliense strain LSU0027 large subunit ribosomal RNA gene, partial sequence | blastn | 31400 | 542 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium kiliense | |
| 16313748 | 16313748 | PRJNA1057075_S_NODE_873_length_366_cov_28363.782334_g774_i0 | PRJNA1057075 | 873 | 366 | 28363.782334 | 103811.44334244 | Ascomycota | 4890 | Fungi | Fungi | 542 | 1.69e-149 | NTclustered | gi|1473258532|gb|MH871476.1| | 5046 | g774 | i0 | 97.771 | 85.792349726776 | 314 | 7 | 86 | 0 | 49 | 362 | 364 | 51 | Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence | blastn | 31400 | 547 | 0.990859232175503 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 19302307 | 19302307 | PRJNA1057075_S_NODE_2796_length_254_cov_51176.985366_g2697_i0 | PRJNA1057075 | 2796 | 254 | 51176.985366 | 129989.54282964 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 2.27e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g2697 | i0 | 88 | 16.9173228346457 | 75 | 6 | 30 | 1 | 14 | 88 | 2269 | 2198 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 4297 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 20137730 | 20137730 | PRJNA1057075_S_NODE_1016_length_351_cov_339.536424_g917_i0 | PRJNA1057075 | 1016 | 351 | 339.536424 | 1191.77284824 | Ascomycota | 4890 | Fungi | Fungi | 529 | 1.2599999999999996e-145 | NTclustered | gi|1473258532|gb|MH871476.1| | 5046 | g917 | i0 | 98.026 | 86.6096866096866 | 304 | 6 | 87 | 0 | 5 | 308 | 51 | 354 | Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence | blastn | 30400 | 534 | 0.99063670411985 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 23128904 | 23128904 | PRJNA1057075_S_NODE_5699_length_192_cov_4.860140_g5600_i0 | PRJNA1057075 | 5699 | 192 | 4.86014 | 9.3314688 | Wickerhamiella azyma | 5488 | Fungi | Fungi | 73.1 | 1.27e-8 | NTclustered | gi|1209454344|ref|NG_055326.1| | 5488 | g5600 | i0 | 80.412 | 8.90104166666667 | 97 | 17 | 50 | 2 | 74 | 169 | 3041 | 2946 | Wickerhamiella azyma NRRL Y-17067 28S rRNA, partial sequence; from TYPE material | blastn | 1709 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella azyma | |
| 26869200 | 26869200 | PRJNA1057075_S_NODE_7841_length_171_cov_1.122951_g7742_i0 | PRJNA1057075 | 7841 | 171 | 1.122951 | 1.92024621 | Teratosphaeriaceae | 668547 | Fungi | Fungi | 47 | 1.43e-4 | NR | WPH01937.1 | 150365 | g7742 | i0 | 88.5 | 3.19298245614035 | 26 | 3 | 45.6 | 0 | 3 | 80 | 106 | 131 | WPH01937.1 60S ribosomal protein L32 [Acrodontium crateriforme] | diamond | 546 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme |
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);;